Обсуждение: Master slave replication

Поиск
Список
Период
Сортировка

Master slave replication

От
arvind chikne
Дата:
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

От
bhanu prabhakar
Дата:
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

От
arvind chikne
Дата:
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

От
Fabio Pardi
Дата:
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

От
Shreeyansh Dba
Дата:
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

От
Mariel Cherkassky
Дата:
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

От
arvind chikne
Дата:
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

От
Ian Lawrence Barwick
Дата:


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

От
suresh neravati
Дата:
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.




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

От
arvind chikne
Дата:
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