Help Center/ Data Replication Service/ Best Practices/ Real-Time Synchronization/ From RDS MySQL to Kafka/ Preparing for Source RDS MySQL/ Generating Test Data
Updated on 2022-09-26 GMT+08:00
View PDF

Generating Test Data

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select EU-Dublin.
  3. Under the service list, choose Databases > Relational Database Service.
  4. Select an RDS instance and choose More > Log In.
  5. In the displayed dialog box, enter the password and click Test Connection.
  6. After the connection is successful, click Log In.
  7. Enter the instance password for logging in to the RDS instance.
  8. Click Create Database to create the db_test database.

  9. Run the following statement in the db_test database to create the corresponding table table3_: 

    CREATE TABLE `db_test`.`table3_` (
	`Column1` INT(11) UNSIGNED NOT NULL,
	`Column2` TIME NULL,
	`Column3` CHAR NULL,
	PRIMARY KEY (`Column1`)
)	ENGINE = InnoDB
	DEFAULT CHARACTER SET = utf8mb4
	COLLATE = utf8mb4_general_ci;