July 2016Monthly Archives

Introduction In production environments, changes to the database schema such as creating new tables or altering existing ones should be tracked and communicated to database administrators or development teams. Receiving notifications whenever these Data Definition Language (DDL) operations occur helps maintain audit trails, detect unauthorized schema modifications, and improve operational… Continue Reading Send Email Notification for MySQL CREATE TABLE and ALTER TABLE Events

Assumption: We have access key and secret key which has a privilege to create snapshot, delete snapshot, list volumes,etc., The script will keep 4 days retention and delete the old backups.   #!/usr/bin/python #Author:Dhanasekaran N #Email:dhanasekaran.n16@gmail.com,support@pheonixsolutions.com #Usage:python create_aws_snapshot.py AWS_TAG_NAME #Version:1.0 #Here come I……. from datetime import datetime, timedelta import datetime… Continue Reading Python Script to take backup of Ec2 Volume with days retention

Introduction Command logging helps administrators monitor the commands executed by users on a Linux server. By configuring Bash and the system logger, every command entered by users can be recorded in a dedicated log file. This is useful for auditing user activity and troubleshooting unexpected changes on the server. Prerequisites… Continue Reading Enable command logging on Linux hosts

Introduction In secure infrastructure environments, production servers are often placed in private networks and are not directly accessible from the internet. Instead, administrators connect through a designated Jump Box (Bastion Host) that has controlled public access and connectivity to internal servers. This approach improves security by reducing the attack surface… Continue Reading How to Use an SSH Jump Box to Access Private Servers

Introduction S3FS is a FUSE (Filesystem in Userspace)-based file system that allows you to mount an Amazon S3 bucket as a local directory on a Linux server. Once mounted, applications can seamlessly read from and write to the S3 bucket using standard file system operations, eliminating the need to interact… Continue Reading How to Install and Configure S3FS to Mount an Amazon S3 Bucket on Linux

Introduction Email service providers (ESPs) such as Gmail, Yahoo, and Outlook monitor the rate at which emails are received from a sender. Sending a large number of emails over a short period or through a single connection may trigger rate limits or cause the sending IP address to be temporarily… Continue Reading How to Configure Recipient-Based Rate Limiting in Postfix