The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-16. For the latest, interactive version please visit https://mariadb.com/kb/.

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.

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.