rds

15 Sep

Execute Lambda triggered by DB record updates

stp2y0 CommentsNewscoding, community, csharp, development, engineering, inclusive, kinesis, lambda, rds, software

What architecture would you use if you wanted to synchronize data across multiple subsystems? Importantly, since transactions are not available, the SQL issuer must take care to ensure that data consistency is maintained. For example, if SQL execution is performed by Lambda, it is necessary to write to database A and database B respectively, but the application logic tends to become complex when updating multiple records. Therefore, Trigger an AWS Lambda function from Amazon RDS for MySQL or Amazon RDS for MariaDB using audit logs and Amazon CloudWatch architecture. With this method, Lambda is triggered by actual writes using audit…

31 Aug

Database Migration from OnPrem to AWS RDS

stp2y0 CommentsNewsaws, coding, community, dbmigration, development, devops, engineering, inclusive, rds, software

This project provides a step-by-step guide on how to migrate a WordPress website and MariaDB database from on-premises to AWS, using peering connections and AWS services such as EC2, RDS, and DMS. The guide covers setting up the simulated environment, creating VPC and peering connection, launching instances, setting up DMS replication, and testing. Installation To use this project, you need to have the following: A simulated AWS on-prem env with a WordPress website and MariaDB database. An AWS account with access to EC2, RDS, and DMS. The guide covers the following steps: Assuming a simulated on-premises environment on AWS with…