Managing SQL Drift: Ensuring Stability in Database Transitions
SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity.
Read more
Defensive Data Techniques
As a data architect I always ensure that for any database schema change there a fully recoverable execution path. I have generally advised to create a patch/revert process for every change.
Read moreMySQL Data Security Risk Assessment presentation
Securing your data is only as good as your weakest link. A clear-text password in a file or history file, shared privileges between test and production or open sudo access when you can connect as an unprivileged user all are security flaws.
Read moreIdentifying MySQL SSL communication using ngrep
Prior to MySQL 5.7 client communications with a MySQL instance were unencrypted by default. This plaintext capability allowed for various tools including pt-query-digest to analyze TCP/IP traffic. Starting with MySQL 5.
Read moreTesting MySQL/MariaDB/Percona versions with Docker
Giuseppe Maxia has provided some great MySQL docker images . Percona and MariaDB also provide version via Docker Hub. In an attempt to have a consistent means of launching these different images I created the following convenience functions.
Read moreGetting a clearer picture of http response time breakdown via CLI
I came across this handy python script https://github.com/reorx/httpstat that provides a http response breakdown in text. This saves you having to open up a browser and look at a visual network response waterfall.
Read moreOTN appreciation day: The Performance Schema of MySQL 5.6+
To focus on just one point for OTN appreciation day on October 11 2016 and to the benefit of all users of MySQL is to consider the extremely convenient and rich value of information available in the MySQL Performance Schema to understand what SQL queries are running in a MySQL instance now.
Read moreMySQL Group Replication OOW Tutorial
Download Slides The second MySQL tutorial session at Oracle Open World was “MySQL Group Replication in a Nutshell” by MySQL Community Manager Frederic Descamps. This is succinctly described as: “Multi-master update anywhere replication for MySQL with built-in conflict detection and resolution, automatic distributed recovery, and group membership.
Read morePresentations at Percona Live Amsterdam 2016
I was fortunate enough to give four presentations at the Percona Live 2016 event in Amsterdam. The slides for these are now available. Improving MySQL Performance with Better Indexes – Download slides – Overview MySQL Replication Smackdown – Download Slides – Overview Securing your MySQL/MariaDB data – A joint presentation with Colin Charles – Download Slides – Overview “A surprising excursion through the astonishing world of math” – Lightning Talk – Download Slides
Read moreNew UUID functions in MySQL 8.0.0
MySQL 8.0.0 introduces three new miscellaneous UUID functions of IS_UUID(), UUID_TO_BIN() and BIN_TO_UUID() joining the UUID() (in 5.0) and UUID_SHORT() (in 5.1) functions. See 8.0.0 Release Notes . Thanks to the great work and hosting by Marcus Popp anybody can test out the SQL syntax of MySQL 8.
Read moreIntroducing the MySQL Cloud Service
The MySQL keynote at Oracle Open World 2016 announced the immediate availability of the MySQL Cloud Service, part of the larger Oracle Cloud offering. You can evaluate this now with a trial copy at cloud.
Read moreMySQL Operations in Docker at Oracle Open World 2016
One of the Monday tutorials at Oracle Open World was MySQL Operations in Docker. A 2 hour tutorial by Giuseppe Maxia . This tutorial showed what you can do with MySQL on Docker which is specifically good for testing.
Read moreMySQL Keynote at Oracle Open World 2016
Tomas Ulin made a number of key announcements at this year’s State of the Dolphin and Customer Experiences keynote. MySQL Public Cloud, MySQL 8.0 DMR, MySQL InnoDB Cluster, MySQL Group Replication (RC).
Read moreA Brief History of Container Technology
The following is the text from a presentation slide at Oracle Open World 2016. While Docker has been playing a key role in adoption of the Linux container Technology, the did not invent the concept of containers.
Read moreThe Legacy Dilemma
Organizations are rapidly developing new software applications to meet the need to consume ever increasing digital content and maintain market share in a given field. These newly developed applications cover a wide range of needs from advanced data analytics, to mobile applications, to personalized recommendation engines.
Read more