Skip to content
Dave Rix
  • Home
  • Projects
  • Blog
  • About
  • Contact

Replication

Database replication – GTID, master-slave, multi-master, Galera and semi-sync.

Deriving unique server IDs from IP addresses

2026-06-102026-06-10 by Dave

AWK scripts for converting between IP addresses and decimal numbers – and why this makes a reliable source of unique server IDs for MySQL replication clusters and other distributed systems.

Categories Databases, Linux & Automation Tags Awk, IP, Linux, MySQL, Replication Leave a comment
Dave

Dave

Senior AWS Cloud Architect, platform engineer and MySQL/Aurora DBA. 30+ years building production infrastructure, now with AI-assisted engineering in the daily toolkit. Available Outside-IR35 via Analysis by Design Ltd.

Verified Services

View Full Profile →

The articles here are my own thoughts, based on many years of working with a variety of technologies. I'm not saying these are the best ways of doing various tasks, but they work for me.

This is also a good way for me to remember processes that are only done on occasion, but saves having to Google and draw from various sources if they are all here in one place!

Recent Posts

  • Deriving unique server IDs from IP addresses
  • Case study: Modernising an AWS estate with Claude Code

Archives

  • June 2026

Categories

  • AWS & Cloud Architecture
  • Databases
  • Linux & Automation
  • Projects
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy
  • Twitter/X
  • LinkedIn
© 2026 Dave Rix • Built with GeneratePress