This is an automated email from the ASF dual-hosted git repository. ephraimanierobi pushed a commit to branch v2-7-test in repository https://gitbox.apache.org/repos/asf/airflow.git
commit 6e22dbabb3cbacfbc94e6551ede276846e2c9ae3 Author: Andrey Anshin <[email protected]> AuthorDate: Thu Sep 14 20:58:06 2023 +0400 Add information about drop support MsSQL as DB Backend in the future (#34375) (cherry picked from commit a122b5709680e2d208a76bc5d40bd039b29dbd4e) --- README.md | 20 +++++++++++--------- docs/apache-airflow/howto/set-up-database.rst | 12 ++++++++++-- generated/PYPI_README.md | 20 +++++++++++--------- 3 files changed, 32 insertions(+), 20 deletions(-) diff --git a/README.md b/README.md index e8c2adc346..ec01fdcccf 100644 --- a/README.md +++ b/README.md @@ -89,18 +89,20 @@ Airflow is not a streaming solution, but it is often used to process real-time d Apache Airflow is tested with: -| | Main version (dev) | Stable version (2.7.1) | -|-------------|------------------------|------------------------| -| Python | 3.8, 3.9, 3.10, 3.11 | 3.8, 3.9, 3.10, 3.11 | -| Platform | AMD64/ARM64(\*) | AMD64/ARM64(\*) | -| Kubernetes | 1.24, 1.25, 1.26, 1.27 | 1.24, 1.25, 1.26, 1.27 | -| PostgreSQL | 11, 12, 13, 14, 15 | 11, 12, 13, 14, 15 | -| MySQL | 5.7, 8.0, 8.1 | 5.7, 8.0, 8.1 | -| SQLite | 3.15.0+ | 3.15.0+ | -| MSSQL | 2017(\*), 2019(\*) | 2017(\*), 2019(\*) | +| | Main version (dev) | Stable version (2.7.1) | +|-------------|------------------------------|------------------------| +| Python | 3.8, 3.9, 3.10, 3.11 | 3.8, 3.9, 3.10, 3.11 | +| Platform | AMD64/ARM64(\*) | AMD64/ARM64(\*) | +| Kubernetes | 1.24, 1.25, 1.26, 1.27, 1.28 | 1.24, 1.25, 1.26, 1.27 | +| PostgreSQL | 11, 12, 13, 14, 15 | 11, 12, 13, 14, 15 | +| MySQL | 5.7, 8.0, 8.1 | 5.7, 8.0 | +| SQLite | 3.15.0+ | 3.15.0+ | +| MSSQL | 2017(\*\*), 2019(\*\*) | 2017(\*), 2019(\*) | \* Experimental +\*\* **Discontinued soon**, not recommended for the new installation + **Note**: MySQL 5.x versions are unable to or have limitations with running multiple schedulers -- please see the [Scheduler docs](https://airflow.apache.org/docs/apache-airflow/stable/scheduler.html). MariaDB is not tested/recommended. diff --git a/docs/apache-airflow/howto/set-up-database.rst b/docs/apache-airflow/howto/set-up-database.rst index d9cf82b756..c5cab0a2e5 100644 --- a/docs/apache-airflow/howto/set-up-database.rst +++ b/docs/apache-airflow/howto/set-up-database.rst @@ -27,14 +27,14 @@ The document below describes the database engine configurations, the necessary c Choosing database backend ------------------------- -If you want to take a real test drive of Airflow, you should consider setting up a database backend to **PostgreSQL**, **MySQL**, or **MSSQL**. +If you want to take a real test drive of Airflow, you should consider setting up a database backend to **PostgreSQL** or **MySQL**. By default, Airflow uses **SQLite**, which is intended for development purposes only. Airflow supports the following database engine versions, so make sure which version you have. Old versions may not support all SQL statements. * PostgreSQL: 11, 12, 13, 14, 15 * MySQL: 5.7, 8 -* MSSQL (Experimental): 2017, 2019 +* MSSQL (Experimental, **Discontinued soon**): 2017, 2019 * SQLite: 3.15.0+ If you plan on running more than one scheduler, you have to meet additional requirements. @@ -323,6 +323,14 @@ In addition, you also should pay particular attention to MySQL's encoding. Altho Setting up a MsSQL Database --------------------------- +.. warning:: + + After `discussion <https://lists.apache.org/thread/r06j306hldg03g2my1pd4nyjxg78b3h4>`__ + and a `voting process <https://lists.apache.org/thread/pgcgmhf6560k8jbsmz8nlyoxosvltph2>`__, + the Airflow's PMC and Committers have reached a resolution to no longer maintain MsSQL as a supported Database Backend. + + For new Airflow installations, it is advised against using MsSQL as the database backend. + You need to create a database and a database user that Airflow will use to access this database. In the example below, a database ``airflow_db`` and user with username ``airflow_user`` with password ``airflow_pass`` will be created. Note, that in case of MsSQL, Airflow uses ``READ COMMITTED`` transaction isolation and it must have diff --git a/generated/PYPI_README.md b/generated/PYPI_README.md index 9bb8767a19..ab1e94f5ad 100644 --- a/generated/PYPI_README.md +++ b/generated/PYPI_README.md @@ -47,18 +47,20 @@ Use Airflow to author workflows as directed acyclic graphs (DAGs) of tasks. The Apache Airflow is tested with: -| | Main version (dev) | Stable version (2.7.1) | -|-------------|------------------------|------------------------| -| Python | 3.8, 3.9, 3.10, 3.11 | 3.8, 3.9, 3.10, 3.11 | -| Platform | AMD64/ARM64(\*) | AMD64/ARM64(\*) | -| Kubernetes | 1.24, 1.25, 1.26, 1.27 | 1.24, 1.25, 1.26, 1.27 | -| PostgreSQL | 11, 12, 13, 14, 15 | 11, 12, 13, 14, 15 | -| MySQL | 5.7, 8.0, 8.1 | 5.7, 8.0, 8.1 | -| SQLite | 3.15.0+ | 3.15.0+ | -| MSSQL | 2017(\*), 2019(\*) | 2017(\*), 2019(\*) | +| | Main version (dev) | Stable version (2.7.1) | +|-------------|------------------------------|------------------------| +| Python | 3.8, 3.9, 3.10, 3.11 | 3.8, 3.9, 3.10, 3.11 | +| Platform | AMD64/ARM64(\*) | AMD64/ARM64(\*) | +| Kubernetes | 1.24, 1.25, 1.26, 1.27, 1.28 | 1.24, 1.25, 1.26, 1.27 | +| PostgreSQL | 11, 12, 13, 14, 15 | 11, 12, 13, 14, 15 | +| MySQL | 5.7, 8.0, 8.1 | 5.7, 8.0 | +| SQLite | 3.15.0+ | 3.15.0+ | +| MSSQL | 2017(\*\*), 2019(\*\*) | 2017(\*), 2019(\*) | \* Experimental +\*\* **Discontinued soon**, not recommended for the new installation + **Note**: MySQL 5.x versions are unable to or have limitations with running multiple schedulers -- please see the [Scheduler docs](https://airflow.apache.org/docs/apache-airflow/stable/scheduler.html). MariaDB is not tested/recommended.
