MYSQL Database Query

[Gracey]

Hello,
I want to install sql server as a database server and Oracle 10 I as a programming language for this i choose windows 2003 server as a operating system..OK.and come to hardware part i have 8 SATA hdd's each one has 300 gb of capacity. my requirement is i want to insert these 8 hdds into a system by using RAID LEVELS(Leave about configuration). in Raid Levels which level will give 100% data backup(safe).if u give preference for one particular raid level please let me know what are the benefits with that Please suggest me with best answers.

Thanks

[speed]

Originally Posted by Gracey

in Raid Levels which level will give 100% data backup(safe).

None.

No RAID level gives 100% data backup/safety, RAID is not a backup solution, you must continue to take backups.

RAID6 is about the best you can get as that will allow you to loose any 2 drives from the array before loosing your data.

[Webby Alisha]

Originally Posted by Gracey

Hello,
I want to install sql server as a database server and Oracle 10 I as a programming language for this i choose windows 2003 server as a operating system..OK.and come to hardware part i have 8 SATA hdd's each one has 300 gb of capacity. my requirement is i want to insert these 8 hdds into a system by using RAID LEVELS(Leave about configuration). in Raid Levels which level will give 100% data backup(safe).if u give preference for one particular raid level please let me know what are the benefits with that Please suggest me with best answers.

Thanks

Gracey, when we use raid facility ,we can connect only 4 hard disk,because no any option r available in our motherboard that's why we connect more then 4 HDD. i think like this if any other answer u may get p, please inform me

[wige]

No raid setup will give 100% backup. RAID only protects against a single type of failure, a hard drive loss. If you are looking for the highest level of protection, you would be looking for RAID 6, which can survive the loss of two drives in the array. Because any other RAID array is vulnerable to data loss if any drive fails during the rebuild process, RAID 6 is recommended for remote installs and data warehousing where the rebuild process will take a long time.

For smaller data sets, your priority may be on maintaining performance. Splitting your eight physical drives into four logical drives paired and mirrored with RAID level 1 might give you the right balance of speed and backup.

What type of data will be stored on the system? How critical is this data? How much continuous storage space do you need (how much of your 2.4Terrabytes do you actually need, and how much can be used for data mirroring)? How much guaranteed uptime do you need? How much Read/Write time can you sacrifice to allow for the increased data duplication? How much data transfer will be occurring? (some RAID setups will increase read and write operations and may increase the chances of a drive failure)

If you are just looking to protect the drives on a small to medium business server, I would probably go with RAID 1. If you are talking about a large corporate data warehouse, I would probably have two data servers with full data redundancy in physically seperate locations over a VPN running RAID 6 or RAID 53.

It all depends on your specific needs for this server.