Connect your MySQL source to Bigeye.
Depending on where your MySQL server is hosted, you must take additional steps in addition to the ones listed below. For example, on Amazon RDS, you must enable the appropriate security groups, and on Google Cloud, you must allow Bigeye's IP address
Bigeye recommends creating a read-only user to connect to your database. Here is a sample of
GRANT statement for creating a read-only user:
GRANT SELECT, SHOW VIEW ON 'database_name'.* TO 'user_name'@'host' IDENTIFIED BY 'password'; FLUSH PRIVILEGES;
password with your actual values. Copy this command and paste it into a MySQL shell to create the user. It grants the user read-only access to ALL tables in your database. Alternatively, you can restrict access to only certain tables in your database.
On the Catalog page, click Add source, and then select MySQL from the Choose a data source section. Click Next to configure the connection to your database.
On the Configure source modal that opens, enter the following details:
|Alias||The identifying name of the data source.|
|Hostname||The name of the server that hosts your database.|
|Port||The default port is 3306.|
|Database||The name of the database.|
|Username||The name of the dedicated user for Bigeye.|
|Password||The password of the Bigeye user.|
|Timeout||The period of non-activity in seconds, after which the database closes its connection.|
After you've configured the source, Bigeye loads and profiles your tables. It can take up to 24 hours for the profiling to complete and your autometrics and autothresholds to populate. See how to deploy autometrics in the Getting Started guide.
Updated 17 days ago