On Fri, Mar 20, 2009 at 1:53 PM, fooler mail <[email protected]> wrote: .. > shared-nothing architecture where each node is independent and > self-sufficient and there is no single point of contention across the > system... one good example and demonstrated how effective > shared-nothing architecture and scale almost *infinitely* by adding an > inexpensive node since there is no single bottleneck to slow down the > system is google database (using a flat file spreads across the > system)... amazon is doing this also... with a massive read and write > transactions.. shared-nothing is the logical choice here... > > i have experienced with oracle rac (10gR2) and experienced how it was > bog down the whole RAC system too.. tsk tsk tsk
1) has anyone really looked into MySQL Cluster? I have. That shared-nothing implementation is.. really hard to use in practice. You are limited to available memory (!) because NDB Cluster is an in-memory implementation. And look at their references.. who has heard of Zillow.com? I looked into MySQL Cluster before at a prior role, and I concluded that for what we wanted, MySQL Cluster was more trouble than it was worth. My understanding is that due to the replication topology, your writes will not scale well as the number of nodes increases as you have to propagate changes OVER THE NETWORK to the other nodes. So much for linear scalability... MySQL Cluster's overview claims "few milliseconds" query latency and "tens of thousands" of transactions per second. I'd bet those are mostly reads. Oracle In-Memory Database can do SIX MICROSECOND selects and FIFTEEN MICROSECOND updates, and up to 750K selects/second (write performance is considerably less, around 200K/second). Granted this is not Oracle DB, but it's the more logical comparison to MySQL Cluster. 2) Amazon has the world's largest data warehouse. And it's not running a shared-nothing MySQL architecture. -- Orlando Andico +63.2.976.8659 | +63.920.903.0335 _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
