Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers
by brianwawok on Friday October 31, 2014 @04:02PM
(#8540815)
It is tricky. It is also hard to make a real FT postgresql instance, as most tutorials have a single pgpool node doing the load balancing, which shifts the SPOF to the pgpool node. You can do it more or less with a virtual IP ala http://www.pgpool.net/pgpool-web/contrib_docs/watchdog_maste...
To add sharding on top of that is a similar tutorial, but even more complicated.
Re:Making PostgreSQL Scale Hadoop-style: Benchmark Numbers
by takeda on Friday October 31, 2014 @05:32PM
(#8541228)
What about Postgres-XL?
I'm genuinely asking. I did not use it yet, but when I was researching database design subject that was my assumption we would use if we need to scale horizontally.
I tried google'n for tutorials but there are none.
There are no books on clustering or sharding postgresql too? At least I haven't found any.