Hi, i need some help with setting up replication of My Sql DB’s. It’s one master and 1 slave server. What lines are required in the Master server .ini, what i ahve so far is
[wampmysqld] port = 3306 socket = /tmp/mysql.sock key_buffer = 16M max_allowed_packet = 16M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M
query_cache_size = 8M join_buffer_size = 128K thread_cache_size = 4
basedir=c:/wamp/bin/mysql/mysql5.5.20 log-error=c:/wamp/logs/mysql.log log-bin=mysql-bin server-id=1000 datadir=c:/wamp/bin/mysql/mysql5.5.20/data
Secondly what do i need to add to the slave .ini file, and where do i place these lines
These are Windows servers, WAMP server inside that.
I really appreciate any help guidance as this a whole new world to me having never done anything like this. Thanks in advance
These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.
Click below to sign up and get $100 of credit to try our products over 60 days!