SQL REPLICATION

I learned about SQL replication today, so I’m going to post this topic today on my blog.

• definition of Replication:
  Imagine about copy. The replication on SQL is the same as copy.

• the process of Replication:

First, you have to create each master and slave server on AWS website. You can also create various slave servers.

Second, using the public IP addresses of master and slave server, connect each server on git bash.
Use the command ssh -i ~/.ssh/[key pair name].pem ubuntu@[public IP address]. (You should install ubuntu before.)

Third, on master and slave server, install MySQL and connect MySQl and server.Create the new account of MySQL on git bash.

Fourth, on MySQL that connected with master server on git bash, create database.

Fifth, come back MySQL program and create new connections with master and slave servers.

Sixth, on the master DB connection of MySQL, type some queries to connect with the slave DB connection.

Seventh, insert some data on the master DB.

Eighth, check if the replication is successful on the slave DB connection.

If you see the yes on the slave status, you succeed!!!!! You’re done!