Category Archives: Disaster Recovery

Always On: Troubleshooting Consolidated

Working on Always On and configuration/setup of AG we have observed many errors. especially when configuration listener with following error 19471 or AG could not configure: Creating availability group listener resulted in an error. ADDITIONAL INFORMATION: Create failed for Availability … Continue reading

Posted in Disaster Recovery, High Avaliability, Installation, Others, Troubleshooting, What I learned today | Tagged , , | Leave a comment

MongoDB Replica-Set

The most important feature of MongoDB is its easy setup and use of Replica set. in mongo db you can easily setup it here is the link for it which I am used by Soham Kamani Create a network: Docker … Continue reading

Posted in Disaster Recovery, High Avaliability, MongoDB, Others, Replication | Tagged , , , | Leave a comment

Day 24 Replication Setup

Today we will discuss how setup a replication: Master – Slave Replication: Requirement: 2 (Linux) System (MasterServer and SlaveServer) MySQL Installed Connection to both servers are accessible. On Master Server: Edit my.cnf with following information: [mysqld] Log-Bin =MySQL_Binlog Server_ID=1 Create … Continue reading

Posted in Disaster Recovery, High Avaliability, Internal, MySQL, Others, Replication, What I learned today | Tagged , , | Leave a comment

Day 21 NDB Storage Engine (Cluster)

MySQL also support High Availability, NDB Storage engine provides high availability- shared-nothing system, NDB Cluster integrates the standard MySQL server with an in-memory clustered storage engine called NDB (which stands for “Network DataBase” NDB Cluster required 3 Nodes required complete the setup: Management node(mgmd): … Continue reading

Posted in Disaster Recovery, High Avaliability, Isolation Level, MySQL, Others | Tagged , , , | Leave a comment

Day 17 Backup and Recovery

There are there types of Backup: Full Backup Incremental Backup Bin-Log Backup Full Backup: is a complete backup of the database You can use following some of the options in the MySQLDump command –all-databases             Dump all tables in all … Continue reading

Posted in Backup and Restore, Disaster Recovery, MySQL, Others | Tagged , , , | Leave a comment

vNext has AG

Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported.   https://blogs.technet.microsoft.com/dataplatforminsider/2017/02/17/sql-server-on-linux-mission-critical-hadr-with-always-on-availability-groups/    

Posted in Disaster Recovery, High Avaliability, Others, SQLonLinux, vNext | Tagged , , | Leave a comment

Sql Cluster Resource not comming online

when you check on the sql server services and sql agent services it’s getting started on windows cluster but on cluster its going down again. on error log you may get the cluster service Login failed for user ‘cluster service … Continue reading

Posted in Add/remove, Bug, Disaster Recovery, Error Log, High Avaliability | Tagged , , , , | Leave a comment

Denali — Day 6: indirect Checkpoint

Denali – Day 6: indirect Checkpoint I have already blog some information about checkpoint here As I have already blog about Checkpoint and how it works. Generally it works approximately every 1 minute(internal – default) . You could do this … Continue reading

Posted in Denali, Disaster Recovery, Transaction Log | Tagged , , | Leave a comment

Denali – Day 2: AlwaysON High Availability (aka Project HADRON)

Denali – Day 2: AlwaysON High Availability (aka Project HADRON ) AlwaysON Availability Group: is another very important achievement done by development team project called “HADRON”. As the name implies AlwaysON is a High availability feature on Failure Clustering where it has … Continue reading

Posted in Denali, Disaster Recovery, High Avaliability | Tagged , , | Leave a comment

High Availability 9’s

This is very important to understand what is high availability 9’s, This is a measurement of high availability  where you can tell how much downtime is feasible for your organization for a Year(annually). the calculation is as follows =Total Hours in a … Continue reading

Posted in Disaster Recovery, High Avaliability | Tagged , | Leave a comment