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 2022/06/29 15:20:27 UTC

[airflow] 42/45: Clarify that users should not use Maria DB (#24556)

This is an automated email from the ASF dual-hosted git repository.

ephraimanierobi pushed a commit to branch v2-3-test
in repository https://gitbox.apache.org/repos/asf/airflow.git

commit bada25d2c3a46fe58cd095beeac563659937ee4e
Author: Jarek Potiuk <ja...@polidea.com>
AuthorDate: Mon Jun 20 14:45:16 2022 +0200

    Clarify that users should not use Maria DB (#24556)
    
    (cherry picked from commit 05c542dfa8eee9b4cdca4e9370f459ce807354b2)
---
 docs/apache-airflow/howto/set-up-database.rst      |  9 +++++
 docs/apache-airflow/installation/prerequisites.rst | 45 ++++++++++++++--------
 2 files changed, 38 insertions(+), 16 deletions(-)

diff --git a/docs/apache-airflow/howto/set-up-database.rst b/docs/apache-airflow/howto/set-up-database.rst
index a83948296d..9a9b6ababc 100644
--- a/docs/apache-airflow/howto/set-up-database.rst
+++ b/docs/apache-airflow/howto/set-up-database.rst
@@ -40,6 +40,15 @@ Airflow supports the following database engine versions, so make sure which vers
 If you plan on running more than one scheduler, you have to meet additional requirements.
 For details, see :ref:`Scheduler HA Database Requirements <scheduler:ha:db_requirements>`.
 
+.. warning::
+
+  Despite big similarities between MariaDB and MySQL, we DO NOT support MariaDB as a backend for Airflow.
+  There are known problems (for example index handling) between MariaDB and MySQL and we do not test
+  our migration scripts nor application execution on Maria DB. We know there were people who used
+  MariaDB for Airflow and that cause a lot of operational headache for them so we strongly discourage
+  attempts of using MariaDB as a backend and users cannot expect any community support for it
+  because the number of users who tried to use MariaDB for Airflow is very small.
+
 Database URI
 ------------
 
diff --git a/docs/apache-airflow/installation/prerequisites.rst b/docs/apache-airflow/installation/prerequisites.rst
index c41da8b451..f4bf65d208 100644
--- a/docs/apache-airflow/installation/prerequisites.rst
+++ b/docs/apache-airflow/installation/prerequisites.rst
@@ -18,7 +18,7 @@
 Prerequisites
 -------------
 
-Airflow is tested with:
+Starting with Airflow 2.3.0, Airflow is tested with:.
 
 * Python: 3.7, 3.8, 3.9, 3.10
 
@@ -31,22 +31,35 @@ Airflow is tested with:
 
 * Kubernetes: 1.20.2, 1.21.1, 1.22.0, 1.23.0, 1.24.0
 
-**Note:** MySQL 5.x versions are unable to or have limitations with
-running multiple schedulers -- please see: :doc:`/concepts/scheduler`. MariaDB is not tested/recommended.
+The minimum memory required we recommend Airflow to run with is 4GB, but the actual requirements depends
+wildly on the deployment options you have
 
-**Note:** SQLite is used in Airflow tests. Do not use it in production. We recommend
-using the latest stable version of SQLite for local development.
+.. warning::
 
-Starting with Airflow 2.3.0, Airflow is tested with Python 3.7, 3.8, 3.9 and 3.10.
+  Despite big similarities between MariaDB and MySQL, we DO NOT support MariaDB as a backend for Airflow.
+  There are known problems (for example index handling) between MariaDB and MySQL and we do not test
+  our migration scripts nor application execution on Maria DB. We know there were people who used
+  MariaDB for Airflow and that cause a lot of operational headache for them so we strongly discourage
+  attempts of using MariaDB as a backend and users cannot expect any community support for it
+  because the number of users who tried to use MariaDB for Airflow is very small.
 
-The minimum memory required we recommend Airflow to run with is 4GB, but the actual requirements depends
-wildly on the deployment options you have
+.. warning::
+
+  MySQL 5.x versions are unable to or have limitations with
+  running multiple schedulers -- please see: :doc:`/concepts/scheduler`.
+
+.. warning::
+  SQLite is used in Airflow tests. Do not use it in production. We recommend
+  using the latest stable version of SQLite for local development.
+
+
+.. warning::
 
-**Note**: Airflow currently can be run on POSIX-compliant Operating Systems. For development it is regularly
-tested on fairly modern Linux Distros and recent versions of MacOS.
-On Windows you can run it via WSL2 (Windows Subsystem for Linux 2) or via Linux Containers.
-The work to add Windows support is tracked via `#10388 <https://github.com/apache/airflow/issues/10388>`__ but
-it is not a high priority. You should only use Linux-based distros as "Production" execution environment
-as this is the only environment that is supported. The only distro that is used in our CI tests and that
-is used in the `Community managed DockerHub image <https://hub.docker.com/p/apache/airflow>`__ is
-``Debian Bullseye``.
+  Airflow currently can be run on POSIX-compliant Operating Systems. For development it is regularly
+  tested on fairly modern Linux Distros and recent versions of MacOS.
+  On Windows you can run it via WSL2 (Windows Subsystem for Linux 2) or via Linux Containers.
+  The work to add Windows support is tracked via `#10388 <https://github.com/apache/airflow/issues/10388>`__
+  but it is not a high priority. You should only use Linux-based distros as "Production" execution environment
+  as this is the only environment that is supported. The only distro that is used in our CI tests and that
+  is used in the `Community managed DockerHub image <https://hub.docker.com/p/apache/airflow>`__ is
+  ``Debian Bullseye``.