VPS for OSCommerce 360,000 Catalog (Setup/Provider)
I need to sign up for a Linux based VPS (I guess I prefer XEN) to host an OS Commerce (OSC) store with 360,000 items in the catalog. I will host my pictures elsewhere, so my main concern is performance in regards to database (which is MySQL) performance when people browse and especially search the catalog.
I think I need hence a VPS with at least 1024MB dedicated RAM, a good CPU share, but only very little storage space (again, the server will basically only contain the database and the necessary OSC PHP files, nothing else)
a) Does anybody have experience with hosting what is essentially a DB server on a VPS and can give me some setup hits regarding memory allocation, server resource allocation, PHP configuration, Apache configuration etc. when using a VPS for this purpose?
b) Does anybody know about a provider which offers a relatively high memory allocation (at least 1024MB, burstable to double that) for a price of not more than US$50.00 / month?
Well, I would like to have a couple of other things, but they are not THAT important, just to mention them:
- cPanel/WHM included,
- four (4) or more IPs included
Thanks for all your input, I sure appreciate your comments and hints!
I had a vps w/ vpsfarm for a few months. It was excellent -- no downtime, felt snappy, ping times outstanding to my location. I only gave it up because I didn't need it any longer, but I would and will gladly sign up with them again if I need another vps. They don't offer a control panel, but I didn't want one.
No experience with XPLHost or VPSLink. You can try searching WHT for their usernames or site names to find reviews.
There may be other high RAM offers in the VPS offers forum. Those are just a few I've noticed.
If you're particularly interested in Xen the site vpschoice.com is handy. Unfortunately, it's currently down.
The problem is the size of your DB. I don't think it will be so stable on a VPS (I'm sure a provider or someone with knowledge can chime in on this). You're really better off going for a dedicated. You can get a dedicated for under $100/month and get a 3rd party to manage it.
Douglas: Thanks for the input. Do you think a US$80 budget would get me somewhere? Any provider suggestions?
I aim to please. Yes, I think you'll have a better chance with that budget than you would with a $50 budget. Just make sure you do your homework.
Originally Posted by ColeColby
Any tips who offers a 64-bit OS and also, any specific MySQL optimization tips?
The hardware and OS bit question should be asked of any hosting provider that you are potentially interested in.
There's a few tutorials on here and on Google. Also, on any VPS that has a good install of MySQL will always include a my-large.cnf file somewhere, which has most of the basic settings for a MySQL configuration file that is geared (but not completely tweaked) for a system with a decent amount of RAM.
Douglas Hazard - Certifiable Sports Junkie and Sports Community Enthusiast
Host of Two Cents Radio - Follow @TwoCentsRadio on Twitter (@BearlyDoug on Twitter)