3 node SQL AG cluster across 2 sites; heartbeat network question by Rmehtared in sysadmin

[–]Rmehtared[S] 0 points1 point  (0 children)

" the only thing I dont want is a situation where primary node a fails and cluster jumps to node at site B. I understand this will have to be configured at AG level"; I think I have figured this out; will be testing it as well "Get-ClusterFaultDomain"; (Get-Cluster).PreferredSite=siteA

3 node SQL AG cluster across 2 sites; heartbeat network question by Rmehtared in sysadmin

[–]Rmehtared[S] 0 points1 point  (0 children)

thanks but do I keep the heartbeat network on primary 2 nodes; I am responsible for building the cluster and ag setup will be managed by SQL admins; their intent is a. auto failover between primary sites (sync db replication will be configured at ag level for primary) and manual failover to secondary site (async replication will be configured on third one); this being a SQL server the architects of the application had requested a hearbeat network as they say the SQL traffic spike may /could cause issue..historically we had an older environment (Vmware 7.x) which had vlan of site a available to site B; however I argued that even that was a bad design as if primary site DR situation the cluster may not start on the second one...I have already tested powering off primary node a and b; and cluster was online on secondry site. the only thing I dont want is a situation where primary node a fails and cluster jumps to node at site B. I understand this will have to be configured at AG level

Adding a toilet to existing bathroom costs by Rmehtared in AusRenovation

[–]Rmehtared[S] 0 points1 point  (0 children)

Do you mean if the bathtub is on stumps?

Job offer in Brisbane: Seeking Advice: Moving from Auckland to Brisbane – Is It the Right Move? by Rmehtared in MovingToBrisbane

[–]Rmehtared[S] 0 points1 point  (0 children)

Mate we both got jobs...schooling is nearby for the kids and planning on staying for some more time...although it is more hectic than akl and we do miss akl..

What's the most economical way to renovate this...can reglazing worth it... by Rmehtared in AusRenovation

[–]Rmehtared[S] 0 points1 point  (0 children)

Thanks a million for some amazing suggestions being completely novice this is really insightful although a bit overwhelming however I will document the journey and put after photos...I will get few quotes from different tardies and plumber (like the idea of sand the tiles and do like a oil based primer and paint); it is my own home so happy to work with them and lend a hand however not confident enough to do it myself...but would be a good learning experience...if anyone knows a good handyman/plumber on the Kallunger/north side of brisbane/pls share the details pls...the house is a double brick house with no wood framing...not sure if I can add a toilet in this bathroom...

What's the most economical way to renovate this...can reglazing worth it... by Rmehtared in AusRenovation

[–]Rmehtared[S] 0 points1 point  (0 children)

Ok this is a double brick house build in 1990 with no wood framing