UPDATE global_variables SET variable_value='monitor' WHERE variable_name='mysql-monitor_username'; UPDATE global_variables SET variable_value='your_secure_password' WHERE variable_name='mysql-monitor_password'; LOAD MYSQL VARIABLES TO RUNTIME; SAVE MYSQL VARIABLES TO DISK; Cek health server pake: ... mau). Pertama, server health check. ProxySQL otomatis nge-ping server MySQL secara berkala. Buat liat statusnya, cek tabel: SELECT * FROM monitor.mysql_server_ping_log ORDER BY time_start_us DESC LIMIT 3; Kalo ada server yang sering timeout, mungkin jaringan atau MySQL-nya lagi bermasalah. Kedua,
server health
- Home
- server health