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

Migrate data from MySQL to DRDS - Data Transmission Service

DTS allows you to migrate data from a MySQL instance to a DRDS instance. The incremental synchronization feature of DTS supports migration to the target DRDS instance without downtime of the MySQL service. This topic describes how to configure a task for ...

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

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

Real-time data synchronization from RDS for MySQL to ES - Elasticsearch

to use Data Transmission Service (DTS) to quickly create a real-time data synchronization task from an RDS for MySQL instance synchronize RDS for MySQL data to ES instances and query data in real time ...

MySQL data source config - DataWorks V1.0

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

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 precautions. Prerequisites You have created an Alibaba Cloud RDS MySQL instance. You have created an ...

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 DLA through MySQL CLI tools - Data Lake Analytics

DLA supports Java Database Connectivity (JDBC) that is compatible with MySQL. You can use a MySQL CLI tool to connect to DLA through JDBC. Prerequisites The MySQL CLI supports MySQL 5.0 and later versions for DLA access. mysql --version mysql Ver ...

Create a MySQL schema - Data Lake Analytics

create a MySQL schema in DLA: CREATE SCHEMA hello_mysql_vpc_rds WITH DBPROPERTIES ( CATALOG = 'mysql', LOCATION' ); VPC_ID: indicates the ID of the VPC where your MySQL instance is located, as shown in the following figure ...

Use mysqldump to migrate MySQL data - ApsaraDB for RDS

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

Perform joint query on multiple MySQL instances in DLA - Data Lake Analytics

joint queries in multiple data sources of the same type. This topic takes two ApsaraDB RDS for MySQL (MySQL) instances as an the MySQL instances. If not, follow these steps to insert test data into the MySQL instances: Create two MySQL instances. DLA ...

[Basic rule] Malicious MySQL UDF execution - Cloud Firewall

MySQL allows users to specify user-defined functions (UDFs). Attackers who have MySQL database privileges can mainly affects opened MySQL application servers. It may cause risks such as unauthorized control over servers, data leakage ...

Introduction to MySQL read-only instances - ApsaraDB for RDS

Currently the following instances support read-only instances: MySQL 5.7 High-Availability Edition (based on local SSDs) MySQL 5.6 SQL Server 2017 Each read-only instance adopts a ...

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