About the MySQL collector
This collector is designed to directly harvest metadata from your MySQL server. It is suitable for both self-hosted MySQL instances and managed MySQL instances, such as those hosted on AWS RDS. This collector also works with MariaDB instances.
Important
The MySQL collector can be run in the Cloud or on-premise using Docker or Jar files.
Note
The latest version of the Collector is 2.243. To view the release notes for this version and all previous versions, please go here.
What is cataloged
The collector catalogs the following information.
Note
The collector harvests all versions of overloaded functions and stored procedures. Each version has its own title/name in the catalog, but a distinct identifier.
Object | Information cataloged |
---|---|
Columns | Name, Description, JDBC type, Column Type, Is Nullable, Default Value, Key type (Primary, foreign), column size, column index |
Table | Name, description, primary key, schema |
Views | Name, description, SQL definition |
Schema | Identifier, Name |
Database | Type, name, identifier, server, port, environment, JDBC URL |
Function | Name, Description, Function Type |
Stored Procedure | Name, Description, Stored Procedure Type |
Relationships between objects
By default, the harvested metadata includes catalog pages for the following resource types. Each catalog page has a relationship to the other related resource types. If the metadata presentation for this data source has been customized with the help of the data.world Solutions team, you may see other resource pages and relationships.
Resource page | Relationship |
---|---|
Table | Columns |
Columns | Table |
Schema | Database that contains Schema, Table that is part of Schema |
Database | Schema contained in Database |
Authentication supported
The MySQL collector supports username/password authentication to MySQL.