diff options
author | Adam Monsen <haircut@gmail.com> | 2023-02-17 06:13:12 -0800 |
---|---|---|
committer | GitHub <noreply@github.com> | 2023-02-17 14:13:12 +0000 |
commit | d1d0d89ba75986237f7b5b7812406b1f08a35c40 (patch) | |
tree | a3a9b08ae8b701e228f5743b6e5ca479da459536 /.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml | |
parent | f49b1edcaa258dae458a00d55b0cc596090c601d (diff) |
Enable MariaDB binary log (#1881)
* Enable MariaDB binary log
This resolves a warning in the database server log:
[Warning] You need to use --log-bin to make --binlog-format work.
Pros:
* support for point-in-time recovery
* necessary for replication
Cons:
* slows down database operations ("slightly", per the manual)
* takes up disk space (mitigated by `--expire-logs-days=2`)
See also:
* <https://mariadb.com/kb/en/binary-log/>
* <https://mariadb.com/kb/en/full-list-of-mariadb-options-system-and-status-variables/>
Alternatives:
1. Do not add `--log-bin`. Remove `--binlog-format` instead. This causes the least amount of change for existing installations.
Signed-off-by: Adam Monsen <haircut@gmail.com>
* remove --expire-logs-days=2 mariadb flag
This better aligns with recommendations in the Nextcloud documentation.
Also: the flag isn't necessary. There are already set times for cleanup: The MySQL and MariaDB documentation both state that binary logs will be purged on startup and flush/rotation.
Signed-off-by: Adam Monsen <haircut@gmail.com>
---------
Signed-off-by: Adam Monsen <haircut@gmail.com>
Diffstat (limited to '.examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml')
-rw-r--r-- | .examples/docker-compose/with-nginx-proxy/mariadb/fpm/docker-compose.yml | 2 |
1 files changed, 1 insertions, 1 deletions
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 80088993..c4e6fec3 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 @@ -3,7 +3,7 @@ version: '3' services: db: image: mariadb:10.5 - command: --transaction-isolation=READ-COMMITTED --binlog-format=ROW + command: --transaction-isolation=READ-COMMITTED --log-bin=binlog --binlog-format=ROW restart: always volumes: - db:/var/lib/mysql |