On Sat, Mar 21, 2009 at 2:16 AM, Orlando Andico <[email protected]> wrote: > This thread has gone in two directions at once: first, a generic > "shared-nothing" versus "shared everything" debate, and second, > comparing MySQL Cluster to other things. > > Since this was originally a "Oracle to MySQL migration" thread I'll > try to address the MySQL cluster topic first:
ok.. let us try to simmer this down... im emphasizing here the shared-everything vs shared-nothing architecture when it comes to scalability... mysql cluster is just only one of the example of shared-nothing as there are lots of shared-nothing technology out there with different approach... ibm's db2 and ncr's teradata are the leaders when it comes to shared-nothing database.. > Very true. Expertise doesn't come free with any technology. is this coming from a closed source mentality? how about the open source mentality? > I would expect that MySQL Cluster is not a major player in the > embedded telecom space. There are a lot of incumbents in there: > TimesTen, SolidDB, Altibase to name a few. but your question is who uses mysql cluster and alcatel and vodafone are examples the ones using it... panterra networks for their on demand unified communications.. bredbandsbolaget a broadband internet provider in sweden for their subscriber profiles and authentication.. viasuisse AG for their real-time traffic information and others... > To be honest, the last time I checked MySQL Cluster was 3 years ago > and I was not impressed. The feature set seems to be improving nicely. > I think it's time I revisit MySQL Cluster. (for which I have fooler to > thank...) orly same true also with oracle 8 and 9 clustering.. oracle suffered some problems too thus the improvements and address those problems come into oracle 10... > This is fine if the workload can be cleanly partitioned. However many > transactional workloads cannot be sliced-and-diced so easily. > > Having shared-nothing and individual buffer caches means you cannot > guarantee transactional integrity across all members. For things like > Google (which is bulk write from robot + many many reads) basically > any read-mostly workload, this will work fine. the industry standard for complex business intelligence processing is the TPC-H benchmark... large-scale and multi-terabyte procesing shows that databases using shared-nothing architecture are the ones heavily used in this arena... furthermore.. shared-nothing architecture have been shown to produce tremendous scaling results for OLTP application (aside from database) when partition.. > As N gets large, RAC scalability for writes gets to the point of > diminishing returns. Not a limitation unique to RAC, even SMP boxes > suffer from this. simply because shared-everything is a SMP while shared-nothing is a MPP... > Shared-nothing is a known scalable solution, almost all the Top500 > supercomputers are MPP. But shared-nothing has been traditionally very > hard use get working properly for traditional workloads. TPC-H will show you the reality... see my last paragraph below... > Greenplum and Netezza (and DATAllegro) have tiny market share. The > much-derided RAC has over 40% of the worldwide data warehousing > market. So if you went for these products, you'd have a much smaller > community to turn to for help. And these products (well even Exadata) > aren't designed for OLTP workloads which I believe are most > interesting to PLUG readers. naahh... you are talking as salesman as well as a marketing guy here.. we should focus the technical merits of a shared-everything versus shared nothing... > Besides it's built for a query workload where it's permissible to lose > data. Which is an important use case but not one that most of us can > use. thats your perception as you simply show that you dont know the inner workings of a shared-nothing architecture... shared-nothing architecture is reliable too.. > It never is just about the finished product. It's also about support, > help with best practices, etc. I have a bad feeling about MySQL > Cluster because the last time I tried it, I got nowhere with it. > Besides, a product's limitations always come out when you're already > doing your non-trivial production workload, at which point, you'll be > much happier if there are some people whose job it is to help you and > you can yell at them. ok then.. assuming you have the million bucks money.. you are not working from oracle and looking for a scalable database... ill refer to you the TPC-H benchmark website: http://www.tpc.org/tpch/ which database clustering solution you would choose as a technical guy as usually we technical guys are always looking for price over performance? fooler. _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
