Score:0

How to deploy multi master Microsoft SQL database as IaaS or AWS RDS

in flag

We have a vendor product, which support only relational databases (Oracle and MS SQL). Due to operational efficiency and cost, we are planning to use MS SQL. However, we have a challenge to deploy the product in Active-Active mode in two different AWS regions (East and West). Since (as per my knowledge) AWS RDS MS SQL or IaaS MS SQL always-on availability group doesn't allow multi-region writes. Also, due to latency concerns, we can not configure the product to the database in other region.

We want to have locally available database instance, where the product can read and write. Is there a way to deploy MS SQL server in multi-region, multi-master, where database servers in both regions can accept write transactions?

P.S.- This product is end user facing, with huge number of transactions. This product makes decisions based on user's transactional data.

Ben Thul avatar
cn flag
Even taking the added complexity of doing on AWS out of the equation, having more than one replica in a topology being able to accept writes is challenging. There's peer-to-peer replication but the db schema really has to be designed to use it (i.e. it's not something you can just put on top of an existing schema and call it done).
in flag
Hi @BenThul , can you please share more information on how to setup peer-to-peer replication?
Ben Thul avatar
cn flag
I have no practical experience with it and so whatever I'd be directing you towards would just be an uninformed regurgitation of Google results. I'd really make sure that you need local writes in multiple locations before going down this road though. There are a *lot* of high transaction websites that do everything from one datacenter (with a cold- to warm-DR site) that work just fine. The overhead in setting up for multiple writers is high.
mangohost

Post an answer

Most people don’t grasp that asking a lot of questions unlocks learning and improves interpersonal bonding. In Alison’s studies, for example, though people could accurately recall how many questions had been asked in their conversations, they didn’t intuit the link between questions and liking. Across four studies, in which participants were engaged in conversations themselves or read transcripts of others’ conversations, people tended not to realize that question asking would influence—or had influenced—the level of amity between the conversationalists.