Advertisement
Guest User

Untitled

a guest
Oct 25th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.06 KB | None | 0 0
  1. mysqldump --databases profiles --single-transaction --triggers --routines --host=10.10.10.10 --port=3306 --user=user --password=pass > ~/dump.sql
  2.  
  3. 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";
  4.  
  5. gtid_mode = ON
  6. enforce_gtid_consistency = true
  7. log_bin = /var/log/mysql/bin_log.index
  8. log_slave_updates = true
  9. server-id = 2061
  10.  
  11. [client]
  12. port = 3306
  13. socket = /var/run/mysqld/mysqld.sock
  14.  
  15. [mysqld_safe]
  16. pid-file = /var/run/mysqld/mysqld.pid
  17. socket = /var/run/mysqld/mysqld.sock
  18. nice = 0
  19.  
  20. [mysqld]
  21. user = mysql
  22. pid-file = /var/run/mysqld/mysqld.pid
  23. socket = /var/run/mysqld/mysqld.sock
  24. port = 3306
  25. basedir = /usr
  26. datadir = /var/lib/mysql
  27. tmpdir = /tmp
  28. lc-messages-dir = /usr/share/mysql
  29. server-id = 10001
  30. explicit_defaults_for_timestamp
  31.  
  32. gtid_mode=ON
  33. enforce_gtid_consistency=true
  34. log_bin=/var/log/mysql/bin_log.index
  35. log_slave_updates=true
  36. master_info_repository=TABLE
  37. relay_log_info_repository=TABLE
  38.  
  39.  
  40. # Instead of skip-networking the default is now to listen only on
  41. # localhost which is more compatible and is not less secure.
  42. #bind-address = 127.0.0.1
  43.  
  44. log-error = /var/log/mysql/error.log
  45.  
  46. # Disabling symbolic-links is recommended to prevent assorted security risks
  47. symbolic-links=0
  48.  
  49. $ sudo apt-get --purge remove mysql-client mysql-server mysql-common
  50. $ sudo apt-get autoremove
  51.  
  52. $ sudo apt-get install mysql-server-5.7
  53.  
  54. $ mysqldump -u username -p -h 10.10.10.10 --skip-lock-tables --single-transaction --triggers --routines --databases db01 > ~/dumpDB01.sql
  55.  
  56. $ grep PURGED ~/dumpDB01.sql
  57. SET @@GLOBAL.GTID_PURGED='d23dceda-08a4-11e5-85e4-005056a2431f:1-10073';
  58.  
  59. sudo vi /etc/mysql/my.cnf
  60.  
  61. gtid_mode =ON
  62. enforce_gtid_consistency =true
  63. log_bin =/var/log/mysql/bin_log.index
  64. log_slave_updates =true
  65. master_info_repository =TABLE
  66. relay_log_info_repository =TABLE
  67. server-id =1001
  68.  
  69. # Instead of skip-networking the default is now to listen only on
  70. # localhost which is more compatible and is not less secure.
  71. #bind-address = 127.0.0.1
  72.  
  73. $ sudo touch /var/log/mysql/bin_log.index
  74. $ sudo chown mysql:mysql /var/log/mysql/bin_log.index
  75. $ sudo service mysql restart
  76.  
  77. SET @@GLOBAL.GTID_PURGED='d23dceda-08a4-11e5-85e4-005056a2431f:1-10073';
  78.  
  79. ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
  80.  
  81. mysql> RESET MASTER;
  82.  
  83. 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';
  84.  
  85. 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";
  86.  
  87. mysql> START SLAVE FOR CHANNEL "db01";
  88. mysql> SHOW SLAVE STATUS FOR CHANNEL "db01"G
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement