[Bringing this twitter discussion to the mailing list...]
So, for mysql, a new user needs to pay attention to a few things so as not to
fall on your face with dismal performance and problems with the default
install, such as:
- Create a my.cnf (start with one of the example files and use the reference
guide to understand all the settings in the example file)
- Ensure innodb is default engine
- Pay special attention to innodb memory allocations
Q mentioned that PostgreSQL has a bit of a learning curve ...... so what are
the top few things to take care of, or gotchas, for an initial setup that is
exclusively used for WebObjects (if that makes any difference)
What is (are) your favorite reference website(s) for PostgreSQL?
What about platform-independent database dumps - does it have sth similar to
mysqldump that makes a SQL file that can recreate the entire server on another
machine and newer version?
Is replication setup as easy as mysql?
Is replication over SSL supported (for remote repl/backup)
How do you install? binaries, build it form source (because the binaries do not
have essential options for example)?
-Kieran _______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to [email protected]
