Posts

Showing posts with the label MongoDB

Setup MongoDB statefulset on AWS Fargate

-
Image
Hi everyone I am Manshu Sharma and today we will see how can we deploy the mongoDB on AWS fargate as a  statefulset  with help of the mongoDB community operator but before we start let's have a quick overview of two important terms statefulset,   stateful application . What actually statefulset is in Kubernetes? StatefulSet is a Kubernetes resource used to manage stateful applications and It manages the scaling , ordering and uniqueness of each pod. It requires headless service and we are responsible for creating this service. What actually is stateful applications? Stateful applications are those programs that save client data from the activities of one session for use in the next session. Consider it as an ongoing periodic conversation with the same person. Some examples of stateful applications are MySQL,    MongoDB, FTP server,  Redis Cache, Kafka  and any Login service that stores client authentication data on the server, labelling clients...
Post a Comment
Read more

MongoDB CheetSheet [In Progress]

-
This guide includes an introduction to MongoDB, a glossary of terms and lists of commonly used MongoDB commands with example. So here we go,  Introduction Mongodb is a non-relational database which means it does not use the tabular schema of rows and columns found in most traditional database systems like MySql.  The second thing about mongodb is that it stores data in a key-value pair.  The third thing about the mongodb is that the attribute _id which is unique and it is automatically created by Mongodb so chill  😎 MongoDB commands Create Database:   use <Database Name> Create Collection:  db.createCollection(<"Name">,{<Option>}) Insert One document in collection:  db.<Collection-Name>.insertOne([{<document>}]) Insert Many Documnets in Collection:  db.<Collection-Name>.insertMany([{<document1>},{<document2>}]) Find a particular row: db.getCollection("<Col...
Post a Comment
Read more

Popular posts from this blog

MySQL Multi Source Master Slave Replication using GTID

-
Image
We are using GTID-based master-slave replication. In this replication, both master and slave should have the same GTID. This blog post aims to provide a step-by-step guide to help you set up MySQL Replication using GTIDs and help you replicate your MySQL data with ease. Prerequisite Master Source 1 Channel name:  DEVELOPMENT Database: mydb1 Enable Replication For Tables testing1 testing2 testing3 Mysql Server Running: 192.168.0.201:3307 Master Source 2 Channel name:  PRODUCTION Database: mydb1 Enable Replication For Tables testing4 testing5 testing6 Mysql Server Running: 192.168.0.201:3308 Slave Mysql Server Running: 192.168.0.209:3306 Configuration of  masters(192.168.0.201:3307/192.168.0.201:3308) and slave (192.168.0.209:3306) my.cnf config for master (192.168.0.201:3307) my.cnf config for master (192.168.0.201:3308) my.cnf config for slave (192.168.0.209:3306) Steps for taking a dump and restoring it Run the following commands in both masters 192.168.0.201:3307 and 1...
Read more

Setting Up PostgreSQL Logical Replication with Docker Compose

-
Hi everyone 😀, Sorry😅 for not posting any blogs; I was stuck in other work. In the previous post, we saw that we enabled MySQL Replication using GTID . Today, we see how to allow Postgres Logical Replication in our local setup using docker-compose.  Environment Setup We have two PostgreSQL instances configured using Docker Compose: Publisher (postgres-1): The source server where changes are captured. Subscriber (postgres-2): The destination server that receives replicated data. Docker Compose Configuration Publisher (docker-compose.yml) version: '3.8' services: postgres-1: build: ./ container_name: postgres-1 environment: POSTGRES_USER: postgresadmin POSTGRES_PASSWORD: admin123 POSTGRES_DB: postgresdb PGDATA: "/data" volumes: - ./postgres-1/pgdata:/data - ./postgres-1/config:/config - ./postgres-1/archive:/mnt/server/archive ports: - "5000:5432" networks: - custom_network ...
Read more

Regex 101: An Introduction to Regular Expressions for Developers

-
Regular expressions (regex) are a powerful tool for searching and manipulating text. They allow you to describe patterns of characters that you want to match, rather than specifying every possible combination of characters. In this blog, we will go over some common regex operations and provide examples for each one. Matching a literal string: regex: hello will match the string "hello". Matching any character: regex: . will match any single character. Matching a set of characters: regex: [aeiou] will match any single vowel. Matching a range of characters: regex: [a-z] will match any single lowercase letter. Matching a negated set of characters: regex: [^aeiou] will match any single non-vowel character. Matching zero or one occurrence: regex: a? will match either the string "a" or an empty string. Matching zero or more occurrences: regex: a* will match any string that contains zero or more "a" characters. Matching one or more occurrences: regex: a+ will matc...
Read more