How to Change Your Django Database to PostgreSQL
For most people, when developing a Django web application, they use the default SQLite3 database. SQLite3 allows you to quickly get started coding without complexities. However when its time to…
Read More »
Installing a database cluster using Galera Cluster with MariaDB
Galera Cluster robust database cluster made on top of MariaDB or MySQL. It contains several features that make it more reliable that standard MySQL Replication. It is a battle-tested solution…
Read More »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 »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 »