Shulou(Shulou.com)06/01 Report--

Download the latest version of Navicat Premium

Navicat Premium is a management tool that can connect to multiple databases. It allows you to connect to MySQL, Oracle and PostgreSQL databases simultaneously with a single program, making it more convenient to manage different types of databases.

Unlike synchronization, synchronization is an one-time process that synchronizes the schema and data of two databases, and replication is a continuous (automatic) process of replicating data between two databases (although schema updates are also possible). Replication can occur asynchronously so that there is no need to establish a permanent connection between the two databases, or to replicate during off-peak hours (for example, late at night, where there is little traffic on the database server).

The primary role of replication is to create a consolidated repository of all user databases and / or to propagate the same level of information among all users. In both cases, the result is a distributed database where users can access data related to their tasks without interfering with the work of others. Database replication is called normalization in order to eliminate data ambiguity or inconsistency between users.

This article describes how to automate database replication using Navicat Premium's new automation utility.

Replication Typ

Database replication can be done in at least three different ways:

Snapshot replication: simply replicating data from one server to another database on the same server or on different servers.

Merge replication: merges data from two or more databases into one database.

Transactional replication: the user receives a complete initial copy of the database and then receives periodic updates when the data changes.

In a distributed database management system (DDBMS), changes, additions, and deletions to data in one location are automatically reflected in data stored in all other locations. Doing so ensures that each user accesses the same dataset as all other users.

Similar to synchronization, replication can be homogeneous or heterogeneous:

Homogeneity: same source and target DBS, that is, Percona to Percona,Mariadb to Mariadb,MySQL to MySQL.

Heterogeneous: different source and destination DBS, i.e. Oracle to Microsoft SQL Server, PostgreSQL, Amazon Dynamodb, MySQL to Amazon Aurora

A scenario that requires heterogeneous replication is when one or more external business partners use a different database type than our own. Automatic periodic data replication between two environments is usually part of this arrangement.

Navicat Advanced Automation Utility

Navicat Premium's new automation utility, introduced in version 12, has an easy-to-use and intuitive interface for creating automated batch jobs. Automation is the execution of a process at one or more periodic intervals, starting and ending at a specific date and time, just like the Windows task scheduler. In addition to replication, it can also be used for a variety of jobs, including backups, queries, and reports.

Figure 1:Navicat Premium 12 Automation utility in Windows

Figure 2:Navicat Premium 12 Automation utility in macOS

User database

We will use Sakila Sample MySQL Database as our user database. It is created specifically to provide a standard model for books, tutorials, articles, and so on.

It focuses on the film industry and covers everything from actors and film studios to video rental stores.

Sakila MySQL database structure in Navicat Premium 12

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.