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
PHP + Mysql on the cloud
Moderator: General Moderators
Re: PHP + Mysql on the cloud
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.
The problem is that I think it will be expensive, since they are afraid of posting the prices.
- Christopher
- Site Administrator
- Posts: 13596
- Joined: Wed Aug 25, 2004 7:54 pm
- Location: New York, NY, US
Re: PHP + Mysql on the cloud
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
Check out Google AppEngine and maybe read about how Google does it: https://www.google.com/search?q=how google scales databases
(#10850)
Re: PHP + Mysql on the cloud
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
Re: PHP + Mysql on the cloud
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.