How I resolved MySQL restart errors after ‘Upgrade’ in Kubernetes
Upgrading a database has always been a slippery slope. Personally, once I set up a database, I will never upgrade it unless a for security reasons – which I have…
Read More »How to Install MySQL 8.0 on Ubuntu 22.04
MySQL 8.0 comes with a load of new features and bug fixes. In this guide we will learn how to install MySQL 8.0 on an Ubuntu 22.04 server. Prerequisites Server…
Read More »
How to Create a Highly Available Database Cluster
Downtime can be very expensive and frustrates users. A sure way to prevent downtime is building a cluster for everything in your environment. Ensuring redundancy of various parts of your…
Read More »How to Disable MySQL Strict Mode on Centos 7
Strict Mode in MySQL controls how MySQL handles invalid or missing values in statements such as INSERT and UPDATE. If strict mode is not in effect, MySQL inserts adjusted values…
Read More »
How to remove MySQL from your CentOS system
When doing an installation of a specific version of MySQL on your CentOS machine, you may get errors caused by the previous MySQL that had been installed earlier; probably a…
Read More »
How to create a Database Server using MariaDB on Centos 7
In our project, the database server will run on MariaDB Prerequisites A VPS with Centos 7 installed Root access to the VPS What do we want? We intend to setup…
Read More »