Shulou(Shulou.com)06/01 Report--

I. binlog mode

Templates versions of mysql 5.6 and above do not provide binlog templates. You can only use gtid mode by default. You can consider making your own templates to copy with binlog.

1. Edit / etc/trove/trove-taskmanager.conf

[DEFAULT]... template_path = / etc/trove/templates/...

2. Check the version of mysql

Trove datastore-list+--+-+ | ID | Name | +-- +-+ | b10f2f73 -77cd-484c-9105-a33bc56e0fa4 | mysql | +-- +-- + trove datastore-version-list mysql+--+-+ | ID | | Name | +-+-+ | 4ee1da20-df29-4e88-b3eb-795b2f4c12f2 | mysql-5.6 | | a52b6fac-2601-4b5b-837c-95d5507d0269 | mysql-5.5 | +-| -+

3. Copy the mysql configuration file template and execute it on the node running trove-taskmanager.

Cp-r trove/templates/ / etc/trove/cd / etc/trove/templates/mysqlcp-r 5.5 mysql-5.5 # mysql-5.5 is determined based on datastore-version-list output

4. Edit / etc/trove/trove-guestagent.conf

[mysql]... replication_strategy = MysqlBinlogReplicationreplication_namespace = trove.guestagent.strategies.replication.mysql_binlog

II. Gtid mode

Does not apply to mysql 5.5 MySQL 5.5 does not support gtid replication

1. Edit / etc/trove/trove-taskmanager.conf

[DEFAULT]... template_path = / etc/trove/templates/...

2. Copy the mysql configuration file template and execute it on the node running trove-taskmanager

Cp-r trove/templates/ / etc/trove/

3. Edit / etc/trove/trove-guestagent.conf

[mysql]... replication_strategy = MysqlGTIDReplicationreplication_namespace = trove.guestagent.strategies.replication.mysql_gtid

Third, create replication

1 、 mysql 5.5

Trove create ab 6-size 5-databases myDB\-users userA:password-datastore_version mysql-5.5\-datastore mysqltrove create ab-slave1 6-size 5-replica_of ab--replica_count 1\-datastore_version mysql-5.5-datastore mysql

2 、 mysql 5.6

Trove create ab 6-size 5-databases myDB\-users userA:password-datastore_version mysql-5.6\-datastore mysqltrove create ab-slave1 6-size 5-replica_of ab--replica_count 1\-datastore_version mysql-5.6-datastore mysql

IV. Reference links:

Https://ly798.github.io/2017/01/20/trove-mysql-replication/

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.