​
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

ParameterRequiredDescription
NameYesA unique identifier for your MySQL source
HostYesThe hostname or IP address of your MySQL server
PortYesThe port number on which MySQL is running (default: 3306)
Database NameYesThe name of the database you want to connect to
Schema NameNoOptional schema name (if different from database name)
UserYesUsername with appropriate permissions to access the database
PasswordYesPassword 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:

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

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