Thread: Master slave replication

Master slave replication

From

arvind chikne

Date:

17 July 2018, 18:01:34

Hi,

Pls suggest a good open source replication tool for huge database, I discovered slonyi but its seems not easy to configure it bit tricky.

Thanks & Regards
Arvind rao chikne

9818979986

Think Green!!! Please consider your environmental responsibility before printing this e-mail

Re: Master slave replication

From

bhanu prabhakar

Date:

17 July 2018, 18:02:45

Go with shareplex

On Tue, Jul 17, 2018, 5:32 PM arvind chikne <arvind.chikne@gmail.com> wrote:

Hi,

Pls suggest a good open source replication tool for huge database, I discovered slonyi but its seems not easy to configure it bit tricky.

--
Thanks & Regards
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail

Re: Master slave replication

From

arvind chikne

Date:

17 July 2018, 18:08:35

Hi Bhanu,

Thanks, is it open source if yes, I would appreciate if you can share some document to configure it on ubuntu/centos platform

On Tue, Jul 17, 2018 at 5:32 PM, bhanu prabhakar <bhanu1208@gmail.com> wrote:

Go with shareplex

On Tue, Jul 17, 2018, 5:32 PM arvind chikne <arvind.chikne@gmail.com> wrote:
Hi,

Pls suggest a good open source replication tool for huge database, I discovered slonyi but its seems not easy to configure it bit tricky.

--
Thanks & Regards
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail

Thanks & Regards
Arvind rao chikne

9818979986

Think Green!!! Please consider your environmental responsibility before printing this e-mail

Re: Master slave replication

From

Fabio Pardi

Date:

17 July 2018, 18:09:16

streaming replication can do it for you

https://www.postgresql.org/docs/current/static/warm-standby.html#STREAMING-REPLICATION

else pglogical extension might fit too

If i were you, I would not look for something 'easy' but 'robust'
instead. Take into account that any replication mechanism you are going
to use, requires knowledge which takes time to acquire.

regards,

fabio pardi

On 07/17/2018 02:01 PM, arvind chikne wrote:
> Hi, 
> 
> Pls suggest a good open source replication tool for huge database, I
> discovered slonyi but its seems not easy to configure it bit tricky.   
> 
> 
> 
> -- 
> /Thanks & Regards/
> Arvind rao chikne
> 9818979986
> *Think Green!!!* Please consider your environmental responsibility
> before printing this e-mail
>

Re: Master slave replication

From

Shreeyansh Dba

Date:

17 July 2018, 18:44:22

Hi Arvind,

You can use repmgr tool to build replication, go through the below link.

https://repmgr.org/docs/repmgr.html

Hope this helps.

On Tue, Jul 17, 2018 at 5:31 PM, arvind chikne <arvind.chikne@gmail.com> wrote:

Hi,

Pls suggest a good open source replication tool for huge database, I discovered slonyi but its seems not easy to configure it bit tricky.

--
Thanks & Regards
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail

Re: Master slave replication

From

Mariel Cherkassky

Date:

17 July 2018, 19:05:31

I recommend the repmgr tool.

2018-07-17 15:44 GMT+03:00 Shreeyansh Dba <shreeyansh2014@gmail.com>:

Hi Arvind,

You can use repmgr tool to build replication, go through the below link.

https://repmgr.org/docs/repmgr.html

Hope this helps.

On Tue, Jul 17, 2018 at 5:31 PM, arvind chikne <arvind.chikne@gmail.com> wrote:

Hi,

Pls suggest a good open source replication tool for huge database, I discovered slonyi but its seems not easy to configure it bit tricky.

--
Thanks & Regards
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail

Re: Master slave replication

From

arvind chikne

Date:

20 July 2018, 18:21:13

Hi All,

I am trying to configure repmgr

I am getting following error while Initialise the master server

[2018-07-20 17:41:23] [ERROR] unable to create the function repmgr_update_last_updated: ERROR: could not access file "$libdir/repmgr_funcs": No such file or directory

[2018-07-20 17:41:23] [ERROR] Unable to create repmgr schema - see preceding error message(s); aborting

I already changed the shared_preload_libraries = 'repmgr' in postgres.conf in master server but still getting the same error pls suggest

On Tue, Jul 17, 2018 at 6:35 PM, Mariel Cherkassky <mariel.cherkassky@gmail.com> wrote:

