| From: | Gregory Wood <gwood(at)ewebengine(dot)com> |
|---|---|
| To: | Jan Wieck <JanWieck(at)Yahoo(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: PG vs MySQL |
| Date: | 2004-03-30 09:55:18 |
| Message-ID: | 40694406.5020003@ewebengine.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Jan Wieck wrote:
> If you don't know the answers to that, I assume it isn't that easy as
> people try to make believe. And in case the answer is "that is not
> possible but ...", then you better think again what you want that
> replication setup for.
Although I agree with your points (especially having set up
contrib/dbmirror in the past, and anticipating Slony all the more
because of that experience), I would like to point out that
failover/high-availability is not the only reason to set up replication.
Lots of people just want the ability to load balance between several
servers.
Personally, I'd want the failover capabilities as well, just as I'd much
rather run RAID 0+1/10 or RAID 5 than RAID 0. That's not to say that
there aren't people that only care about speed through parallelism
though. In which case, your scenario isn't necessarily valid, with
regards to ease of setup/maintenence of replication.
Greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Shanmugasundaram Doraisamy | 2004-03-30 11:54:39 | Can we have time based triggers in Postgresql?? |
| Previous Message | Matthias Teege | 2004-03-30 08:23:20 | concat strings but spaces |