Step 3 — Replication Configuration on Replication Server

• On Replication Server

• sudo nano /etc/mysql/my.cnf

• [mysqld]
  server-id = 2
  relay_log = /var/log/mysql/mysql-relay-bin.log
  replicate_do_db = your_database
  replicate_do_table = your_database.your_table