I recommend the repmgr tool.

2018-07-17 15:44 GMT+03:00 Shreeyansh Dba <shreeyansh2014@gmail.com>:
Hi Arvind,

You can use repmgr tool to build replication, go through the below link.

https://repmgr.org/docs/repmgr.html

Hope this helps.

On Tue, Jul 17, 2018 at 5:31 PM, arvind chikne <arvind.chikne@gmail.com> wrote:
Hi,

Pls suggest a good open source replication tool for huge database, I discovered slonyi but its seems not easy to configure it bit tricky.

--
Thanks & Regards
Arvind rao chikne
9818979986
Think Green!!! Please consider your environmental responsibility before printing this e-mail

Thanks & Regards
Arvind rao chikne

9818979986

Think Green!!! Please consider your environmental responsibility before printing this e-mail

Re: Master slave replication

From

Ian Lawrence Barwick

Date:

21 July 2018, 06:52:26

2018-07-20 21:21 GMT+09:00 arvind chikne <arvind.chikne@gmail.com>:

Hi All,

I am trying to configure repmgr

I am getting following error while Initialise the master server

[2018-07-20 17:41:23] [ERROR] unable to create the function repmgr_update_last_updated: ERROR: could not access file "$libdir/repmgr_funcs": No such file or directory

[2018-07-20 17:41:23] [ERROR] Unable to create repmgr schema - see preceding error message(s); aborting

I already changed the shared_preload_libraries = 'repmgr' in postgres.conf in master server but still getting the same error pls suggest

How did you install repmgr, e.g. from an OS package (which?) or from source?

Regards

Ian Barwick

Re: Master slave replication

From

suresh neravati

Date:

21 July 2018, 10:01:12

Hi,

There is another open source tool, stolon. sorintlab/stolon This has 3 components, sentinel, keeper and proxy.

Sentinel will monitor the Postgresql database master/slave, Keeper will manages the Postgresql database on the node, Proxy maintains the connection coming from application to database.

Stolon will monitor and maintain the streaming replication automatically. In case of Failover/switchover, stolon will take care of changing slave to master and failed master to standby automatically.

Only one additional thing you need is Consul/etcd to store the master/slave instant information by stolon.

This works even for the Kubernates in case if you want to use the Postgresql database on Cloud.

Please let me know if you have any further questions.

Thanks,

Suresh Neravati.

sorintlab/stolon

stolon - PostgreSQL cloud native High Availability and more.

On Friday, July 20, 2018, 5:53:00 PM PDT, Ian Lawrence Barwick <barwick@gmail.com> wrote:

2018-07-20 21:21 GMT+09:00 arvind chikne <arvind.chikne@gmail.com>:

Hi All,

I am trying to configure repmgr

I am getting following error while Initialise the master server

[2018-07-20 17:41:23] [ERROR] unable to create the function repmgr_update_last_updated: ERROR: could not access file "$libdir/repmgr_funcs": No such file or directory

[2018-07-20 17:41:23] [ERROR] Unable to create repmgr schema - see preceding error message(s); aborting

I already changed the shared_preload_libraries = 'repmgr' in postgres.conf in master server but still getting the same error pls suggest

How did you install repmgr, e.g. from an OS package (which?) or from source?

Regards

Ian Barwick

Re: Master slave replication

From

arvind chikne

Date:

21 July 2018, 18:01:21

yes i installed it through os package apt-get install

On Sat, Jul 21, 2018 at 6:22 AM, Ian Lawrence Barwick <barwick@gmail.com> wrote:

2018-07-20 21:21 GMT+09:00 arvind chikne <arvind.chikne@gmail.com>:
Hi All,

I am trying to configure repmgr

I am getting following error while Initialise the master server

[2018-07-20 17:41:23] [ERROR] unable to create the function repmgr_update_last_updated: ERROR: could not access file "$libdir/repmgr_funcs": No such file or directory

[2018-07-20 17:41:23] [ERROR] Unable to create repmgr schema - see preceding error message(s); aborting

I already changed the shared_preload_libraries = 'repmgr' in postgres.conf in master server but still getting the same error pls suggest

How did you install repmgr, e.g. from an OS package (which?) or from source?

Regards

Ian Barwick

Thanks & Regards
Arvind rao chikne

9818979986

Think Green!!! Please consider your environmental responsibility before printing this e-mail