MySQL master/slave configurations
Posted: Fri Oct 26, 2012 1:53 pm
For thoose who are interested, i compiled 2 example configurations for a master/slave setup.
One is a simple "Master/Slave Replication"(1 Master & 3 Slaves) setup and the other is a "Circular Replication" setup where every server(4 servers) is master and slave.
The binary MySQL distribution goes into "server_app"("bin", "data", "scripts" and "share" folders are required from the binary MySQL distribution).
The other folders contain the replication configuration examples. Each contains a "manager" folder where a "main.bat" file is located which you can
start to clean, start and stop the servers in the setup.
I have no manager scripts for linux to download and get started out of the box.
To test this on linux, you should copy the "data" folder from "server_app" to the server folders in each configuration folder(circular_master_slave, master_slave), where also the my.ini files for the server configurations are stored.
The copied folder should be set as data folder and the my.ini file as defaults file.
One is a simple "Master/Slave Replication"(1 Master & 3 Slaves) setup and the other is a "Circular Replication" setup where every server(4 servers) is master and slave.
The binary MySQL distribution goes into "server_app"("bin", "data", "scripts" and "share" folders are required from the binary MySQL distribution).
The other folders contain the replication configuration examples. Each contains a "manager" folder where a "main.bat" file is located which you can
start to clean, start and stop the servers in the setup.
I have no manager scripts for linux to download and get started out of the box.
To test this on linux, you should copy the "data" folder from "server_app" to the server folders in each configuration folder(circular_master_slave, master_slave), where also the my.ini files for the server configurations are stored.
The copied folder should be set as data folder and the my.ini file as defaults file.