Explore Our Latest Updates

Stay informed and inspired with our blogs to navigate and resolve any technical challenges that you may encounter.

How to setup a Percona cluster (PXC)

by Visakh S | Apr 1, 2016 | MySQL, Server Administration

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...

How to fix MySQL high IOWait

by Visakh S | Mar 30, 2016 | MySQL, Server Management

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. Is it really high IOWait? MySQL load can be due to high...

How to setup Percona bootstrap in an XtraDB cluster

by Visakh S | Mar 30, 2016 | Server Administration

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...

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

by Visakh S | Mar 29, 2016 | Server Administration

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...

How to fix MySQL high memory usage

by Visakh S | Mar 25, 2016 | MySQL, Server Management

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. What causes MySQL high memory usage? Before we discuss...

Magento and Percona – Using XtraDB cluster to improve website speed and uptime

by Visakh S | Mar 24, 2016 | Magento, Server Management

Magento is built to be flexible and feature rich, but its Achilles heel is performance. Magento uses multiple database queries, and extensive database logging for each website access. So, just by optimizing the database service, Magento page speed can be improved...