Best MYSQL Server For High Traffic

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • 247mg
    Yellowplum / 247mg
    • Feb 2008
    • 2162

    #1

    Best MYSQL Server For High Traffic

    friends, i am looking to have best and power mysql server for my nats program which can handle high traffic with no issues.

    Any recommendations! shoot with some good configuration
    247mg.com - Indian Affiliate Program - Over 50+ Sites To Promote - Monetize Your INDIAN Traffic Today!
  • camgirlshide
    Confirmed User
    • Jan 2005
    • 1558

    #2
    I like HP servers myself. It takes a lot to slow down mysql when configured correctly.
    Useful adult webmaster links -
    Alphabetical list of solo models with webcam
    Stats on my best converting affiliate programs - camgirlshide webmaster blog
    complete list of affiliate programs I use.

    Comment

    • 247mg
      Yellowplum / 247mg
      • Feb 2008
      • 2162

      #3
      Configuration?
      247mg.com - Indian Affiliate Program - Over 50+ Sites To Promote - Monetize Your INDIAN Traffic Today!

      Comment

      • Juicy D. Links
        So Fucking Banned
        • Apr 2001
        • 122992

        #4
        Use SSD drives in your DB server if this is a option..

        Comment

        • Cyandin
          Confirmed User
          • Aug 2008
          • 1723

          #5
          Originally posted by dpapa
          friends, i am looking to have best and power mysql server for my nats program which can handle high traffic with no issues.

          Any recommendations! shoot with some good configuration
          Dual Intel Quadcore Xeon e5640's
          32GB DDR3-1333 ECC RAM
          8x80GB Intel 80GB SSD in Raid-10 (yielding a mind numbingly fast 320GB storage volume)

          From there, you can implement memcached, or even use a chunk of the servers memory for a ramdisk. There are lots of good options on the software side.

          A server like this will be a sickeningly fast, DB shredding machine.

          Comment

          • camperjohn64
            Confirmed User
            • Feb 2005
            • 1531

            #6
            Originally posted by Cyandin
            Dual Intel Quadcore Xeon e5640's
            32GB DDR3-1333 ECC RAM
            8x80GB Intel 80GB SSD in Raid-10 (yielding a mind numbingly fast 320GB storage volume)

            From there, you can implement memcached, or even use a chunk of the servers memory for a ramdisk. There are lots of good options on the software side.

            A server like this will be a sickeningly fast, DB shredding machine.
            I have a setup similar to this with Dual Quadcore 5640's, and have a hard time getting it to blink no matter how much I throw at it. 2 Thumbs up for the Dual Quadcore 5640's
            www.gimmiegirlproductions.com

            Comment

            • Cyandin
              Confirmed User
              • Aug 2008
              • 1723

              #7
              Originally posted by camperjohn64
              I have a setup similar to this with Dual Quadcore 5640's, and have a hard time getting it to blink no matter how much I throw at it. 2 Thumbs up for the Dual Quadcore 5640's
              Yessir! If you can make this system cry, then you are probably in need of one of these.


              IBM Blue Gene-P Supercomputer

              Comment

              • borked
                Totally Borked
                • Feb 2005
                • 6284

                #8
                Originally posted by Cyandin
                (yielding a mind numbingly fast 320GB storage volume)
                320 GB storage for a db server?

                I think the quad core + 32GB RAM though goes a long way to help to the speed, not the storage

                For coding work - hit me up on andy // borkedcoder // com
                (consider figuring out the email as test #1)



                All models are wrong, but some are useful. George E.P. Box. p202

                Comment

                • camperjohn64
                  Confirmed User
                  • Feb 2005
                  • 1531

                  #9
                  Originally posted by Cyandin
                  Yessir! If you can make this system cry, then you are probably in need of one of these.


                  IBM Blue Gene-P Supercomputer

                  My last server was bogging down with traffic and I looked at upgrading packages, then decided to just shell out the cash for to own the server and no longer lease.

                  Then my traffic dropped like a rock :-)
                  www.gimmiegirlproductions.com

                  Comment

                  • Cyandin
                    Confirmed User
                    • Aug 2008
                    • 1723

                    #10
                    Originally posted by borked
                    320 GB storage for a db server?

                    I think the quad core + 32GB RAM though goes a long way to help to the speed, not the storage
                    The Raid-10 out of SSD's portion of what I said is the important part, as far as db serving is concerned. True, most of the 320GB will not be used. Duh.

                    Also, using the right sized stripe in that array is very important too - something most people forget.

                    Comment

                    • HomerSimpson
                      Too lazy to set a custom title
                      • Sep 2005
                      • 13826

                      #11
                      if you want it fast you need high end server the best you can buy
                      and some geeks to set things up... without them hardware is useless
                      Make a bank with Chaturbate - the best selling webcam program
                      Ads that can't be block with AdBlockers !!! /// Best paying popup program (Bitcoin payouts) !!!

                      PHP, MySql, Smarty, CodeIgniter, Laravel, WordPress, NATS... fixing stuff, server migrations & optimizations... My ICQ: 27429884 | Email:

                      Comment

                      • Alky
                        Confirmed User
                        • Apr 2002
                        • 5651

                        #12
                        Originally posted by Cyandin
                        Dual Intel Quadcore Xeon e5640's
                        32GB DDR3-1333 ECC RAM
                        8x80GB Intel 80GB SSD in Raid-10 (yielding a mind numbingly fast 320GB storage volume)

                        From there, you can implement memcached, or even use a chunk of the servers memory for a ramdisk. There are lots of good options on the software side.

                        A server like this will be a sickeningly fast, DB shredding machine.
                        we have two of something similar but a little downgraded... E5520's, 32GB Memory (8x4GB), 1066MHz, 5 146GB 15K's om each.

                        they handle our databases quite nicely

                        Comment

                        Working...