Category: MySQL

On DBs

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

T

Turbo charging MySQL by setting up the query cache

To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file . Usually its my.cnf or my.ini so check on your server with the shell

M

Moving mySQL DBs between servers

Moving mySQL DBs from one server to another: mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql puts the entire thing in one nicely portable text file. on a new server it takes mysql -uUSER -pPASSWORD txp_database <

T

Taking backup of mysql database using cron

Taking backup of mysql database using cron Create a file called database_backup.sh and also an empty directory called mysql_backup. The database_backup.sh script should have the following info :

H

How can I repair corrupt MySQL tables?

How can I repair corrupt MySQL tables? Every so often, MySQL tables have a way of corrupting themselves. MySQL offers a quick and painless method of repairing those tables.