New answers tagged

-1

Why don't you use Database Mirroring instead and configure your applications to connect using a fail-over partner in the connection string (read more about that here Connect Clients to a Database Mirroring Session (SQL Server)). If you require automatic DBM fail-over then you will also need a Witness server (and run in-sync) in order to use High-Safety Mode ...


0

As mysqld spawns a new thread per connected slave to dump binary logs, I do not think adding a slave would have significant impact on node's performance.


-2

http://blogs.msdn.com/b/alwaysonpro/archive/2014/01/15/msdtc-recommendations-on-sql-failover-cluster.aspx just to link sQL servers why would you need MSDTC ? unless the sql servers are using the a distributed transaction in the tsql


0

Try single quotes in your powershell script. I beat my head against this for an hour before i switched that out, and it worked like a charm.


1

Removing SQL Server from failover cluster - you have to run the setup.exe and in maintenance you have to select remove node. Then removing the node from windows cluster, I would suggest you use PowerShell Remove-ClusterNode –Name node4 #change your node name here The Remove-ClusterNode cmdlet removes a node from a failover cluster. After the node is ...


0

I have just evicted in the past, it will stop the cluster services for you.


2

I've never tried this before but thinking this out logically, these are the things I would do (in no specific order): To answer your question yes, exclude drive K as a dependency as a cluster resource (this should prevent it from causing the cluster to go down when you need to remove it) Manually take those databases offline that are stored on drive K (I ...


2

Does the Windows Failover Cluster for a multi-subnet SQL Server Availability Group require a static IP entry for each subnet? The CNO will require an IP address for every subnet it could reside in. I am running SQL Server 2012 on Windows Server 2012 Hyper V VMs in 2 separate subnets in the same domain. I understand that I will need an IP from ...


1

edited answer based on the comments. For a basic setup here are a few things that I do before getting to the actual SQL install Have two additional IPs / Host Names in mind for the Windows Cluster and the SQL Server VIP Have two Domain service accounts setup for the Engine and the Agent (Something like DOMAIN\sql.eng.svc and DOMAIN\sql.agt.svc) Enable the ...


2

The config servers only hold metadata about which chunk is stored on which cluster, no actual data. There is no such thing called a "master server" in mongoDB, but I think what you are talking about is the shard router (mongos). When that is the case, then that server doesn't store any data at all. So the total capacity of the cluster is the sum of the ...



Top 50 recent answers are included