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

Generating Test Data

  1. Log in to the management console.
  2. Click in the upper left corner of the management console and select AP-Singapore.
  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. Click Create Database to create the db_test database.

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