Category: MySQL

On DBs

How to Reset MySQL or MariaDB Root Password in Linux

If you are setting up a MySQL or MariaDB database server for the first time, chances are you will be running mysql_secure_installation soon afterwards to implement basic security settings. One of these settings is...

Learn How to Use Several Functions of MySQL and MariaDB – Part 2

This is the second part of a 2-article series about the essentials of MariaDB / MySQL commands. Please refer to our previous article on this topic before proceeding. Learn MySQL/MariaDB Basics for Beginners –...

Learn MySQL / MariaDB for Beginners – Part 1

In this article we will show how to create a database (also known as a schema), tables (with data types), and explain how to perform Data Manipulation Language (DML) operations with data on a...

How to Backup/Restore MySQL/MariaDB and PostgreSQL Using ‘Automysqlbackup’ and ‘Autopostgresqlbackup’ Tools

If you are a database administrator (DBA) or are responsible for maintaining, backing up, and restoring databases, you know you can’t afford to lose data. The reason is simple: losing data not only means...

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 …

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 …

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 …

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 …

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 …

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 …

c

cPanel Server : Restoring MySQL SimLink.

If you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you may see that there is no simlink To create a simlink you can do the

H

How To Set Up A Load-Balanced MySQL Cluster With MySQL 5.1

This tutorial is based on Falko Timme’s tutorial for MySQL Cluster 5.0. It shows how to configure a MySQL 5.1 cluster with five nodes: 1 x management, 2 x storage nodes and 2 x balancer