HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=4)
-   -   Create NEW raid 1 device and mount for mysql (http://www.howtoforge.com/forums/showthread.php?t=58908)

ShadoweElf 29th September 2012 11:29

Create NEW raid 1 device and mount for mysql
 
Hi all

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

thx

falko 30th September 2012 10:33

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.

ShadoweElf 30th September 2012 16:42

thx falco
 
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...

Thx

Puck 11th October 2012 17:37

Read man mdadm. it's very clear 8-)


All times are GMT +2. The time now is 00:10.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.