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

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. Then, the SQL statements are run and the returned results ...

Configure MySQL data source - DataWorks V2.0

The MySQL data source allows you to read data from and write data to MySQL, and supports configuring synchronization tasks in wizard mode and script mode. Note If you are using MySQL in a VPC environment ...

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 ...

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] 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 ...

[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' ...

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

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 RDS and ...

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 ...

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 ...

Inaccurate query result returned by ApsaraDB for RDS for MySQL due to the Large Decimal Field - ApsaraDB for RDS

Currently, ApsaraDB for RDS for MySQL may return inaccurate query results because the decimal field is too large. This is a bug of MySQL. The problem can be solved by adding indexes. Refer to the following solution for SQL:create table mlgtestdecimal ...

Harden MySQL service security - Security Advisories

operation with MySQL database system security hardening configurations. Vulnerability detectionYou can use the Server Guard Enterprise Edition to detect MySQL vulnerabilities in your own servers, or you can check for vulnerabilities by yourself. Security ...

Commonly used SQL statements for MySQL - ApsaraDB for RDS

including command parameters and restrictions, see MySQL 5.7 Reference Manual. Database-related commands ...

Configure MySQL writer - DataWorks

The MySQL Writer plug‑in provides the ability to write data into a target table of a MySQL database. At the underlying implementation level, MySQL Reader connects to a remote MySQL database through JDBC, and runs the “insert into …” (or ...

Configure MySQL Writer - DataWorks V2.0

In this article we will show you the data types and parameters supported by MySQL Writer and how to configure Writer in both wizard mode and script mode. The MySQL Writer plug-in can write data into a target table of a MySQL ...

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 ...