How to install data on a RAID HDD??
Hello List: First my apology: I have previously asked this question and saved the response. But we lost our Win NT server and all the saved data, so I ask the same question again. I have looked in archives for the last three months and have not been able to find my previous Q/A. I will be setting up MySQL server, as soon as I know how. I plan to install MySQL on a RH 9 Server named data. This server has one main disk (which is a boot disk with all the O/S ) and two RAID-1 HDD mirroring one another. My plan is to install MySQL on the main HDD but install/create all the SQL data, tables, Indexes, etc., on the RAID HDD. RAID HDD will have only SQL data. I have no problem installing MySQL on the main HDD but can not figure out what changes are needed so all the data goes to RAID disks. I am a newbie so please, give direction!! Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to install data on a RAID HDD??
Configure your my.cnf data_dir parameter to point to the raid Hard Drive. Original Message On 2/24/04, 12:44:13 PM, Kirti S. Bajwa [EMAIL PROTECTED] wrote regarding How to install data on a RAID HDD??: Hello List: First my apology: I have previously asked this question and saved the response. But we lost our Win NT server and all the saved data, so I ask the same question again. I have looked in archives for the last three months and have not been able to find my previous Q/A. I will be setting up MySQL server, as soon as I know how. I plan to install MySQL on a RH 9 Server named data. This server has one main disk (which is a boot disk with all the O/S ) and two RAID-1 HDD mirroring one another. My plan is to install MySQL on the main HDD but install/create all the SQL data, tables, Indexes, etc., on the RAID HDD. RAID HDD will have only SQL data. I have no problem installing MySQL on the main HDD but can not figure out what changes are needed so all the data goes to RAID disks. I am a newbie so please, give direction!! Kirti -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to install data on a RAID HDD??
I have no problem installing MySQL on the main HDD but can not figure out what changes are needed so all the data goes to RAID disks. I am a newbie so please, give direction!! The easiest way to do this would be to move the data directory and all its contents onto the RAID disks. Then symlink to that directory from the original location. Example only from basic source install: mv /usr/local/mysql/var /hdRAID/var ln -s /hdRAID/var /usr/local/mysql/var Please make sure that mysql is shutdown before doing this task. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: How to install data on a RAID HDD??
Worked like a charm. Thanks. You are a life saver. Kirti -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 24, 2004 2:21 PM To: Kirti S. Bajwa Cc: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: Re: How to install data on a RAID HDD?? I have no problem installing MySQL on the main HDD but can not figure out what changes are needed so all the data goes to RAID disks. I am a newbie so please, give direction!! The easiest way to do this would be to move the data directory and all its contents onto the RAID disks. Then symlink to that directory from the original location. Example only from basic source install: mv /usr/local/mysql/var /hdRAID/var ln -s /hdRAID/var /usr/local/mysql/var Please make sure that mysql is shutdown before doing this task. Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to install data on a RAID HDD??
Kirti S. Bajwa [EMAIL PROTECTED] wrote: Worked like a charm. Thanks. You are a life saver. The easiest way to do this would be to move the data directory and all its contents onto the RAID disks. Then symlink to that directory from the original location. Example only from basic source install: mv /usr/local/mysql/var /hdRAID/var ln -s /hdRAID/var /usr/local/mysql/var You're quite welcome. Now if I could just find a company in need of these skills :) Anyone in the SF Bay Area know of any openings that could use someone skilled in handling RDBMS tasks? My background includes 9 years of RDBMS experience - mySQL, Oracle, Informix, Sybase, SQL-server, 8 years of web/back-end integration PHP, perl/CGI, and 13 years of Unix kernel internals. 22 years using C and 20 years of perl history (3, 4, and 5). Brad Eacker ([EMAIL PROTECTED]) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
