This file contains al notable changes to the mariadb Ansible role.
This file adheres to the guidelines of http://keepachangelog.com/. Versioning follows Semantic Versioning.
- Add support for Debian (#45, credit: @nxet)
- Add support for EL 9 (#59, credit: @MartenBE)
- Fix baseurl for package repository (fixes #53)
- Fix repository URL in Yum/DNF configuration, use https instead of http
- Fix link to Ansible docs for mysql_user module
- Add support for AlmaLinux
- Tests with Molecule and either Vagrant+VirtualBox or Docker
- (GH-30) Added support for EL8
- Added support for Fedora 31. Fedora 32 is as of yet not supported by MariaDB.
- (GH-34) Added unix_socket authentication capability and skip password tasks for 10.4 because it has secure passwordless login with unix_socket by default. (credit: @herd-the-cats)
- (GH-37) Added logrotate management capability (credit: @herd-the-cats)
- Fixed linter warnings and code style
- (GH-33) Fixed a bug that caused the task that set the root password to fail. (credit: Nate Henderson)
- (GH-35) Select predictable UID/GID for system user (credit: @herd-the-cats)
- Configure swappiness only if the required command
sysctl
exists. If the command does not exist (e.g. in minimal Docker containers), the task would fail.
- Support for Fedora 30
- (GH-19) Allow the user to set arbitrary configuration settings by providing a dictionary of keys/values in new role variable
mariadb_server_cnf
- Vagrant test environment with base boxes for CentOS 7.6 and Fedora 30 from the Bento project.
- (GH-20) Fix iteration for Python 3. (credit: Dachi Natsvlishvili)
- (GH-21) Fix for mysql module in newer Ansible versions. By providing the
socket
location, it is possible to bypass the requirement to have.my.cnf
files on the server with credentials. (credit: Dachi Natsvlishvili) - (GH-22) Database init scripts are now considered to be Jinja2 templates, so Ansible variables can be used in the scripts.
- (GH-24) Solve deprecation warning in swappiness (credit: Adail Horst)
- Update versions of supported distros, RedHat/CentOS 7.6 and Fedora 30
- Fix package names for Fedora and RedHat/CentOS.
- Breaking change Set default MariaDB version to latest stable release, 10.4.
- Issue a warning when the role variable
mariadb_root_password
was not set.
- Breaking change. Role variables for setting some variables in
server.cnf
were removed. You can now specify arbitrary settings using variablemariadb_server_cnf
.
- Allow setting the yum download mirror with role variable
mariadb_mirror
- (GH-18) OracleLinux support (credit: Vincenzo Castiglia)
- (GH-11) Allow default character set and collation to be configured (credit: Ripon Banik)
- (GH-12) Added several server configuration variables for better performance. See
templates/etc_my.cnf.d_server.cnf.j2
(credit: Tom Stechele) - (GH-13) Allow the role to skip setting the swappiness of the mariadb process.
- (GH-16) Allow user privileges to be added instead of overwritten (credit: Cédric Delgehier)
- Allow custom configuration not specified in the template
- (GH-13) Allow the role to skip setting the swappiness of the mariadb process
- (GH-15) Allow
mariadb_service
to be overridden by the user - Bump default MariaDB version to 10.3, the current stable
- Bump versions of supported platforms (EL 7, Fedora 28)
- Fix MariaDB service name in handler
- Deprecated variables
innodb_file_format_check
,innodb_file_format
- Removed Ansible 2.4 deprecation warnings (include -> include_tasks)
- (GH-7, GH-8) Fix for downloading from the MariaDB repository on RHEL systems (credit: @raznikk, @piuma)
- (GH-5) MariaDB is installed from the project repositories and the version can be chosen.
- (GH-3) Added template for server.cnf (credit: Louis Tournayre)
- Made settings in server.cnf configurable and added default values.
- (GH-1) Added performance related settings (credit: Thomas Eylenbosch)
- Added Docker based playbook and functional tests executed on Travis CI on each commit for all supported platforms (CentOS, Fedora)
- Swappiness can be configured, and is turned off by default. This means that swapping processes to disk is avoided at all cost.
- (GH-2) Made database initialisation idempotent. In order to implement this, a breaking change was introduced in the way
mariadb_databases
is defined. - (GH-4) Remove initialisation scripts from the server after executing them.
- (GH-6) Test code was moved to a separate branch
- The database root password is no longer stored on the server in
~/.my.cnf
- Fix ignored
host:
option inmariadb_users
- In variable
mysql_users
, it is now possible to set ahost
pattern that specifies the hosts from where a user is allowed to query the database.
- Support for Fedora
- Fixed Ansible 2.0 deprecation warnings
- Prepared the role for supporting multiple platforms
- Fixed a bug that makes the role fail when
mariadb_init_scripts
is undefined.
- Databases can be initialised with a SQL script
First release!
- Install MariaDB
- Secure installation (change root password, delete anonymous user, test table)
- Manage bind_port
- Create databases and users