MySQL
Do 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.
Understanding 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:
Utilizing 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.
Understanding 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.
Expired 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.
Oracle 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 .
Managing 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:
Testing 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.
My thoughts on Architecture and Software Development with MySQL
Yesterday I was able to present to the Portland MySQL Users Group two presentations that are important foundations for effective development with MySQL. Download Architecture Presentation Download Development Presentation With 26 years of architectural experience in RDBMS and 16 years of MySQL knowledge, my extensive exposure to large and small companies from consulting has lead to these presentations containing common obstacles I have seen an help organization with.
Percona Live Presentation: MySQL Security Essentials
The slides for my MySQL Security Essentials presentation at Percona Live 2015 MySQL Conference and Expo are now available. In this presentation I discuss just how insecure legacy versions of MySQL are and what are the essential requirements for securing your installation on disk, via network and with user privileges.
Percona Live Presentation: Improving Performance With Better Indexes
The slides for my Improving Performance With Better Indexes presentation at Percona Live 2015 MySQL Conference and Expo are now available. In this presentation I discuss how to identify, review and analyze SQL statements in order to create better indexes for your queries.
Updating MySQL on Ubuntu 12.04 LTS to MySQL 5.6
The Ubuntu 12.04.3 LTS release only provides MySQL 5.1 and MySQL 5.5 using the default Ubuntu package manager. Oracle (owners of the MySQL(tm)) now provide Debian/Ubuntu APT repositories for all GA and DMR versions of MySQL including supporting Ubuntu 12.
Validating MySQL version numbers
As part of a MySQL 5.5 to MySQL 5.6 upgrade across several Ubuntu servers of varying distros an audit highlighted a trivial but interesting versioning identification error in Ubuntu’s packaging of MySQL.
Dynamic recreation of InnoDB redo logs
MySQL 5.6 will now automatically recreate the InnoDB redo log files during a MySQL restart if the size (or number) of these logs changes, i.e. a change to innodb_log_file_size. See Changing the Number or Size of InnoDB Log Files which states “If InnoDB detects that the innodb_log_file_size differs from the redo log file size, it will write a log checkpoint, close and remove the old log files, create new log files at the requested size, and open the new log files.