You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@airflow.apache.org by ep...@apache.org on 2023/10/05 10:46:25 UTC
[airflow] 38/44: Add information about drop support MsSQL as DB Backend in the future (#34375)
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 <An...@taragol.is>
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.