MS Sql has a fake active-active system. They are all active-passive or 'pretend' active-active, with no load balancing. You cant just throw in 10 sql servers with non shared storage, attach a load balancer, and gain 10x read/write performance and redundancy. Things like AWS Aurora support this out of the box. Why doesn't Sql offer something similar after decades?
4
-
1This is a GREAT idea. You should post it on Microsoft's feedback forum for SQL Server. Make sure you update your question with a link to the feedback item.– Erik Reasonable Rates DarlingCommented Nov 24, 2021 at 11:30
-
Seems like you might have a misunderstanding of the features available on SQL Server and perhaps should do some more research and experimentation before posing such a blunt question. In short, Load Balancing and true Active-Active data synchronization does exist among the many data synchronization features available in SQL Server. If after you research those features and have a question specific to one of them, then your question may be better suited here. Or if you want to ask a question regarding your end goals, then the appropriate features can be suggested to achieve them.– J.D.Commented Nov 24, 2021 at 12:41
-
In addition to editing your question to be more focused, it will be more likely to be re-opened if you change the tone to be less like a rant.– Doug DedenCommented Nov 24, 2021 at 16:11
-
im sorry ive been searching for years for a solution. just frustrated. i created another question which is less a rant. thanks for the info about Transactional Replication.– LukeCommented Nov 25, 2021 at 21:56
Add a comment
|
2 Answers
SQL Server has Merge Replication, you can read and write on both Publisher and Subscriber sides:
If Merge Replication does not have load balancing, it doesn't mean it is "fake active active system". It just does not have kind of load balancing you want, however you can still set up your apps so they use all nodes
Why doesn't Sql offer something similar after decades?
Because MSSQL's biggest customers who bring most money to MS, did not ask for that feature you want ? If they did, believe me SQL Server could already do what you described
answered Nov 24, 2021 at 12:43
-
1Peer-to-Peer Transactional Replication and Transactional Publication with Updatable Subscriptions are two other Active-Active features as well. But I didn't feel OP's question warranted an answer with how unfocussed it was.– J.D.Commented Nov 24, 2021 at 12:59
-
im sorry ive been searching for years for a solution. just frustrated. i created another question which is less a rant. thanks for the info about Transactional Replication.– LukeCommented Nov 25, 2021 at 21:56
-
@Luke happens. Please vote up and mark as answer if you find my above answer useful. I will try to write an answer for your another question, later this evening. Have something to share Commented Nov 26, 2021 at 8:56
Have you ever heard about SQL server's AlwaysOn? It might meet some of your requirements and answer your questions.
-
AO is confusing. But Transactional Replication seems to do everything anyone could want. Hopefully doesnt require AD.– LukeCommented Nov 25, 2021 at 21:58