| From: | dforum <dforums(at)vieonet(dot)com> |
|---|---|
| To: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Distant mirroring |
| Date: | 2008-08-09 17:29:39 |
| Message-ID: | 489DD403.6010101@vieonet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello,
I'm trying to install a solution to permit me to :
- Secure the datas, without RAID
- Giving ability to increase the potentiality of the database towards
the needs.
I have read about slony, DRBD, pgpool....
I don't find the good system to do what I want.
I manage for now 50 millions of request per month.
I will reach 100 millions in the end of the year I suppose.
There is 2 difficulties :
1 - is the storage : to get faster access,it is recommend to use SAS 15
000 tps. But the disk I can get are 149 GO of space. As the database is
growing par 1,7 Go per week at the moment, it will reach is maximum in 3
month. I can add 3 disk at least so It can go to 9 month. What to do
after, and especially what to do today to prevent it?
2 - The machine will treat more and more simultaneous entrance, so I
need to loadbalance those inserts/updates on several machine and to
replicate the datas between them. It's not a real problem if the data
are asynchrony.
I'm migrating to postgresql 8.3.3.
Thanks for all your remarks, suggestions and helps
David
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2008-08-09 19:29:52 | Re: Distant mirroring |
| Previous Message | Jeff Frost | 2008-08-09 06:17:23 | Re: index scan cost |