Databases
WeSQL Introduction – MySQL running on S3
I recently became aware of WeSQL . A MySQL-compatible database that separates compute and storage, using S3 as the storage layer. The product uses a columnar format by default which is significantly more space-efficient than InnoDB.
Read more
Managing SQL Drift: Ensuring Stability in Database Transitions
SQL drift is a significant challenge that occurs when SQL statements from an existing system produce unexpected results after migration to a new environment or system. These issues manifest in several critical ways: SQL statements may generate new execution errors, experience significant performance degradation, or yield differences in data integrity.
Read more
RDS MySQL Aurora 3.07.0 is unusable for upgrades
Yesterday I detailed an incompatible breakage with RDS MySQL Aurora 3.06.0 , and one option stated is to upgrade to the just released 3.07.0. Turns out that does not work. It is not possible to upgrade any version of AWS RDS MySQL Aurora 3.
Read more
Database testing for all version changes (including minor versions)
We know that SQL statement compatibility can change with major database version upgrades and that you should adequately test for them. But what about minor version upgrades? It is dangerous to assume that your existing SQL statements work with a minor update, especially when using an augmented version of an open-source database such as a cloud provider that may not be as transparent about all changes.
Read more
Are you patching your AWS RDS MySQL 5.7 EOL databases?
Recently, I noticed a second AWS RDS MySQL 5.7 version available 5.7.44-rds.20240408. Curious what this was as 5.7.44 is the only RDS 5.7.x EOL version available, I launched an instance to discount this as errant metadata.
Read more
The curse of MySQL warnings
MySQL warnings are an anti-pattern when it comes to maintaining data integrity. When the information retrieved from a database does not match what was entered, and this is not identified immediately, this can be permanently lost.
Read more![Digital Tech Trek Digest [#Issue 2024.09]](https://ronaldbradford.com/images/blog/2024-digital-tech-trek-digest.png)
Digital Tech Trek Digest [#Issue 2024.09]
As an entrepreneur, pricing is an important consideration in any evaluation, development, and customer testing. In How To Price A SaaS Product , we see different pricing strategies, cost-based pricing, competitor-based pricing, penetration pricing, value-based pricing, freemium pricing.
Read moreDigital Tech Trek Digest [#Issue 2024.08]
The One Billion Row Challenge Shows That Java Can Process a One Billion Rows File in Two Seconds Well, it’s way under 2 seconds for the 1brc . The published results are in, and if you’re good, you can read 1 billion data points of weather data and analyze it.
Read moreDigital Tech Trek Digest [#Issue 2024.03]
Lessons from going freemium: a decision that broke our business As an entrepreneur always considering how to produce a sustaining passive revenue, what licensing model to use, and how to acquire and retain customers, the allure of a freemium model is ever present in so many offerings.
Read moreMastering 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:
Read moreAWS 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.
Read moreUpcoming 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.
Read more#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.
Read more