Skip to main content

MySQL Replication

A few interesting MySQL replication scenarios: 

Encrypted WAN Replication:
A company with mission-critical database services wanted real-time WAN backup of MySQL database. I setup remote, ssh-encrypted MySQL replications across WAN for real-time backup of SQL database. System supports “catch-up” replication in case network is slow or down.  Allows client to recover to any moment in time if main server goes down.

Web-based Traffic Management System managing real-time data from roadside devices

Worked with embedded device team to create a vertically integrated system from field devices to server system to end user. Part of the investigation was looking at raw TCP/IP to generate minimal HTTP requests to minimize network traffic from the numerous, mobile-connected devices. 

Investigated technologies and built from scratch web-system used to manage of deployment, monitoring, reporting, TFTP updates, calculations, and real-time display of data from sensors deployed along roads and connected via mobile traffic.

Automated Incremental Offsite Backups from VMWARE ESXi (4,5,6) systems.

Incremental full VM backups from running systems. 

Setup scripts to increment through all VMWARE VMS that needed to be backed up and sent to NFS share attached to removable hot-swap (USB attached) spinning disk media.

Setup 7 day rotation and monthly backup schedule to allow full backups and to have quick and easy removal/replacement of media for offsite storage of complete daily snapshots of VMs. 

Subscribe to Bash