Hi Dipti,

We thought of keeping DR as simple as possible without MaxScale. When prod data center is gone for some reason (total disaster which includes application server as well as maxscale server because everything is from that data center), DR will serve as a bare-minimum infrastructure for business continuity. 

So our current plan is: 

- keep only one Maria DB server instance - (replicated as real-time from production site to DR site)
- keep all the application servers pointing to this maria DB
- no max scale configuration at DR

All operation (including write) will be on this DR Site. We will sync-it up later to the prod Db when its up. Please share your thought on this. 

The reason we are not planning to use max scale at DR is - we are not going to have any replication feature required in DR since its going to be a single instance of maria db. All queries from app server will directly connecting this maria DB without maxscale. 

Regards,
Karthick

On Tue, Jul 5, 2016 at 7:56 PM, Dipti Joshi <dipti.joshi@mariadb.com> wrote:
Karthick:

Wanted to confirm what is your server configuration on  DR site ? Do you expect your write queries to continue on DR site  when production is down ?

Regards,
Dipti

On Tue, Jul 5, 2016 at 8:16 AM, Dipti Joshi <dipti.joshi@mariadb.com> wrote:
Karthick,

Also copying this conversation to maxscale@googlegroups.com

Based on your configuration, you should also setup your DR site similar way as your product site, i.e. MaxScale in both locations. 

Regards,
Dipti

On Tue, Jul 5, 2016 at 12:02 AM, Karthick Subramanian <ksubramanian@paycommerce.com> wrote:
Dear Experts,

I have a question on Max Scale requirement:

In prod - we have two DB server as Primary(Master) and Secondary(Slave). Both being controlled via MaxScale. 

Do we need to really set it up similar way in DR site also? I meant - Do we need to keep Max Scale set it up in DR as well. Anyway, DR is going to be exceptional scenarios in which entire application servers also work out of DR site and we can still point all the app servers in DR site configured directly to access the Maria DB server at DR instead of Max Scale. 

Note: We are currently not using MaxScale for any complex needs, we are using MaxScale for normal routing like RW split etc. 

I know ideal is keep both Prod site and DR site equivalent. But as cost cutting on servers etc, shall we keep DR the way I mentioned. Could you please provide your opinion on this. 

Regards,
Karthick

_______________________________________________
Mailing list: https://launchpad.net/~maria-discuss
Post to     : maria-discuss@lists.launchpad.net
Unsubscribe : https://launchpad.net/~maria-discuss
More help   : https://help.launchpad.net/ListHelp