• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
Re: Database choices
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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
  • Follow-Ups:
    • Re: Database choices
      • From: Andrew Lindesay <email@hidden>
References: 
 >Database choices (From: Ken Foust <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)
 >Re: Database choices (From: Chuck Hill <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)
 >Re: Database choices (From: Chuck Hill <email@hidden>)
 >Re: Database choices (From: Mike Schrag <email@hidden>)

  • Prev by Date: Re: Database choices
  • Next by Date: Re: WOApplication.createRequest 5.3 and 5.4
  • Previous by thread: Re: Database choices
  • Next by thread: Re: Database choices
  • Index(es):
    • Date
    • Thread