I am using MariaDB and below is my config file:
cat /etc/my.cnf.d/server.cnf
....
binlog_format=row
server_id=12
sync_binlog = 100
binlog-row-image = full
binlog_cache_size = 16M
binlog_stmt_cache_size = 16M
BUT tpm install has error message like below:
ERROR >> 127_0_0_1 >> The MySQL datasource binlog_format must be set to 'ROW'
for heterogenous replication. The MySQL configuration file does not include
binlog_format=row (RowBasedBinaryLoggingCheck)
ERROR >> 127_0_0_1 >> The MySQL config file '/etc/my.cnf.d/server.cnf' does
not include a value for server-id (MySQLApplierServerIDCheck)
Check the file to ensure a value is given and that it is not commented out
Please help!
I has sloved this problem by adding "--skip-validation-check=MySQLApplierServerIDCheck" option. For mariaDB, tungsten-replicator looks in the main configuration file, not in the included ones.