MySQL Walkthrough

Introduction

This document aims to guide users through the process of creating a MySQL instance, and performing basic database operations.

How to Work with MySQL?

Step 1: Establish a Connection

Make sure you possess appropriate credentials for establishing a connection with a MySQL database server.

Step 2: Granting Read-Only Access for Data Extraction in MySQL

Configure a MySQL user with read-only access to extract data from a specific database.
Execute the following SQL statements in MySQL:

-- Grants read access and view metadata permissions on the target database
GRANT SELECT, SHOW VIEW ON my_database.* TO 'etl_user'@'%';

-- Grants permission to list available databases (optional for some tools)
GRANT SHOW DATABASES ON *.* TO 'etl_user'@'%';

Replace Placeholders

• my_database: Target database name.
• etl_user: MySQL username used for extraction.

Step 3: Choose the River Mode

Once you have successfully established a connection to MySQL, select the River mode to load data into a Target. There are 3 available options for you to choose from:

• Multi-Tables : Simultaneously load multiple tables from MySQL to your desired Target.
  • Standard Extraction - This River mode maps, transforms, and loads data from multiple tables into a unified schema. It uses SQL queries for transformations and can be scheduled or manually triggered.
  • Change Data Capture (CDC) - This mode monitors Source database logs, capturing and transforming changes in real-time. This ensures minimal data loss and low latency transfer when loading the transformed data into the target database, keeping it in sync with the Source.
• Custom Query : Create a customized query and import it into your designated Target.
• Legacy River: Select a sole Source table for loading into a Target.

Step 4: Run the River

Once you have successfully configured the River mode, selected the extraction method, and set up the scheduling, you are now ready to initiate the River and start its operation.