Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
- Subject: Re: Dr. Miguel 'Optimistic Locking' Arroz [was Re: WebObjects stress Testing tool?]
- From: Kieran Kelleher <email@hidden>
- Date: Thu, 03 Dec 2009 20:25:39 -0500
- Sun-java-system-smtp-warning: Lines longer than SMTP allows found and wrapped.
I was just wondering why people were saying disaster, toy, etc ....
wondering if I am missing something and going to lose all my data next
week!
Like I said, I have not used FrontBase or PostgreSQL in production and
have never touched PostgreSQL, so if it is comparison you are after, I
don't have one. However I will say that I started using MySQL at 4.0,
then 4.1 and now 5.0. Being the stickler for learning as much as I
think I need to do something right, I bought the original Jeremy
Zawodny book "Advanced MySQL" and that gave me a clear understanding
and confidence of how to set the thing up. I have never used the
cluster engine (NDB).... yet. I have always used InnoDB. I used MyISAM
once for a readonly database (about 5 tables only) that has geocode
lookups on tables of about 100 million rows because at the time it
appeared faster (with mysql 4.0 at the time) to do points in radius
operations which sometimes selected up to 500,000 rows in a select. My
main ongoing project is InnoDB and every user is a user that does
edits, with a small percentage of users absolutely hammering the
database with production processing during business hours each day. I
replicate to 3 slaves on that project purely for backup. It runs 24/7
and almost never have any "Scheduled Maintenance" downtime garbage
because of the fact that the replication slaves are where the backups
happen. One slave is remote and 2 onsite with the master. The binary
logs on the master are written to a separate phyaical drive
Why do I like it?
- It is free
- It has never left me down - no data/table corruption
- It is simple to set up and configure
- replication is a breeze to set up
- It has multiple engine types for different scenarios
- and finally the reason that most people like what they use: "I am
comfortable with it" ;-)
What would I like that I think I might be missing?
- transactional structure changes (ie., create table and roll back.)
transactions in InnoDB only apply to table/record edits themselves.
On Dec 3, 2009, at 7:17 PM, Chuck Hill wrote:
It is probably better to look at the flip side: what are my reasons
FOR using this database instead of any other database?
On Dec 3, 2009, at 2:58 PM, Kieran Kelleher wrote:
Miguel, anyone, please enlighten me as to what specifically is
wrong with using MySQL InnoDB as a database for WO because I have
not seen any problem, but then I have not used PostgreSQL or
FrontBase either - so maybe I don't see a problem that I should be
concerned about.
-Kieran
On Dec 3, 2009, at 5:41 PM, Miguel Arroz wrote:
Hi!
On 2009/12/03, at 22:32, Kieran Kelleher wrote:
I create new OSCs for most background tasks. The one thing is
that I dispose() on it at the end of the task .... and the
dispose() is only useful if you use ERXJDBCAdaptor is used
since the regular WO 5.3 jdbc adaptor opens two connections for
every OSC and leaves the stupid things open forever.
ERXJDBCAdaptor only opens one db connection and releases it
when u call dispose() IIRC.
Dude! <http://terminalapp.net/webobjects-postgresql-and-db-growing-and-growing/
> ;)
Dude! www.mysql.com - innodb (or cluster NDB) .... doesn't "grow
and grow" (and it is not a "toy", no matter what Chuck
says ;-) )
No, it's a disaster! ;)
The "growing" is a side effect of leaving the transaction opening
that happens on PostgreSQL due to its architecture, but the point
is the same, do what I say there to avoid the dumb connection. :)
Yours
Miguel Arroz
_______________________________________________
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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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