...
It means MySQL servers. You may install as many instances of SQL DM for MySQL as you like as long as the total number of MySQL servers monitored does not exceed your license.
| Note |
|---|
Note: DM for MySQL can scale to large instance counts with adequate resources. However, anything over 3000 instances may require a separate installation of DM for MySQL. |
TOP
2. Do I need to install SQL DM for MySQL on the same host as MySQL?
...
- Please check whether you have libxml2 installed in your system.
- Download mod_proxy_html.c from from
| Newtab2 |
|---|
| alias | http://apache.webthing.com/ |
|---|
| url | http://apache.webthing.com/ |
|---|
|
- Now build mod_proxy_html with apxs, apxs -c -I/usr/include/libxml2 -i mod_proxy_html.c
You need to load the following modules, so add the following entries in [/etc/httpd/conf/httpd.conf].
| Code Block |
|---|
|
LoadModule proxy_module modules/mod_proxy.so
LoadModule proxy_http_module modules/mod_proxy_http.so
LoadModule headers_module modules/mod_headers.so
LoadModule deflate_module modules/mod_deflate.so
LoadFile /usr/lib/libxml2.so
LoadModule proxy_html_module modules/mod_proxy_html.so |
- Add the following configuration in your Apache configuration file [/etc/httpd/conf/httpd.conf]
...
They have similarities (in which they both differ from server-side scripts used for monitoring): they both make use of a HTTP service, a database and both use a web-browser for reporting. However, important differences are:
- SQL DM for MySQL is distributed with a perpetual license and is not bundled with anything else. But other MySQL Monitoring Tools are available only as part of a larger support package with periodical license terms.SQL DM for MySQL needs no installation (of 'agents') on the server where the MySQL servers are running. Other does.
- SQL DM for MySQL 'has everything in itself' - the webserver, the database, the MySQL client. It does not depend on the existence of other webservers, runtimes/Virtual Machines (like JAVA) and needs no separate database install. Other monitoring tools requires a full JDK (java), a TOMCAT server and a MySQL server instance for itself. Due to this simplified architecture install, configuration and first of all maintenance and upgrade is much simpler with SQL DM for MySQL. Download packages and disk storage required are much smaller with SQL DM for MySQL.
...
20. SQL DM for MySQL throws an error when trying to connect to MySQL.
Please go through through
| Newtab2 |
|---|
| alias | Error when trying to connect to MySQL |
|---|
|
. | | url | http://faq.webyog.com/category/7/connection-issues.html |
|---|
|
. The same applies to SQL DM for MySQL as the client code is exactly the same in both programs. Observe however that everything related to HTTP-tunneling with SQLyog is not relevant for SQL DM for MySQL.
...
Four ways:
- Website Intercom
| Newtab2 |
|---|
| alias | https://www.idera.com/ |
|---|
| url | https://www.idera.com/ |
|---|
|
- Post in our Forums Forums
| Newtab2 |
|---|
| alias | http://community.idera.com/ |
|---|
| url | http://community.idera.com/ |
|---|
|
- Create ticket: ideramysqlsupport@idera.com
- SQL DM for MySQL UI intercom
...
| Code Block |
|---|
|
sudo monit reload |
TOP