Depending on where your MySQL server is hosted, you may need to take some 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 should allow Bigeye's IP address
Bigeye recommends creating a read-only user for connecting to your database. Here is a sample
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. This will grant the user read-only access to ALL tables in your database. Alternatively, you can also restrict access to only certain tables in your database.
From the Catalog tab in the sidebar, select Add Source. This will take you to a page where you can configure the connection to your database.
To connect a database, you will need to input the following information:
- Alias - identifying name for this data source
- Vendor - MySQL
- Hostname - name of the server that hosts your database
- Port - 3306
- Database name - your database name
- Username - username of the MySQL read-only user you created previously
- Password - password of the MySQL read-only user you created
Once filled out, the form should look something like this
Bigeye will now start loading and profiling your tables. It can take up to 24 hours for the profiling to complete and your autometrics/autothresholds to populate. You can now proceed to deploying autometrics in the Getting Started guide.
Updated about 1 year ago