On Sat, Mar 21, 2009 at 10:36 PM, Orlando Andico <[email protected]> wrote: >
now we are dealing another topic to debate but ill answer you... > Teradata isn't used for transactional at all.. teradata database specializing in data warehousing but their database is capable of transactional too.. it can do transaction rollback (eg. begin transaction (BT) and end transaction (ET) commands)... look at their customers section at wikipedia... http://en.wikipedia.org/wiki/Teradata bank of america.. you know how highly critical monetary transactions are there... > And DB2 hasn't won on any SAP ERP benchmarks recently. So > shared-nothing is not the end-all solution. I did point out earlier > that for business intelligence workloads (which is what TPC-H is) > Teradata is very dominant in this space. as what i have said in my first post.. there are pros and cons for everything.. know your workload first and choose the right database for you.. as you can see.. mysql has its own place based on the TPC benchmark... > No, it works both ways. I don't think MySQL Cluster can be tuned > effectively by someone like... me. It takes a lot of effort to tune > any technology the best way, and that costs time and/or money. If > expertise was easy to come by, we would not be on this mailing list. tuning is a black art... > > amusingly, all of these are from MySQL Cluster's wikipedia entry.... > but I digress. but that proves that they used mysql clustering and they are happy with it without a problem on their side... > And yes... for the commodity market, everybody is still going with > SMP. My point is that MPP is either exotic or expensive. Expertise is > harder to come by. the argument here is scalability... when SMP cant scale.. the next step is MPP.. > Shared-nothing is a well-known scalable technology, but for the vast > majority of the market, it's still exotic. exotic is meaningless if you need to scale as your workload grows... > > Top500 doesn't count. Teradata users don't count (they have lots of > money). Core banking systems, even our beloved web forums, mail > servers, most of them run on shared-everything. Shared-nothing is > still not within the reach of the "common technical user." > > Which is my entire point -- shared-nothing requires more rocket > science skills than shared-everything. Of course we all know the > limitations and performance plateau of shared-everything: but that > plateau is still high enough for most use cases. orly because your mindset wont adapt to the next level...your mindset is just like an old people that dont want to touch that computer or cellphone as it is hard for them to learn... > But again, that's not something we on PLUG generally do as part of our > daily lives. but someday they do and others are on it... fooler. _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List http://lists.linux.org.ph/mailman/listinfo/plug Searchable Archives: http://archives.free.net.ph
