Yearly Archives: 2017


Validate a Let’s encrypt certificates on CloudFlare-enabled websites

In this quick tutorials, I will mention a method to Auto-Renew / Validate a Let’s encrypt certificates on CloudFlare-enabled websites. As you may know, if you use CloudFlare for DNS/CDN purposes, then you cannot access to several server ports for Let’s Encrypt to validate the certification request. So in this […]


Upgrading Percona XtraDB Cluster

Guide can be found at https://www.percona.com/doc/percona-xtradb-cluster/5.7/howtos/upgrade_guide.html. There is no need to re-invent the wheel. I am too lazy to do it. Issue 1: If you are running mysql_upgrade and face the following error: “mysql_upgrade: [ERROR] 1136: Column count doesn’t match value count at row 1”, just do as follows: Clone https://github.com/mysql/mysql-sys and […]