How to connect the remote MYSQL database

(Jones Thomas) #1

I have a Ubuntu server and MySQL Cloud server.i have packetbeat installed in Ubuntu server, and i need to monitor MySQL Cloud server (3306-port).
In kibana i cant see any data.
1- Where should i use the (MySQL-host / ip) in the packetbeat.yml file which is installed in the Ubuntu server?
2- how to monitor MySQL remotely?

(Jones Thomas) #2

any idea?

(Steffen Siering) #3

packetbeat operates on unencrypted network packets. For this you will either have to install packetbeat on the machine MYSQL is running, or use port-forwarding or network taps, to forward the network packets to packetbeat. If encryption is used, packetbeat will not be able to analyze the traffic though.

For getting metrics/stats from mysql, one can use metricbeat. Metricbeat can actively connect to a remote mysql instance and query mysql for common metrics.

(system) #4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.