​
Release MySQL SQL Review Guide

SQL Review Guide lists all the rules in schema change review, from the naming convention of Table, Column, and Index to the designated WHERE clause. We provide rule templates for the MySQL Dev and Prod environments. DBAs can configure the rules manually based on our templates, and generate images for internal reference.  Meanwhile, we are actively working on the following area:

  • Add more rules. We also welcome DBAs’ suggestions at Issues · bytebase/bytebase
  • Integrate those rules into the Bytebase product by detecting rule violations automatically.

Currently, we only support MySQL. We will add PostgreSQL support later.

​
🚀 Features

  • Toggle Debug mode at runtime for easier troubleshooting

Only OWNER and DBA can toggle Debug mode

When the Debug mode is enabled, you can see the internal error messages on the web console, and more details are included in the logs. Previously, users can use --debug on Bytebase startup to do this. Now you can toggle this setting at runtime. Debug mode is a global setting and will affect all users, thus only OWNER and DBA can toggle it. It’s expected to be temporarily turned on for troubleshooting issues.

​
🎄 Enhancements

  • [SQL editor] support more types of EXPLAIN queries on the basis of EXPLAIN SELECT, such as EXPLAIN INSERT.

​
🎠 Community

​
⚙️ Install and Upgrade

Warning 1): Bytebase does not support in-place downgrade. Make sure to back up your metadata before upgrading. 2) Never run multiple containers on the same data directory. Stop and remove the old one first to avoid corruption.