MySQL
Presentations 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 moreUnderstanding the MySQL Release Cadence
Download PDF Presentation At the recent New York Oracle Users Group summer general meeting I gave a presentation to the Oracle community on the MySQL product release cycle. Details included:
Read moreUtilizing OpenStack Trove DBaaS for deployment management
Trove is used for self service provisioning and lifecycle management for relational and non-relational databases in an OpenStack cloud. Trove provides a RESTful API interface that is same regardless of the type of database.
Read moreUnderstanding the DBaaS capability for your organization
As your organization transforms to embrace the wealth of digital information that is becoming available, the capability to store, manage and consume this data in any given format or product becomes an increasing burden for operations.
Read moreExpired MySQL passwords
I was surprised to find on one of my websites the message “Connect failed: Your password has expired. To log in you must change it using a client that supports expired passwords.
Read moreOracle OpenStack leveraging MySQL Cluster and Docker
At Oracle Openworld this year, Oracle OpenStack Release 2 was announced. This Kilo based distribution included some new deployment features not see in other OpenStack distros including the use of Kolla , Docker and MySQL Cluster .
Read moreManaging MySQL Version Upgrades Presentation
The following presentation was given at the Oracle Technology Network (OTN) Latin America 2015 tour events in Uruguay, Argentina, Chile and Peru. Download Presentation In this presentation I talk about the various versions and means of installing and upgrading MySQL including:
Read moreTesting and Verifying your MySQL Backup Strategy Presentation
This past week I have been the sole MySQL representative on the Oracle Technology Network (OTN) Latin America 2015 tour events in Uruguay, Argentina, Chile and Peru. Download Presentation In this presentation I talk about the important steps for testing and verifying your MySQL backup strategy to ensure your business continuity in any disaster recovery situation.
Read more