Learn how to manage MySQL schemas with Atlas using both declarative and versioned workflows. This guide covers automatic MySQL schema migration, inspection, migration planning, and applying changes via CLI and CI/CD integrations.
Learn how to use CHECK constraints in MySQL to enforce data integrity. This guide covers syntax, examples, and how to manage CHECK constraints with Atlas.
All common open-source relational database management systems are supported in all versions of Atlas.
Learn how to create and use descending indexes in MySQL to optimize queries with ORDER BY clause, and how to manage them using Atlas.
Learn how to detect the dropping of foreign key constraints in MySQL databases using Atlas's linting capabilities. Understand the implications of dropping foreign keys and how to prevent accidental drops.
Learn how to detect inline REFERENCES clauses in MySQL using Atlas's linting capabilities. Understand the implications of inline foreign key constraints and how to prevent them in your migrations.
Learn how to create and manage functional indexes in MySQL to optimize query performance using expressions and functions.
Learn how to use generated columns in MySQL with Atlas. Understand the difference between stored and virtual generated columns, their limitations, and how to implement them using Atlas HCL schema.
Learn how to use Atlas to manage your MySQL schema with HCL declarative migrations. This guide covers inspecting the database, planning changes, and applying them.
Learn how to use Atlas to manage your MySQL schema with declarative migrations using SQL. This guide covers inspecting the database, planning changes, and applying them.
Learn how to manage MySQL on AWS RDS using Terraform and Atlas. This guide covers provisioning, schema management, and evolving schemas with Atlas HCL.
Learn how to create and use prefix indexes in MySQL to optimize query performance and reduce storage space. Understand the syntax, examples, and benefits of using prefix indexes.
Learn how to prevent accidental column deletion in MySQL databases using Atlas's linting capabilities. Understand the impact of dropping columns and how to enforce policies against destructive changes.