SQL: April 2018 Archives

若 Host A 與 Host B 之間有 table 需要 Sync, 資料量不大, 不需很即時, 還用不到 Replication, 可排程執行
mysqldump -h Host_A -uuser -ppassword db_name table_name | ssh Host_B "mysql -uuser -ppassword db_name"
(ssh 要先建好 Key)
若 Host A 有設定 gtid_mode=ON, mysqldump 需加上參數 --set-gtid-purged=OFF

About this Archive

This page is an archive of entries in the SQL category from April 2018.

SQL: October 2016 is the previous archive.

Find recent content on the main index or look in the archives to find all content.

Monthly Archives