How to connect to the database (it's on a VPS) to another site?

Question

MySQL

You need to move your website from hosting to VPS. I do not want to turn it off, especially since orders are made by visitors all the time and the database is replenished.
Is it possible to transfer a database dump to a VPS and immediately switch the database on the old site to the VPS one? How to do it?
And then change the DNS servers, thus minimizing the difference in orders in the database for the duration of the database transfer and updating the DNS servers?

Answer 1

Of course, I would recommend doing replication from hosting to VPS, otherwise you will still lose data during the transfer, this is the first thing.
And secondly, there are no such options so that right without stopping the service, in any case, you will need to slow down the service, hang up a message stating that you are in service and during this time change everything at once, and test it in parallel.
And do not be afraid to lose a couple of tens or hundreds of orders, it's better than when people order, pay, and then it turns out that their goods are lost. The same Apple store is generally turned off for many hours even in order to add one item of goods.

Answer 2

Replication:
https://ruhighload.com/post/%D0%A8%D0%B0%D1%80%D0%...
https://ruhighload.com/post/%D0%A0%D0%B5%D0 %BF%D0%...
https://ruhighload.com/post/%D0%9A%D0%B0%D0%BA+%D0...

Answer 3

> Is it possible to transfer a database dump to a VPS and immediately switch the database on the old site to the VPS-vskuyu? How to do it?
yes, you can, just specify the remote database connection address and port instead of "localhost" in the CMS settings.
don't forget to open the DBMS port on the VPS