Go to Qiita Advent Calendar 2024 Top
LoginSignup
9
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?

More than 5 years have passed since last update.

グレンジAdvent Calendar 2017

Day 2
@s1na9ak1inサムザップ

Tungsten Replicator 5.0 を MySQL/MySQL のレプリケーション

Last updated at Posted at 2017-12-01

グレンジ Advent Calendar 2017 2日目の記事を担当しました、s1na9ak1 と申します。
グレンジでサーバサイドエンジニアをしております。

今回は、Tungsten Replicator 5.0 を使って MySQL / MySQL のレプリケーションをした内容の記事になります。

概要

Tungsten Replicator 5.0 で Master/Slave レプリケーションを行う。
Master 1台、スレーブ1台でレプリケーションを行う。
また、DatabaseはMySQLを使用します。

99f88091-f36c-29a1-1f1f-4d10dd1a52ee.png

準備

インスタンス

gce でインスタンスを用意しました。

  • Staging
    • インスタンスID: tungsten-staging-02
    • 内部IP: 10.64.0.10
  • Host
    • インスタンスID: tungsten-host-02
    • 内部IP: 10.64.0.8
  • 共通
    • OS: CentOS 6
    • ゾーン：asia-east1-b
    • ネットワーク： tmp

インストール

共通

  • Ruby
[tungsten-staging-02 ~]$ sudo yum install ruby
Installing:
 ruby                         x86_64             1.8.7.374-5.el6             base             538 k
Installing for dependencies:
 compat-readline5             x86_64             5.2-17.1.el6                base             130 k
 ruby-libs                    x86_64             1.8.7.374-5.el6             base             1.7 M
  • Mysql-server
[test@tungsten-staging-02 ~]$ sudo yum install mysql-server
Installing:
 mysql-server               x86_64             5.1.73-8.el6_8                base             8.6 M
Installing for dependencies:
 mysql                      x86_64             5.1.73-8.el6_8                base             895 k
 perl-DBD-MySQL             x86_64             4.013-3.el6                   base             134 k
 perl-DBI                   x86_64             1.609-4.el6                   base             705 k
  • Java
[test@tungsten-staging-02 ~]$ wget --no-cookies --no-check-certificate --header "Cookie: gpw_e24=http%3A%2F%2Fwww.oracle.com%2F; oraclelicense=accept-securebackup-cookie" "http://download.oracle.com/otn-pub/java/jdk/7u79-b15/jdk-7u79-linux-x64.rpm" -O jdk-7u79-linux-x64.rpm
[test@tungsten-staging-02 ~]$ sudo rpm -ivh jdk-7u79-linux-x64.rpm
[test@tungsten-staging-02 ~]$ java -version
java version "1.7.0_79"
Java(TM) SE Runtime Environment (build 1.7.0_79-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)

構成

Staging 構成

8d28c170-5dfd-a89b-a76e-22b10f29d750.png

１．実行ユーザ作成

[test@tungsten-staging-02 ~]$ sudo adduser tungsten

２．mysql グループに追加

[test@tungsten-staging-02 ~]$ sudo usermod -G mysql tungsten

３．tungsten ユーザ編集

[test@tungsten-staging-02 ~]$ sudo passwd -u -f tungsten

４．ログイン

[test@tungsten-staging-02 ~]$ su - tungsten

５．ssh キー作成

[tungsten@tungsten-staging-02 ~]$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/tungsten/.ssh/id_rsa):
Created directory '/home/tungsten/.ssh'.
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/tungsten/.ssh/id_rsa.
Your public key has been saved in /home/tungsten/.ssh/id_rsa.pub.
The key fingerprint is:
2c:f4:b8:ef:79:32:6d:2c:cf:b9:16:9c:7d:10:4c:9c tungsten@tungsten-staging-02
The key's randomart image is:
+--[ RSA 2048]----+
|           +..   |
|            E    |
|      .      .   |
|     . +    .    |
|      o S. o .   |
|       o  + . .  |
|      .  o . .   |
|       .+o*.     |
|       .+O=.     |
+-----------------+

