RE: help with site+database
On Tuesday, July 17, 2001 10:37 AM, Jeremy Lunn wrote:
>I do have a serious use for a database soon so I'll be sure to test both
>database packages out myself. Replication will be important though and
>last time I checked mysql didn't have any which is pretty useless (but I
>think they might have been implementing it).
MySQL 3.23.x does have replication however it is rudimentary. You basically
have master/slave configurations. Although this can work bidirectionally,
that can screw up AUTO_INCREMENT tables if you do an INSERT into such a
table on both your servers ``simultaniously''. It also seems like no fun to
administer.
If you can live with doing all your UPDATEs on a single, master server, and
slaving your other server(s) to it, MySQL's replication is not impossible to
use or understand; but obviously that makes application development more
difficult and time-consuming.
What replication capabilities does pgsql have? Here is a link to MySQL's
replication documentation:
http://www.mysql.com/doc/R/e/Replication.html
- jsw
Reply to: