Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Create 3 empty MariaDB servers with the following configurations:
- This procedure was tested with the MariaDB 10.1.8 Stable deb package available at http://mirror.edatel.net.co/mariadb/mariadb-10.1.8/repo/ubuntu
- SETTING: Server_id: 1 | Domain_id: 1 | IP: 10.0.3.223
- STOP ALL SLAVES;
- CHANGE MASTER "M_2" TO
- master_host = "10.0.3.136",
- master_user = "replicator",
- master_use_gtid = slave_pos,
- master_password = "pass",
- do_domain_ids = (2);
- CHANGE MASTER "M_3" TO
- master_host = "10.0.3.171",
- master_user = "replicator",
- master_use_gtid = slave_pos,
- master_password = "pass",
- do_domain_ids = (3);
- START ALL SLAVES;
- SETTING: Server_id: 2 | Domain_id: 2 | IP: 10.0.3.136
- STOP ALL SLAVES;
- CHANGE MASTER "M_1" TO
- master_host = "10.0.3.223",
- master_user = "replicator",
- master_use_gtid = slave_pos,
- master_password = "pass",
- do_domain_ids = (1);
- CHANGE MASTER "M_3" TO
- master_host = "10.0.3.171",
- master_user = "replicator",
- master_use_gtid = slave_pos,
- master_password = "pass",
- do_domain_ids = (3);
- START ALL SLAVES;
- SETTING: Server_id: 3 | Domain_id: 3 | IP: 10.0.3.171
- STOP ALL SLAVES;
- CHANGE MASTER "M_1" TO
- master_host = "10.0.3.223",
- master_user = "replicator",
- master_use_gtid = slave_pos,
- master_password = "pass",
- do_domain_ids = (1);
- CHANGE MASTER "M_2" TO
- master_host = "10.0.3.136",
- master_user = "replicator",
- master_use_gtid = slave_pos,
- master_password = "pass",
- do_domain_ids = (2);
- START ALL SLAVES;
- Wait for all replications to be actually active them issue the following command on server 1:
- OPTIMIZE TABLE mysql.user;
- This command will be asigned a GTID 1-1-X
- After that, look on binlogs of servers 2 and 3. On at least one of them you will find this same command with GTID 2-1-Y or 3-1-Y
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement