Re: better architecture?

On 11/19/2014 05:58 PM, zach cruise wrote:
> i need some advice:
>
> 1. for our small business, i have a master (dev) - slave (prod) setup.
> i develop using the master. i get data from other people's dev
> (mssql) databases. i also get data from their prod (mssql) databases. i
> replicate everything on slave.
>
> apps using the master can connect only to dev databases, and apps using
> the slave can connect only to prod databases. so when it's time to go
> from dev to prod, i simply change that connection. no restart.
>
> comments?

Yes I am confused.

What replication method are you using?
The built in methods, Slony. Bucardo, etc?

The production users cannot enter or update records?

If you have replication set up master -> slave, how can there be a
difference between the two?

Not sure where the mssql databases into this?

>
> 2. what happens if master-slave are rebooted at different times?
>
> 3. i also need to auto-promote slave to master if master fails (without
> using repmgr or postgres-r or even postgres-xl). how?

Answers for 2 & 3 are dependent on answers to the above questions.
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com