Advertisement
Guest User

Untitled

a guest
Mar 17th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.59 KB | None | 0 0
  1. [mysqld]
  2. console
  3. datadir=e:/gr/n1/data
  4. basedir=e:/mysql-5.7.17-winx64
  5. tmpdir=e:/gr/n1
  6. port=3306
  7. server_id=1
  8. gtid_mode=ON
  9. enforce_gtid_consistency=ON
  10. master_info_repository=TABLE
  11. relay_log_info_repository=TABLE
  12. transaction_isolation=READ-COMMITTED
  13. binlog_checksum=NONE
  14. log_slave_updates=ON
  15. log_bin=binlog
  16. binlog_format=ROW
  17. transaction_write_set_extraction=XXHASH64
  18. loose-group_replication_group_name="aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa"
  19. loose-group_replication_start_on_boot=OFF
  20. loose-group_replication_local_address="127.0.0.1:24901"
  21. loose-group_replication_group_seeds="127.0.0.1:24901,127.0.0.1:24902,127.0.0.1:24903"
  22. loose-group_replication_bootstrap_group=OFF
  23. loose-group_replication_single_primary_mode=ON
  24. disabled_storage_engines=MyISAM,BLACKHOLE,FEDERATED,ARCHIVE,MEMORY,MRG_MYISAM,CSV
  25.  
  26.  
  27. [to setup the group..]
  28. SET SQL_LOG_BIN=0;
  29. FLUSH PRIVILEGES;
  30. CREATE USER rpl_user@'%';
  31. GRANT REPLICATION SLAVE ON *.* TO rpl_user@'%' IDENTIFIED BY 'rpl_pass';
  32. FLUSH PRIVILEGES;
  33. SET SQL_LOG_BIN=1;
  34. CHANGE MASTER TO MASTER_USER='rpl_user', MASTER_PASSWORD='rpl_pass' FOR CHANNEL 'group_replication_recovery';
  35.  
  36. INSTALL PLUGIN group_replication SONAME 'group_replication.dll';
  37. SHOW PLUGINS;
  38.  
  39. SET GLOBAL group_replication_bootstrap_group=ON;
  40. START GROUP_REPLICATION;
  41. SET GLOBAL group_replication_bootstrap_group=OFF;
  42. SELECT * FROM performance_schema.replication_group_members;
  43. drop database if exists test;
  44. CREATE DATABASE if not exists test;
  45. use test;
  46. drop table if exists t1;
  47. CREATE TABLE t1 (c1 INT PRIMARY KEY, c2 blob)ENGINE=InnoDB;
  48. insert into t1 values(1,'hollow');
  49. SHOW BINLOG EVENTS;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement