If you have currently planning to migrate or move your database server from MySQL 8.0 to the long-term-support version of MariaDB 10.6 database server, kindly read the following documentation. It’s quite easy to applied on your production server, either it running under VPS, Cloud or … Read more
MariaDB is free, open-source RDBMS and drop-in-replacement (compatible) for MySQL database server and have many similarity both in syntax, commands and its coding style. In the earlier version of MariaDB database server, excatly MariaDB 5.1 it was based on MySQL 5.1 database server. Some of … Read more
MongoDB is a popular database engine used in conjunction with various scripting languages, particularly Python and Rails. Its strongest point is JSON-like data storage, which allows for the natural processing of data stored in the database. The query used by MongoDB is also in the … Read more
This annoying errors happened to our team few days ago when we were trying to migrate a site from one Linux server to another. So on the current server we compressed all the website files into tar.gz archive and the dump the MySQL database using … Read more
This tutorial will guide you on how to disable MySQL Validate Password Plugin on VestaCP CentOS 7. The MySQL validate password plugin is intended to improve security on the MySQL database server by requiring an account password and enabling strength testing for potential passwords. This … Read more
If you have been using the MySQL database server for a long time, you might be a little confused when you switch to MariaDB. Especially in terms of resetting root password, even though we know that MariaDB is a drop-in replacement for MySQL database server. … Read more
MySQLTuner is a script written in Perl that helps us to analyze and configure the MySQL/MariaDB database server in order to get increased performance, stability and balanced server environment. However, under certain conditions we cannot execute the mysqltuner command. That error most often occurs on … Read more
VestaCP is an open source control panel, lightweight and absolutely free. This control panel is designed to be very lightweight which can work seamlessly with Apache web server + Nginx as a reverse proxy, or Nginx web server + PHP-FPM (PHP FastCGI Process Manager). VestaCP … Read more