Connect MySQL

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 35.163.65.120.

1. Create a MySQL read-only user

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;

Replace database_name, user_name, host, and 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.

2. Add MySQL as data source in Bigeye

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.

1266


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
  • Timeout

Once filled out, the form should look something like this

663

3. Next Steps

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.