MySQL 5.7 復制的過濾參數有哪些

這篇文章將為大家詳細講解有關MySQL 5.7 復制的過濾參數有哪些，文章內容質量較高，因此小編分享給大家做個參考，希望大家閱讀完這篇文章后對相關知識有一定的了解。

1、庫級過濾參數

--binlog-do-db=db_name Master節點記錄二進制日志的庫

--binlog-ignore-db=db_name Master節點不記錄二進制日志的庫

--replicate-do-db=db_name Slave節點應用日志的庫

--replicate-ignore-db=db_name Slave節點不應用日志的庫

2、表級過濾參數

--replicate-do-table=db_name.tbl_name Slave節點執行指定表的修改事件

--replicate-wild-do-table=db_name.tbl_name Slave節點執行正則中含有指定表的修改事件

--replicate-ignore-table=db_name.tbl_name Slave節點不執行指定表的修改事件

--replicate-wild-ignore-table=db_name.tbl_name Slave節點不執行正則中含有指定表的修改事件

MySQL里面有啟動參數、系統參數，啟動參數通過show variables無法查詢到，可以在mysqld的選項中查到
例如關于二進制日志有Startup Options Used with Binary Logging、System Variables Used with Binary Logging兩種參數
上面所說的復制過濾參數均為啟動參數

設置參數
[root@localhost log]# mysqld --verbose --help > 02.txt
[root@localhost log]# vim 02.txt
..
  --binlog-do-db=name Tells the master it should log updates for the specified
                      database, and exclude all others not explicitly
                      mentioned.
..
  --binlog-ignore-db=name
                      Tells the master that updates to the given database
                      should not be logged to the binary log.
..
  --replicate-do-table=name
                      Tells the slave thread to restrict replication to the
                      specified table. To specify more than one table, use the
                      directive multiple times, once for each table. This will
                      work for cross-database updates, in contrast to
                      replicate-do-db.
[root@localhost log]# vim /etc/my.cnf
..
# log
server-id = 10000
log-bin = /log/binlog/mysql-bin
binlog_format = MIXED
binlog-do-db = test

啟動數據庫后，查看參數
mysql> show master status;
+------------------+----------+--------------+------------------+-------------------+
| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |
+------------------+----------+--------------+------------------+-------------------+
| mysql-bin.000009 |      120 | test         |                  |                   |
+------------------+----------+--------------+------------------+-------------------+
1 row in set (0.03 sec)

關于MySQL 5.7 復制的過濾參數有哪些就分享到這里了，希望以上內容可以對大家有一定的幫助，可以學到更多知識。如果覺得文章不錯，可以把它分享出去讓更多的人看到。