MySQL
#WDILTW – To use a RDBMS is to use a transaction
I learned this week that 30+ years of Relational Database Management System (RDBMS ) experience still does not prepare yourself for the disappointment of working with organizations that use a RDBMS; MySQL specifically; have a released production product, have dozens to hundreds of developers, team leaders and architects, but do not know the importance of, nor use transactions.
Read moreDefensive 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 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 moreQ: Does MySQL support ACID? A: Yes
I was recently asked this question by an experienced academic at the NY Oracle Users Group event I presented at. Does MySQL support ACID? (ACID is a set of properties essential for a relational database to perform transactions , i.
Read moreDo you control your database outages?
Working with a client last week I noted in my analysis, “The mysql server was restarted on Thursday and so the [updated] my.cnf settings seems current”. This occurred between starting my analysis on Wednesday and delivering my findings on Friday.
Read more