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: Chuck Hill <email@hidden>
- Date: Thu, 3 Dec 2009 21:39:10 -0800
On Dec 3, 2009, at 5:44 PM, Lachlan Deck wrote:
On 04/12/2009, at 12:25 PM, Kieran Kelleher wrote:
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.
+ Deferred constraints!
That is a pretty big strike against MySQL in my books.
Chuck
--
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