How to migrate MySQL to MariaDB on Linux

Since the Oracle’s acquisition of MySQL, a lot of MySQL developers and users moved away from MySQL due to Oracle’s more closed-door stance on MySQL development and maintenance. The community-driven outcome of such movement is a fork of MySQL, called MariaDB. Led by original MySQL developers, the development of MariaDB follows the open-source philosophy and […]
Continue reading…

 

How to replicate a MySQL database on Linux

Database replication is a technique where a given database is copied to one or more locations, so that the reliability, fault-tolerance or accessibility of the database can be improved. Replication can be snapshot-based (where entire data is simply copied over to another location), merge-based (where two or more databases are merged into one), or transaction-based […]
Continue reading…

 

How to manage remote MySQL databases on Linux VPS using a GUI tool

If you need to run a MySQL server on a remote VPS instance, how will you manage databases hosted by the server remotely? Perhaps web-based database administration tools such as phpMyAdmin or Adminer will first come to mind. These web-based management tools require a backend web server and PHP engine up and running. However, if […]
Continue reading…

 

How to install LAMP stack (Apache, MariaDB/MySQL and PHP) on CentOS

LAMP stack is a popular server-side software stack which is used to build and run dynamic web sites and web applications on Linux platforms. The LAMP stack is composed of Apache (as an HTTP server), MariaDB or MySQL (as a database backend), and PHP, Perl or Python (as a server-side programming language), and hence the […]
Continue reading…

 

How to install LEMP stack (nginx, MariaDB/MySQL and PHP) on CentOS

The LEMP stack is an increasingly popular web service stack, powering mission-critical web services in many production environments. As the name implies, the LEMP stack is composed of Linux, nginx, MariaDB/MySQL and PHP. nginx is a high performance and lightweight replacement of slow and hard-to-scale Apache HTTP server used in the traditional LAMP stack. MariaDB […]
Continue reading…

 

How to secure a LAMP server on CentOS or RHEL

LAMP is a software stack composed of Linux (an operating system as a base layer), Apache (a web server that “sits on top” of the OS), MySQL (or MariaDB, as a relational database management system), and finally PHP (a server-side scripting language that is used to process and display information stored in the database). In […]
Continue reading…

 

How to find and kill misbehaving MySQL queries

Sometimes the complexity of a relational database system can be overwhelming. Fortunately, that complexity is an advantage, as with MySQL’s tools for managing queries. In this tutorial, I will show you how to find and kill any misbehaving MySQL queries. To view the currently-running queries, log in to the MySQL console and run the ‘show […]
Continue reading…

 

How to repair a crashed WordPress database table

A WordPress database may experience failure and corruption under various circumstances. One of common problems with it is “crashed database.” When that happens, you will find the following error in WordPress error log: WordPress database error Table ‘./my_home/wp_posts’ is marked as crashed and last (automatic?) repair failed for query SELECT post_date_gmt FROM wp_posts WHERE post_status […]
Continue reading…

 

How to set up a lightweight web server on Raspberry Pi

There are a variety of web server software available for Linux-based platforms including Raspbian. Using one of those available web server software, we can turn Raspberry Pi into a 24/7 available portable web server. In this case, however, we must understand that Raspberry Pi has hardware limitations in terms of CPU clock speed, memory, etc. […]
Continue reading…