Data Ingestion
MySQL
MySQL is an open-source relational database management system (RDBMS).
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 tablesSHOW DATABASES- For listing available databasesSHOW VIEW- For accessing viewsREFERENCES- 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.