Clusteringformeremortals.com View information data

Clustering For Mere Mortals – Microsoft Cloud and …

Details: This data transfer cost can be minimized with the use of compression available in DataKeeper. Controlling Failover. In an FSx multi-subnet configuration there is a preferred availability zone and a standby …

› Verified 7 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Windows Server 2012 Clustering Step-by-Step

Details: The application data resides locally on each cluster node and DataKeeper keeps it replicated between all the cluster nodes to ensure each node has a local copy of the data. Failover clustering controls which node is the source, so when a failover happens all the writes occur locally and are automatically replicated to all of the remaining nodes

› Verified 2 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Step-by-Step: How to configure a SQL Server Failover …

Details: Before clicking Next, click on the Data Directories tab. Once SQL is installed on the first node, you will then need to run the installation on the second node. Create an Internal Load Balancer. Once the cluster is configured, you will need to create the internal load balancer(ILB) which will be used for all client access.

› Verified 9 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Step-by-Step: Configuring a 2-node multi-site cluster on Windows …

Details: SQL Server 2008 multi-site cluster on Windows Server 2008 R2. In Part 1 of this series, I showed you how to prepare your multi-site cluster, including setting up the Node and File Share Majority Quorum.In Part 2, we saw a video example of how to integrate SteelEye DataKeeper, one of the available cluster replication solutions, with failover clustering to …

› Verified 4 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Step-by-Step: Configuring a 2-node multi-site cluster on Windows …

Details: What is Metadata (with examples) - Data terminology

› Verified 4 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Step-by-Step: How to Trigger an Email Alert from …

Details: Windows Performance Counter Alerts can be configured to be triggered on any Performance Monitor (Perfmon) Counter through the use of a User Defined Data Collector Set. However, if you wish to be notified via email when an Alert is triggered you have have to use a combination of Perfmon, Task Scheduler and good ol' Powershell.…

› Verified 4 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

STEP-BY-STEP: HOW TO CONFIGURE A SQL SERVER 2008 …

Details: An unpatched instance of SQL Server could lead to data loss, downtime or a devastating data breach. One of the challenges you will face when running SQL Server 2008/2008 R2 in Azure is ensuring high availability. On premises you may be running a SQL Server Failover Cluster (FCI) instance for high availability, or possibly you are running SQL

› Verified Just Now

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Step-by-Step: Configuring a 2-node multi-site cluster on Windows …

Details: Integrating your storage replication with Failover Clustering Introduction. In Part 1 of this series, we took a look at the first steps required for building a multi-site cluster. We got to the point where we had a two node cluster that used a node and file share majority quorum, with no resources yet defined.

› Verified 4 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Step-by-Step: How to Trigger an Email Alert when a …

Details: From the XML view you can see all the data included with an event. Near the bottom of the XML you will see an array of data called <EventData>. Within there you will find additional Event Data stored as parameters. As show below, in the “param1” we will find the name of the Service being that either stopped or started.

› Verified 3 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Step-by-Step: How to Trigger an Email Alert from a …

Details: Introduction Setting up an email alert is as simple as creating a Windows Task that is triggered by an Event. You then must specify the action that will occur when that Task is triggered. Since Microsoft has decided to deprecate the "Send an e-mail" option the only choice we have is to Start a Program.…

› Verified Just Now

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Step-by-Step: How to configure a SQL Server 2008 R2 Failover …

Details: Today, most people have business critical SQL Server 2008/2008 R2 configured as a clustered instance (SQL Server FCI) in their data center. When looking at Azure you have probably come to the realization that due to the lack of shared storage it might seem that you can’t bring your SQL Server FCI to the Azure cloud.

› Verified 4 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  BusinessGo Now

Clustering SQL Server 2012 on Windows Server 2012 Step-by-Step

Details: Run DK Setup. Go through the entire installation process selecting all of the default values. Restart the computer after the installation completes as prompted and repeat the process on the SECONDARY server. Launch the DataKeeper UI on PRIMARY and click Connect to Server. Connect to PRIMARY and then connect to SECONDARY.

› Verified 1 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

How to Create a Site-to-Site VPN Tunnel to the Windows Azure …

Details: Not long ago I set out to build a multisite SQL Server cluster where one my nodes resides in my local data center and the other node resides in Microsoft’s Infrastructure as a Service (IaaS) offering, the Windows Azure Cloud.The Azure Cloud has an offering where you can deploy VMs and pay for just the resources you utilize, much like Amazon’s EC2.

› Verified 3 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

How to extend your existing SQL Server Failover Cluster Instance …

