Level 37
Look into replication and setting up a second DB server using MySQL's built in functionality (https://dev.mysql.com/doc/refman/8.0/en/replication.html)
Jul 3, 2020
1
Level 3
database clone in real time
The Problem: I have a medium size database that has records every few seconds, the data is very important I would like to keep a clone of the database in the real time.
-
Database: Mysql 5.7
-
Remote access allowed: Yes
-
Please note that I cannot install any third party application on the Master Operating System.
What are the solutions ?
Please or to participate in this conversation.