Databases
AWS RDS Aurora wish list
I’ve had this list on a post-it note on my monitor for all of 2022. I figured it was time to write it down, and reuse the space. In summary, AWS suffers from the same problem that almost every other product does.
SELECT 1
If you have worked with an RDBMS for some time, you will likely have come across the statement SELECT 1. However, rarely is it correctly explained to engineers what the origin of SELECT 1 is, and why it’s useless and wasteful?
Upcoming Percona Live 2021 Presentations
I am pleased to have been selected to present at Percona Live 2021 May 12-13. My presentations include talks on AWS RDS Aurora and QLDB managed services. Understanding AWS RDS Aurora Capabilities The RDS Aurora MySQL/PostgreSQL capabilities of AWS extend the HA capabilities of RDS read replicas and Multi-AZ.
#WDILTW – What can I run from my AWS Aurora database
When you work with AWS Aurora you have limited admin privileges. There are some different grants for MySQL including SELECT INTO S3 and LOAD FROM S3 that replace the loss of functionality to SELECT INTO OUTFILE and mysqldump/mysqlimport using a delimited format.
#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.
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.
MySQL 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.
Identifying 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.
Testing 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.
Q: 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.
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.
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.
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.