cookbook 'mariadb', '= 0.2.12'
mariadb
(85) Versions
0.2.12
-
-
6.2.0
-
6.1.1
-
6.1.0
-
6.0.0
-
5.5.5
-
5.5.4
-
5.5.3
-
5.5.2
-
5.5.1
-
5.5.0
-
5.4.0
-
5.3.2
-
5.3.1
-
5.3.0
-
5.2.19
-
5.2.18
-
5.2.17
-
5.2.16
-
5.2.15
-
5.2.14
-
5.2.13
-
5.2.12
-
5.2.11
-
5.2.10
-
5.2.9
-
5.2.8
-
5.2.7
-
5.2.6
-
5.2.5
-
5.2.4
-
5.2.3
-
5.2.2
-
5.2.1
-
5.2.0
-
5.1.0
-
5.0.2
-
5.0.1
-
5.0.0
-
4.3.0
-
4.2.1
-
4.2.0
-
4.1.4
-
4.1.3
-
4.1.2
-
4.1.1
-
4.1.0
-
4.0.1
-
4.0.0
-
3.2.0
-
3.1.0
-
3.0.0
-
2.1.0
-
2.0.0
-
1.5.4
-
1.5.3
-
1.5.2
-
1.5.1
-
1.5.0
-
1.4.0
-
1.3.0
-
1.2.0
-
1.1.0
-
1.0.1
-
0.3.4
-
0.3.3
-
0.3.2
-
0.3.1
-
0.3.0
-
0.2.13
-
0.2.12
-
0.2.11
-
0.2.10
-
0.2.9
-
0.2.8
-
0.2.7
-
0.2.6
-
0.2.5
-
0.2.4
-
0.2.3
-
0.2.2
-
0.2.1
-
0.2.0
-
0.1.8
-
0.1.7
-
0.1.6
Follow51
- 6.2.0
- 6.1.1
- 6.1.0
- 6.0.0
- 5.5.5
- 5.5.4
- 5.5.3
- 5.5.2
- 5.5.1
- 5.5.0
- 5.4.0
- 5.3.2
- 5.3.1
- 5.3.0
- 5.2.19
- 5.2.18
- 5.2.17
- 5.2.16
- 5.2.15
- 5.2.14
- 5.2.13
- 5.2.12
- 5.2.11
- 5.2.10
- 5.2.9
- 5.2.8
- 5.2.7
- 5.2.6
- 5.2.5
- 5.2.4
- 5.2.3
- 5.2.2
- 5.2.1
- 5.2.0
- 5.1.0
- 5.0.2
- 5.0.1
- 5.0.0
- 4.3.0
- 4.2.1
- 4.2.0
- 4.1.4
- 4.1.3
- 4.1.2
- 4.1.1
- 4.1.0
- 4.0.1
- 4.0.0
- 3.2.0
- 3.1.0
- 3.0.0
- 2.1.0
- 2.0.0
- 1.5.4
- 1.5.3
- 1.5.2
- 1.5.1
- 1.5.0
- 1.4.0
- 1.3.0
- 1.2.0
- 1.1.0
- 1.0.1
- 0.3.4
- 0.3.3
- 0.3.2
- 0.3.1
- 0.3.0
- 0.2.13
- 0.2.12
- 0.2.11
- 0.2.10
- 0.2.9
- 0.2.8
- 0.2.7
- 0.2.6
- 0.2.5
- 0.2.4
- 0.2.3
- 0.2.2
- 0.2.1
- 0.2.0
- 0.1.8
- 0.1.7
- 0.1.6
Installs/Configures MariaDB
cookbook 'mariadb', '= 0.2.12', :supermarket
knife supermarket install mariadb
knife supermarket download mariadb
MariaDB Cookbook
Description
This cookbook contains all the stuffs to install and configure a mariadb server on a dpkg/apt compliant system (typically debian), or a rpm/yum compliant system (typically centos)
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. -
socat
- if you want to use the xtrabckup 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
- not fully tested on ubuntu, but should work -
centos
- not fully tested on centos, but should work
Attributes
mariadb::default
<table>
<tr>
<th>Key</th>
<th>Type</th>
<th>Description</th>
<th>Default</th>
</tr>
<tr>
<td><tt>['mariadb']['install']['version']</tt></td>
<td>String</td>
<td>Version to install (currently 10.0 et 5.5)</td>
<td><tt>10.0</tt></td>
</tr>
<tr>
<td><tt>['mariadb']['use_default_repository']</tt></td>
<td>Boolean</td>
<td>Wether to install MariaDB default repository or not. If you don't have a local repo containing packages, put it to true</td>
<td><tt>false</tt></td>
</tr>
<tr>
<td><tt>['mariadb']['server_root_password']</tt></td>
<td>String</td>
<td>local root password</td>
<td><tt></tt></td>
</tr>
<tr>
<td><tt>['mariadb']['forbid_remote_root']</tt></td>
<td>Boolean</td>
<td>Wether to activate root remote access</td>
<td><tt>true</tt></td>
</tr>
<tr>
<td><tt>['mariadb']['allow_root_pass_change']</tt></td>
<td>Boolean</td>
<td>Wether to allow the recipe to change root password after the first install</td>
<td><tt>false</tt></td>
</tr>
<tr>
<td><tt>['mariadb']['client']['development_files']</tt></td>
<td>Boolean</td>
<td>Wether to install development files in client recipe</td>
<td><tt>true</tt></td>
</tr>
<tr>
<td><tt>['mariadb']['apt_repository']['base_url']</tt></td>
<td>String</td>
<td>The http base url to use when installing from default repository</td>
<td><tt>'ftp.igh.cnrs.fr/pub/mariadb/repo'</tt></td>
</tr>
</table>
Usage
To install a default server for mariadb choose the version you want (MariaDB 5.5 or 10, galera or not), then call the recipe accordingly.
List of availables recipes:
- mariadb::default (just call server recipe with default options)
- mariadb::server
- mariadb::galera
- mariadb::client
Please be ware that by default, the root password is empty! If you want have changed it use the node['mariadb']['server_root_password']
attribute to put a correct value. And by default the remote root access is not activated. Use node['mariadb']['forbid_remote_root']
attribute to change it.
Sometimes, the default apt repository used for apt does not work (see issue #6). In this case, you need to choose another mirror which worki (pick it from mariadb website), and put the http base url in the attribute node['mariadb']['apt_repository']['base_url']
.
mariadb::galera
When installing the mariadb::galera on debian recipe, You have to take care of one specific attribute:
node['mariadb']['debian']['password']
which default to 'please-change-me'
As wee need to have the same password for this user on the whole cluster nodes... We will change the default install one by the content of this attribute.
mariadb::client
By default this recipe install the client, and all needed packages to develop client application. If you do not want to install development files when installing client package,
set the attribute node['mariadb']['client']['development_files']
to false.
Providers
This recipe define 2 providers:
- Chef::Provider::Mariadb::Configuration
shortcut resource mariadb_configuration
- Chef::Provider::Mariadb::Replication
shortcut resource mariadb_replication
mariadb_configuration
Mainly use for internal purpose. You can use it to create a new configuration file into configuration dir. You have to define 2 variables section
and option
.
Where section
is the configuration section, and option
is a hash of key/value. The name of the resource is used as base for the filename.
Example:
ruby
mariadb_configuration 'fake' do
section 'mysqld'
option {foo: 'bar'}
end
will become the file fake.cnf in the include dir (depend on your platform), which contain:
[mysqld]
foo=bar
If the value start with a '#', then it's considered as a comment, and the value is printed as is (without the key)
Example:
ruby
mariadb_configuration 'fake' do
section 'mysqld'
option {comment1: '# Here i am', foo: bar}
end
will become the file fake.cnf in the include dir (depend on your platform), which contain:
```
[mysqld]
Here i am
foo=bar
```
mariadb_replication
This LWRP is used to manage replication setup on a host. To use this LWRP, the node need to have the mysql binary installed (via the mariadb::client or mariadb::server or mariadb::galera recipe).
It have 4 actions:
- add - to add a new replication setup (become a slave)
- stop - to stop the slave replication
- start - to start the slave replication
- remove - to remove the slave replication configuration
The resource name need to be 'default' if your don't want to use a named connection (multi source replication in MariaDB 10).
So by default the provider try to use the local instance of mysql, with the current user and no password. If you want to change, you have to define host
, port
, user
or password
mariadb_replication 'default' do user 'root' password 'fakepass' host 'fakehost' action :stop end
will stop the replication on the host fakehost
using the user root
and password fakepass
to connect to.
When you add a replication configuration, you have to define at least 4 values master_host
, master_user
, master_password
and master_use_gtid
. And if you don't want the GTID support, you have to define also master_log_file
and master_log_pos
Example:
ruby
mariadb_replication 'usefull_conn_name' do
master_host 'server1'
master_user 'slave_user'
master_password 'slave_password'
master_use_gtid 'current_pos'
action :add
end
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
License and Authors
Authors:
Nicolas Blanc sinfomicien@gmail.com
mariadb CHANGELOG
This file is used to list changes made in each version of the mariadb cookbook.
0.2.12
- [BUG #39] - Push gpg key adds through http/80 - Helps with firewalled installs
- [ENH #46] - Add cookbook attribute on configuration lwrp
- [ENH #47] - Allow to pass true for unary options
- [BUG #48] - Load the needed plugins at startup
0.2.11
- [ENH #38] - Add CentOS support
- [ENH #40] - Add sensitive flag to resource that deal with passwords
- [BUG #43] - Fix convert TypeError in the replication provider
0.2.10
- [BUG] - Audit Plugin test and installation - Correct bad notifies, and stdout test
0.2.9
- [BUG #36] - Audit plugin installation can crash mariadb server
0.2.8
- [BUG #30] - When using galera, nodes were not sorted, applying configuration change too often
- [BUG #31] - ChefSpec coverage was not 100%
- [BUG #28] - Remove the only_if to mysql service
- [BUG #29] - Add a switch to not launch audit plugin install, when already installed
- [ENH] - Add a switch to separate server install and audit install when needed
- [ENH] - Add a rule to authorize line length to be 120 characters long
0.2.7
- [BUG #24] - Fix convert TypeError in the replication provider
- [BUG #25] - Data are now moved when default datadir is changed
- [ENH #21] - Add audit_plugin management
0.2.6
- [BUG #18] - Fix provider mariadb_replication compilation error
- [DOCS] - Complete Changelog, and correct README
0.2.5
- [ENH #16] - Add a LWRP to manage replication slave
- [ENH #17] - Be able to not install development files within client recipe
- [ENH #11] - Fix the galera root password preseed
- [BUG #12] - Fix the debian-sys-maint user creation/password change
- [BUG #6] - Can change the apt repository base_url when the default one fail
- [TEST] - Add new tests for the new features (galera,development files install,replication LWRP)
- [DOCS] - Complete Changelog, and add new features explanations into README
0.2.4
- [BUG #10] - Correct a FC004 broken rule
- [BUG #9] - Correct foodcritic tests (add --epic-fail any to be sure it fails when a broken rule is detected)
0.2.3
- [BUG #4] - Add a real management of mysql root password
- [ENH #5] - Now restart mysql service when port is changed
- [ENH #7] - Remove or add root remote access via attribute
- [DOCS] - Complete documentations
- [TEST] - Add a lot of chefspec and kitchen/serverspec tests
0.2.2
- [sinfomicien] - Correct repository install under debian family
- [sinfomicien] - Correct client install to add dev files
- [sinfomicien] - Correct and add multiples tests
0.2.1
- [sinfomicien] - Use stove to package (remove PaxHeaders.*)
0.2.0
- [sinfomicien] - Add rpm/yum management
- [sinfomicien] - Refactor the whole recipes list and management to ease it
- [sinfomicien] - Correct the Documentation
- [sinfomicien] - Rename the provider (from extraconf to configuration), and add matchers to it
- [sinfomicien] - Add a recipe to manage client only installation
- [sinfomicien] - Refactor all tests to manage new platform (centos/redhat/fedora)
0.1.8
- [sinfomicien] - Add ignore-failure to debian grants correct, as it can break on initial setup
0.1.7
- [sinfomicien] - Correct a typo (unnecessary call to run_command)
0.1.6
- [sinfomicien] - improve Galera configuration management
- [sinfomicien] - Add new rspec tests
- [sinfomicien] - Create Kitchen test suite
0.1.5
- [sinfomicien] - improve attributes management
0.1.4
- [sinfomicien] - adapt galera55 recipe to use a generic galera recipe
- [sinfomicien] - use a generic galera recipe to create the galera10 recipe
- [sinfomicien] - Improve documentation
0.1.0
- [sinfomicien] - Initial release of mariadb
Foodcritic Metric
0.2.12 failed this metric
FC031: Cookbook without metadata file: /tmp/cook/3120128d724ed4a005b84c7f/mariadb/metadata.rb:1
FC045: Consider setting cookbook name in metadata: /tmp/cook/3120128d724ed4a005b84c7f/mariadb/metadata.rb:1
0.2.12 failed this metric
FC045: Consider setting cookbook name in metadata: /tmp/cook/3120128d724ed4a005b84c7f/mariadb/metadata.rb:1