Pasos¶

configurar el firewall para aceptar peticiones TCP en los puertos 3306, 4567, 4568 y 4444
instalar mariadb-server y mariadb-client
1. ejecutar secure_installation
configurar los hosts en /etc/hosts y colocar la estructura descrita en hosts
configurar galera en /etc/mysq/conf.d/galera.cnf
1. Escribir lo escrito en galera.cnf

hosts¶

<node_ip>   <node_name>
...
<node_ip>   <node_name>

galera.cnf¶

[mysqld]
binlog_format=ROW
default-storage-engine=innodb
innodb_autoinc_lock_mode=2
bind-address=0.0.0.0

# Galera Provider Configuration
wsrep_on=ON
wsrep_provider=<WSREP_install_dir>

# Galera Cluster Configuration
wsrep_cluster_name="test_cluster"
wsrep_cluster_address="gcomm://<nodes_ip>"

# Galera Synchronization Configuration
wsrep_sst_method=rsync

# Galera Node Configuration
wsrep_node_address="<curr_node_ip>"
wsrep_node_name="<node_name>"

Demostración¶

sudo nano /etc/hosts

    3.139.99.96    batman
    13.58.37.253   superman

sudo nano /etc/mysql


NODO MSB                                                    NODO LSB
sudo systemctl stop mysql                                   sudo systemctl stop mysql
galera_new_cluster                                          galera_new_cluster

-                                                           sudo mysql -u root -p -e 'SHOW SCHEMAS;';
mysql -u root -p -e '                                   
DROP SCHEMA IF EXISTS PlayGround;
CREATE SCHEMA PlayGround;
CREATE TABLE PlayGround.Equipment ( id INT NOT NULL AUTO_INCREMENT, type VARCHAR(50), quant INT, color VARCHAR(25), PRIMARY KEY(id));
INSERT INTO PlayGround.Equipment (type, quant, color) VALUES ("slide", 2, "blue");'

-                                                           mysql -u root -p -e 'SELECT * FROM PlayGround.Equipment;'
-                                                           mysql -u root -p -e 'INSERT INTO PlayGround.Equipment (type, quant, color) VALUES ("swing", 10, "yellow");'

mysql -u root -p -e 'SELECT * FROM PlayGround.Equipment;'