Category: Database

PostgreSQL with PHP on Ubuntu – LEPP stack

Well, after reading some debate on using PostgreSQL for a production work for heavy site with full-text search capability instead of combining MySQL and ElasticSearch, I decide to give it …

Running MariaDB Galera Cluster On CentOS

In this quick tutorial I will list out some necessary steps to setting up mariadb galera cluster on CentOS. The selected CentOS version is 6.5 and the MariaDB is running with …

Some tweaks for MySQL InnoDB performance

In most recent mysql-based applications today, InnoDB is used as the database engine due to its great supported features such as transaction, foreign key, etc. But if the DB server …

Some notes on MySQL index query

Some rules we should remember when doing MySQL index query: Index uses B-TREE, so be sure we understand how B-Tree works. Index is left-most, so if there is (c1, c2, c3) …

MySQL Query Optimization using UNION

Every developers might also understand how important index is when performing query but not of all do really care about how MySQL Query Optimization works. In the most cases, developers …

Install Percona in CentOS

This tutorial helps you install percona server in CentOS as a replacement for MySQL server. According to Percona, Their “MySQL service clients and open source software users achieve breakthrough results …