Tag: cluster

Recover WSFC and AlwaysOn from Resolving State

There is a SQL Server Availability Group (AG) on a Windows Server Failover Cluster (WSFC) with 3 nodes using Node Majority quorum configuration. In an unforeseen circumstance, 2 nodes went completely offline at the same time causing the WSFC to go down. This caused the Availability Group to go into a Resolving state and all …

Continue reading

odbc_log: Unable to retrieve database handle. CDR failed.

I correctly configured ODBC connection on Asterisk server to MSSQL database in Always On cluster. The working configuration was as follows:

Continue reading

MariaDB(MySQL) Master-Master Replication

I’m going to develop my cluster further and create MariaDB(MySQL) geo-cluster by enabling MariaDB(MySQL) Master-Master Replication. I’ve already deployed MariaDB cluster in the second datacenter (nodes 4, 5 and 6) and now I need to configure Master-Master replication between two MariaDB clusters. The replication will take place between node 1 (first datacenter, we will name …

Continue reading

MariaDB Galera three nodes cluster on CentOS 6

Let’s build MariaDB Galera cluster with three nodes on CentOS x64 6.7 Minimal. On all nodes static IP adresses have been configured. Node1- 10.20.20.11 Node2 – 10.20.20.12 Node3 – 10.20.20.13 On all nodes we need to install necessary packages:

Continue reading