Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysqldump --databases profiles --single-transaction --triggers --routines --host=10.10.10.10 --port=3306 --user=user --password=pass > ~/dump.sql
- CHANGE MASTER TO MASTER_HOST="10.10.10.10", MASTER_PORT=3306, MASTER_USER="user", MASTER_PASSWORD="pass", MASTER_AUTO_POSITION=1 FOR CHANNEL "channel1";
- gtid_mode = ON
- enforce_gtid_consistency = true
- log_bin = /var/log/mysql/bin_log.index
- log_slave_updates = true
- server-id = 2061
- [client]
- port = 3306
- socket = /var/run/mysqld/mysqld.sock
- [mysqld_safe]
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/run/mysqld/mysqld.sock
- nice = 0
- [mysqld]
- user = mysql
- pid-file = /var/run/mysqld/mysqld.pid
- socket = /var/run/mysqld/mysqld.sock
- port = 3306
- basedir = /usr
- datadir = /var/lib/mysql
- tmpdir = /tmp
- lc-messages-dir = /usr/share/mysql
- server-id = 10001
- explicit_defaults_for_timestamp
- gtid_mode=ON
- enforce_gtid_consistency=true
- log_bin=/var/log/mysql/bin_log.index
- log_slave_updates=true
- master_info_repository=TABLE
- relay_log_info_repository=TABLE
- # Instead of skip-networking the default is now to listen only on
- # localhost which is more compatible and is not less secure.
- #bind-address = 127.0.0.1
- log-error = /var/log/mysql/error.log
- # Disabling symbolic-links is recommended to prevent assorted security risks
- symbolic-links=0
- $ sudo apt-get --purge remove mysql-client mysql-server mysql-common
- $ sudo apt-get autoremove
- $ sudo apt-get install mysql-server-5.7
- $ mysqldump -u username -p -h 10.10.10.10 --skip-lock-tables --single-transaction --triggers --routines --databases db01 > ~/dumpDB01.sql
- $ grep PURGED ~/dumpDB01.sql
- SET @@GLOBAL.GTID_PURGED='d23dceda-08a4-11e5-85e4-005056a2431f:1-10073';
- sudo vi /etc/mysql/my.cnf
- gtid_mode =ON
- enforce_gtid_consistency =true
- log_bin =/var/log/mysql/bin_log.index
- log_slave_updates =true
- master_info_repository =TABLE
- relay_log_info_repository =TABLE
- server-id =1001
- # Instead of skip-networking the default is now to listen only on
- # localhost which is more compatible and is not less secure.
- #bind-address = 127.0.0.1
- $ sudo touch /var/log/mysql/bin_log.index
- $ sudo chown mysql:mysql /var/log/mysql/bin_log.index
- $ sudo service mysql restart
- SET @@GLOBAL.GTID_PURGED='d23dceda-08a4-11e5-85e4-005056a2431f:1-10073';
- ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
- mysql> RESET MASTER;
- mysql> SET @@GLOBAL.GTID_PURGED='d23dceda-08a4-11e5-85e4-005056a2431f:1-10073,d23dceda-08a4-11e5-85e4-005056a2431f:1-10073,d23dceda-08a4-11e5-85e4-005056a2431f:1-10073';
- mysql> CHANGE MASTER TO MASTER_HOST="10.10.10.10", MASTER_PORT=3306, MASTER_USER="username", MASTER_PASSWORD="password", MASTER_AUTO_POSITION=1 FOR CHANNEL "db01";
- mysql> START SLAVE FOR CHANNEL "db01";
- mysql> SHOW SLAVE STATUS FOR CHANNEL "db01"G
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement