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! with regards, -- Lachlan Deck _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
