// Execution: Building the Bridge

The execution happened remarkably fast.

First, I enabled the binlog on the legacy MySQL 5.7 instance, ensuring the format was set to ROW to capture the exact data changes. I provisioned an AWS SQS queue and created a strictly scoped IAM user to handle the authentication.

Then came the Go agent. Using a library called canal, I wrote a listener specifically targeting order creations, updates, and deletions.

To test it safely, I didn't push code to the server immediately. Instead, I established a secure SSH tunnel from my Mac in Parkdale directly to the locked-down port 3306 on the production EC2 instance.

I ran go run main.go locally.

2025/07/11 21:49:15 🚀 Agent started successfully! Real-time DB monitoring active...
2025/07/11 21:49:15 INFO begin to sync binlog from position "(mysql-bin.000001, 4)"

I triggered a few dummy order updates in the IMS web interface. Instantly—within milliseconds—the messages appeared in the AWS SQS dashboard. The bridge was alive.