Category Archives: High Avaliability

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

vNext has AG

Now vNext SQL Server on Linux supports Availability Group HA/DR functionality supported.    

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

Distributed AG

going though Allan Hirt’s 24 SQLPASS  recording, he has explained the new feature of SQL Server Availability group you can get it here. he is expert in Clustering /AG/ and published several blogs and books. Distributed AG is advance and extended … Continue reading

Posted in High Avaliability, Others, sql 2016 | Tagged , , , , | Leave a comment

Re-initialize replication not working

For someone re-initialization is very simple, just go to publisher and right click and select re-initiallize and it will ask for- do you want to generate snapshot now, if you say “yes” it will create a metadata of the articles … Continue reading

Posted in Add/remove, High Avaliability, Replication, Troubleshooting | 1 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