mariadb (81) Versions 5.5.5 Follow51

Installs/Configures MariaDB

Policyfile

Berkshelf

Knife

cookbook 'mariadb', '~> 5.5.5', :supermarket

cookbook 'mariadb', '~> 5.5.5'

knife supermarket install mariadb

knife supermarket download mariadb

README

Dependencies

Changelog

Quality 50%

MariaDB Cookbook

Description

This cookbook contains all the stuffs to install and configure and manage a mariadb server on a dpkg/apt compliant system (typically debian), or a rpm/yum compliant system (typically centos)

Maintainers

This cookbook is maintained by the Sous Chefs. The Sous Chefs are a community of Chef cookbook maintainers working together to maintain important cookbooks. If you’d like to know more please visit sous-chefs.org or come chat with us on the Chef Community Slack in #sous-chefs.

Requirements

repository

mariadb - This cookbook need that you have a valid apt repository installed with the mariadb official packages

packages

percona-xtrabackup - if you want to use the xtrabckup SST Auth for galera cluster.
mariadb-backup - if you want to use the mariabackup SST Auth for galera cluster.
socat - if you want to use the xtrabckup or mariabackup SST Auth for galera cluster.
rsync - if you want to use the rsync SST Auth for galera cluster.
debconf-utils - if you use debian platform family.

operating system

debian - this cookbook is fully tested on debian
ubuntu - this cookbook is fully tested on ubuntu
centos - this cookbook is fully tested on centos

Chef version

Chef Infra Client >= 15.3

Upgrading

If you are wondering where all the recipes went in v2.0+, or how on earth I use this new cookbook please see upgrading.md for a full description.

Resources

Contributing

Fork the repository on Github
Create a named feature branch (like add_component_x)
Write your change
Write tests for your change (if applicable)
Run the tests, ensuring they all pass
Submit a Pull Request using Github

Contributors

This project exists thanks to all the people who contribute.

Backers

Thank you to all our backers!

Dependent cookbooks

selinux >= 6.0

Contingent cookbooks

mariadb CHANGELOG

All notable changes to this project will be documented in this file.

This project adheres to Semantic Versioning.

5.5.5 - 2024-07-15

Standardise files with files in sous-chefs/repo-management

5.5.4 - 2024-05-06

5.5.3 - 2024-05-06

5.5.2 - 2023-11-01

5.5.1 - 2023-09-04

5.5.0 - 2023-08-30

Allow changing action behaviour of the package resource (:install, :upgrade)

5.4.0 - 2023-08-19

Treat redhat like other members of the platform_family when generating yum repo url

5.3.2 - 2023-07-10

5.3.1 - 2023-05-17

5.3.0 - 2023-05-02

Remove version suffix from package names for debian-based OSes
Put the mysql control credentials in to a reusable method
Remove unnecessary method arguments and setting of version in run_state
Fix default_pid_file method
Add tests for 10.11
Extend unit tests
Fix libgalera install path issue on MariaDB 10.4+
Fix resource idempotency issues with MariaDB 10.5 and 10.6
Simplify conditionals in helpers.rb
Alter yum repo path to match what MariaDB recommend

5.2.19 - 2023-04-18

Patched the ability to use SELinux with setup_repo disabled

5.2.18 - 2023-04-16

5.2.17 - 2023-04-12

Update test matrix
Update default MariaDB version to 10.11 (current LTS)

5.2.16 - 2023-04-11

Standardise files with files in sous-chefs/repo-management

5.2.15 - 2023-04-07

Standardise files with files in sous-chefs/repo-management

5.2.14 - 2023-04-01

5.2.13 - 2023-04-01

5.2.12 - 2023-04-01

Standardise files with files in sous-chefs/repo-management

5.2.11 - 2023-03-13

Manually update standardized files with files in sous-chefs/repo-management

5.2.10 - 2023-03-11

Cleanup various CI issues

5.2.9 - 2023-03-02

Standardise files with files in sous-chefs/repo-management

