Hi Tom,
For minimal downtime, you could build your new cluster and then add a
node as a slave to your existing host, sounds like that's your plan.
This will then allow data to flow over to the cluster. Once your happy
it's replicating ok then do an orderly switchover and forget the
original master. Downtime is maybe 10 minutes on a slow day depending
on what effort to repoint your application layer. Also, you can
probably bring up a single app node initially much quicker and add your
remaining nodes more leisurely. Allows you to check for errors on your
app layer through a single node and control things
I would use Percona Xtrabackup to make our backup. It's much quicker
and I found much better to MySQLDump unless it's presently only a small
database. Will also carry over your GTID etc for sync. I have some
notes on my blog on my switchovers
Cheers
Peter
On Wed, 6 Nov 2019 at 00:55, Tom Worster <fsb@xxxxxxxxxx> wrote:
I've three servers with Debian 9, Maria 10.1 and running a Galera
cluster.
We're upgrading the hardware by getting three new servers. They will
have Debian 10 and Maria 10.3.
What are my options for accomplishing this with minimal service
downtime?
One option I can think of
Using a mysqldump snapshot, set up Maria on one of the new servers to
replicate as an asyncronous slave from one node of the existing
cluster.Set up Maria on the two remaining new servers in a cluster
with that async slave.When all looks good, migrate workload to the new
cluster.
Does that seem reasonable?
Tom
_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to : maria-discuss@xxxxxxxxxxxxxxxxxxx
Unsubscribe : https://launchpad.net/~maria-discuss
More help : https://help.launchpad.net/ListHelp
--
Peter McLarty
Leader and Technologist
0402094238
http://petermclarty.setmore.com/
