recovery with binlogs?

Posted on

Question :

I would like to know if there is a way that I can restore my databases, I don’t have a replication and I would like to migrate my databases without downtime or losing data.
So with binlogs could I do that? I have in my new server already a database but is kinda old, could this be possible.
Thanks in advance

Answer :

if you want to finish your database migration onlineļ¼Œ replication is necessary.

The common practice for database migration is building replication between your old mysql and new mysql(as slave). When the slave catch the master, switch your business to the mysql(slave).

if you just want to use binlog , you need to lock table during your migrating the database, or you will loss some data.

Leave a Reply

Your email address will not be published. Required fields are marked *