Database

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…

6 months ago

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…

11 months ago

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…

11 months ago

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…

11 months ago