Blog
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 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 moreThe agile software development lifecycle responsibility
The eXtreme Programming (XP) methodology places emphasis on a number of core principles for agile software development. These include (and are not limited to) the planning game, short and frequent iterations, testing, frequent refactoring, continuous integration, ownership and standards.
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 moreAre you a responsible developer?
What is a good example of individual developer responsibility? Here is just one example. A developer downloads a copy of the core production database to their own development laptop. Why? Because it’s easy to work with real data, and it’s hard to consider building applicable test data that all engineers can utilize.
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 more