Overview

MySQL is one of the world’s most popular open-source relational database management systems. Datazone provides seamless integration with MySQL databases, allowing you to easily ingest and manage your MySQL data.

Connection Parameters

Parameter	Required	Description
Name	Yes	A unique identifier for your MySQL source
Host	Yes	The hostname or IP address of your MySQL server
Port	Yes	The port number on which MySQL is running (default: 3306)
Database Name	Yes	The name of the database you want to connect to
Schema Name	No	Optional schema name (if different from database name)
User	Yes	Username with appropriate permissions to access the database
Password	Yes	Password for the specified user

Required Permissions

The MySQL user account needs the following permissions:

SELECT - For reading data from tables
SHOW DATABASES - For listing available databases
SHOW VIEW - For accessing views
REFERENCES - For foreign key constraints

Limitations

Be aware of the following limitations when working with MySQL sources:

Supported MySQL versions: 5.6 and above
Some MySQL-specific data types might be converted to standard types
Large table scans may impact source database performance
Consider using read replicas for heavy data extraction

Next Steps

After configuring your MySQL source:

Create extracts to specify which tables to ingest
Configure scheduling for recurring extracts
Integrate the source into your data pipelines

For more information about working with extracts and pipelines, refer to their respective documentation sections.

Get Started

Reference

Deployment

Tutorial

MySQL

Overview

Connection Parameters

Required Permissions

Limitations

Next Steps

​Overview

​Connection Parameters

​Required Permissions

​Limitations

​Next Steps

Overview

Connection Parameters

Required Permissions

Limitations

Next Steps