Select Page

percona


How to fix MySQL high CPU usage

How to fix MySQL high CPU usage

A majority of web applications are database driven. MySQL is a popular database server for open source applications, but we’ve seen that it can cause performance issues in the long run.

MySQL databases grow in size, and tables fragment over time. This contributes to MySQL load spikes. So, protecting a server from MySQL high CPU issues requires close monitoring and periodic optimization.
(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 fix ‘MySQL Remote Root Code Execution’ / ‘Privilege Escalation’ (zero day ) vulnerability – CVE-2016-6662

How to fix ‘MySQL Remote Root Code Execution’ / ‘Privilege Escalation’ (zero day ) vulnerability – CVE-2016-6662

On Sep 12th, Dawid Golunski announced CVE-2016-6662 aka MySQL Remote Root Code Execution / Privilege Escalation (0 day) vulnerability.

CVE-2016-6662 is reported as a critical exploit which can allow local and remote attackers to execute arbitrary code with root privileges in a vulnerable MySQL server. (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 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…)

Percona incremental backup – Why use it, and how to set it up

Percona incremental backup – Why use it, and how to set it up

A properly configured backup helps you bounce back from a server failure within minutes. However, backups impose a performance penalty and it is known to even bring down servers due to high load. So, backups should be setup such that it uses as little resources as possible. (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…)

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…)