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...
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...
by Visakh S | Mar 29, 2016 | Incremental backup, 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...
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...
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...
Recent Comments