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      (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 [EMAIL PROTECTED]

Reply via email to