Setup ubiq for MySQL database on Amazon RDS

Step 1 - Download & unzip ubiq agent

Click to Download

After unzipping the file, click Next

Click to Download

Double click downloaded file to unzip. After unzipping file, click Next


Open Shell(Terminal). Type the following & press enter.

For rpm based systems - Red Hat, SUSE, Fedora, CentOS, etc

					yum install sudo (if sudo command is not present)
					sudo curl -O http://ubiq.co/static/ubiq_linux_rpm.tar.gz
					sudo tar -pzxf ubiq_linux_rpm.tar.gz
					cd ubiq_linux_rpm
					sudo chmod +x manage.sh

For debian based systems - Ubuntu, Debian, etc

					apt-get install sudo (if sudo command is not present)
					sudo curl -O http://ubiq.co/static/ubiq_linux_deb.tar.gz
					sudo tar -pzxf ubiq_linux_deb.tar.gz
					cd ubiq_linux_deb
					sudo chmod +x manage.sh

After executing these commands, click Next

Step 2 - Configure ubiq agent

1

Open unzipped folder(ubiq_mac) and double click on Ubiq_App. Click open to run Ubiq_App. Enter your Mac account/admin password if asked.

2

Next, add user details for at least one of your databases for ubiq agent. When you save the details, ubiq agent will be started automatically in background. Specify host as DB instance (e.g myinstance.123456789012.us-east-1.rds.amazonaws.com)

1

Open shell. Navigate to the unzipped folder(e.g ubiq_linux). Type the following & press enter

./manage.sh
2

Next, add user details for at least one of your databases for ubiq agent. When you save the details, ubiq agent will be started automatically as shown. Specify host as DB instance (e.g myinstance.123456789012.us-east-1.rds.amazonaws.com)

Open the unzipped folder(ubiq_windows) and double click on manage_ubiq.bat. Next, add user details for at least one of your databases for ubiq agent and click Save. Ubiq agent will be started automatically in background. Specify host as DB instance (e.g myinstance.123456789012.us-east-1.rds.amazonaws.com)

Do not use database admin username/passwords. Use a read only user credentials. Here's how you can create one.


Step 3 - Update IP

Go to Home > Settings. Update the IP to 127.0.0.1 if not done already



Step 4 - Test setup

Go to Home > Settings. Click on Test Setup button (shown above) to test it. You should see a popup saying setup successful.