Skip to main content

Aliyun RDS for 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 Aliyun RDS for MariaDB database in TapData Cloud.

Supported Versions​

MariaDB 10.x

Prerequisites (As a Source)​

Enable binlog for Aliyun ADB MySQL.

Cascade deletes, such as those generated by the database, are not recorded in the binlog and are therefore not supported.

Create MariaDB Account​

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

Grant Permissions​

Grant SELECT permission for a specific database

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

Grant global privileges

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 privileges

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