I have a need to be able to automatically failover my databases and most need data replication. However, one database does not need data replication and so, for performance reasons, we do not include that in the auto failover plan since it requires data replication. Is there a way to disable data replication for certain databases?
Sql-server – Automatic Failover without data replication
failoverreplicationsql-server-2012
Related Question
- SQL Server AlwaysOn – How Automatic Failover Works
- MongoDB – Setting Up Automatic Failover Without Data Duplication
- Postgres 9.4 Replication Slots – Failover Master Issues
- Sql-server – Manual sql failover machine with replication
- MySQL Master to Master Replication Setup with Automatic Failover
- MariaDB Master / Slave failover / failback automation
- Sql-server – Cannot connect after Availability Group automatic failover
Best Answer
Judging by your comment, it sounds like you are looking to make the move to AlwaysOn Availability Groups. The way that availability groups work is that you choose which databases are added to the availability group and are therefore part of the high availability implementation.
So in other words, if you want
Database1andDatabase2to be highly available with automatic failover, then you configure a partner to have synchronous commit and be an auto failover partner, and when you create your availability group you add those two databases to the availability group. But if you don't wantDatabase3to be part of that topology, then you simply don't do anything with that database regarding the availability group.