How to SELinux allow Apache or PHP-FPM connect remote MySQL
If you have trouble apache or PHP-FPM can not connect to remote MySQSL server, example error on PDO connection on remote server like below First you need to check is…
Category: Database
How to Avoid MariaDB Galera Cluster stalls on ALTER
If you have trouble when upgrading table schema or alter table on MariaDB Galera Cluster, that make your database not response and then connection will over limit. We have experienced…
Install MariaDB on CentOS 7 or RHEL 7
By default Centos 7 repository is MySQL 5.5. If you want to use latest stable MariaDB, you need to use Official MariaDB repository. You need to create MariaDB repository on…
How to MySQL update join with other table
Sometimes we need to update a MYSQL table data based on other table data. For example order_table field city is NULL, and users_data have a field city, we need to…