4 ms·

I wish postgresql was easy to cluster. I tried google'n for tutorials but there are none. There are no books on clustering or sharding postgresql too? At leas

• brianwawok 12y ago
  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_master_slave/en.html 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.
• takeda 12y ago
  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.