By murrayhall
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
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!
<b>“… as this a whole new world to me having never done anything like this.”</b> <br> <br>Not to undermine what you’re trying to do, and how you’re trying to do it; but, what are you trying to accomplish? What’s the end goal here? I only ask b/c there <i>may</i> be an easier, or more efficient, way of accomplishing the same thing.
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and SMBs
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.