Category: MySQL

On DBs

15 Useful MySQL/MariaDB Performance Tuning and Optimization Tips

MySQL is a powerful open source Relational Database Management System or in short RDBMS. It was released back in 1995 (20 years old). It uses Structured Query Language which is probably the most popular...

Reducing Our Installer’s Timey-Wimey Stuff

“People assume that time is a strict progression of cause to effect, but actually, from a non-linear, non-subjective viewpoint, it’s more like a big ball of wibbly-wobbly, timey-wimey stuff.” Over the last few versions, we’ve noticed that the time that it takes to install cPanel & WHM on a new server has increased. We want to make sure that using cPanel & WHM saves you as much time …

No Server Left Behind! (Removal of MySQL Blockers)

Earlier this year, we implemented a blocker that requires you to upgrade your MySQL server to version 5.5 or later before you can upgrade your cPanel & WHM server to version 11.44. We are removing the blocker from cPanel & WHM versions 11.40 and later for MySQL versions 5.0 and 5.1 so that you can use the new and improved MySQL update tool that we will release very …

The Story Behind Acquisition of ‘MySQL’ by Sun Microsystem and the Rise of ‘MariaDB’

A database is an information organized in such a fashion that a computer program can access the stored data or a part of it. This electronic file system is stored, updated, selected and deleted...

Installing LAMP (Linux, Apache, MySQL/MariaDB, and PHP/PhpMyAdmin) in Arch Linux

Arch Linux provides a flexible cutting age system environment and is a powerful best suited solution for developing web applications on small non-critical systems due to the fact that is a complete Open Source...

Installing LEMP (Nginx, PHP, MySQL with MariaDB engine and PhpMyAdmin) in Arch Linux

Due to its Rolling Release model which embrace cutting age software Arch Linux was not designed and developed to run as a server to provide reliable network services because it requires extra time for...

M

MySQLDumper: A PHP and Perl Based MySQL Database Backup Tool

MySQL is one of the most popular database in the world. This database can be installed on the Microsoft Windows platform besides of Linux platform. Why this database is so popular? It may caused...

UI Technology Preview: MySQL Feature Using Modern Tools and Technology

The cPanel User Interface team has been hard at work these past six months. One of the projects we have been working on, in the shadows of the publicly released features, is an exploration of new technology for cPanel’s User Interface. The next stage in this exploration was to find a replacement for YUI2 and our in-house developed CJT (cPanel JavaScript Tools) library. We started a skunk works project in Fall 2013 to look …

4

4 Useful Commandline Tools to Monitor MySQL Performance in Linux

There are plenty of tools to monitor MySQL performance and troubleshoot a server, but they don’t always perfect match for a MySQL developer or administrator’s for their common needs, or may not work in...

Adminer – A Advanced Web Based Databases Administration Tool for Linux

We always interact with the databases to perform tasks in various way. We may connect directly and execute the tasks using SQL CLI mode or non-DBA user prefer to use GUI tools called phpMyAdmin...

10 MySQL Database Interview Questions for Beginners and Intermediates

In our last article, we’ve covered 15 Basic MySQL Questions, again we are here with another set interview questions for intermediate users. As we said earlier these questions can be asked in Job Interviews....

MySQL 5.1 End Of Life

As of December 31, 2013, Oracle will no longer distribute updates for MySQL 5.1. To facilitate migration from MySQL 5.1 to 5.5 or 5.6, we will continue to support MySQL 5.1 through the life of cPanel & WHM software version 11.42. Of course, we also encourage you to upgrade your version of MySQL sooner if at all possible. Beginning with cPanel & WHM version 11.44, upgrades will require …

15 Basic MySQL Interview Questions for Database Administrators

Prior to This Article, three articles has already been published in ‘Linux Interview‘ Section and all of them were highly appreciated by our notable readers, however we were receiving feedback to make this interactive...

It’s Time to Upgrade MySQL

Beginning sometime in 2014, cPanel & WHM software will no longer support MySQL 5.1. This EOL will provide several benefits: Better pre-release testing Simplified EasyApache support Simplified database support In cPanel & WHM version 11.42, we will add support for MySQL 5.6, in addition to our continued support of MySQL 5.5. Please note: If you haven’t upgraded to one of these versions before we remove support for MySQL 5.1, then you will be blocked from …

Install Latest Apache 2.4, MySQL 5.5/MariaDB 10.1 and PHP 5.5/5.6 on RHEL/CentOS 7/6 & Fedora 24-18

This how-to guide explains how to install the latest version of the Apache 2.4, MariaDB/MySQL 5.5, and PHP 5.5/PHP 5.6 along with the required PHP modules on RHEL / CentOS 7/6 and Fedora 18-24....

Removed Scripts in cPanel & WHM Version 11.42

All good things must come to an end. In version 11.42, we will remove several deprecated service update scripts from cPanel & WHM. These scripts have been deprecated since version 11.36. Because of this, system administrators should make certain that they have already updated any cronjobs or other dependencies that might include them. Otherwise, you may be depending on out-of-date or broken scripts to perform important service-related tasks on your server. What’s the difference between deprecated …

MySQL Basic Database Administration Commands – Part I

Database is a structured set of data stored electronically. The concept of database was known to our ancestors even when there were no computers, however creating and maintaining such database was very tedious job....

phpMyBackupPro – A Web Based MySQL Backup Tool for Linux

phpMyBackupPro is an open source very easy to use web based MySQL backup application, written in PHP language released under the GNU GPL. It allows you to create schedule backups, restore and manage them,...

Install MariaDB 10.2 on Fedora 28/27, CentOS/RHEL 7.5/6.9

MariaDB is a binary drop in replacement for MySQL database server. This means that for most cases, you can just uninstall MySQL and install MariaDB and you are good to go. Why MariaDB? MariaDB is totally open source version of MySQL It works just like MySQL and is compatible with MySQL setups Fedora and Red […]

How to replace MySQL with MariaDB in 11.36+

UPDATE: As of cPanel & WHM 11.48 we now support MariaDB natively, and this guide no longer needs to be followed. Please read about that in the 11.48 release notes. Important: This setup is considered to be unsupported by the cPanel/WHM team. Please note that once cPanel/WHM no longer maintains MySQL on your system it is on the Systems Administrator to manage and maintain any updates and maintenance on the database …