Re: Database choices
Re: Database choices
- Subject: Re: Database choices
- From: Kieran Kelleher <email@hidden>
- Date: Mon, 29 Oct 2007 15:27:29 -0400
WRT MySQL, configuring the /etc/my.cnf file for good InnoDB
performance is trivial enough. The my.cnf is simply a way of putting
all command line launch options in a file.... actually the format is
identical to our beloved WebObjects Properties file. The options are
very well documented in the online manual and in the three sample
config files provided.
About 10 settings and you are done .... they provide three sample
config files. Just pick one as a starting point and go to the innodb
section and configure the properties which are documented there with
comments.
Replication is very easy to setup and works very very reliably since
4.1.XX latest.
I use 4.1.XX latest with 5.0.XX latest "Connector/J" driver. Have not
had chance to move production to 5.0.XX yet since no compelling
reason for standard WebObjects usage.
On Oct 29, 2007, at 2:40 PM, Mike Schrag wrote:
I suspect they very likely have compelling performance numbers, but
I haven't had time to actually run tests with our real databases on
it ... There are graphical MySQL front-ends (whereas FB's is fine,
but sort of "passable"), and honestly there are pkg installs of it
also at this point, so it's not a WHOLE lot more than double-click-
to-install at this point. Slightly more obnoxious with permissions
and users, etc, I suspect. I think FB wins pretty handily in the
competition from zero-to-running-database, but how often are you
doing that part? In terms of % of time spent, that's only a
fraction of your db's life. I just don't want to discount it
because a decade ago it sucked.
ms
On Oct 29, 2007, at 2:22 PM, Chuck Hill wrote:
I am sure that you can make it go, but other than clustering, why
bother? If you don't need that it seems like a lot of
configuration work, research, etc. for what FrontBase gives you
with a single click installer.
Chuck
_______________________________________________
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