On Mon, Aug 01, 2005 at 06:44:50PM +0200, Vratislav_Morkus@xxxxxx wrote: > Hi all, > I am sorry for a stupid easy question, but I'am PostgreSQL novice. > Our development team has encountered problem with trying to install and > maintain cluster (pgcluster) on our production database. So they have > decided to switch the entire solution to MySql database. > a) have you got any good/bad experience with administering and running > cluster on PostrgeSQL DB? > b) would u switch PostgreSQL to MySql (7.4 --> 4.1) and why? For pgcluster help, your best bet is to hit either their mailling list or their forums. http://pgfoundry.org/projects/pgcluster/ has more info. As for MySQL, http://sql-info.de/mysql/gotchas.html has about 100 different reasons why you don't want to use MySQL. Some favorites: Feb. 31st is a valid date Data will be silently truncated if it overflows 1/0 = NULL count(*) is an approximation easy to configure in such a way that it's not ACID ... -- Jim C. Nasby, Database Consultant decibel@xxxxxxxxxxx Give your computer some brain candy! www.distributed.net Team #1828 Windows: "Where do you want to go today?" Linux: "Where do you want to go tomorrow?" FreeBSD: "Are you guys coming, or what?" ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
