percona


How to fix MySQL high CPU usage

MySQL is quite popular among open source web apps, but if it is prone to performance issues, if not maintained properly.

Performance issues happen primarily through table fragmentation, unoptimized memory settings, and more. All this can result in MySQL high CPU usage, and application errors.
(more…)

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 fix MySQL high IOWait

How to fix MySQL high IOWait

MySQL is the most popular database used in web applications. It is supported by all hosting providers, is easy to administer, and free. However, MySQL servers often face high server load due to high disk IOWait. (more…)

How to fix MySQL high memory usage

How to fix MySQL high memory usage

MySQL is the most popular database used in web applications. It is supported by all hosting providers, is easy to administer, and free. However, MySQL servers often face high server load due to high memory usage. (more…)