PHP + Mysql on the cloud

Ye' old general discussion board. Basically, for everything that isn't covered elsewhere. Come here to shoot the breeze, shoot your mouth off, or whatever suits your fancy.
This forum is not for asking programming related questions.

Moderator: General Moderators

Post Reply
User avatar
yacahuma
Forum Regular
Posts: 870
Joined: Sun Jul 01, 2007 7:11 am

PHP + Mysql on the cloud

Post by yacahuma »

I wanted to create an application that can be part of google apps. Since there is no way knowing how many user one might use it, How do you expand your database architecture? I know you can shard the database. I know you can create master-slaves configurations and write on the master and read from the slaves. But all this configurations are still limited. They will always hit a limit and then you have to add more masters and slave. If the communication fails between master and slaves then you also have problems. I just dont see this as a real solution.

My question is, what are people doing to run commercial saas cloud applications?


Thank you
User avatar
yacahuma
Forum Regular
Posts: 870
Joined: Sun Jul 01, 2007 7:11 am

Re: PHP + Mysql on the cloud

Post by yacahuma »

Well, after a lot of reading. I found something interesting www.scalebase.com

The problem is that I think it will be expensive, since they are afraid of posting the prices.
User avatar
Christopher
Site Administrator
Posts: 13596
Joined: Wed Aug 25, 2004 7:54 pm
Location: New York, NY, US

Re: PHP + Mysql on the cloud

Post by Christopher »

You will be able to build scale behind you app when it is wildly successful because you will be able to afford it then. I would recommend focusing on the app, putting the datasource behind a clean interface, and worrying about performance problems later.

Check out Google AppEngine and maybe read about how Google does it: https://www.google.com/search?q=how google scales databases
(#10850)
User avatar
yacahuma
Forum Regular
Posts: 870
Joined: Sun Jul 01, 2007 7:11 am

Re: PHP + Mysql on the cloud

Post by yacahuma »

i just saw a video about app engine. google is looking for big companies with huge back process. not little ones. at least for now
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: PHP + Mysql on the cloud

Post by Benjamin »

It takes an immense amount of traffic combined with a large dataset and/or complex queries to get to a point where you even need slave servers. Focus more on the user experience.
Post Reply