hisrarul

How to Add rsync to Git Bash for Windows 10

Download the package: http://www2.futureware.at/~nickoe/msys2-mirror/msys/x86_64/rsync-3.1.2-2-x86_64.pkg.tar.xz

Extract it and move rsync.exe to %HOMEDRIVE%%HOMEPATH%\AppData\Local\Programs\Git\usr\bin.

Chapter 1: How to copy table from one database to another in MySQL?

Scenario: I'm trying to build a Jenkins pipeline. According to the requirement, the pipeline should take backup the content from a database and restore it to the new mysql database running on Kubernetes.

Problem statement

When I have tried to restore the dump to new mysql server. It was creating a database which was backed up during the dump process. In a moment, I realised that my application is trying to hit another database for the content. In this case, I left with two options:

Update the code of the application
Create a database required by application and copy all the tables from one database to another.

Chapter 2: How to convert plain text log to JSON format?

I wanted to send the metrics data of an application to the prometheus and grafana.

Problem statement

The application is generating logs in plain text. To send meaningful data to prometheus and grafana it is important to parse them.

Solution

Chapter 1: Calculate the cost of data stored in AWS S3.

Scenario: There are so many buckets which we are consuming for data stroage. Some of these buckets are costing huge amount to us. Now, we need to find out which bucket is costing more amount so we can plan for data archive.

Problem statement

We need to create the excel sheet which will contain the name of the bucket and the storage occupied by the files in those bucket. The s3 service charges is $0.25 per GB so accordingly we can apply formula in our excel sheet.

Solution

Q.1 Create IAM user using aws cli and name of the user is "devops".

user='devops'
aws iam create-user --user-name $user

Q.2 Create IAM group using aws cli and name of the group is "devops".

group='devops'
aws iam create-group --group-name $group

	version: '2'
	services:
	openldap:
	image: osixia/openldap:1.2.3
	container_name: openldap
	environment:
	LDAP_LOG_LEVEL: "256"
	LDAP_ORGANISATION: "Example Inc."
	LDAP_DOMAIN: "example.org"
	LDAP_BASE_DN: ""