| From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: general features |
| Date: | 2007-06-03 15:47:27 |
| Message-ID: | 4662E28F.5000805@cox.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 06/03/07 09:08, Badawy, Mohamed wrote:
[snip]
>
> Thanks for all of the replies,,,
>
> What I mean by clustering is to put the database on many machines.
Single database on many machines?
Do you mean federation/horizontal scaling, or DR replication or
something different. PostgreSQL has master-slave replication using
Slony-1.
If you mean simultaneous access to the same disks from multiple
machines without corrupting the data, you'll have to go to a
proprietary system. 10K (15K if you've got the scratch) RPM RAID10,
8GB RAM and a couple of dual-core Opterons is a *really* fast
database box. You might not need more than that.
But if you *do* need the continuous uptime that shared-disk
clustering and rolling in-place upgrades gives you, then Rdb/VMS
can't be beat. It'll *cost*, though.
--
Ron Johnson, Jr.
Jefferson LA USA
Give a man a fish, and he eats for a day.
Hit him with a fish, and he goes away for good!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ian Harding | 2007-06-03 15:48:51 | Re: multimaster |
| Previous Message | Badawy, Mohamed | 2007-06-03 14:08:14 | Re: general features |