I'm new to MySQL load balancing, I want to try the master-slave concept.
Whenever I setup master-slave for the first time, and both have up-to-date fresh data, that works perfectly fine. However, whenever the master goes down, or I stop and then restart it, the slave starts generating errors because of duplicate keys.
Why would this be happening and how can I prevent this?
My application has a lot of update queries something like 5
SELECTs then 3
My data will grow with time and I'm expecting quite a high load in the future.