The following configuration file shows how toĬonfigure one database, named DATABASE_NAME. At the moment, no drop-inĬonfiguration is available. MySQL is configured per database on your system. STATS_USER and STATS_PASS in the following config file.
This user and password are referred to as Prerequisitesįor MySQL collection, you must add a user with a password to MySQL that can run The following instructions to configure the MySQL plugin on your instances.
SLES 12 sudo zypper install libmysqlclient18Īfter you install the monitoring agent, use Ubuntu 19.10 sudo apt-get install libmysqlclient21ĭebian 9 sudo apt-get install libmariadbclient18Īmazon AMI 2016.03 or later sudo yum install mysql-libs Ubuntu 16.04 LTS and Ubuntu 18.04 LTS sudo apt-get install libmysqlclient20 Library with MySQL, run the appropriate command to install it: For Linux distributions that don't include the Connector/C Select Dashboards and then select the MySQLĭashboard from the list. To see the metrics for MySQL, go to Monitoring: Checking for ports opened to 3306 via firewall rules.Preferred agent for collecting telemetry from your Compute Engine instances.įor details, see configuring the Ops Agent forĮven if the MySQL plugin is not configured, Monitoring willĭiscover MySQL services running in your Cloud Platform project by: Note: You can now collect metrics from your MySQL instance using the This functionality is only available for agents running on Linux. Providing multi-user access to a number of databases. MySQL is a relational database management system that runs as a server Save money with our transparent approach to pricing Managed Service for Microsoft Active Directory Rapid Assessment & Migration Program (RAMP) Hybrid and Multi-cloud Application PlatformĬOVID-19 Solutions for the Healthcare Industry
Table of Contents 3 Prerequisites 3.1 Installer Files 3.2 Prerequisites 3.2.1 System Requirements 3.2.2 Supported Platforms 3.2.3 Requirements for Monitoring 3.2.4 MySQL Enterprise Monitor Repository 3.3 Credentials Required for Installation 3.3.1 Existing Users 3.3.2 Users Created During Installation 3.3.3 Users Created on First Log-in 3.4 Supported Browsers 4 Service Manager Installation 4.1 MySQL Enterprise Monitor Installation Types 4.2 MySQL Enterprise Service Manager Graphical Installation Wizard 4.3 Text-Based Installation 4.4 Starting/Stopping MySQL Enterprise Monitor Services 4.5 MySQL Enterprise Service Manager Configuration Settings 5 Monitor Agent Installation 5.1 General Agent Related Notes 5.2 Creating MySQL User Accounts for the Monitor Agent 5.3 Java Considerations on UNIX-like Platforms 5.4 Monitoring Agent Graphical Installation Wizard 5.5 Starting/Stopping MySQL Enterprise Monitor Agent 5.5.1 Starting/Stopping the Agent on Windows 5.5.2 Starting/Stopping the Agent on Mac OS X 5.5.3 Starting/Stopping the Agent on Unix 5.5.4 sql_mode 5.6 Monitoring Multiple MySQL Servers 5.7 Configuring an Agent to Monitor a Remote MySQL Server 5.8 Monitoring Outside the Firewall with an SSH Tunnel 5.9 HTTP Connection Timeout 5.10 Troubleshooting the Agent 5.11 Agent Backlog 6 Upgrading MySQL Enterprise Monitor Installations 6.1 General considerations when upgrading MySQL Enterprise Monitor 6.2 Upgrading MySQL Enterprise Monitor 6.3 Restoring from Backup 7 Post-installation Considerations 7.1 General Considerations 7.2 Installing SSL Certificates 7.3 Backup the Repository 7.4 Changing an SSH Host Key 8 Unattended Installation Reference 8.1 Unattended Installation 8.1.1 Performing an Unattended Installation 8.1.2 MySQL Enterprise Service Manager Options 8.1.3 MySQL Enterprise Monitor Agent Options 9 Performance Tuning MySQL Enterprise Monitor 9.1 Tuning Memory 9.2 Tuning CPU 9.3 Tuning Apache Tomcat Threads 9.4 Tuning Agent Memory Requirements 10 Configuration Utilities 10.1 Service Manager Configuration Utilities 10.2 Agent Configuration Utility 11 Uninstalling MySQL Enterprise Monitor 11.1 Windows Platforms 11.2 Mac OS Platforms 11.Discover why leading businesses choose Google Cloud