MySQL | KC's Blog

Monitoring and Restart MySQL Service Automatically with Monit

February 24, 2020January 24, 2023 Kent ChenNetwork

I have a Ubuntu VPS that runs a bunch of websites powered by MySQL server at the back end. For whatever reason, the websites just kept turning down because of the crush of the MySQL service. I could scale up the server to dip in more memory or set up some sort of monitoring system to monitor and restart MySQL […]

Fixing Unknown Collation utf8mb4_unicode_520_ci

November 1, 2018January 24, 2023 Kent ChenTips & Tricks

I was trying to restore a database to a MySQL server on a test machine and this error occurred: #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’ The problem is, the server that runs the live database is MySQL 5.7 that supports utf8mb4_unicode_520_ci but the test server I run is only MySQL 5.5 which does not support this specific encoding. By the way, […]