| Subject | Re: [Firebird-Architect] Re: web scale databases |
|---|---|
| Author | Milan Babuskov |
| Post date | 2010-05-28T12:56:50Z |
Hi Paul,
I agree with you that most web companies do not need a scale-out solution.
paulruizendaal wrote:
these kind of systems? I love Firebird, but it would really need to be
tested in these types of scenarios. Do we know of any use cases?
I believe even MSSQL does not stand a chance against MySQL. If you look
at the article about stackoverflow, even they concluded that foreign
keys and normalization are not a good idea when "absolute" performance
is necessary. This means they are dropping the main benefits of
"enterprise features" and only using the database as a dumb store
without any business logic - exactly where MySQL shines. In fact, they
would've probably got it much cheaper and faster with combined
Microsoft+OpenSource stack. I would never use MySQL for some ERP, but I
would think twice before switching away from it for Internet-run web apps.
Hm, maybe I really should do some benchmark. I have one website with 5k+
daily visitors, 400k+ PHP page hits and some 5milion-record tables in
the database - which are read at least twice on each page load.
Currently MySQL load peaks at about 60-70 simultaneous connections and
it's handling it well. All this on VPS hosting with 512MB of RAM. Maybe
I should try rewriting the backend to use Firebird and let it run to see
where we're at. I guess SuperServer should be able to handle this load
nicely.
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================
I agree with you that most web companies do not need a scale-out solution.
paulruizendaal wrote:
> There are a few ways to overcome this problem, just to name a few:I assume you are aiming at Firebird being the database of choice for
> - convince number 1,001 to 10,000 on the Alexa list that they need a scale out database right from the start because they may become a top-1000 player
> - find uses for scale out databases other than web properties
these kind of systems? I love Firebird, but it would really need to be
tested in these types of scenarios. Do we know of any use cases?
I believe even MSSQL does not stand a chance against MySQL. If you look
at the article about stackoverflow, even they concluded that foreign
keys and normalization are not a good idea when "absolute" performance
is necessary. This means they are dropping the main benefits of
"enterprise features" and only using the database as a dumb store
without any business logic - exactly where MySQL shines. In fact, they
would've probably got it much cheaper and faster with combined
Microsoft+OpenSource stack. I would never use MySQL for some ERP, but I
would think twice before switching away from it for Internet-run web apps.
Hm, maybe I really should do some benchmark. I have one website with 5k+
daily visitors, 400k+ PHP page hits and some 5milion-record tables in
the database - which are read at least twice on each page load.
Currently MySQL load peaks at about 60-70 simultaneous connections and
it's handling it well. All this on VPS hosting with 512MB of RAM. Maybe
I should try rewriting the backend to use Firebird and let it run to see
where we're at. I guess SuperServer should be able to handle this load
nicely.
> - don't sell a cloud database but a web solution, including all the surrounding engineering in $ 1 mln projectsNow if only there was a company smart enough to start doing that today... ;)
--
Milan Babuskov
==================================
The easiest way to import XML, CSV
and textual files into Firebird:
http://www.guacosoft.com/xmlwizard
==================================