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 »

Use Case: Horizontal Scaling vs Vertical Scaling with Nginx

When deploying high traffic sites/web apps, often times you’ll be faced with a dilemma on whether to use horizontal scaling or vertical scaling. Horizontal scaling is the use of several…

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 »