６．tungsten インストールディレクトリ作成

[test@tungsten-staging-02 ~]$ sudo mkdir -p /opt/continuent/software/conf
[test@tungsten-staging-02 ~]$ sudo chown tungsten.tungsten /opt/
[test@tungsten-staging-02 ~]$ sudo mkdir -p /opt/continuent/software/replicator.conf
[test@tungsten-staging-02 ~]$ export CONTINUENT_PROFILES=/opt/continuent/software/conf
[test@tungsten-staging-02 ~]$ export REPLICATOR_PROFILES=/opt/continuent/software/replicator.conf

Host 構成

１．ユーザ作成

[test@tungsten-host-02 ~]$ sudo adduser tungsten
[test@tungsten-host-02 ~]$ sudo usermod -G mysql tungsten
[test@tungsten-host-02 ~]$ sudo passwd -u -f tungsten

２．sudo実行権限

[test@tungsten-host-02 ~]$ sudo visudo
tungsten ALL=(ALL)      ALL

３．/etc/security/limits.conf 編集

[tungsten@tungsten-host-02 ~]$ sudo vi /etc/security/limits.conf
tungsten         -       nofile          65535
mysql            -       nofile          65535
tungsten         -       nproc           8096
mysql            -       nproc           8096

４．/tmp パーミッション変更

[tungsten@tungsten-host-02 ~]$ sudo chmod 777 /tmp/

５．tungsten 認証キーを設置

