Results 1 to 9 of 9
  1. #1

    * Is IBM x3250 a right choice as a database server?

    Hi,

    I have an IBM System x3250 Intel Xeon 3040 Dual Core 1.87GHz/1066MHz FSB, 2x1MB L2 cache
    2x512MB 667MHz PC2-5300 ECC DDR2 SDRAMs/8GB Max (4 DIMM)
    250GB Simple Swap SATA HDD

    This is mainly going to run MySQL database for my e-newsletter application. I do an email blast of about 100,000 email at a time about 3 times a week. Every clicks and every opens of newsletter will be recorded in the database. Is this server a right choice?

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Hanoi
    Posts
    4,309
    Is it single disk? For DB server, I would like to use raid-10, not even raid-1

  3. #3
    Join Date
    Jan 2006
    Location
    Santa Cruz, California
    Posts
    391
    I'd go for raid10 too, but otherwise it sounds like a decent server.

    Our new database box is going to be

    x2 4800 dual core
    4x 2gb ddr2 800 (8gb ram total)

    4x sata2 drives raid10 for db's
    2x raid 0 drives for operating system and search indexer which indexes the databases every 5 mins (some sites every 1 min) The quicker it can write to the drive the better.
    -Chris@XS
    www.xenserv.com Your High Performance Hosting Specialists - Try the Xen Experience Today!
    http://uploadpla.net - My free Media hosting site.

  4. #4
    Join Date
    Jun 2006
    Location
    Chicago
    Posts
    462
    Quote Originally Posted by cmanns View Post
    I'd go for raid10 too, but otherwise it sounds like a decent server.

    Our new database box is going to be

    x2 4800 dual core
    4x 2gb ddr2 800 (8gb ram total)

    4x sata2 drives raid10 for db's
    2x raid 0 drives for operating system and search indexer which indexes the databases every 5 mins (some sites every 1 min) The quicker it can write to the drive the better.
    Why raid 0 for the OS and search indexer? Take two SAS 15K drives and Raid 1 them if cost is an issue.

    Raid 0 = Shoot yourself in the foot for production servers.

  5. #5
    Join Date
    Jun 2006
    Location
    Chicago
    Posts
    462
    Quote Originally Posted by everisk View Post
    Hi,

    I have an IBM System x3250 Intel Xeon 3040 Dual Core 1.87GHz/1066MHz FSB, 2x1MB L2 cache
    2x512MB 667MHz PC2-5300 ECC DDR2 SDRAMs/8GB Max (4 DIMM)
    250GB Simple Swap SATA HDD

    This is mainly going to run MySQL database for my e-newsletter application. I do an email blast of about 100,000 email at a time about 3 times a week. Every clicks and every opens of newsletter will be recorded in the database. Is this server a right choice?

    Thanks.
    You're going to want some more ram, and a raid controller and more hard drives on this machine. To start, you'll want ~8 GB of ram, and 4 x 250 GB SATAII Raid 10 Drives, although starting with SAS/SCSI drives from the get-go would definitely be worthwhile.

  6. #6
    Join Date
    Jan 2006
    Location
    Santa Cruz, California
    Posts
    391
    Quote Originally Posted by Jdubz31 View Post
    Why raid 0 for the OS and search indexer? Take two SAS 15K drives and Raid 1 them if cost is an issue.

    Raid 0 = Shoot yourself in the foot for production servers.
    How so? I've never had a drive fail me right now all our servers are on single drive setups.

    I couldn't ever afford a 15k drive...
    -Chris@XS
    www.xenserv.com Your High Performance Hosting Specialists - Try the Xen Experience Today!
    http://uploadpla.net - My free Media hosting site.

  7. #7
    Join Date
    Jun 2006
    Location
    Chicago
    Posts
    462
    Quote Originally Posted by cmanns View Post
    How so? I've never had a drive fail me right now all our servers are on single drive setups.

    I couldn't ever afford a 15k drive...
    My 15K SAS/SCSI response was to the OP. As for you, Raid 0 holds very few advantages except in a couple setups that I have seen (non-critical redundant systems). The Raid 0 stripe will yield very little performance gains, in comparison the simple, yet effective redundancy of Raid 1.

    I would easily take a singe quality drive over striping my data over 2 drives. Although you would have two volumes, instead of one, you would eliminate a scenario of one drive failing, and one still running, yet all data on that system being hosed.

  8. #8
    Thank you for all your responses! Seem like the server is not bad.

  9. #9
    Just out of curiosity. If we decided to do RAID 0 and use other database tool to synchronize data in the database to another database on another server, will that work?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •