Category Archives: Others

MSDB Size growing

msdb is growing due to queue. their is a great blog to help to reduce this How to reduce MSDB size from 42Gb to 200Mb query to get object size: USE msdb GO SELECT TOP(10) o.[object_id] , obj = SCHEMA_NAME(o.[schema_id]) … Continue reading

Posted in Experts, Others, Performance Tuning, Troubleshooting | 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

Docker – Install Other Open source DB

We can quickly install anything on Docker with hub.docker.com PostgreSQL: $ docker run –name some-postgres -e POSTGRES_PASSWORD=mysecretpassword -d postgres MariaDB: docker run –name mariadbtest -e MYSQL_ROOT_PASSWORD=mypass -d mariadb/server:10.3 –log-bin –binlog-format=MIXED

Posted in Kubernetes/Docker/Container, Open Source, Others, RDBMS | Tagged , | Leave a comment

Informix on Docker

Today we will discuss how to install/configure informix on Docker, >docker run -it –name ifx –privileged -p 9088:9088 -p 9089:9089 -p 27017:27017 -p 27018:27018 -p 27883:27883 -e LICENSE=accept ibmcom/informix-developer-database:latest   >docker exec -it ifx bash   Other information to consider: … Continue reading

Posted in Kubernetes/Docker/Container, Others, RDBMS | Tagged | 1 Comment

Imp Linux Commands

Important Linux Commands 1. uname -a: To know what version of unix we are using 2. hostname: System name 3. ifconfig:      ip information 4. ping -c 3 :    ping 3 times 5. chmod:        change mode – permission … Continue reading

Posted in General, Linux, Others | 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

Docker Swarm

As we studied the basics of Docker and container and containerization , Docker – is a open-source platform to have multiple light weighted containers (applications/services). Docker Swarm: now if we want to use Docker as High Availability or Load-balancer , … Continue reading

Posted in Containerization, Docker Swarm, Kubernetes/Docker/Container, Others | Tagged , , | Leave a comment

Error – Hung Docker

Sometime when you not actively working on Docker and on you are not actively working on the system. it could be possible that Docker services goes into hung State and you will get an error as follows: Starting containers fails … Continue reading

Posted in Kubernetes/Docker/Container, Others, What I learned today | Tagged | Leave a comment

Containerization

Docker has containers to work on processes or application. now docker containers has some limitations as it uses resources from the system and its shared. Docker Compose: to group all related application/services  or container one system is called compose i … Continue reading

Posted in Containerization, Docker Swarm, 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