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

You are viewing an old version of this question. View the current version here.

Agenda and notes from day 2 of the MariaDB Developer Meeting in Athens, Greece.

Agenda

TimeMain TrackSide Track
09:00‑10:00Email & Hacking time (Public)
10:00-11:00GIS in MariaDB: Current status, upcoming milestones. (Public)
11:00‑11:15Small break
11:15-12:30Replication in MariaDB (Public)
12:30‑13:30Lunch
13:30‑14:00Email and hacking time.
14:00‑15:15Xentio Presentation (Public)
15:15‑15:45Coffee break
15:45-16:30MariaDB 5.3: Technical Status (Public)
16:30-17:30MariaDB 5.5: Planning (features, release theme, release dates, etc...) (Public)

Printed Schedule (pdf)

Notes

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.