SQL DM for MySQL AMI comes with the default installation of 64 bit SQL DM for MySQL and nginx reverse proxy on Amazon Linux. You can find SQL DM for MySQL installer in the home directory.

If SQL DM for MySQL AMI default security group is used, SQL DM for MySQL User Interface can be accessed on port 80(http) and 443(https).

The URL to access SQL DM for MySQL would be:

  • http://<Public DNS of the Amazon instance>
  • https://<Public DNS of the Amazon instance>

Upgrading And Installing

Upgrading and installing SQL DM for MySQL can be either done by using:

  • YUM to upgrade:

    # yum update MONyog

    or to install SQL DM for MySQL:

    # yum install MONyog
  • Downloading the binaries and upgrading it with RPM:

    # rpm -Uvh MONyog-*.rpm

    or, installing it with RPM:

    # rpm -ivh MONyog-*.rpm

Nginx Configuration

SQL DM for MySQL AMI is configured with nginx reverse proxy. Nginx listens on ports 80 and 443 and forwards the incoming traffic to SQL DM for MySQL default port:  5555.

SQL DM for MySQL AMI comes with an SSL certificate which is not verfied by any Certificate Authority(CA).

Note

We highly recommend you to change the SSL certificates. You can either have a self-signed SSL certificate or get one signed by any Certificate Authority(CA). Refer the following to know more about generating SSL certificates with OpenSSL: CA.pl. Also refer FAQ 14 points 5-7.

To change SSL certificates in Nginx follow the FAQ 13 section of the HELP file.Reset the admin password before continuing to use SQL DM for MySQL.

Reset the admin password before continuing to use SQL DM for MySQL.



SQL Diagnostic Manager for MySQL agentless and cost-effective performance monitoring for MySQL and MariaDB.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal



  • No labels