2 {{ upvoteCount | shortNum }}
2 {{ upvoteCount | shortNum }}

Any Server/hardware experts here?

by packerfan
2 replies
First, I know very little about this subject, so forgive me if I ask the wrong questions...

I have a MySQL database that will ultimately have about 50,000,000 records (5 rows each).

I have a PHP front end to query the database.

Right now this all on my local machine (database has 16,000,000 records)

All is basically well, but I'd like to move this online so I have access from anywhere.

On a typical day it will queried maybe 100 times.

Can anyone give me any advice on what kind of server I need, how much memory, CPU, etc.

There is a memory issue right now on the query were it just uses all that's available. I need to set a limit or something. But assuming that's fixed.

Speed isn't overly important, but I don't want to wait an hour for each query.

Sorry if I'm asking the wrong questions, but I hope you get the idea.
#experts #server or hardware
  • Profile picture of the author TrueStory
    I RE READ your post

    EDIT: disregard what I typed below the line, here is why:

    MySQL database that will ultimately have
    My banal explanation: when you come to this bridge you'll cross it. Database migration is not that complicated. if it takes you 4 years to get to that, many things might change by then. Technology evolves fast.

    Right now this all on my local machine (database has 16,000,000 records)
    This is not a large DB. A simple shared MySQL server can handle it on any shared hosting plan. (i use justhost.com or bluehost.com or imhosted.com)

    On a typical day it will queried maybe 100 times.
    I cannot believe i missed this. I kind of assumed that database that large will be accessed several hundreds times a day. eBay has ****-load of records, and they probably get 10,000 hits a day ( i am just guessing )

    For 100 times a day, use shared hosting.

    MY ORIGINAL POST:
    __________________________________________________ ______

    What you're asking about is cloud computing. Basically you need a remote server you can access securely and easily from anywhere (through a web interface)?

    Depending on how large are your records. If those are basic text data (user account data). If you're storing images, large files (in BLOBs) in your database, you might need something customized.

    But biggest question is: HOW MUCH DO YOU WANT TO SPEND?

    Any dedicated server hosting will be fine. (no, we are not talking about shared hosting )
    Cloud Computing, Managed Hosting, Dedicated Server Hosting by Rackspace has been one of the industry leaders when it comes to dedicated servers.

    Dedicated Servers, Reliable Dedicated Hosting & Advanced Hosting Solutions | iWeb has prices from 99 bucks per month. If you need redundancy and backup, iweb is pretty good.

    If your business will rapidly grow, or you need a lot of storage space, Amazon is your answer. (Amazon Relational Database Service (Amazon RDS))

    Let me know if that answers your question.
    Signature

    Your business matters only to people that matter to your business[/U][/B] - Reach them?

    {{ DiscussionBoard.errors[5442785].message }}
  • Profile picture of the author Coolraul
    Best bet is a dedicated server. You can use an Amazon or Azure cloud computing instance but it would likely be very costly compared to a dedicated server.

    On the machine you are currently running this db what are the specifications? Use that as a starting point and since you say there is a memory problem which could be configuration or overall capacity you will need to first figure out if it is just configuration.

    I agree with Truestory, you can't use shared hosting, it is vps, dedicated or cloud but my first guess is that it is likely a dedicated server that is needed.

    IWeb is great but you should get something with reasonable speeds to you if you are the one who will be working on the system the most.
    {{ DiscussionBoard.errors[5442835].message }}

Trending Topics