Category: wordpress
MySQL 8.0 InnoDB ReplicaSet with WordPress in OCI
Today’s article is again related to WordPress and MySQL 8.0. We will see how we can setup MySQL InnoDB ReplicaSet and configure WordPress to split the load using both MySQL Instances: we will split reads and writes between the Primary and the Secondary member of our ReplicaSet. This will be the first part of our journey to achieve HA for … Read More
Using OCI to install WordPress and MySQL 8.0
Today we will see how to install WordPress in Oracle Cloud (OCI). We will use Oracle Cloud’s Free Trier and deploy 2 compute instances: the webserver (apache, PHP and WordPress) the database server (MySQL 8.0)
Replace MariaDB 10.3 by MySQL 8.0
Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more powerful (new redo log design, less contention, extreme scale out of InnoDB, …), better operation management (SQL Roles, instant add columns), many … Read More
Migrate from MariaDB to MySQL on CentOS
On this article, I will show you how to migrate your wordpress database from the MariaDB on CentOS to the real MySQL. Why migrating to MySQL 8.0 ? MySQL 8.0 brings a lot of new features. These features make MySQL database much more secure (like new authentication, secure password policies and management, …) and fault tolerant (new data dictionary), more … Read More
MySQL Group Replication, the perfect HA database backend for web hosting
Many web hosting provider are looking for HA solution for the database backend they deliver to their customers. Galera never became the perfect choice for these environment due to 2 factors: no DBA really manage the databases Galera runs database changes in Total Order Isolation What does that really mean ? In fact, when you are a website hosting provider, … Read More
comments