Migrate data from on-premises MySQL to RDS for MySQL - Data Transmission Service

DTS can migrate data from on-premises MySQL databases to RDS for MySQL databases without server outage. This document describes how to configure a data migration task from on-premises MySQL to RDS for MySQL. BackgroundMigration typesMigration from on ...

Migrate RDS for MySQL data to a local MySQL database - ApsaraDB for RDS

RDS for MySQL supports migration of cloud data to local databases using physical and logical backup files. For MySQL 5.6 and earlier version, install Percona XtraBackup 2.3. For MySQL 5.7, install Percona XtraBackup ...

Configure MySQL Reader - DataWorks V2.0

This topic describes how to configure a MySQL Reader. The MySQL Reader connects to a remote MySQL database through the JDBC connector. The SQL query statements are generated and sent to the remote MySQL database based on your configuration ...

Configure MySQL data source - DataWorks V2.0

This topic describes how to configure the MySQL data source. The MySQL data source allows you to read /write data on MySQL, and supports configuring synchronization tasks in wizard and script mode. Note If ...

How to back up and roll back databases in ApsaraDB for RDS for MySQL - ApsaraDB for RDS

ApsaraDB for RDS instance database. Step 1: Install MySQL Client on ECS (Linux)1) Download MySQL ClientRun: wget http://dev.mysql.com/get/archives/mysql-5.6/MySQL-client-5.6.15-1.linux_glibc2.5.x86_64.rpm 2) Install MySQL ClientRun: rpm -ivh MySQL-client-5.6.15 ...

Migrate data from on-premises Oracle to RDS for MySQL - Data Transmission Service

DTS can migrate data from on-premises Oracle databases to RDS for MySQL databases for schema migration and existing data Oracle database to an RDS for MySQL database. BackgroundMigration typesMigration from Oracle to RDS for MySQL only supports schema ...

Configure HybridDB for MySQL data source - DataWorks V2.0

This topic describes detailed steps and related instructions for configuring the HybridDB for MySQL data source. The HybridDB for MySQL data source allows you to read/write data to HybridDB for MySQL. You can configure ...

MySQL data source config - DataWorks

The MySQL relational database data source provides the ability to read data from and write data to MySQL, and supports configuring the data sync task in both wizard and script modes. Note: If you are using MySQL in a VPC environment, and the type is ...

[Vulnerability notice] Weak password vulnerability in MySQL - Security Advisories

DescriptionWeak passwords in your MySQL root can be easily cracked, making it easier to access the database. Weak passwords are the SET PASSWORD command: mysql -u rootmysql SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass' ...

[Vulnerability notice] CVE-2016-5616/6663: Privilege escalation race condition vulnerability in MySQL, MariaDB, and PerconaDB - Security Advisories

On November 1, 2016, a security researcher Dawid Golunski revealed a race condition vulnerability in MySQL, MariaDB, and privileges and run arbitrary code as the database system user (typically ‘mysql’). Successful exploitation can allow an ...

Configure MySQL Reader - DataWorks

MySQL Reader plug-in can connect to remote MySQL database by the JDBC connector. SQL query statements are generated and sent to the remote MySQL database based on your configuration. Then, the SQL statements are run and the returned results are assembled ...

Configure HybridDB for MySQL Writer - DataWorks V2.0

This topic describes the data types and parameters supported by HybridDB for MySQL Writer and how to configure it in both Wizard and Script modes. HybridDB for MySQL Writer writes data into a HybridDB for MySQL database. At the ...

Configure MySQL Writer - DataWorks V2.0

This topic describes the data types and parameters supported by MySQL Writer and how to configure the Writer in both Wizard and Script mode. The MySQL Writer plug-in can write data into a target table of a MySQL database. At the ...

Use EMR for real-time MySQL binlog transmission - E-MapReduce

implement quasi-real-time transmission of MySQL binlog. Basic architecture RDS - SLS - Spark Streaming - Spark HDFS. Prepare the environment Install a MySQL database (using MySQL protocol, such as ...

Connect to Data Lake Analytics with MySQL clients - Data Lake Analytics

This topic explains how to implement Data Lake Analytics (DLA) by using the MySQL command line client. PrerequisitesYou must use MySQL client version 5.5, 5.6, or 5.7. Later versions do not support client protocols. Note: To check the MySQL client version ...

Migrate a MySQL database from Google Cloud to Alibaba Cloud - ApsaraDB for RDS

This topic describes how to migrate a MySQL database from Google Cloud to Alibaba Cloud and the corresponding. Limits Structure migration does not support migration of events. For MySQL databases, DTS ...

Use mysqldump to migrate MySQL data - ApsaraDB for RDS

mysqldump is used to migrate MySQL data. The disadvantage of mysqldump is that the service downtime is long. Use fully compatible with MySQL, the procedure for migrating local databases to an RDS instance is similar to the procedure for ...

Configure HybridDB for MySQL Reader - DataWorks V2.0

HybridDB for MySQL Reader can read tables and views. For table fields, you can specify all columns in sequence, specify certain columns, adjust the column order, specify constant fields, and configure HybridDB for MySQL functions such as now ...

Remotely obtaining the Binlog record from ApsaraDB for RDS for MySQL - ApsaraDB for RDS

1. Connect to ApsaraDB for RDS for MySQL and view its binlog file with either of the following commands:show master logs;orshow binary logs;2. Use the --read-from-remote-server parameter to remotely retrieve the mysql-bin.000497 file (for example) and ...

Configure MySQL full-database migration - DataWorks V2.0

This topic describes how to migrate a Full-MySQL Database to MaxCompute with the Full-Database Migration feature upload all tables in the MySQL database to MaxCompute. For more information about Full-Database Migration, see Full-Database ...