I need help from my fellow mysql users. I know some of the people who read this are alot better then me with mysql so hopefully you can help
So today we decided that we are going to migrate one of our master database servers to new hardware. Since we got the hardware this morning and we wanted to move on to it asap, we decided that we will take our slave down, copy data from it, and bring it up on future master server. At that point, we will let it run as slave to the current master server until its time for us to take it down. Reason we did that instead of mysqldump/import was to avoid the lag mysqldump creates on our server.
After we did all this and put up the new master server, we started to notice odd issues. After looking around and comparing old db with new, we found out that new db[Read more...]