Moving MySQL Data Folder on cPanel Environment

According to an advice from a cPanel engineer, the best way to move MySQL data folder to a different folder (e.g. on a different partition with more available disk space) on a cPanel / CentOS environment is to create symbolic link rather than modifying the my.cnf file.

Presuming that the original MySQL data folder is located on /var/lib/mysql and the partition with more available disk space is mounted as /home, these are the steps on how to move the MySQL data folder from /var/lib/mysql to /home/var_mysql/mysql.

1. Backup the whole MySQL database, just in case.

mkdir /home/backup (if it doesn't exist yet)
mysqldump --all-databases | gzip > /home/backup/alldatabases.sql.gz

2. Stop MySQL service and verify that it's stopped.

/etc/init.d/mysql stop
/etc/init.d/mysql status

3. Create destination folder, move the folder and all the files and subfolders from existing to new destination folder, change permission settings and create symbolic link.

mkdir /home/var_mysql
mv /var/lib/mysql /home/var_mysql
chown -R mysql:mysql /home/var_mysql/mysql
ln -s /home/var_mysql/mysql /var/lib/mysql

4. Start back MySQL service, and verify that it's started.

/etc/init.d/mysql start
/etc/init.d/mysql status

That's all. :)

Servelet Templates for cPanel and Plesk

This article is originally posted on SimplerCloud's blog here.

Good news for web-hosters!  We have released servelet templates for cPanel and Plesk. You can find them on the list of templates for plan M and above. With these templates, you will not need to install cPanel or Plesk manually yourselves. You can just select the templates (either CentOS+cPanel or Ubuntu+Plesk) and the control panel applications will be pre-installed for you, upon the provisioning of your servelets. You will just have to do the initial configuration, by accessing to the web interface of the control panels, for you to start using them, almost immediately! The templates are provided for free, for the convenience of all our customers. Take note that the templates come without licenses.

On top of that, you can also buy cPanel licenses from us. The price starts from $15.95 for cPanel/WHM VPS Optimized License, which is the most suitable license for your servelets. You will just need to provide the IP address and hostname of your cPanel servelet, and the license will be active immediately after you made your payment. It’s just that simple! 

We are also currently in the midst of talking to Parallels for us to start providing Plesk licenses for you, for the convenience of all our customers.

More information about how to install cPanel and Plesk on our servelets, and also on how to purchase cPanel license through our customer portal, can be found in our knowledge base.