[TUTORIAL] Instalar DirectAdmin, más cluster Master/Master

sudo cp /etc/ssh/sshd_config /etc/ssh/sshd_config.bak

sudo wget "mi URL de mi git privado" (Script básico propio de segurización "básicamente solo son sed -i, para reemplazar cadenas)

sudo chmod +x ./secure-ssh.sh

sudo vi /etc/ssh/sshd_config

rpm -ivh exim-3.36-2.i386.rpm

rpm -e --nodeps sendmail

rpm -q servicename

rpm -qa | grep substring

rpm -qa | grep apache

yum install wget gcc gcc-c++ flex bison make bind bind-libs bind-utils openssl openssl-devel perl quota libaio \
libcom_err-devel libcurl-devel gd zlib-devel zip unzip libcap-devel cronie bzip2 cyrus-sasl-devel perl-ExtUtils-Embed \
autoconf automake libtool which patch mailx bzip2-devel lsof glibc-headers kernel-devel expat-devel \
psmisc net-tools systemd-devel libdb-devel perl-DBI perl-Perl4-CoreLibs perl-libwww-perl xfsprogs rsyslog logrotate crontabs file kernel-headers

cd /root

wget https://www.directadmin.com/setup.sh

chmod 755 setup.sh

./setup.sh

ipconfig -a

/usr/bin/openssl req -x509 -newkey rsa:2048 -keyout /usr/local/directadmin/conf/cakey.pem -out /usr/local/directadmin/conf/cacert.pem -days 9000 -nodes
chown diradmin:diradmin /usr/local/directadmin/conf/cakey.pem
chmod 400 /usr/local/directadmin/conf/cakey.pem

vi /usr/local/directadmin/conf/directadmin.conf

SSL=1

systemctl restart directadmin.service

cd /usr/src

rm -fv csf.tgz

wget https://download.configserver.com/csf.tgz

tar -xzf csf.tgz

cd csf

sh install.sh

sudo iptables -L -n -v

mysql -u -root -p
mysql>
mysql> grant replication slave on \*.\* to slaveuser@'[private IP of srv01]' identified by '[some password]';
mysql> flush privileges;
mysql> exit
mysql> grant replication slave on \*.\* to slaveuser@'[private IP of srv02]' identified by '[some password]';
mysql> flush privileges;
mysql> exit

Editar el archivo /etc/mysql/my.cnf, en la máquina srv01:

bind-address = 0.0.0.0
server-id = 1
log-bin = /var/log/mysql/var/bin.log
log-slave-updates
log-bin-index = /var/log/mysql/log-bin.index
log-error = /var/log/mysql/error.log
relay-log = /var/log/mysql/relay.log
relay-log-info-file = /var/log/mysql/relay-log.info
relay-log-index = /var/log/mysql/relay-log.index
auto_increment_increment = 10
auto_increment_offset = 1
master-host = [private IP address of srv02]
master-user = [replication username]
master-password = [replication password]
replicate-do-db = <database name to be replicated>

Editamos el archivo, en la otra máquina:

bind-address = 0.0.0.0
server-id = 1
log-bin = /var/log/mysql/var/bin.log
log-slave-updates
log-bin-index = /var/log/mysql/log-bin.index
log-error = /var/log/mysql/error.log
relay-log = /var/log/mysql/relay.log
relay-log-info-file = /var/log/mysql/relay-log.info
relay-log-index = /var/log/mysql/relay-log.index
auto_increment_increment = 10
auto_increment_offset = 1
master-host = [private IP address of srv01]
master-user = [replication username]
master-password = [replication password]
replicate-do-db = <database name to be replicated>

Reiniciamos las dos bases de datos.

Comprobamos los logs y nos aseguramos de que no hay ningún error:

tail -f /var/lib/mysql/server.hostname.com.err (RedHat/CentOS)

Testear escenario MySQL Master/Master:

mysql> create database [nombre-db]
mysql> use [nombre-db]
mysql> create table foo (id int not null, username varchar(30) not null);
mysql> insert into foo values (1,'bar');