Each migration was to happen on different days. All of them were to be consolidated onto one set of database servers. The databases resided on two sets of database servers. We had to move several hundred gigabytes of data onto new production servers. I was recently involved in a large database migration project. Using MySQL Master Master Replication to Facilitate Database Migrations Use cases for MySQL Master Master Replication This tutorial assumes that it is a new configuration where everything is being set up in advance of the application hitting the database servers. In this tutorial we’ll cover a basic example of three servers two masters and one slave but first let’s understand why we might want to set up chained replication with mysql. Take a look at this diagram which helps to illustrate one possible configuration.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |