To back up data in a timely manner, you can use full backup + differential backup or log backup. This article introduces how to use the database replication technology to synchronize data:
PS: The article focuses on images. The pictures show the operation steps and configuration methods more intuitively!
1. First create a test database named FA_BU to publish data. Because it is a demo, there are two fields.
2. Release the database. Here I will release the local FA_BU database.
3. Local subscription. You can select another server.
In the next step, select the server to be released:
The create database dialog box is displayed when you select "create database" as follows:
Next, you need to set the access permission. Click the button next to it to go to the settings page:
Set Schedule as follows:
4. Now let's test it. First query the data in the two databases and we can find that the data is empty.
INSERT a piece of data in the FA_BU database,
Query the data of the two databases again and find that the data has been synchronized, as shown in the following figure: