Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: pgsql vs mysql
- From: "Jim C. Nasby" <jnasby(at)pervasive(dot)com>
- To: Merlin Moncure <mmoncure(at)gmail(dot)com>
- Cc: "howachen(at)gmail(dot)com" <howachen(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
- Subject: Re: pgsql vs mysql
- Date: Fri, 30 Jun 2006 19:30:18 -0500
On Fri, Jun 30, 2006 at 01:07:32PM -0400, Merlin Moncure wrote: > * mysql has decent out of the box replication that is easy to set up > (one day I hope pg get hot PITR which is analagous feature) Actually, PITR is in no way analagous. Try replicating something like 'INSERT INTO table SELECT random();' on MySQL and note how all the data is different. pgpool replication is equivalent to MySQL's replication. Or if you want more sophisticated replication, use Slony. BTW, anyone curious about the differences should take a look at google:'mysql gotchas' (there's also a PostgreSQL section on that site). See also the MySQL/PostgreSQL thread that was on this list yesterday. -- Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- References:
- pgsql vs mysql
- From: howachen
- Re: pgsql vs mysql
- From: Merlin Moncure
- pgsql vs mysql
- Prev by Date: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
- Next by Date: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
- Previous by thread: Re: pgsql vs mysql
- Next by thread: stored procedures
- Indexes: