When we start out website, we may not care about how big our HDD must is.
But when your site is grow up, we need more space for store many types of log files and our MySQL Database increase.
In this post i will introduce you the simple way to deal with new adding HDD to existed Ubuntu Server.
Mount your new HDD as a new folder in current system.
When we plug the new HDD to our Ubuntu server, it just stay there and nothing affected to current system,
Let’s see our current server status by using df -h to see the list of current hdd at our system.
- Mount our new HDD to one folder in current system :
|
1 2 3 4 5 6 7 |
# for example, out new HDD is /dev/sda3 and current sysstem is `/dev/sda6` # we create new folder mkdir /hdd sudo vim /etc/fstab and add follow line : /dev/sdba3 /hdd ext4 defaults 0 0 #mount mount /hdd |
- Stop Running MySQL instance and copy database using
rsync:
|
1 2 3 4 5 |
service mysql stop mkdir /hdd/store # rsync all current mysql files to /hdd/store/mysql sudo rsync -av /var/lib/mysql /hdd/store |
After rsync command completed, we must go to detail about our current MySQL configuration and apparmor services.
Edit current MySQL configuration and AppArmor Service
Go to your MYSQL configuration at /etc/mysql and every config have /var/lib/mysql to /hdd/store/mysql.
Edit apparmor service :
|
1 2 3 4 5 6 7 8 9 |
sudo vim etc/apparmor.d/usr.sbin.mysqld # comment all line contain /var/lib/mysql # add add 2 lines /hdd/store/mysql/ r, /hdd/store/mysql/** rwk, #restart service apparmor restart |
Reconfigure MySQL if needed
Now we have new directory contains all current MySQL files.
Try to rename the old directory and reconfigure MySQL
|
1 2 3 4 5 6 |
mv /var/lib/mysql /var/lib/mysql.bak # if your MySQL is 5.5 sudo dpkg-reconfigure mysql-server-5.5 # start mysql again service mysql start |
If everything fine, we will have MySQL running on new datadir location.
Now we can remove old /var/lib/mysql.bak.
If have any errors, check the section below.
Find error MySQL can not start
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
# upstart log sudo tail -f /var/log/upstart/mysql.log # Login as mysql user to see error output. su mysql mysqld #Checking apparmor's status requires root privileges: aa-status tail -f /var/log/syslog less /var/log/mysql.err or /var/log/mysql.log |