Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > General Hosting/Server Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Server MySQL question Details »»
Server MySQL question
Version: , by attroll attroll is offline
Developer Last Online: Mar 2023 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 12-01-2007 Last Update: Never Installs: 0
 
No support by the author.

I am getting ready to build my second sever and I have some questions. I want to make this server better then the first one I built. Here are the stats on my first one and the one I am currently using:

2x INTEL XEON 5345 2.33GHZ 8MB QUAD CORE, This is 8 cores
4x 2048MB Memory giving me a total of 8GB of memory
4x 250GB hard drive setup as raid 10 = 500GB total usage
1x 250GB as a backup drive
1x 250GB a spare drive

This works fine for what I am using this for. For my second server I am going to have 8 hard drives. Four of the hard drives will be set on a raid 10 I think. I want to use the other four hard drives for MySQL databases. What would be the best way to set these drives up for MySQL?

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 12-01-2007, 06:57 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

You should be setting up the mysql drives in raid 10 (4 drives needed).

I would prolly do a raid 0/1 for your served page drives (2 mirrored), having 1 backup and 1 spare drive.
Reply With Quote
  #3  
Old 12-02-2007, 03:30 AM
attroll's Avatar
attroll attroll is offline
 
Join Date: Jan 2003
Location: Litchfield, Me
Posts: 664
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My thoughts were for setting the MySQL drives as a raid 10 and the other four I was thinking of putting on a raid 10 also. That would give me two raid 10 setups. In having raid 10 setups I would not really need a spare drive because if one of the raid 10 drives failed it would give me time to send them a new drive to replace it. The backup drive would be nice also. It is a tossup though.
If I go raid 0 and one of the drives fails I am screwed because all the data will be lost.
If I go raid 1 then won't the read and write speed be slower then a raid 10?
Reply With Quote
  #4  
Old 12-02-2007, 09:25 PM
snakes1100 snakes1100 is offline
 
Join Date: Dec 2001
Location: Michigan
Posts: 3,733
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

If your looking for redundancy and speed, then raid 10 is favorable over raid 5.

As to raid 0 - Yes you would lose the data, but that is what backups are for and typically using a NAS backup at the host is favorable as well.

As to Raid 1 - The speeds should basically be the same as Raid 10, as Raid 10 is basically Raid 1 & 0 combined.
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 05:34 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04037 seconds
  • Memory Usage 2,223KB
  • Queries Executed 19 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (4)post_thanks_box
  • (4)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (4)post_thanks_postbit_info
  • (3)postbit
  • (4)postbit_onlinestatus
  • (4)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete