Question

Replication of MySQL DB on Windows 2008 R2

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

The MySQL server

[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


Submit an answer

This textbox defaults to using Markdown to format your answer.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!

Sign In or Sign Up to Answer

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.

reply <br>

<b>“Yes, that’s more aimed at unix.”</b> <br> <br>This entire <i>company</i> is aimed @ Linux (not just the article). Given that most people wouldn’t walk into a hardware store and ask for a good dinner recipe. Why not ask your ?s in a Windows Server forum(s)?