MySQL
![Digital Tech Trek Digest [#Issue 2024.10]](https://ronaldbradford.com/images/blog/2024-digital-tech-trek-digest.png)
Digital Tech Trek Digest [#Issue 2024.10]
Google advances with vector search in MySQL, leapfrogging Oracle in LLM support As the title states, GCP is the first MySQL-managed service to offer “vector” support. Clearly the buzz-word of 2024 along with RAG, genAI and LLM is so 2023.
Digital Tech Trek Digest [#Issue 2024.06]
MySQL Belgian Days 2024 and FOSDEM 2024 In this past week, I’ve been able not just to read or watch digital content online but to meet people in person. In Brussels, first at the MySQL Belgian Days 2024 event, followed by FOSDEM 2024 .
Mastering MySQL 5.7 EOL migrations
In a recent podcast on Mastering EOL Migrations: Lessons learned from MySQL 5.7 to 8.0 I discuss with my colleague Adam North not only the technical issues that become a major migration but also key business and management requirements with having a well-articulated strategy that covers:
Data Masking 101
I continue to dig up and share this simple approach for production data masking via SQL to create testing data sets. Time to codify it into a post. Rather than generating a set of names and data from tools such as Mockaroo , it is more practical to use actual data for a variety of testing reasons.
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?
What does the MySQL mysqlsh util.checkForServerUpgrade() execute
During a recent Aurora MySQL 8 upgrade process, a number of validation checks have failed. This is an analysis of the error message “present in INFORMATION_SCHEMA’s INNODB_SYS_TABLES table but missing from TABLES table”.
Upgrading to AWS Aurora MySQL 8
With Aurora MySQL 8 now generally available to all, you may want to consider the plan for an upgrade path if you would like to take advantage of the new features for your application, for example, Common Table Expressions (CTE).
AWS Aurora MySQL 8 is now generally available
AWS has just announced the general availability of Aurora MySQL 8 compatibility (known as Aurora Version 3). This is long awaited addition to RDS MySQL 8 and provides many of the new features that can be found in the open-source MySQL 8 community version.
A QLDB Cheat Sheet for MySQL Users
The AWS ledger database (QLDB) is an auditors best friend and lives up to the stated description of “Amazon QLDB can be used to track each and every application data change and maintains a complete and verifiable history of changes over time.
Understanding AWS RDS Aurora Capabilities
The RDS Aurora MySQL/PostgreSQL capabilities of AWS extend the High Availability (HA) capabilities of RDS read replicas and Multi-AZ. In this presentation I discuss the different capabilities and HA configurations with RDS Aurora including:
#WDILTW – Functions with options
In the late 1990s I learned MySQL and Java at approximately the same time. How did I teach myself? For MySQL I read the online MySQL manual cover to cover. For Java it was the Java Language Specification or Java Programming Language book, again cover to cover.
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 – Creating examples can be hard
This week I was evaluating AWS QLDB . Specifically the verifiable history of changes to determine how to simplify present processes that perform auditing via CDC. This is not the first time I have looked at QLDB so there was nothing that new to learn.