5.2.8 - 2023-02-23

Standardise files with files in sous-chefs/repo-management

5.2.7 - 2023-02-15

Update Actions (#348)

5.2.6 - 2023-02-15

Standardise files with files in sous-chefs/repo-management

5.2.5 - 2022-12-13

Standardise files with files in sous-chefs/repo-management

5.2.4 - 2022-03-16

Install mariadb.pp SELinux policy instead of building mariadb-server.te policy

5.2.3 - 2022-02-14

Remove delivery and move to calling RSpec directly via a reusable workflow
Update tested platforms
Fix Alma / Rocky Linux (resolves #340)

5.2.2 - 2022-02-08

Remove delivery folder

5.2.1 - 2021-11-03

Add CentOS Stream 8 to CI pipeline

5.2.0 - 2021-10-29

Testing MariaDB 10.4 server install
Fix root password cannot be manually set on 10.4+

5.1.0 - 2021-10-13

Migrate to using selinux cookbook which incorporates selinux_policy cookbook resources

5.0.2 - 2021-08-30

Standardise files with files in sous-chefs/repo-management

5.0.1 - 2021-06-01

Standardise files with files in sous-chefs/repo-management

5.0.0 - 2021-05-14

Chef 17 updates: enable unified_mode on all resources
Bump required Chef Infra Client to >= 15.3

4.3.0 - 2021-02-15

Make sleep configurable in apply-mariadb-root-password

4.2.1 - 2021-01-25

Ensure we run selinux_policy_install if selinux is enabled

4.2.0 - 2020-12-01

Add bootstrap and join actions to mariadb_galera_configuration to bootstrap and join clusters

4.1.4 - 2020-11-26

Add back selinux_policy to install vendored SELinux policies

4.1.3 - 2020-11-23

Remove unused selinux_policy cookbook dependency

4.1.2 (2020-11-18)

fix default libgalera_smm.so path on x86_64 systems

4.1.1 (2020-11-18)

resolved cookstyle error: spec/libraries/helper_spec.rb:2:18 convention: Style/RedundantFileExtensionInRequire
resolved underscore bug: mariadb_user's :grant action incorrectly handled privileges with underscores, now it correctly substitutes them with a space

4.1.0 (2020-08-27)

Allowed " in password
Changed resources to use :provides
Replaced mysql service name with mariadb
resolved cookstyle error: resources/galera_configuration.rb:114:5 convention: Style/RedundantAssignment
resolved cookstyle error: resources/galera_configuration.rb:115:5 convention: Layout/IndentationWidth
resolved cookstyle error: resources/galera_configuration.rb:120:26 warning: Layout/EndAlignment
resolved cookstyle error: resources/galera_configuration.rb:121:1 convention: Layout/EmptyLinesAroundMethodBody
resolved cookstyle error: resources/galera_configuration.rb:121:1 convention: Layout/TrailingWhitespace
resolved cookstyle error: resources/user.rb:187:5 convention: Style/RedundantAssignment
resolved cookstyle error: resources/user.rb:188:5 convention: Layout/IndentationWidth
resolved cookstyle error: resources/user.rb:189:21 convention: Layout/ElseAlignment
resolved cookstyle error: resources/user.rb:190:5 convention: Layout/IndentationWidth
resolved cookstyle error: resources/user.rb:191:21 convention: Layout/ElseAlignment
resolved cookstyle error: resources/user.rb:192:5 convention: Layout/IndentationWidth
resolved cookstyle error: resources/user.rb:193:21 warning: Layout/EndAlignment
resolved cookstyle error: resources/user.rb:194:1 convention: Layout/EmptyLinesAroundMethodBody
resolved cookstyle error: resources/user.rb:194:1 convention: Layout/TrailingWhitespace
resolved cookstyle error: resources/user.rb:203:5 convention: Style/RedundantAssignment
resolved cookstyle error: resources/user.rb:204:1 convention: Layout/EmptyLinesAroundMethodBody
resolved cookstyle error: resources/user.rb:204:1 convention: Layout/TrailingWhitespace
resolved cookstyle error: test/cookbooks/test/recipes/user_database.rb:1:1 refactor: ChefCorrectness/IncorrectLibraryInjection
resolved cookstyle error: test/cookbooks/test/recipes/user_database.rb:17:3 refactor: ChefModernize/ConditionalUsingTest
resolved cookstyle error: test/cookbooks/test/recipes/user_database.rb:27:3 refactor: ChefModernize/ConditionalUsingTest
resolved cookstyle error: test/cookbooks/test/recipes/user_database.rb:37:3 refactor: ChefModernize/ConditionalUsingTest
resolved cookstyle error: test/cookbooks/test/recipes/user_database.rb:47:3 refactor: ChefModernize/ConditionalUsingTest
resolved cookstyle error: test/cookbooks/test/recipes/user_database.rb:57:3 refactor: ChefModernize/ConditionalUsingTest
resolved cookstyle error: test/cookbooks/test/recipes/user_database.rb:67:3 refactor: ChefModernize/ConditionalUsingTest

4.0.1 (2020-06-02)

resolved cookstyle error: resources/repository.rb:60:18 refactor: ChefCorrectness/InvalidPlatformFamilyInCase

4.0.0 (2020-05-22)

Update CHANGELOG format
Add CentOS 8 to GitHub Actions
Add Ubuntu 20.04 to GitHub Actions
Remove Amazon Linux 2 from GitHub Actions
Chef 15 is now the lowest supported version
- See cookbook support for more information.

3.2.0 (2020-05-05)

Simplify a platform version check in the repository resource and the helpers library
Migrate testing to Github Actions
Simplify the apt_repository resource usage in the repository resource
Use true/false in the user resource not TrueClass / FalseClass
Fixed changing the character set and collation of an existing database resource
Simplify a platform version check in the repository resource
Migrate testing to GitHub Actions
Various Cookstyle fixes:
- resolved cookstyle error: resources/server_configuration.rb:203:5 refactor: ChefStyle/NegatingOnlyIf
- resolved cookstyle error: resources/server_configuration.rb:288:7 refactor: ChefStyle/NegatingOnlyIf
- resolved cookstyle error: test/cookbooks/test/recipes/user_database.rb:1:16 warning: Lint/SendWithMixinArgument
- resolved cookstyle error: resources/database.rb:24:42 refactor: ChefRedundantCode/StringPropertyWithNilDefault
- resolved cookstyle error: resources/database.rb:25:42 refactor: ChefRedundantCode/StringPropertyWithNilDefault
- resolved cookstyle error: resources/galera_configuration.rb:24:66 refactor: ChefRedundantCode/StringPropertyWithNilDefault
- resolved cookstyle error: resources/galera_configuration.rb:25:66 refactor: ChefRedundantCode/StringPropertyWithNilDefault
- resolved cookstyle error: resources/galera_configuration.rb:32:66 refactor: ChefRedundantCode/StringPropertyWithNilDefault
- resolved cookstyle error: resources/replication.rb:25:54 convention: Layout/ExtraSpacing
- resolved cookstyle error: resources/replication.rb:25:56 refactor: ChefRedundantCode/StringPropertyWithNilDefault
- resolved cookstyle error: resources/replication.rb:26:71 convention: Layout/ExtraSpacing
- resolved cookstyle error: resources/server_configuration.rb:27:62 refactor: ChefRedundantCode/StringPropertyWithNilDefault
- resolved cookstyle error: resources/server_configuration.rb:65:62 refactor: ChefRedundantCode/StringPropertyWithNilDefault
- resolved cookstyle error: resources/server_configuration.rb:93:62 refactor: ChefRedundantCode/StringPropertyWithNilDefault

3.1.0 (2019-10-24)

Fix mariadbbackup_pkg_name helper for yum-based platforms (#276)
Fix replication resource load_current_value to use Integers where required
Fix Make server_configuration and server_install resources idempotent (#265)
Simplify platform check logic in the repository resource

3.0.0 (2019-10-17)

Added tests suite for 2 scenarios (galera_configuration and port_changed)
Added support for Debian 10
Update documentation following sous-chefs.org guidelines
Fix undefined method ext_conf_dir when using mariadb 2.0.0 (#225)
Fix Rename property apt_repository to apt_repository_uri in repository resource (#245)
Fix markdown and yaml linting, cookstyle, and parallel circle builds
Remove support for debian 8 (end of life since 2018-6-6)

2.1.0

Add property apt_key_proxy to mariadb_repository to be able to pass a proxy setting to apt-key (#234)
Add a mechanism to properly set the root password for mariadb (#234-bc33fb2 : #234-c576d42)
Add APT repository property to allow the user to select another mirror than ovh.net
Fix String quoting that prevented some SQL commands to execute properly (#220)
Fix broken CHANGELOG links
Fix setup repo condition, it always updated even if setup_repo was false

2.0.0

Added all resources which replace the old recipes
Removed support for fedora
Removed all recipes
Removed support for Chef 13

1.5.4 (2018-05-25)

Added resource mariadb_database to manage databases (#187)
Added resource mariadb_user to manage users and privileges (#187)
Added support for MariaDB galera 10.2 (#197)
Added support for Debian 9 (#193,#194,#198,#202)
Added the new SST method mariabackup (#192)
Fixed a libssl conflict when using resources based on mysql2 gem (#193)
Fixed lack of libmariadbclient-dev on Ubuntu 16.04 when using native package (#186)
Removed support for Chef 12 (#203)

1.5.3 (2017-10-13)

This cookbook was transferred to Sous Chefs.

Fixed bug where cookbook tries to set root password on every run instead of first install only (#174)

1.5.2 (2017-10-05)

Added optimisations for client and server ChefSpec (#165)
Added support for Percona XtraBackup 2.4 package (#170)
Fixed CookStyle warnings (#172)
Fixed Chefspec/Fauxhai deprecation messages (#171)
Fixed missing privileges on sstuser (#168)
Ensure configuration reload and server start after config (#166)
Removed some OSes from Travis test suite; now only running tests on latest supported OS releases to get faster feedback

1.5.1 (2017-05-02)

Remove check for chef-client running in local mode in the galera recipe which skips search - this prevents being able to search when using TK (#160)

1.5.0 (2017-04-25)

Add the ability to set a custom wsrep_node_port, for when you want to specify a non default wsrep_node_incoming_address value (#152)

1.4.0 (2017-04-21)

#128 solved, mysql-libs is prevented from being removed on newer CentOS versions causing Chef to break (#153)
mariadb_replication rewritten as a custom resource (#151)
Remove Fedora support, tested versions are long gone EOL and hard to support; only latest version has a repo on yum.mariadb.org

1.3.0 (2017-03-20)

Add ability to enable and disable server audit logging (#150)

1.2.0 (2017-03-15)

Add recipe and attributes to install using Software Collections (SCL) on RedHat family systems (#149)

1.1.0 (2017-03-12)

Correctly set server-id and fixed replication provider nil string bug (#118)
Make open-files-limit configurable (previously commented out in template) (#118)
Fix package name for RedHat family distros using MariaDB 10.1 (#138)
Add ability to specify your own gcomm:// address for Galera replication (#139)
Add attribute containing my.cnf sections to configure to allow users to override what cookbook manages
Add attributes to configure general and slow log options (#137)
Add Docker CI tests (add new APT key to fix #107, add Supermarket version badge and change Travis badge to show master build status to README)
Add Docker tests to Travis for smoke tests
Change CHANGELOG format to follow Keep a Changelog (v0.3.0)
Change Chef search results message log level to debug to remove unnecessary output (#90)
Update Vagrant box names to match latest OS versions for testing with VirtualBox
Remove Fedora platfrom from Test-Kitchen, not something we'll test on going forward
Remove Ubuntu 12.04 LTS from Test-Kitchen, not something we'll test on going forward as it reaches EOL in one month

1.0.1

Correct ServerSpec tests
Correct some Units tests (Use ServerRunner instead of SoloRunner to test search)
Add an option to not install extra packages
Update OS version to check with Kitchen

1.0.0

Fix fetching apt key on every run bug (#91)
Fix Foodcritic and RuboCop offences
Fix ChefSpec tests (and adding more coverage)
Fix some typos
Fix CI
Fix non-interpolated array
Fix only_if
Fix unary operator; ensure script exits on any error
Prevent cookbook from crashing Chef < 12
Add support for configuring skip-name-resolve
Add missing code to my.cnf template to deploy mysqld_safe options
Add the ability to config skip-log-bin to be present
Add MariaDB 10.1 and data bag support
Add exception handling, when searching for data bag
Add some mandatory attributes and minor fixes
Add test for bin_log unset
Add sensitive tag to execute statement
Add support to disable binlog (by setting log_bin to false)
Apply a more standard .gitignore
Update chef components to more recent versions
Update documentation for 'options' hash
Use Berkshelf 4.x and RVM 2.1.7
Remove anonymous users and test database by default

0.3.3

Add the ability to configure skip-log-bin to be present (#110)

0.3.2

Add missing code to my.cnf template to deploy mysqld_safe options (#125)
Add support for configuring skip-name-resolve (#126)

0.3.1

Add user and password to correct debian-grants (#57)
Correct service name inconsistency on CentOS 7 (#68)
Fix directory permissions regression (#73)
mariadb_configuration template uses current cookbook as template source (#66)
Service is restarted every run if not localhost (#76)
Add Scientific Linux support (#69)
Add a vagrant config to test a Galera cluster (#64)
Add xtrabackup-v2 support for SST Method (#71)
Allow Galera cluster nodes to be configured when using Chef Solo (#62)

0.3.0

Add support for using operating system shipped mariadb packages

0.2.12

Push gpg key adds through http/0 - Helps with firewalled installs (#39)
Load the needed plugins at startup (#48)
Add cookbook attribute on configuration LWRP (#46)
Allow to pass true for unary options (#47)

0.2.11

Fix TypeError in the replication provider (#43)
Add CentOS support (#38)
Add sensitive flag to resource that deal with passwords (#40)

0.2.10

Audit Plugin test and installation - Correct bad notifies and stdout test

0.2.9

Audit plugin installation can crash mariadb server (#36)

0.2.8

Add a switch to not launch audit plugin install, when already installed (#29)
Remove the only_if to mysql service (#28)
When using Galera, nodes were not sorted, applying configuration change too often (#30)
Add more ChefSpec coverage (#31)
Add a switch to separate server install and audit install when needed
Add a RuboCop rule to allow line length to be 120 characters long

0.2.7

Fix convert TypeError in the replication provider (#24)
Data is now moved when ['mariadb']['mysqld']['datadir'] is changed (#25)
Add audit_plugin management (#31)

0.2.6

Fix provider mariadb_replication compilation error (#18)
Complete CHANGELOG and correct README

0.2.5

Fix the debian-sys-maint user creation/password change (#12)
Fix the Galera root password preseed (#11)
Add a LWRP to manage replication slave (#16)
Add attribute to set custom apt_repository's' base_url (#6)
Add new tests for the new features (Galera, development files install, replication LWRP)
Add option to skip installing development files within client recipe (#17)
Add CHANGELOG and add new feature explanations to README

0.2.4

Fix FC004 broken rule (#10)
Fix Foodcritic tests (add --epic-fail any to be sure it fails when a broken rule is detected) (#9)

0.2.3

Fix management of the mysql root password (#4)
Add a lot of ChefSpec and kitchen/ServerSpec tests
Add ability to add or remove root remote access via attribute (#7)
Add immediate restart of the mysql service when port is changed (#5)
Add more documentation

0.2.2

Fix and add multiple tests
Fix client install to add dev files
Fix repository install under Debian family

0.2.1

Add stove to package/publish cookbook (remove PaxHeaders)

0.2.0

Correct the Documentation
Add a recipe to manage client only installation
Add RPM/Yum management
Refactor all tests to manage new platform (CentOS/RedHat/Fedora)
Refactor the whole recipes list and management to ease it
Rename the provider (from extraconf to configuration) and add matchers for it

0.1.8

Add ignore-failure to debian-grants correct as it can break on initial setup

0.1.7

Correct a typo (unnecessary call to run_command)

0.1.6

Add new rspec tests
Create Kitchen test suite
Improve Galera configuration management

0.1.5

Improve attributes management

0.1.4

Adapt galera55 recipe to use a generic galera recipe
Improve documentation
Use a generic Galera recipe to create the galera10 recipe

0.1.0

Initial release of mariadb

Collaborator Number Metric

5.5.5 passed this metric

Contributing File Metric

5.5.5 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file

Cookstyle Metric

5.5.5 passed this metric

No Binaries Metric

5.5.5 passed this metric

Testing File Metric

5.5.5 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file

Version Tag Metric

5.5.5 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number

Adoptable Cookbooks List

Supermarket Belongs to the Community

View our collection of guides, documentation, and articles

Select Badges

Select Supported Platforms

Select Status

MariaDB Cookbook

Description

Maintainers

Requirements

repository

packages

operating system

Chef version

Upgrading

Resources

Contributing

Contributors

Backers

Sponsors

Dependent cookbooks

Contingent cookbooks

mariadb CHANGELOG

5.5.5 - 2024-07-15

5.5.4 - 2024-05-06

5.5.3 - 2024-05-06

5.5.2 - 2023-11-01

5.5.1 - 2023-09-04

5.5.0 - 2023-08-30

5.4.0 - 2023-08-19

5.3.2 - 2023-07-10

5.3.1 - 2023-05-17

5.3.0 - 2023-05-02

5.2.19 - 2023-04-18

5.2.18 - 2023-04-16

5.2.17 - 2023-04-12

5.2.16 - 2023-04-11

5.2.15 - 2023-04-07

5.2.14 - 2023-04-01

5.2.13 - 2023-04-01

5.2.12 - 2023-04-01

5.2.11 - 2023-03-13

5.2.10 - 2023-03-11

5.2.9 - 2023-03-02

5.2.8 - 2023-02-23

5.2.7 - 2023-02-15

5.2.6 - 2023-02-15

5.2.5 - 2022-12-13

5.2.4 - 2022-03-16

5.2.3 - 2022-02-14

5.2.2 - 2022-02-08

5.2.1 - 2021-11-03

5.2.0 - 2021-10-29

5.1.0 - 2021-10-13

5.0.2 - 2021-08-30

5.0.1 - 2021-06-01

5.0.0 - 2021-05-14

4.3.0 - 2021-02-15

4.2.1 - 2021-01-25

4.2.0 - 2020-12-01

4.1.4 - 2020-11-26

4.1.3 - 2020-11-23

4.1.2 (2020-11-18)

4.1.1 (2020-11-18)

4.1.0 (2020-08-27)

4.0.1 (2020-06-02)

4.0.0 (2020-05-22)

3.2.0 (2020-05-05)

3.1.0 (2019-10-24)

3.0.0 (2019-10-17)

2.1.0

2.0.0

1.5.4 (2018-05-25)

1.5.3 (2017-10-13)

1.5.2 (2017-10-05)

1.5.1 (2017-05-02)

1.5.0 (2017-04-25)

1.4.0 (2017-04-21)

1.3.0 (2017-03-20)

1.2.0 (2017-03-15)

Collaborator Number Metric

5.5.5 passed this metric

Contributing File Metric

5.5.5 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file

Cookstyle Metric

5.5.5 passed this metric

No Binaries Metric

5.5.5 passed this metric

Testing File Metric

5.5.5 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file

Version Tag Metric

5.5.5 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number