Category Archives: High Avaliability

AG without WSFC SQL 2017 and more…

Starting Sql Server 2017 Microsoft can allow you to enable the configuration manager for “Always ON” feature for standalone system without WSFC and linux without Pacemaker . it has a limitation as : It cannot have listener configuration This would … Continue reading

Posted in Disaster Recovery, High Avaliability, Others, SQL Server 2017, SQL Server 2019, Webcast, What I learned today, Whats New | Tagged , , , , , | Leave a comment

Read-only URL removal

When I blog to configure Read only replica. it would require to provide read-only URL information, and provide the replica sequence. but their is no easy way to remove the Read-only URL. we have to remove the AG group to … Continue reading

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

Read-only Replica -AG

Read only replica is a great concept where we can re-direct all the read only connections to that replica.   Following are some of the great articles for it. How to Configure Read-Only Routing for an Availability Group in SQL … Continue reading

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

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

Configure Kubernetes with minikube

We have discussed about Docker Swarm to know how to use Docker as a Load balance. Today we will discuss about Kubernetes – Wiki: “Kubernetes is an open-source container orchestration system for automating application deployment, scaling, and management. It was originally … Continue reading

Posted in Cloud, DevOps, High Avaliability, Kubernetes/Docker/Container, Others | 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 4: MySQL Architecture Continue…

MySQL is an open source and configuration of MySQL is very simple and can be customized per the requirement. MySQL works on following options: Option/configuration file (my.cnf) System variables (Local /Global) Status variables My.cnf option file will have various Groups and … Continue reading

Posted in Basic, DB Design, High Avaliability, MySQL, Others, RDBMS, Replication, What I learned today | Tagged , | Leave a comment

HA between Windows and Linux

If you ask before couple of years about Microsoft and Linux can be compatible was a dream. now Microsoft has made SQL Server to work on Linux we have accepted that. It has some Middle OS to interact with Linux … Continue reading

Posted in Azure, High Avaliability, Others, SQLonLinux, What I learned today, Whats New | Tagged , , , , | Leave a comment