Create NEW raid 1 device and mount for mysql
I have a perfect setup centos 6.2 with ispconfig 3 installed.
It is a production server.
Database are very big (100 G) and I want to add a raid ssd device for mysql
I want to buy 2 ssd hdd, create a raid1 device and mount it in /var/lib/mysql where is the deault folder.
I need help because is a production server. With a test server I can try and play, but I can't do test's in my situation...
i'm looking for something like a perfect setup
This isn't possible without stopping MySQL for some seconds. You must mount your RAID device somewhere, stop MySQL, copy /var/lib/mysql to the new device, rename /var/lib/mysql to something else (like /var/Lib/mysql_old), create a new and empty /var/Lib/mysql directory, remount the RAID device to /var/lib/mysql, chown /var/lib/mysql to mysql:mysql, and start MySQL.
Thx falco, but I need the commands to run
I have unformatted devices sdc and sdd
I want to know how I create a new ext4 raid1 device...
Read man mdadm. it's very clear 8-)
|All times are GMT +2. The time now is 19:56.|
Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.