Details: If you are using SQL Server Standard Edition then your job is done. You would simply follow these instructions to access you data on the 3rd node and then mount the replicated databases. These directions are applicable whether your …

› Verified 8 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Performance of Azure Shared Disk with Zone Redundant Storage …

Details: On September 9th, 2021, Microsoft announced the general availability of Zone-Redundant Storage (ZRS) for Azure Disk Storage, including Azure Shared Disk. What makes this interesting is that you can now build shared storage based failover cluster instances that span Availability Zones (AZ). With cluster nodes residing in different AZs, users can now qualify for …

› Verified 3 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Creating a multi-site cluster in Windows Azure for Disaster …

Details: We are now going to extend the existing cluster (SQL1 and SQL2) to your local data center, SQL3. This configuration will give you both high availability for your application within the Azure Cloud, as well as a disaster recovery solution should Azure suffer a major outage. You could configure this in reverse as well with your on premise

› Verified 9 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

What is the network speed between Azure regions connected with …

Details: Using these two peered networks I am helping a client address SQL Server disaster recovery using SIOS DataKeeper to asynchronously replicate SQL data between regions for disaster recovery. SIOS DataKeeper replicating data from Azure EAST US 2 to CENTRAL US. In this particular scenario we were measuring a RPO measured in milliseconds.

› Verified 5 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  AddressGo Now

Calculating Application Availability in the Cloud

Details: The more copies of the data we have distributed across different availability zones, the more likely we will be able to survive a failure. For example, an application that stores its data across two different disks in different availability zones will benefit from the redundancy and instead of 99.9% availability it is more likely to achieve 99

› Verified 8 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

STORAGE SPACES DIRECT (S2D) FOR SQL SERVER FAILOVER …

Details: With the introduction of Windows Server 2016 Datacenter Edition a new feature called Storage Spaces Direct (S2D) was introduced.At a very high level, this solution allows you to pool together locally attached storage and present it to the cluster as a CSV for use in a Scale Out File Server, which can then be accessed over SMB 3 and used to hold cluster data such as …

› Verified Just Now

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

New Azure “SQL Server settings” blade in the Azure Portal

Details: In addition to adding this new Storage configuration option on SQL Server settings blade, they also removed the option to add Data Disks on the Disks blade. So if I wanted to provision additional storage without creating a Storage Space, I would have to create the instance first and then come back and add Data disks after it the virtual machine

› Verified 4 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Storage Considerations for Running SQL Server in Azure

Details: Use the local SSD, aka, the D: drive. The D drive is going to be the best location for your tempdb. Because it is a local drive the data is considered “temporary”, meaning it can be lost if a server is moved, rebooted, etc. That’s okay, tempdb is recreated each time SQL starts anyway. The local SSD is going to be fast and have low latency

› Verified 3 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Achieving SQL Server HA/DR with a mix of Always On Availability …

Details: Introduction The topic of mixing SQL Server Failover Cluster Instances (FCI) with Always On Availability Groups (AG) is pretty well documented. However, most of the available documentation documents configurations that assume the SQL Server FCI portion of the solution utilizes shared storage. What if I want to build a SANless SQL Server FCI using Storage…

› Verified 9 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Understanding the Windows Server Failover Cluster Quorum in …

Details: Before we look at the new quorum features in Windows Server 2016, I think it is important to know where we came from. In my previous post Understanding the Windows Server Failover Cluster Quorum in Windows Server 2012 R2 I went into some great detail regarding the history and evolution of the cluster quorum. I suggest you review that post to understand how …

› Verified 8 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

WSFC – Clustering For Mere Mortals

Details: This data transfer cost can be minimized with the use of compression available in DataKeeper. Controlling Failover. In an FSx multi-subnet configuration there is a preferred availability zone and a standby availability. Should the FSx file server in the preferred availability zone experience a failure, the file server in the standby AZ will

› Verified 1 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Using Amazon FSx for SQL Server Failover Cluster Instances – …

Details: This data transfer cost can be minimized with the use of compression available in DataKeeper. Controlling Failover. In an FSx multi-subnet configuration there is a preferred availability zone and a standby availability. Should the FSx file server in the preferred availability zone experience a failure, the file server in the standby AZ will

› Verified 9 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

How to Overcome the Performance Problems with SQL Server …

Details: Attending the sessions at PASS Summit this week it has become obvious that AlwaysOn is a hot topic with about six sessions dedicated to the topic. The one thing that I learned is that although AlwaysOn certainly has its applications, most of the successful deployments are based on using AlwaysOn in an asynchronous fashion. The…