[tungsten@tungsten-host-02 ~]$ mkdir .ssh
[tungsten@tungsten-host-02 ~]$ chmod 700 ~/.ssh
[tungsten@tungsten-host-02 ~]$ vi .ssh/authorized_keys
[tungsten@tungsten-host-02 ~]$ chmod 600 ~/.ssh/*
[tungsten@tungsten-host-02 ~]$ chmod 600 ~/.ssh/*

６．sshでログイン

[tungsten@tungsten-staging-02 ~]$ ssh tungsten@tungsten-host-02
The authenticity of host 'tungsten-host-02 (10.64.0.11)' can't be established.
RSA key fingerprint is 53:f1:8e:46:db:c4:cf:c0:96:c9:82:15:69:82:b2:a8.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'tungsten-host-02,10.64.0.11' (RSA) to the list of known hosts.
[tungsten@tungsten-host-02 ~]$

７．tungsten作業ディレクトリ作成

[tungsten@tungsten-host-02 ~]$ sudo mkdir /opt/continuent
[tungsten@tungsten-host-02 ~]$ sudo chown tungsten /opt/continuent
[tungsten@tungsten-host-02 ~]$ sudo chmod 700 /opt/continuent

MySQL設定

my.conf

  • Staging
[test@tungsten-staging-02 ~]$ cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

server-id = 1
open_files_limit = 65535
log-bin = mysql-bin
sync_binlog = 1
max_allowed_packet = 52m
default-storage-engine = InnoDB
innodb_flush_log_at_trx_commit = 2
innodb_flush_method=O_DIRECT
binlog-format = row

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
  • Host
[test@tungsten-staging-02 ~]$ cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

server-id = 2
open_files_limit = 65535
log-bin = mysql-bin
sync_binlog = 1
max_allowed_packet = 52m
default-storage-engine = InnoDB
innodb_flush_log_at_trx_commit = 2
innodb_flush_method=O_DIRECT
binlog-format = row

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

※ my.conf 更新後は、mysqlを再起動しておく

MySQLユーザ作成

  • Staging/Host 共通

１．起動

[test@tungsten-staging-02 ~]$ sudo /etc/init.d/mysqld start

２．ユーザ作成

[test@tungsten-staging-02 ~]$ mysql -uroot
mysql> CREATE USER tungsten@'%' IDENTIFIED BY 'tungsten';
Query OK, 0 rows affected (0.01 sec)

mysql> GRANT ALL ON *.* TO tungsten@'%'  WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

tungsten 設置

１．ダウンロード

[tungsten@tungsten-staging-02 ~]$ wget https://sourceforge.net/projects/tungsten-replicator.mirror/files/v5.0.1/tungsten-replicator-5.0.1-138.tar.gz/download
[tungsten@tungsten-staging-02 ~]$ mv download tungsten-replicator-5.0.1-138.tar.gz

２．コピー、解凍

[tungsten@tungsten-staging-02 ~]$ cp ./tungsten-replicator-5.0.1-138.tar.gz /opt/continuent/software/.
[tungsten@tungsten-staging-02 software]$ tar zxf tungsten-replicator-5.0.1-138.tar.gz

tungsten

tpm・trepctl・thl コマンド

  • レプリケーション開始 tpm start + SERVICE NAME
  • レプリケーション停止 tpm stop + SERVICE NAME
  • ステータス確認 trepctl services
  • レプリケーションされたbinlogを確認する thl list

tungsten 実行

１．tungsten 実行

[tungsten@tungsten-staging-02 tungsten-replicator-5.0.1-138]$ ./tools/tpm install alpha\
>   --topology=master-slave \
>   --master=10.64.0.10 \
>   --replication-user=tungsten \
>   --replication-password=tungsten \
>   --install-directory=/opt/continuent \
>   --members=10.64.0.10,10.64.0.11 \
>   --skip-validation-check=MySQLMyISAMCheck \
>   --skip-validation-check=SwappinessCheck \
>   --skip-validation-check=MySQLSettingsCheck \
>   --rmi-port=10002 \
>   --master-thl-port=2112 \
>   --master-thl-host=10.64.0.10 \
>   --thl-port=2112 \
>   --start
NOTE  >> Data service(s) alpha updated in /opt/continuent/software/tungsten-replicator-5.0.1-138/deploy.cfg
.......
WARN  >> 10_64_0_10 >> The open file limit is set to 1024, we suggest a value of 65535. Add '*       -    nofile  65535' to your /etc/security/limits.conf and restart your session (OpenFilesLimitCheck)
.......

#####################################################################
# Next Steps
#####################################################################
Once your services start successfully replication will begin.
To look at services and perform administration, run the following command
from any database server.

  /opt/continuent/tungsten/tungsten-replicator/bin/trepctl services

Configuration is now complete.  For further information, please consult
Tungsten documentation, which is available at docs.continuent.com.

NOTE  >> Command successfully completed
  • --install-directory=/opt/continuent：Hostのインストールディレクトリ。
  • --master-thl-port と --thl-port のポート番号は合わせる。
  • --skip-validation-check=MySQLMyISAMCheck：MyISAMのチェックをしない。
  • --skip-validation-check=SwappinessCheck：スワッピングのチェックをしない。
  • --skip-validation-check=MySQLSettingsCheck：default スキーマのチェック等をしない。（2回目実行時にdefaultのテーブルが存在し、エラーとなるため）
  • Staging, Host ともにホスト名の指定も可能だが、ホスト名に - を含む場合、エラー。

２．tungsten 起動確認

  • Staging
[tungsten@tungsten-staging-02 tungsten-replicator-5.0.1-138]$ /opt/continuent/tungsten/tungsten-replicator/bin/trepctl services
Processing services command...
NAME              VALUE
----              -----
appliedLastSeqno: 0
appliedLatency  : 1.738
role            : master
serviceName     : alpha
serviceType     : local
started         : true
state           : ONLINE
Finished services command...

staue: ONLINE で成功。上記以外はエラー。

  • Host
[tungsten@tungsten-host-02 ~]$ /opt/continuent/tungsten/tungsten-replicator/bin/trepctl services
Processing services command...
NAME              VALUE
----              -----
appliedLastSeqno: 0
appliedLatency  : 2.69
role            : slave
serviceName     : alpha
serviceType     : local
started         : true
state           : ONLINE
Finished services command...

３．検証

１．Staging で database 作成

[tungsten@tungsten-staging-02 tungsten-replicator-5.0.1-138]$ mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 70
Server version: 5.1.73-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> create database hoge;
Query OK, 1 row affected (0.01 sec)

２．Host でdatabaseができていることを確認

[tungsten@tungsten-host-02 ~]$ mysql -uroot
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 40
Server version: 5.1.73-log Source distribution

Copyright (c) 2000, 2013, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| hoge               |
| mysql              |
| test               |
| tungsten_alpha     |
+--------------------+
5 rows in set (0.00 sec)

３．レプリケーションされた binlog リスト確認

[tungsten@tungsten-staging-02 tungsten-replicator-5.0.1-138]$ /opt/continuent/tungsten/tungsten-replicator/bin/thl list
SEQ# = 0 / FRAG# = 0 (last frag)
- TIME = 2017-04-24 11:03:38.0
- EPOCH# = 0
- EVENTID = mysql-bin.000004:0000000000000375;-1
- SOURCEID = 10.64.0.10
- METADATA = [mysql_server_id=1;dbms_type=mysql;tz_aware=true;is_metadata=true;service=alpha;shard=#UNKNOWN;heartbeat=MASTER_ONLINE]
- TYPE = com.continuent.tungsten.replicator.event.ReplDBMSEvent
- OPTIONS = [foreign_key_checks = 1, unique_checks = 1, time_zone = '+00:00', ##charset = ISO-8859-1]
- SQL(0) =
 - ACTION = UPDATE
 - SCHEMA = tungsten_alpha
 - TABLE = heartbeat
 - ROW# = 0
  - COL(1: ) = 1
  - COL(2: ) = NULL
  - COL(3: ) = NULL
  - COL(4: ) = 2017-04-24 11:03:38.0
  - COL(5: ) = NULL
  - COL(6: ) = NULL
  - COL(7: ) = 1
  - COL(8: ) = [B@2e2e06bd
  - KEY(1: ) = 1
SEQ# = 1 / FRAG# = 0 (last frag)
- TIME = 2017-04-24 11:08:11.0
- EPOCH# = 0
- EVENTID = mysql-bin.000004:0000000000000458;70
- SOURCEID = 10.64.0.10
- METADATA = [mysql_server_id=1;unsafe_for_block_commit;dbms_type=mysql;tz_aware=true;service=alpha;shard=hoge]
- TYPE = com.continuent.tungsten.replicator.event.ReplDBMSEvent
- OPTIONS = [##charset = ISO8859_1, createOrDropDB = , autocommit = 1, sql_auto_is_null = 1, foreign_key_checks = 1, unique_checks = 1, sql_mode = '', character_set_client = 8, collation_connection = 8, collation_server = 8]
- SQL(0) = create database hoge

トラブル シューティング

  • Staging state: ONLINE で、Hostでエラー

Staging の state: ONLINE で、Host側でエラーとなった場合。
エラー解消後、インストールディレクトリを新規で作成し、実行。
このときのインストールディレクトリ（/opt/continuent）の権限に注意。
下記を確認。
Staging、Hostともに trepctl status でステータスを確認し、実行されていないことを確認。実行されている場合は、tpm stop する。
Stagingで設定ファイルを削除。
Hostのtungstenが実行されていると、tpm start 、tpm update ともにHostの更新がされないので、注意。

  • Host エラー例
[tungsten@tungsten-host-01 tmp]$ /opt/continuent1/tungsten/tungsten-replicator/bin/trepctl status
Processing status command...
NAME                     VALUE
----                     -----
appliedLastEventId     : NONE
appliedLastSeqno       : -1
appliedLatency         : -1.0
autoRecoveryEnabled    : false
autoRecoveryTotal      : 0
channels               : -1
clusterName            : alpha
currentEventId         : NONE
currentTimeMillis      : 1492755019458
dataServerHost         : 10.64.0.8
extensions             :
host                   : 10.64.0.8
latestEpochNumber      : -1
masterConnectUri       : thl://10.64.0.9:2112/
masterListenUri        : thl://10.64.0.8:2113/
maximumStoredSeqNo     : -1
minimumStoredSeqNo     : -1
offlineRequests        : NONE
pendingError           : Stage task failed: stage=q-to-dbms seqno=0 fragno=0
pendingErrorCode       : NONE
pendingErrorEventId    : mysql-bin.000006:0000000000000375;-1
pendingErrorSeqno      : 0
pendingExceptionMessage: Filter failed processing primary key information
pipelineSource         : UNKNOWN
relativeLatency        : -1.0
resourcePrecedence     : 99
rmiPort                : 10002
role                   : slave
seqnoType              : java.lang.Long
serviceName            : alpha
serviceType            : unknown
simpleServiceName      : alpha
siteName               : default
sourceId               : 10.64.0.8
state                  : OFFLINE:ERROR
timeInStateSeconds     : 1243.935
timezone               : GMT
transitioningTo        :
uptimeSeconds          : 5014.482
useSSLConnection       : false
version                : Tungsten Replicator 5.0.1 build 138
Finished status command...
  • Staging 実行時エラー例
[tungsten@tungsten-staging-01 tungsten-replicator-5.0.1-138]$ ./tools/tpm install alpha\
> --topology=master-slave \
> --master=tungsten-staging-01 \
> --replication-user=tungsten \
> --replication-password=tungsten \
> --install-directory=/opt/continuent \
> --members=tungsten-staging-01,tungsten-host-01 \
> --start
NOTE  >> Data service(s) alpha__topology=master_slave updated in /opt/continuent/software/tungsten-replicator-5.0.1-138/deploy.cfg
......
ERROR >> Value must consist only of letters, digits, and underscore (_)
ERROR >> Value must consist only of letters, digits, and underscore (_)
ERROR >> Value must consist only of letters, digits, and underscore (_)
ERROR >> tungsten_host_01 >> Value must consist only of letters, digits, and underscore (_)
ERROR >> tungsten_host_01 >> Value must consist only of letters, digits, and underscore (_)
ERROR >> tungsten_host_01 >> Value must consist only of letters, digits, and underscore (_)
ERROR >> tungsten_host_01 >> Value must consist only of letters, digits, and underscore (_)
ERROR >> tungsten_host_01 >> Value must consist only of letters, digits, and underscore (_)
ERROR >> tungsten_host_01 >> Value must be a valid filename
ERROR >> Value must consist only of letters, digits, and underscore (_)
ERROR >> tungsten_host_01 >> Value must be a valid filename
ERROR >> Value must consist only of letters, digits, and underscore (_)
ERROR >> tungsten_host_01 >> Value must be a valid filename
ERROR >> tungsten_host_01 >> Value must be a valid filename
ERROR >> tungsten_host_01 >> Value must be a valid filename
ERROR >> tungsten_host_01 >> Value must be a valid filename
ERROR >> Value must be a valid filename
ERROR >> Value must be a valid filename
ERROR >> Value must be a valid filename
ERROR >> Value must be a valid filename
ERROR >> Value must be a valid filename
ERROR >> Value must be a valid filename
.
#####################################################################
# There are errors with the values provided in the configuration file
#####################################################################
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Dataservice alpha__topology=master_slave: Name of this dataservice
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Prompt Class: DataServiceName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Dataservice alpha__topology=master_slave: Name of this dataservice
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Prompt Class: ClusterName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Dataservice alpha__topology=master_slave: The db schema to hold dataservice details
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Argument: --dataservice-schema
ERROR >> > Prompt Class: DataserviceSchema
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-staging-01 - alpha__topology=master_slave: What is the replication service name?
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Prompt Class: ReplicationServiceName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-staging-01 - alpha__topology=master_slave: What is the local service name?
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Prompt Class: LocalReplicationServiceName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-staging-01 - alpha__topology=master_slave: Path to replication service static properties file
ERROR >> > Message: Value must be a valid filename
ERROR >> > Argument: --svc-config-file
ERROR >> > Prompt Class: ReplicationServiceConfigFile
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-staging-01 - alpha__topology=master_slave: Path to replication service dynamic properties file
ERROR >> > Message: Value must be a valid filename
ERROR >> > Argument: --svc-dynamic-config
ERROR >> > Prompt Class: ReplicationServiceDynamicConfigFile
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-staging-01 - alpha__topology=master_slave: Replicator log directory
ERROR >> > Message: Value must be a valid filename
ERROR >> > Prompt Class: ReplicationServiceTHLStorageDirectory
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-staging-01 - alpha__topology=master_slave: Directory for logs transferred from the master
ERROR >> > Message: Value must be a valid filename
ERROR >> > Prompt Class: ReplicationServiceRelayLogStorageDirectory
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-staging-01 - alpha__topology=master_slave: Path to my.cnf file customized for this service
ERROR >> > Message: Value must be a valid filename
ERROR >> > Prompt Class: MySQLServiceConfigFile
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-staging-01 - alpha__topology=master_slave: Path to my.cnf file customized for this service
ERROR >> > Message: Value must be a valid filename
ERROR >> > Prompt Class: DirectMySQLServiceConfigFile
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Dataservice alpha__topology=master_slave: Name of this dataservice
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Prompt Class: DataServiceName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Dataservice alpha__topology=master_slave: Name of this dataservice
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Prompt Class: ClusterName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Dataservice alpha__topology=master_slave: The db schema to hold dataservice details
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Argument: --dataservice-schema
ERROR >> > Prompt Class: DataserviceSchema
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-host-01 - alpha__topology=master_slave: What is the replication service name?
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Prompt Class: ReplicationServiceName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-host-01 - alpha__topology=master_slave: What is the local service name?
ERROR >> > Message: Value must consist only of letters, digits, and underscore (_)
ERROR >> > Prompt Class: LocalReplicationServiceName
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-host-01 - alpha__topology=master_slave: Path to replication service static properties file
ERROR >> > Message: Value must be a valid filename
ERROR >> > Argument: --svc-config-file
ERROR >> > Prompt Class: ReplicationServiceConfigFile
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-host-01 - alpha__topology=master_slave: Path to replication service dynamic properties file
ERROR >> > Message: Value must be a valid filename
ERROR >> > Argument: --svc-dynamic-config
ERROR >> > Prompt Class: ReplicationServiceDynamicConfigFile
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-host-01 - alpha__topology=master_slave: Replicator log directory
ERROR >> > Message: Value must be a valid filename
ERROR >> > Prompt Class: ReplicationServiceTHLStorageDirectory
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-host-01 - alpha__topology=master_slave: Directory for logs transferred from the master
ERROR >> > Message: Value must be a valid filename
ERROR >> > Prompt Class: ReplicationServiceRelayLogStorageDirectory
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-host-01 - alpha__topology=master_slave: Path to my.cnf file customized for this service
ERROR >> > Message: Value must be a valid filename
ERROR >> > Prompt Class: MySQLServiceConfigFile
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ERROR >> Replication service tungsten-host-01 - alpha__topology=master_slave: Path to my.cnf file customized for this service
ERROR >> > Message: Value must be a valid filename
ERROR >> > Prompt Class: DirectMySQLServiceConfigFile
  • Value must consist only of letters, digits, and underscore (_)
    → ホスト名にアンスコやめる= ipで指定
  • The alpha_topology=master_slave has a conflicting THL port with alpha (ConflictingReplicationServiceTHLPortsCheck)
    → port指定
  • Unable to determine if MyISAM tables exist.
    → MyISAMチェックをスキップ

以上です。ありがとうございました。

注意点

参考URL

Tungsten Replicator 5.0 Manual

Download

Tungsten Replicator

9
2
0

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
Sign upLogin
9
2

Delete article

Deleted articles cannot be recovered.

Draft of this article would be also deleted.

Are you sure you want to delete this article?