maria-discuss team mailing list archive

[Karthick Subramanian <ksubramanian@xxxxxxxxxxxxxxx>]

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@xxxxxxxxxxx> 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@xxxxxxxxxxx>
> wrote:
>
>> Karthick,
>>
>> Also copying this conversation to maxscale@xxxxxxxxxxxxxxxx
>>
>> 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@xxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx
>>> Unsubscribe : https://launchpad.net/~maria-discuss
>>> More help   : https://help.launchpad.net/ListHelp
>>>
>>>
>>
>