Practice
Vendor-neutral MySQL and MariaDB operations.
Architecture
Schema, replication, HA, and security reviews from production failure modes.
Remote DBA
Monitoring, backups you have restored, upgrades, emergency response.
OQGRAPH
Hierarchies and networks in SQL — ENGINE=OQGRAPH.
Mentoring
Fixed-fee guidance for teams operating production databases.
OQGRAPH
Edge table in InnoDB. Paths and reachability via latch queries.
SELECT GROUP_CONCAT(linkid ORDER BY seq) AS path
FROM oq_graph
WHERE latch='dijkstras' AND origid=1 AND destid=6;Selected notes
Operations writing the community kept linking to.
MariaDB security updates: open patches, fast response
How MariaDB’s public patch process changes CVE response for operators.
HOST_FLUSH and the myth of userspace disk cache control
Linux will not let userspace invent durability after the fact. Use fsync contracts.
Experiment: MySQL tmpdir on tmpfs
Point tmpdir at tmpfs to speed spills — and know the OOM failure mode.
OQGRAPH examples: paths, reachability, leaves
Runnable OQGRAPH patterns: backing table, Dijkstra, BFS, leaves, weights.
Implementing sequences with a stored function and triggers
Shared sequence numbers in MySQL via a counter table, LAST_INSERT_ID, and triggers.