Good Day I need some advice with regards to what the best procedure would be to move from two existing MySQL servers to a single new server.
The old machines are running Red Hat Enterprise Linux ES release 3 with MySQL 3.23.58 The new machine is running Red Hat Enterprise Linux Server release 5 with MySQL 5.0.22 The data is approximately 30GB in size and we can't afford down-time so the cut-over between the servers have to as seamless and quickly as possible. I have already configured replication between one of the old servers and the new one. The databases on the two servers all have different names. I can normally replicate the previous day's data in less than 1 hour. My problem is how to add the second server's data to the new MySQL server and keep it current since the sites are located approximately 30km apart. Restoring backups are out of the question since they will have to be created, fetched and then restored. Would it be possible to set up the replication or write a script on the new machine to do the following: - Load saved replication data for server 1 (Excluding databases on server 2) - Start replication - Wait 30 minutes - Stop replication - Save last executed log and position for server 1 - Load saved replication data for server 2 (Excluding databases on server 1) - Start replication - Wait 30 minutes - Stop replication - Save last executed log and position for server 2 - ... Repeat ... This will mean that the new server will have a copy of all of the databases on server 1 and 2 and will be 30 minutes behind them at the most. I can then change the script to switch between the two servers every 5 minutes and run it until it is up-to date after which we will do the cut-over. Marthinus _______________________________________________ rhelv5-list mailing list [email protected] https://www.redhat.com/mailman/listinfo/rhelv5-list
