Posts

Showing posts from June, 2022

Digital Marketing

You can use the Amazon SES mailbox simulator to simulate successful deliveries, hard bounces, out-of-office responses or feedback.

The Amazon SES mailbox simulator makes it easy to test how your application handles certain scenarios, such as bounces or complaints, without impacting your sender reputation. Using the mailbox simulator is as easy as sending a test email to a specific address.  The Amazon SES Mailbox Simulator is a set of email addresses. Each address represents a different email sending scenario. There is an email address for: Successful delivery Hard bounce Complaint Out-of-the-Office (OOTO) Address on Suppression List

SSH Agent Forwarding

You allow the remote server to access your local SSH agent while you’re connected.  It doesn't send your private keys over the internet, not even while they’re encrypted; it just lets a remote server access your local SSH agent and verify your identity. Add the following to your SSH config file: Host sqley ForwardAgent yes

Caterpillar Inc. will move its headquarters to near Dallas-Forth Worth

Load big data to MySQL by chunks

pt-fifo-split --lines 1000000 your-huge-file & while [ -e /tmp/pt-fifo-split ]; do mysql --login-path=your-login  --local-infile=1  -e "LOAD DATA LOCAL INFILE '/tmp/pt-fifo-split' INTO TABLE your-table" your-database; done pt-fifo-split is a part of Percona Toolkit

AWS: How to Mount S3 Bucket on EC2 Linux

s3fs allows Linux, macOS, and FreeBSD to mount an S3 bucket via FUSE. s3fs preserves the native object format for files, allowing use of other tools like AWS CLI. https://github.com/s3fs-fuse/s3fs-fuse Amazon Linux via EPEL: sudo amazon-linux-extras install epel sudo yum install s3fs-fuse

Install docker on AWS EC2

# # Update the installed packages and package cache on your instance. sudo yum update -y # # Install the most recent Docker Community Edition package. sudo yum install docker # # Check docker version docker version docker --version # # Add the ec2-user to the docker group so you can execute Docker commands without using sudo. # # Exit the terminal and re-login to make the change effective sudo usermod -a -G docker ec2-user exit # # Enable docker service sudo systemctl enable docker # # Start docker service sudo systemctl start docker # # Check the Docker service. sudo systemctl status docker

mail: command not found in AWS EC2

 yum install mailx  

Load text data into AWS RDS MySQL serverless v2

If you encounter this while running "load data local infile" (3948, 'Loading local data is disabled; this must be enabled on both the client and server sides') For server parameter, it is enabled by default. You can double check by running: SHOW GLOBAL VARIABLES LIKE 'local_infile'; +---------------+-------+ | Variable_name | Value | +---------------+-------+ | local_infile | ON | +---------------+-------+ So, you just need to enable it on client side: mycli --local-infile=1 

MySQL Show Users Command

SELECT User, Host FROM mysql.user;

Limiting S3 Sync Bandwidth

$ aws configure set default.s3.max_bandwidth 20MB/s It is thread based. You need to set thread count too: $ aws configure set default.s3.max_concurrent_requests 2