The Ultimate Guide to High Availability with MariaDB

How can I Move (migrate) a Replication Server (MariaDB) to a new Hardware and OS.

I have a server (Master) and 5 clients (slaves). The replication work’s fine. Now I must migrate the Server/Master Database to a new System. How can I move/migrate the old Master DB to the new Hardware?

1: Install MariaDB on new System. 2: Create all Table and so on on ew system. 3: Stop replikation on old Server 4: export all Tabledata from old Server and import to the new server 5: Start Replikation with the new Server IP ???

Answer Answered by Ian Gilfillan in this comment.

Essentially yes, although importing and creating the tables are usually done at the same time.

You can also run the new master as a slave at first, and then switch to using it as the new master (this might save you some disruption to your environment). See https://dev.mysql.com/doc/refman/5.5/en/replication-solutions-switch.html for a description of this process.

Comments

Comments loading...
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.