Blog

MySQL 5.7 to 8: Schema and DDL Changes

MySQL 5.7 reached its end-of-life in October 2023, and managed database products such as Amazon RDS are starting to transition to expensive “extended support” pricing for 5.7 users. Before you jump on a last-minute MySQL 8 upgrade, it is essential to understand the major functional differences between these database versions. In this post, we’ll provide a deep-dive on the upgrade implications for schema management and DDL operations.

Continue reading

Versioning and Deploying Stored Procedures

Stored procedures are a powerful database feature. However, they’re also somewhat controversial, in part due to operational challenges with their development workflow and lifecycle. In this post, we’ll review Git version control and deployment concepts for stored procedures, along with practical solutions when using Skeema.

Continue reading

Skeema v1.11.0 released

Skeema v1.11.0 has been released! This new version includes spatial index support, safe trigger DDL operations with table locking, new options to ignore some types of table differences, and additional safety guardrails.

Continue reading

MySQL vs MariaDB: Tables and DDL

Although MySQL and MariaDB share a common ancestry, their functionality has diverged in subtle ways over the years. In this post, we’ll explore the differences in DDL and schema-related features of these two database servers, as well as operational concerns when performing schema changes.

Continue reading

Skeema v1.10.0 released

Skeema v1.10.0 is now available! Our latest release adds support for managing seed data in the Premium CLI, as well as several linter enhancements and more.

Continue reading

Skeema v1.9.0 released

Skeema v1.9.0 has been released! This new version includes support for environment variables in option files, temp-schema workspace offloading in Premium CLI, improved ignore regex options, and support for this month’s new MariaDB releases including MariaDB 10.10.

Continue reading

Understanding MySQL's lower_case_table_names

When running database servers on multiple operating systems, data and schema portability can be challenging due to identifier case sensitivity differences. The lower_case_table_names server variable in MySQL and MariaDB can help, but it is often misunderstood. In this post, I’ll provide in-depth guidance on this tricky subject, and show how Skeema can assist.

Continue reading

Skeema v1.8.0 released

Skeema v1.8.0 is now available! This new release adds support for non-Linux database servers, SSH tunnels in the Premium CLI, and MariaDB 10.8 support.

Continue reading

Exploring AWS Aurora v3 for MySQL 8

AWS unveiled Aurora v3 a couple months ago, finally including support for MySQL 8 in their premium database-as-a-service offering. In this post, we’ll review some of its functionality, with a focus on DDL functionality and schema design.

Continue reading

Skeema v1.7.0 released

Skeema v1.7.0 has been released! This new version adds support for Aurora MySQL 8 and MariaDB 10.7, 64-bit Linux ARM builds, self-update functionality in the Premium CLI, and more.

Continue reading