I'm setting up a mariadb galera cluster to ultimately switch production to. However, I don't have the ability to stop the production instance so I'm trying to set this up using various workarounds I've come across. The current setup relies on a pair of mariadb servers as a master/slave pair. I've added a 3rd mariadb server and I'm restoring a full backup to third, empty server.
To backup the server I executed the following:
mysqldump -u root -p --all-databases --master-data=2 | gzip > backup.sql.gz
once the new server was ready, I restored the database:
zcat backup.sql.gz | mysql -u root --port=3309 --socket=/var/run/mysqld/mysqld400.sock
When I log into mysql and do a show databases, I don't see anything other than the default db's (information, performance, and mysql). I stopped and restarted mariadb and it still the same. Is there another step I need to point to the data that was just restored?
backup.sql.gz
are what you think they are? – mustaccio Jun 4 '19 at 18:10