Re: MySQL [was: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]]
Re: MySQL [was: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]]
- Subject: Re: MySQL [was: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]]
- From: Mike Schrag <email@hidden>
- Date: Fri, 4 Dec 2009 20:46:15 -0500
>> So, to sum up the pros and cons we heard in the discussion:
>>
>> FOR MySQL
>> - Free
>> - Easy to setup and configure
>> - Clustering engine
>
> I have read a bit about this part as I'm always curious about synchronous multi-master clustering support in DBs. From Are people here referring to NDB Cluster? From reading the white papers I was kind of wondering how this could in any way be used in the typical (outside big corporations) requirements. Is somebody here actually using this?
>
> And I'm not talking about asynchronous replication, I'm talking about real multi-master cluster with guaranteed integrity.
That's what I'm referring ... I have not used it, only read about it enough to be intrigued by it. It requires your entire database to be loaded into memory, but memory is pretty damn cheap. If you have a truly HUGE database, this is not an option, but most of ours are not larger than the reasonable max amount of memory.
>> AGAINST MySQL
>> - Lack of deferred constraints
>> - Lack of transactional DDL (roll back failing migrations for example). As Mike pointed out, neither does Oracle, so not alone there.
> All toys ... :-P
Oracle's a weird cat ... On the one hand, it his this weird pile of ancient restrictions (31 char column name limits, etc). On the other hand, it's insanely fast. I don't have real scientific comparisons to back this up, but anecdotally, it's fast as hell.
ms
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden