I have a setup with one master mysql server and three read-only slaves (all mariadb 5.5 on centos 7). Now I want to move the master server to a new hardware, so I need to replace the old master with the new server in the replication setup.
How can I do this without too much downtime and without a need to ‘mysqldump’ all databases again to the slaves.
I don’t have MariaDB 10.0 or later, so multimaster replication is not a option at the moment.