Skip to main content

TencentDB MariaDB

Applicable EditionsTapData CloudTapData Cloud offers you cloud services that are suitable for scenarios requiring rapid deployment and low initial investment, helping you focus more on business development rather than infrastructure management. Free trial with TapData Cloud.TapData EnterpriseTapData Enterprise can be deployed in your local data center, making it suitable for scenarios with strict requirements on data sensitivity or network isolation. It can serve to build real-time data warehouses, enable real-time data exchange, data migration, and more.TapData CommunityTapData Community is an open-source data integration platform that provides basic data synchronization and transformation capabilities. This helps you quickly explore and implement data integration projects. As your project or business grows, you can seamlessly upgrade to TapData Cloud or TapData Enterprise to access more advanced features and service support.

Please follow the instructions below to successfully add and use MariaDB databases in TapData Cloud.

Supported Version​

MariaDB 10.x

Prerequisites (as a source)​

Enable Binlog​

  • Binlog must be enabled in MariaDB for TapData to complete synchronization work.
  • Cascading delete operations (CASCADE DELETE) generated by the database are not recorded in the binlog and are not supported. Modify $MYSQL_HOME/mysql.cnf, for example:
server_id         = 223344
log_bin           = mysql-bin
expire_logs_days  = 1
binlog_format     = row
binlog_row_image  = full

Restart MariaDB​

/etc/init.d/mysqld restart

Verify that binlog is enabled by executing the following command in the mysql shell:

show variables like 'binlog_format';

The output should show ROW as the value for format.

Create MariaDB Account​

create user 'username'@'localhost' identified by 'password';

Grant tapdata Account Permissions​

Grant SELECT permissions for a specific database:

GRANT SELECT, SHOW VIEW, CREATE ROUTINE, LOCK TABLES ON <DATABASE_NAME>.<TABLE_NAME> TO 'tapdata' IDENTIFIED BY 'password';

Grant global permissions:

GRANT RELOAD, SHOW DATABASES, REPLICATION SLAVE, REPLICATION CLIENT, SUPER ON *.* TO 'tapdata' IDENTIFIED BY 'password';

Prerequisites (as a target)​

Grant full privileges for a specific database:

GRANT ALL PRIVILEGES ON <DATABASE_NAME>.<TABLE_NAME> TO 'tapdata' IDENTIFIED BY 'password';

Grant global permissions:

GRANT PROCESS ON *.* TO 'tapdata' IDENTIFIED BY 'password';