我有一个使用TokuDB表的从服务器,但是从使用InnoDB表的主服务器复制。主服务器是PXC的一部分,而使用TokuDB表的从服务器只使用普通的percona服务器(而不是XtraDB)。
当我运行连接到主站的多个应用程序的复制时,似乎从站服务器没有使用relay_log,因此导致如下所示的复制问题:
2016-02-25 16:42:04 9604 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname changed!! Please use '--relay-log=db-kdb-slave-6-relay-bin' to avoid this problem.
2016-02-25 16:42:05 9604 [Warning] Recovery from master pos 552554502 and file mysqld-bin.001163. Previous relay log pos and relay log file had been set to 552554714, ./db-kdb-slave-6-relay-bin.002933 respectively.
2016-02-25 16:42:05 9604 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information.更多信息:我启用了GTID,并且从机也启用了log_bin。两台服务器都在Ubuntu 14.04上运行,并且具有相同的硬件和服务器规格。
我的问题是,我如何确保从站正在使用relay_log?