Skip to content

Instantly share code, notes, and snippets.

View anorth848's full-sized avatar

Adam North anorth848

2 followers · 2 following
View GitHub Profile
@anorth848
anorth848 / rds_mysql_dml_auditing.md
Last active September 3, 2025 12:12
Enable Audit Logging in RDS MySQL for DML operations

RDS MySQL Audit Logging Setup Guide

This guide covers enabling audit logging for RDS MySQL instance database-1 with export to CloudWatch and querying examples.

Requirements

  1. Capture all DML (Data Manipulation) operations performed against the database
  2. Store logs in CloudWatch for 90 days
  3. Query event history in CloudWatch to be able to audit where DML operations are coming from
  • Specifically, all DML against the item table by an IP address other than 172.31.67.209
@anorth848
anorth848 / get_tournament_matches.py
Last active January 22, 2025 19:47
Get DartConnect Event matches json response
import requests
import json
import argparse
import pyperclip
parser = argparse.ArgumentParser()
parser.add_argument("--event", help="The dartconnect event id for the event", required=True)
args = parser.parse_args()
@anorth848
anorth848 / AWS_Backup.yaml
Last active August 13, 2021 19:55
Example AWS Backup cloudformation template including IAM and SNS resources
AWSTemplateFormatVersion: "2010-09-09"
Description: Example AWS Backup resources including IAM and SNS
Parameters:
NotificationEmail:
Type: String
AllowedPattern: '(^[a-zA-Z0-9_.+-]+@[a-zA-Z0-9-]+\.[a-zA-Z0-9-.]+$)'
Description: "Email address for notification on job completions"
ResourceArns:
Type: CommaDelimitedList
Description: "Comma delimited string of resource ARNs to backup"