diff options
| author | Greek <e1128193@student.tuwien.ac.at> | 2018-02-08 20:34:08 +0100 |
|---|---|---|
| committer | Greek <e1128193@student.tuwien.ac.at> | 2018-02-08 20:34:08 +0100 |
| commit | 8c86333de9f4e8187fa0372e28d8d2b92c983da2 (patch) | |
| tree | 1d50c7d6edf0ce83fcaa334c499e2f7aedee1196 /.examples/docker-compose | |
| parent | 80a384c2b6bf3c642c730d4cc7929742ee896094 (diff) | |
* Fix the Transaction Isolation Level of the MYSQL/MariaDB Databases
in the .example section.
Diffstat (limited to '.examples/docker-compose')
16 files changed, 48 insertions, 0 deletions
diff --git a/.examples/docker-compose/insecure/mariadb-cron-redis/apache/docker-compose.yml b/.examples/docker-compose/insecure/mariadb-cron-redis/apache/docker-compose.yml index ab307200..3b25bc68 100644 --- a/.examples/docker-compose/insecure/mariadb-cron-redis/apache/docker-compose.yml +++ b/.examples/docker-compose/insecure/mariadb-cron-redis/apache/docker-compose.yml @@ -7,6 +7,7 @@ services: restart: always volumes: - db:/var/lib/mysql + - ./mysql.conf:/etc/mysql/conf.d/mysql-config.cnf environment: - MYSQL_ROOT_PASSWORD= env_file: diff --git a/.examples/docker-compose/insecure/mariadb-cron-redis/apache/mysql.conf b/.examples/docker-compose/insecure/mariadb-cron-redis/apache/mysql.conf new file mode 100644 index 00000000..15e5a425 --- /dev/null +++ b/.examples/docker-compose/insecure/mariadb-cron-redis/apache/mysql.conf @@ -0,0 +1,5 @@ +[mysqld] +# Set Transaction isolation Level to READ-COMMITED (Required by nextcloud) +# ================================================ +# https://docs.nextcloud.com/server/12/admin_manual/configuration_database/linux_database_configuration.html#database-read-commited-transaction-isolation-level +transaction-isolation = READ-COMMITTED
\ No newline at end of file diff --git a/.examples/docker-compose/insecure/mariadb-cron-redis/fpm/docker-compose.yml b/.examples/docker-compose/insecure/mariadb-cron-redis/fpm/docker-compose.yml index 92fe787d..f072a803 100644 --- a/.examples/docker-compose/insecure/mariadb-cron-redis/fpm/docker-compose.yml +++ b/.examples/docker-compose/insecure/mariadb-cron-redis/fpm/docker-compose.yml @@ -7,6 +7,7 @@ services: restart: always volumes: - db:/var/lib/mysql + - ./mysql.conf:/etc/mysql/conf.d/mysql-config.cnf environment: - MYSQL_ROOT_PASSWORD= env_file: diff --git a/.examples/docker-compose/insecure/mariadb-cron-redis/fpm/mysql.conf b/.examples/docker-compose/insecure/mariadb-cron-redis/fpm/mysql.conf new file mode 100644 index 00000000..15e5a425 --- /dev/null +++ b/.examples/docker-compose/insecure/mariadb-cron-redis/fpm/mysql.conf @@ -0,0 +1,5 @@ +[mysqld] +# Set Transaction isolation Level to READ-COMMITED (Required by nextcloud) +# ================================================ +# https://docs.nextcloud.com/server/12/admin_manual/configuration_database/linux_database_configuration.html#database-read-commited-transaction-isolation-level +transaction-isolation = READ-COMMITTED
\ No newline at end of file diff --git a/.examples/docker-compose/insecure/mariadb/apache/docker-compose.yml b/.examples/docker-compose/insecure/mariadb/apache/docker-compose.yml index 4ea67755..a048fcd6 100644 --- a/.examples/docker-compose/insecure/mariadb/apache/docker-compose.yml +++ b/.examples/docker-compose/insecure/mariadb/apache/docker-compose.yml @@ -7,6 +7,7 @@ services: restart: always volumes: - db:/var/lib/mysql + - ./mysql.conf:/etc/mysql/conf.d/mysql-config.cnf environment: - MYSQL_ROOT_PASSWORD= env_file: diff --git a/.examples/docker-compose/insecure/mariadb/apache/mysql.conf b/.examples/docker-compose/insecure/mariadb/apache/mysql.conf new file mode 100644 index 00000000..15e5a425 --- /dev/null +++ b/.examples/docker-compose/insecure/mariadb/apache/mysql.conf @@ -0,0 +1,5 @@ +[mysqld] +# Set Transaction isolation Level to READ-COMMITED (Required by nextcloud) +# ================================================ +# https://docs.nextcloud.com/server/12/admin_manual/configuration_database/linux_database_configuration.html#database-read-commited-transaction-isolation-level +transaction-isolation = READ-COMMITTED
\ No newline at end of file diff --git a/.examples/docker-compose/insecure/mariadb/fpm/docker-compose.yml b/.examples/docker-compose/insecure/mariadb/fpm/docker-compose.yml index dc3a8aaf..52095ed8 100644 --- a/.examples/docker-compose/insecure/mariadb/fpm/docker-compose.yml +++ b/.examples/docker-compose/insecure/mariadb/fpm/docker-compose.yml @@ -7,6 +7,7 @@ services: restart: always volumes: - db:/var/lib/mysql + - ./mysql.conf:/etc/mysql/conf.d/mysql-config.cnf environment: - MYSQL_ROOT_PASSWORD= env_file: diff --git a/.examples/docker-compose/insecure/mariadb/fpm/mysql.conf b/.examples/docker-compose/insecure/mariadb/fpm/mysql.conf new file mode 100644 index 00000000..15e5a425 --- /dev/null +++ b/.examples/docker-compose/insecure/mariadb/fpm/mysql.conf @@ -0,0 +1,5 @@ +[mysqld] +# Set Transaction isolation Level to READ-COMMITED (Required by nextcloud) +# ================================================ +# https://docs.nextcloud.com/server/12/admin_manual/configuration_database/linux_database_configuration.html#database-read-commited-transaction-isolation-level +transaction-isolation = READ-COMMITTED
\ No newline at end of file diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/apache/docker-compose.yml b/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/apache/docker-compose.yml index b4ff47ad..f8213f5d 100644 --- a/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/apache/docker-compose.yml +++ b/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/apache/docker-compose.yml @@ -7,6 +7,7 @@ services: restart: always volumes: - db:/var/lib/mysql + - ./mysql.conf:/etc/mysql/conf.d/mysql-config.cnf environment: - MYSQL_ROOT_PASSWORD= env_file: diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/apache/mysql.conf b/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/apache/mysql.conf new file mode 100644 index 00000000..15e5a425 --- /dev/null +++ b/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/apache/mysql.conf @@ -0,0 +1,5 @@ +[mysqld] +# Set Transaction isolation Level to READ-COMMITED (Required by nextcloud) +# ================================================ +# https://docs.nextcloud.com/server/12/admin_manual/configuration_database/linux_database_configuration.html#database-read-commited-transaction-isolation-level +transaction-isolation = READ-COMMITTED
\ No newline at end of file diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/fpm/docker-compose.yml b/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/fpm/docker-compose.yml index cfbfa91e..cb654f68 100644 --- a/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/fpm/docker-compose.yml +++ b/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/fpm/docker-compose.yml @@ -7,6 +7,7 @@ services: restart: always volumes: - db:/var/lib/mysql + - ./mysql.conf:/etc/mysql/conf.d/mysql-config.cnf environment: - MYSQL_ROOT_PASSWORD= env_file: diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/fpm/mysql.conf b/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/fpm/mysql.conf new file mode 100644 index 00000000..15e5a425 --- /dev/null +++ b/.examples/docker-compose/with-nginx-proxy/mariadb-cron-redis/fpm/mysql.conf @@ -0,0 +1,5 @@ +[mysqld] +# Set Transaction isolation Level to READ-COMMITED (Required by nextcloud) +# ================================================ +# https://docs.nextcloud.com/server/12/admin_manual/configuration_database/linux_database_configuration.html#database-read-commited-transaction-isolation-level +transaction-isolation = READ-COMMITTED
\ No newline at end of file diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb/apache/docker-compose.yml b/.examples/docker-compose/with-nginx-proxy/mariadb/apache/docker-compose.yml index 45406dcb..aeb2d6b0 100644 --- a/.examples/docker-compose/with-nginx-proxy/mariadb/apache/docker-compose.yml +++ b/.examples/docker-compose/with-nginx-proxy/mariadb/apache/docker-compose.yml @@ -7,6 +7,7 @@ services: restart: always volumes: - db:/var/lib/mysql + - ./mysql.conf:/etc/mysql/conf.d/mysql-config.cnf environment: - MYSQL_ROOT_PASSWORD= env_file: diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb/apache/mysql.conf b/.examples/docker-compose/with-nginx-proxy/mariadb/apache/mysql.conf new file mode 100644 index 00000000..15e5a425 --- /dev/null +++ b/.examples/docker-compose/with-nginx-proxy/mariadb/apache/mysql.conf @@ -0,0 +1,5 @@ +[mysqld] +# Set Transaction isolation Level to READ-COMMITED (Required by nextcloud) +# ================================================ +# https://docs.nextcloud.com/server/12/admin_manual/configuration_database/linux_database_configuration.html#database-read-commited-transaction-isolation-level +transaction-isolation = READ-COMMITTED
\ No newline at end of file diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml b/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml index 7417a665..7d2b7916 100644 --- a/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml +++ b/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml @@ -7,6 +7,7 @@ services: restart: always volumes: - db:/var/lib/mysql + - ./mysql.conf:/etc/mysql/conf.d/mysql-config.cnf environment: - MYSQL_ROOT_PASSWORD= env_file: diff --git a/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/mysql.conf b/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/mysql.conf new file mode 100644 index 00000000..15e5a425 --- /dev/null +++ b/.examples/docker-compose/with-nginx-proxy/mariadb/fpm/mysql.conf @@ -0,0 +1,5 @@ +[mysqld] +# Set Transaction isolation Level to READ-COMMITED (Required by nextcloud) +# ================================================ +# https://docs.nextcloud.com/server/12/admin_manual/configuration_database/linux_database_configuration.html#database-read-commited-transaction-isolation-level +transaction-isolation = READ-COMMITTED
\ No newline at end of file |