MySQL
What is MySQL ?¶
MySQL is one of the most recognizable technologies in the modern big data ecosystem. Often called the most popular database and currently enjoying widespread, effective use regardless of industry, it’s clear that anyone involved with enterprise data or general IT should at least aim for a basic familiarity of MySQL.
Environment¶
Note
If you need to use this data source, you need to upgrade the DataCap service to >= 1.0.x
Support Time: 2022-09-19
Configure¶
DataCap uses configuration files by default mysql.json
Note
If your MySQL service version requires other special configurations, please refer to modifying the configuration file and restarting the DataCap service.
Field | Required | Default Value |
---|---|---|
Name |
:material-check-circle: | - |
Host |
:material-check-circle: | 127.0.0.1 |
Port |
:material-check-circle: | 3306 |
Field | Required | Default Value |
---|---|---|
Username |
:material-check-circle: | - |
Password |
:material-check-circle: | - |
SSL |
:material-close-circle: | false |
Field | Required | Default Value |
---|---|---|
Database |
:material-check-circle: | default |
Note
You can add the already supported MySQL parameters by adding Key Value, the parameters can be reference document
Default:
Key | value |
---|---|
useOldAliasMetadataBehavior |
true |
Version (Validation)¶
Warning
The online service has not been tested yet, if you have detailed test results, please submit issues to us
- 5.x
- 6.x
- 7.x
Created: January 29, 2023