Results 1 to 3 of 3
  1. #1

    vps for MySQL Server

    Hi,
    i want to move my SQL server to another machine.
    i thought it would be nice to start from vps and if necessary upgrade it to dedicated.

    currently my MySQL Server handle 1500 tables, average of 200 queries per second (~16M per day).

    i expect it will grow to 1,000 queries per second in the next few months (2-4 months).

    so i thought about this configuration:

    2 cores
    1GB RAM+
    10-20GB HDD
    600GB Bandwidth+

    what do you think? vps will handle it?

    Thanks!

  2. #2
    Join Date
    May 2009
    Location
    Vaduz/LI
    Posts
    2,771
    1500 tables? 1kq/s?

    1Gb ram?

    This does not compute... you have quite a massive amount of querys there.

  3. #3
    currently my MySQL Server using 800MB RAM. 1GB RAM + 512-1024MB Burst, will be fine, no? the ram isn't the main issue (i can always raise it), what about the cpu? which virtualization software will be the best?

Similar Threads

  1. optimizing Mysql server in plesk VPS
    By rankris in forum Hosting Security and Technology
    Replies: 0
    Last Post: 10-22-2009, 04:43 AM
  2. how to install MYSQL Server on VPS linux
    By ezak in forum Hosting Security and Technology
    Replies: 5
    Last Post: 06-03-2009, 08:16 AM
  3. Replies: 3
    Last Post: 08-01-2007, 03:51 PM
  4. Replies: 2
    Last Post: 07-29-2007, 03:08 PM
  5. VPS for Tomcat/Mysql 5.0/ SMTP server
    By barruda in forum VPS Hosting
    Replies: 10
    Last Post: 07-27-2007, 01:45 PM

Posting Permissions

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