As you may know, I started working with high load MySQL servers in 2010 (and then there are several entries that were noted in 2012 after I purchased back this domain :-D) and I mostly go with multi-slaves replications. These might be true in many practical cases where most of […]
Database
Recently I often faced problems with MariaDB Galera Cluster, so I decided to give Percona XtraDB Cluster a try. I write here necessary steps to setup a PHP Stack with Percona XtraDB Cluster on CentOS 7. To avoid problems, be sure that SELinux is not enabled in the server. Guide can be found […]
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 a try with my new early-start-up project. In this tutorial I will note necessary steps to install PostgreSQL with PHP […]
Well, last week I worked on simple PHP – Oracle project so one of the problem I must do is installing Oracle DB for testing. As some of you may know, we normally need a GUI to run install script from Oracle, or use quite installation with pre-defined response file. […]
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 the 10.0 version. Preparation We will need to install required softwares as regular: Disable SELinux: [bash]setenforce 0[/bash] Add MariaDB repo […]
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 is not configured properly, it might cause significant impact on the application performance. This quick article summarize some suggested tweaks for […]
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) index, then query WHERE c1 = 1 AND c2 = 2 does use index, but not WHERE c2 = 2 When […]
Upgrading from MySQL 5.1 to MySQL 5.5 / 5.6 when there is existing data is quite head-cache and scary story. Some notes might also help you when do upgrading: After upgrading, we need to run mysql_upgrade. In order to do that, we must have the mysql service running[bash]mysqld –skip-grant-tables –user=mysql mysql_upgrade […]
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 will think that index will work as it is and do not check in detail how index really work for […]
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 with MySQL: cost savings, faster time to market, higher system up-time, and long-term scalability. MySQL performance is a focus for […]