18 docs tagged with "mysql"

MySQL schema migrations with Atlas, declarative and versioned. Covers inspection, migration planning, 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.

Trace column-level data lineage across tables and views of your MySQL database. Visualize how columns are derived, inspect transformation expressions, and map upstream and downstream dependencies.

Connect Atlas to your database using a standard URL format. Examples for PostgreSQL, MySQL, MariaDB, SQLite, SQL Server, ClickHouse, Oracle, Snowflake, Spanner, Databricks, and more.

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.

Define lookup tables and seed data as code. Atlas computes INSERT, UPDATE, and DELETE statements automatically.

Define MySQL roles, users, and permissions as code. Atlas plans and applies changes automatically - no more manual GRANT/REVOKE drift.

Manage MySQL roles, users, and permissions through versioned migrations. Every security change goes through code review and CI before reaching production.

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.