Обсуждение: postgresql and glusterFS
Hi all. I wonder if I can install/configure postgresql with a distributed file system ...specifically glusterFS? is it supported? Does it work properly.the ENV is on Centos 7Any idea?Cheers--Alfredo
Hey Alfredo,You can set up ceph as back end/data storage for postgres. Moreover you'll get a better community support as well.On Wed, Sep 12, 2018 at 2:26 PM Alfredo De Luca <alfredo.deluca@gmail.com> wrote:Hi all. I wonder if I can install/configure postgresql with a distributed file system ...specifically glusterFS? is it supported? Does it work properly.the ENV is on Centos 7Any idea?Cheers--Alfredo
Dear team,
Would please remove me from the group? thx
Beat Regard,
Zhenyu Xu
发件人: Prince Pathria <prince.pathria@goevive.com>
发送时间: Wednesday, September 12, 2018 17:12
收件人: alfredo.deluca@gmail.com
抄送: pgsql-admin@lists.postgresql.org
主题: Re: postgresql and glusterFS
Hey Alfredo,
You can set up ceph as back end/data storage for postgres. Moreover you'll get a better community support as well.
On Wed, Sep 12, 2018 at 2:26 PM Alfredo De Luca <alfredo.deluca@gmail.com> wrote:
Hi all. I wonder if I can install/configure postgresql with a distributed file system ...specifically glusterFS? is it supported? Does it work properly.
the ENV is on Centos 7
Any idea?
Cheers
--
Alfredo
Hi all. I wonder if I can install/configure postgresql with a distributed file system ...specifically glusterFS? is it supported? Does it work properly.the ENV is on Centos 7Any idea?
Em qua, 12 de set de 2018 às 10:56, Alfredo De Luca <alfredo.deluca@gmail.com> escreveu:Hi all. I wonder if I can install/configure postgresql with a distributed file system ...specifically glusterFS? is it supported? Does it work properly.the ENV is on Centos 7Any idea?It works and it supports all POSIX semantics. And because of it, it's slow as hell to writes because a FS lock acquired by PostgreSQL has to be replicated to all nodes before being confirmed. If you have a read bound database you should be fine tho.I have tested it but never put in production, it's useless.What exactly you want to do?Flavio
thanks heaps.The idea is actually to use K8s so install postgres with glusterfs as storage manager so in case a POD crashes can start again on another node with the same file systems
Re: Flavio Henrique Araque Gurgel 2018-09-13 <CAGHTAeMkTMRe+nMAxW_2sMPPraMoBMTnbvZVa=SmXX4Ci1S+fA@mail.gmail.com> > You should think of using PostgreSQL native replication to a standby pod on > another kubernetes node. patroni supports kubernetes, have a look at that. Christoph
Re: Flavio Henrique Araque Gurgel 2018-09-13 <CAGHTAeMkTMRe+nMAxW_2sMPPraMoBMTnbvZVa=SmXX4Ci1S+fA@mail.gmail.com>
> You should think of using PostgreSQL native replication to a standby pod on
> another kubernetes node.
patroni supports kubernetes, have a look at that.
On 12/09/18 21:11, Prince Pathria wrote: > Hey Alfredo, > > You can set up ceph as back end/data storage for postgres. Moreover > you'll get a better community support as well. > I'd add a +1 for Ceph as opposed to Gluster. Great community support and a better designed product. Where I work, we run an Openstack Cloud with Ceph as the backing for the block storage provider (Cinder). A number of customers use Postgres and Mysql on this setup. regards Mark
On 12/09/18 21:11, Prince Pathria wrote:
> Hey Alfredo,
>
> You can set up ceph as back end/data storage for postgres. Moreover
> you'll get a better community support as well.
>
I'd add a +1 for Ceph as opposed to Gluster. Great community support and
a better designed product.
Where I work, we run an Openstack Cloud with Ceph as the backing for the
block storage provider (Cinder). A number of customers use Postgres and
Mysql on this setup.
regards
Mark
thanks everybody. I don't think we can use ceph (which I would prefere anyway) as we have already glusterFS for other stuff.thanks heapsOn Thu, Sep 13, 2018 at 12:05 PM Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:On 12/09/18 21:11, Prince Pathria wrote:
> Hey Alfredo,
>
> You can set up ceph as back end/data storage for postgres. Moreover
> you'll get a better community support as well.
>
I'd add a +1 for Ceph as opposed to Gluster. Great community support and
a better designed product.
Where I work, we run an Openstack Cloud with Ceph as the backing for the
block storage provider (Cinder). A number of customers use Postgres and
Mysql on this setup.
regards
Mark--Alfredo
The information contained in this email message is PRIVATE and intended only for the personal and confidential use of the recipient named above. If the reader of this message is not the intended recipient or an agent responsible for delivering it to the intended recipient, you are hereby notified that you have received this message in error and that any review, dissemination, distribution or copying of this message is strictly prohibited. If you have received this communication in error, please notify us immediately by email, and delete the original message.