› Verified 2 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

SQL Server High Availability in AWS #Cloud

Details: The SIOS solution is based on SQL server in a Microsoft Failover Clustering using DataKeeper Cluster Edition host based replication. By using hosted based replication they have overcome the first obstacle of clustering in EC2 – lack of shared storage. The second obstacle that SIOS had to overcome was the issue of client redirection described

› Verified Just Now

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Cluster Quorum File Share Witness on a USB stick

Details: Many of these customers just decided to forgo clustering, or they used an alternative clustering solution like the SIOS Protection Suite. Now they have a viable alternative coming in Windows Server 2019. By leveraging a supported router, a USB disk inserted into the router can be configured with a file share that can be used as the witness

› Verified 7 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  SupportGo Now

Were you prepared

Details: In addition to data protection, having a procedure in place to rapidly recover business critical applications is an essential part of any disaster recovery plan. There are various replication and recovery options available, from services provided by the cloud vendor themselves like Azure Site Recovery,

› Verified 5 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  Services,  BusinessGo Now

DataKeeper – Page 6 – Clustering For Mere Mortals

Details: Posts about DataKeeper written by daveberm. Clustering For Mere Mortals Microsoft Cloud and Datacenter MVP David Bermingham's thoughts and advice on Windows clustering and other related technologies

› Verified 4 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Making sense of virtualization availability options

Details: In this configuration the performance and behavior is the same as a local area cluster, but yet it can span data centers. What this means is that you can actually move your virtual machines across data centers with little to no perceivable downtime. Failback is the same process, just point and click to move the virtual machine resource back to

› Verified 2 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Azure Outage Post-Mortem – Part 1 – Clustering For Mere Mortals

Details: The first official Post-Mortems are starting to come out of Microsoft in regards to the Azure Outage that happened last week. While this first post-mortem addresses the Azure DevOps outage specifically (previously known as Visual Studio Team Service, or VSTS), it gives us some additional insight into the breadth and depth of the outage, confirms the cause of the …

› Verified Just Now

› Url: Clusteringformeremortals.com Go Now

› Get more:  AddressGo Now

Is AlwaysOn Availability Groups a viable alternative to AlwaysOn

Details: I recently read an article entitled SQL Server 2012 AlwaysOn: High Availability database for cloud data centers where the author John Joyner makes a case for using AlwaysOn Availability Groups for SQL Server high availability in the cloud. I have been investigating AlwaysOn Availability Groups since it was available in pre-release versions of SQL Server…

› Verified 1 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Configuring the #Azure ILB in ARM for SQL Server FCI or AG using …

Details: In an earlier post I went into some great detail about how to configure the Azure ILB in ARM for SQL Server AlwaysOn FCI or AG resources. The directions in that article were written prior to the GA of Azure PowerShell 1.0. With the availability of Azure PowerShell 1.0 the main script that creates the ILB needs to be slightly different.

› Verified 3 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Windows Server 10 “Cloud Witness” in a failover cluster

Details: Using a Cloud Share Witness eliminates the cost associated with maintaining a 3 rd data center. There will be a slight monthly fee for the Azure Cloud service, but this will be minimal in comparison to the cost associated with maintaining a File Share Witness. Scenario 2 – #SANLess Hyper-V Cluster at Remote Office/Branch Office (ROBO)

› Verified 2 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

Highly Available SQL Server Storage Options in #Azure: SMB 3.0 …

Details: When looking at storage options for deployments of SQL Server deployments in Azure you have a few options as described in the article Windows Server Failover Cluster on Azure IAAS VM – Part 1 (Storage).The article also references the newly released Azure File Service which can be used to host your SQL Server cluster data over SMB 3.0.

› Verified 5 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

New Azure ILB feature allows you to build a multi-instance SQL …

Details: At Microsoft Ignite this past September, Microsoft made some announcements around Azure. One of these announcements was the general availability of multiple VIPs on internal load balancers. Why is this so important to a SQL Server DBA? Well, up until now if you want to deploy highly available SQL Server in Azure you were limited…

› Verified 4 days ago

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now

AWS – Page 2 – Clustering For Mere Mortals

Details: With the introduction of Windows Server 2016 Datacenter Edition a new feature called Storage Spaces Direct (S2D) was introduced.At a very high level, this solution allows you to pool together locally attached storage and present it to the cluster as a CSV for use in a Scale Out File Server, which can then be accessed over SMB 3 and used to hold cluster data such as …

› Verified Just Now

› Url: Clusteringformeremortals.com Go Now

› Get more:  DataGo Now