Select Page

xtradb cluster


How to setup WordPress high availability hosting using Percona XtraDB cluster

Your website is only as fast as its slowest component. In a WordPress server infrastructure, database servers are often the slowest. This is because databases depend on good old hard disks instead of the super fast server memory to fetch data.

In high traffic WordPress websites, database servers are known to incur intermittent downtime and performance bottlenecks. Today we’ll see how a Percona XtaDB cluster can be used to deliver WordPress high availability hosting.
(more…)

How to setup a Percona cluster (PXC)

How to setup a Percona cluster (PXC)

Percona is a high performance alternative for MySQL. It uses a modified InnoDB engine called XtraDB, and uses Galera’s clustering technology to offer better performance and uptime than MySQL. Today, let’s take a look at how you can setup a Percona cluster, and migrate your databases from MySQL. (more…)

How to setup Percona bootstrap in an XtraDB cluster

How to setup Percona bootstrap in an XtraDB cluster

In an earlier post, we discussed how Percona XtraDB Cluster (PXC) can be used to achieve database high availability. PXC uses master-master replication, which makes each server in the cluster capable of making changes to the database. In such a system, data update conflicts are possible if servers are not in sync. Percona bootstrapping is a way to avoid conflicts when starting up a cluster.
(more…)

cPanel and Percona – Should you replace MySQL? Here’s all your questions answered

cPanel and Percona – Should you replace MySQL? Here’s all your questions answered

From WordPress to Magento, almost all popular web apps use MySQL as their default database. While MySQL is easy to use and administer, it causes frequent performance issues in web hosting servers. Many website owners and web hosting providers now use high performance MySQL alternatives such as MariaDB or Percona. (more…)

Percona load balancing – How to setup and maintain high performance XtraDB clusters

Percona load balancing – How to setup and maintain high performance XtraDB clusters

In any web server infrastructure, database servers are often the slowest. This is because databases fetch data from good ol’ hard disks instead of the super fast server memory. High speed storage such as RAID and SSDs have been able to reduce the latency, but if a site visit requires database access, it’ll induce significant page load delay. (more…)

How to setup and maintain Percona backup using XtraBackup

How to setup and maintain Percona backup using XtraBackup

Backups are your insurance against server failures. A well designed backup helps you quickly get back online even if the whole server is lost. For modern websites running WordPress, Magento, etc., the entire information is stored in databases. So, a sound backup design for such sites should include reliable database backups. (more…)