How to organize a MySQL database move?

Question

linux

There is a 700GB MySQL database, everything is in 1 file - ibdata1
The current server is limited in terms of disk space, the database is slowly filling up, it becomes relevant to transfer the database to a new server with more disk storage, and also make sure that the tables in the database are separate files.
How to do it right? With minimal downtime.
Thanks in advance!

Answer 1

You can very quickly transfer the database with all the data Disable
writing
Transferring data
mysqldump -uroot DB |
mysql --host= host.com -uroot -ppass -C
DB

Answer 2

master -> slave or master-> master
on the same MariaDB Galera Cluster
can be freely transferred .. the only thing of course, when transferring to the record, there will be a lock ...