Re: How can we expand PostgreSQL ecosystem?

On 07/03/16 11:54, José Luis Tallón wrote:
> On 03/07/2016 07:30 AM, Tsunakawa, Takayuki wrote:
>>> From: pgsql-hackers-owner@postgresql.org
>>> [mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of Mark Kirkwood
>>> For cloud - in particular Openstack (which I am working with ATM), the
>>> biggest thing would be:
>>>
>>> - multi-master replication
>>>
>>> or failing that:
>>>
>>> - self managing single master failover (voting/quorum etc)
>
> Hmm.... consul (optionally in a dockerized setup) ?
>     https://www.consul.io/

    There are already HA solutions based on consensus, like Patroni: 
https://github.com/zalando/patroni

>
>>> so that operators can essentially 'set and forget'. We currently use
>>> Mysql+ Galera (multi master) and Mongodb (self managing single master)
>>> and the convenience and simplicity is just so important (Openstack is a
>>> huge complex collection of services - hand holding of any one 
>>> service is
>>> pretty much a non starter).
>> Yes, I was also asked whether PostgreSQL has any optional 
>> functionality like Galera Cluster for MySQL.  He was planning a 
>> scalable PaaS service which performs heavy reads and writes. Demand 
>> exists.
>
> AFAIK, Galera has its own set of drawbacks....
    Right, some of them are explained here: 
https://aphyr.com/posts/327-jepsen-mariadb-galera-cluster
    Regards,
    Álvaro


-- 
Álvaro Hernández Tortosa


-----------
8Kdata