WordPress, the content management system that does not require any introduction. But here is the fact, There are 313,050 million sites built on WordPress. And it has a 59.7% of market share in content management. With WordPress, you can host files and database on different servers/machines very quickly as it uses MySQL as a database [...]
MySQL is the second most popular database management system in the world! The reason why it is so popular is, It allows us to scale our databases very easily and effectively. More than that, It's open source (With name "MariaDB"). In this tutorial, I will show you how you can allow and secure MySQL remote [...]
In this guide, I will show you how you can set up master-slave replication in MySQL. However, Let's first understand what exactly is MySQL and it's capabilities. MySQL is one of the most popular relational database management system. It is used on small applications like a personal time tracker to gigantic web applications like Wikipedia. [...]
WHM servers are not supported .NET platform by default. However, this can be enabled using a third party plugin called NexusCore. The respected plugin is compatible with Apache as well as Litespeed. Here, we can discuss about the installation and configuration tips regarding the plugin on WHM servers. Installation 1) ssh to your [...]
MariaDB Server is one of the most popular database servers in the World and it's made by the original developers of MySQL and guaranteed to stay open source. In this tutorial, we will show how to upgrade MariaDB from 10.0 to 10.3 on Ubuntu 16.4. The first part is you have to verify that [...]
There is a way to reset MySQL installation on a cPanel server without reinstalling, but it is not recommended, because doing this will make all databases inaccessible. However, we can do this in a critical situation such as catastrophic InnoDB corruption. In such situations, the stated goal is to reset mysql and restore from [...]
How to Optimize MySQL Database Using phpMyAdmin in Plesk? In this tutorial, we are going to discuss about how to optimize a database table from phpMyAdmin in Plesk. Table optimization can be used if you have deleted a part of the table, or you have made many changes to the rows or columns of the [...]
Upgrade MariaDB or MySQL Version in Linux In this tutorial, you are going to upgrade your MariaDB version from 5.5 to 10.0/10.1/10.2 or MySQL from 5.5 to 5.6/5.7 on Linux and Plesk control panel. For Ubuntu 12.04 and 14.04, Debian 7: Ubuntu 14.04 it is already equipped with MySQL 5.5 by default. 1) Create [...]
How to Increase the Upload Size of MySQL Database in PhpMyAdmin on a cPanel Server? The cPanel server imposes a limit for the database which can be uploaded into PhpMyAdmin. The default limit is limited to 50MB. In this case, it will be very difficult to upload a large database to PhpMyAdmin. To cover this [...]
In this tutorial, we are going to discuss about how to optimize a MySQL database table from phpMyAdmin in cPanel. Table optimization can be used if you have deleted a part of the table, or you have made many changes to the rows or columns of the table with variable length rows etc... The deleted [...]