Skip to content

KC's Blog

  • Home
  • About Me
  • Sitemap

ubuntu

Monitoring and Restart MySQL Service Automatically with Monit

February 24, 2020February 27, 2020 Kent ChenNetwork
image - Monitoring and Restart MySQL Service Automatically with Monit

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 […]

Read more

Fixing Unknown Collation utf8mb4_unicode_520_ci

November 1, 2018November 1, 2018 Kent ChenTips & Tricks
mysqlhero - Fixing Unknown Collation utf8mb4_unicode_520_ci

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, […]

Read more
  • image - Why Office 365 GPO Settings Don't Apply? And What To Do?
    Why Office 365 GPO Settings Don’t Apply? And What To Do?
  • PowerShell
    Taking Screenshots with PowerShell on Windows 10
  • image 7 - Fix Windows 10 20H2 Upgrade Error 0xc1900223 via WSUS
    Fix Windows 10 20H2 Upgrade Error 0xc1900223 via WSUS
  • image 3 - How To Connect-MsolService without Login Prompt
    How To Connect-MsolService without Login Prompt
  • directory synchronization - How To Convert A Cloud Account to Azure AD Synced Account in Microsoft 365?
    How To Convert A Cloud Account to Azure AD Synced Account in Microsoft 365?

KC's Blog

  • Home
  • About Me
  • Sitemap
Powered by WordPress | Theme: Astrid by aThemes.