cookbook 'percona', '= 1.0.0'
percona
(59) Versions
1.0.0
-
-
3.4.8
-
3.4.7
-
3.4.6
-
3.4.4
-
3.4.3
-
3.4.2
-
3.4.1
-
3.4.0
-
3.3.1
-
3.3.0
-
3.2.11
-
3.2.10
-
3.2.9
-
3.2.8
-
3.2.7
-
3.2.6
-
3.2.5
-
3.2.4
-
3.2.3
-
3.2.2
-
3.2.1
-
3.2.0
-
3.1.3
-
3.1.2
-
3.1.1
-
3.1.0
-
3.0.0
-
2.1.2
-
2.1.1
-
2.1.0
-
2.0.1
-
2.0.0
-
1.1.1
-
1.1.0
-
1.0.0
-
0.17.2
-
0.17.1
-
0.17.0
-
0.16.5
-
0.16.1
-
0.16.0
-
0.15.5
-
0.15.4
-
0.15.3
-
0.15.2
-
0.15.1
-
0.15.0
-
0.14.5
-
0.14.4
-
0.14.3
-
0.14.2
-
0.14.1
-
0.14.0
-
0.13.0
-
0.12.4
-
0.12.3
-
0.12.2
-
0.1.1
-
0.0.1
Follow45
- 3.4.8
- 3.4.7
- 3.4.6
- 3.4.4
- 3.4.3
- 3.4.2
- 3.4.1
- 3.4.0
- 3.3.1
- 3.3.0
- 3.2.11
- 3.2.10
- 3.2.9
- 3.2.8
- 3.2.7
- 3.2.6
- 3.2.5
- 3.2.4
- 3.2.3
- 3.2.2
- 3.2.1
- 3.2.0
- 3.1.3
- 3.1.2
- 3.1.1
- 3.1.0
- 3.0.0
- 2.1.2
- 2.1.1
- 2.1.0
- 2.0.1
- 2.0.0
- 1.1.1
- 1.1.0
- 1.0.0
- 0.17.2
- 0.17.1
- 0.17.0
- 0.16.5
- 0.16.1
- 0.16.0
- 0.15.5
- 0.15.4
- 0.15.3
- 0.15.2
- 0.15.1
- 0.15.0
- 0.14.5
- 0.14.4
- 0.14.3
- 0.14.2
- 0.14.1
- 0.14.0
- 0.13.0
- 0.12.4
- 0.12.3
- 0.12.2
- 0.1.1
- 0.0.1
Installs Percona MySQL client and server
cookbook 'percona', '= 1.0.0', :supermarket
knife supermarket install percona
knife supermarket download percona
Percona Cookbook
Description
Installs the Percona MySQL client and/or
server components. (We are attempting to leverage the Sous-Chefs
MySQL cookbook as much as possible.)
Optionally installs:
- XtraBackup hot backup software
- Percona Toolkit advanced command-line tools
- XtraDB Cluster high availability and high scalability solution for MySQL.
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
Supported Platforms
We provide an expanding set of tests against the following 64-bit platforms which match what upstream supports:
- CentOS 7+
- Debian 9+
- Ubuntu 16.04+ LTS
Cookbooks
Chef
This cookbook requires Chef >= 13.
Recipes
-
percona
- The default which includes the client recipe. -
percona::package_repo
- Sets up the package repository and installs common packages. -
percona::client
- Installs the Percona MySQL client libraries. -
percona::server
- Installs and configures the Percona MySQL server daemon. -
percona::backup
- Installs and configures the Percona XtraBackup hot backup software. -
percona::toolkit
- Installs the Percona Toolkit software -
percona::cluster
- Installs the Percona XtraDB Cluster server components -
percona::configure_server
- Used internally to manage the server configuration. -
percona::replication
- Used internally to grant permissions for replication. -
percona::access_grants
- Used internally to grant permissions for recipes. -
percona::ssl
- Used internally to setup ssl certificates for server/client.
Usage
This cookbook installs the Percona MySQL components if not present, and pulls updates if they are installed on the
system.
This cookbook uses inclusion terminology where applicable replacing terms such as master/slave
to source/replica
which matches the terminology decided upstream. Older
releases of Percona still use the terms in their configuration so those will remain, however we will be using the newer
terms with attributes, property and variable names. Currently both terms should work however the next major release of
this cookbook will only use the new terminology.
Encrypted Passwords
This cookbook requires Encrypted Data Bags. If you forget to use them or do not use a node attribute to overwrite them empty passwords will be used.
To use encrypted passwords, you must create an encrypted data bag. This cookbook assumes a data bag named passwords
, but you can override the name using the node['percona']['encrypted_data_bag']
attribute. You can also optionally specify a data bag secret file to be loaded for the secret key using the node['percona']['encrypted_data_bag_secret_file']
attribute.
This cookbook expects a mysql
item and a system
item. Please refer to the official documentation on how to get this setup. It actually uses a MySQL example so it can be mostly copied. Ensure you cover the data bag items as described below.
You also may set expected item names via attributes node['percona']['encrypted_data_bag_item_mysql']
and node['percona']['encrypted_data_bag_item_system']
.
Skip passwords
Set the ['percona']['skip_passwords']
attribute to skip setting up passwords. Removes the need for the encrypted data bag if using chef-solo. Is useful for setting up development and ci environments where you just want to use the root user with no password. If you are doing this you may want to set ['percona']['server']['debian_username']
to be "root"
also.
Skip Configure
Set the ['percona']['skip_configure']
attribute to skip having the server recipe include the configure_server recipe directly after install. This is mostly useful in a wrapper cookbook sort of context. Once skipped, you can then perform any pre-config actions your wrapper needs to, such as dropping a custom configuration file or init script or cleaning up incorrectly sized innodb logfiles. You can then include configure_server where necessary.
mysql item
The mysql item should contain entries for root, backup, and replication. If no value is found, the cookbook will fall back to the default non-encrypted password.
system item
The "system" item should contain an entry for the debian system user as specified in the node['percona']['server']['debian_username']
attribute. If no such entry is found, the cookbook will fall back to the default non-encrypted password.
Example: "passwords" data bag - this example assumes that node['percona']['server']['debian_username'] = spud
{ "mysql" : { "root" : "trywgFA6R70NO28PNhMpGhEvKBZuxouemnbnAUQsUyo=\n" "backup" : "eqoiudfj098389fjadfkadf=\n" "replication" : "qwo0fj0213fm9020fm2023fjsld=\n" }, "system" : { "spud" : "dwoifm2340f024jfadgfu243hf2=\n" } }
Above shows the encrypted password in the data bag. Check out the encrypted_data_bag_secret
setting in knife.rb
to setup your data bag secret during bootstrapping.
Replication over SSL
To enable SSL based replication, you will need to flip the attribute node['percona']['server']['replication']['ssl_enabled']
to true
and add a new data_bag item
to the percona encrypted data_bag (seenode['percona']['encrypted_data_bag']
attribute) with the id ssl_replication
( see node['percona']['encrypted_data_bag_item_ssl_replication']
attribute) that contains this data:
{ "id": "ssl_replication", "ca-cert": "CA_CERTIFICATE_STRING", "server": { "server-cert": "SERVER_CERTIFICATE_STRING", "server-key": "SERVER_KEY_STRING" }, "client": { "client-cert": "CLIENT_CERTIFICATE_STRING", "client-key": "CLIENT_KEY_STRING" } }
All certificates and keys have to be converted to a string (easiest way is to use ruby: /usr/bin/env ruby -e 'p ARGF.read' <filename>
) and placed
instead of CA_CERTIFICATE_STRING, SERVER_CERTIFICATE_STRING, SERVER_KEY_STRING, CLIENT_CERTIFICATE_STRING, CLIENT_KEY_STRING.
Percona XtraDB Cluster
Below is a minimal example setup to bootstrap a Percona XtraDB Cluster. Please see the official documentation for more information. This is not a perfect example. It is just a sample to get you started.
Wrapper recipe recipes/percona.rb:
# Setup the Percona XtraDB Cluster cluster_ips = [] unless Chef::Config[:solo] search(:node, 'role:percona').each do |other_node| next if other_node['private_ipaddress'] == node['private_ipaddress'] Chef::Log.info "Found Percona XtraDB cluster peer: #{other_node['private_ipaddress']}" cluster_ips << other_node['private_ipaddress'] end end cluster_ips.each do |ip| firewall_rule "allow Percona group communication to peer #{ip}" do source ip port 4567 action :allow end firewall_rule "allow Percona state transfer to peer #{ip}" do source ip port 4444 action :allow end firewall_rule "allow Percona incremental state transfer to peer #{ip}" do source ip port 4568 action :allow end end cluster_address = "gcomm://#{cluster_ips.join(',')}" Chef::Log.info "Using Percona XtraDB cluster address of: #{cluster_address}" node.override['percona']['cluster']['wsrep_cluster_address'] = cluster_address node.override['percona']['cluster']['wsrep_node_name'] = node['hostname'] include_recipe 'percona::cluster' include_recipe 'percona::backup' include_recipe 'percona::toolkit'
Example percona role roles/percona.rb:
name "percona" description "Percona XtraDB Cluster" run_list 'recipe[paydici::percona]' default_attributes( "percona" => { "server" => { "role" => "cluster" }, "cluster" => { "package" => "percona-xtradb-cluster-56", "wsrep_cluster_name" => "percona_cluster_1", "wsrep_sst_receive_interface" => "eth1" # can be eth0, public, private, etc. } } )
Now you need to bring three servers up one at a time with the percona role applied to them. By default the servers will sync up via rsync server state transfer (SST)
Explicit my.cnf templating
In some situations it is preferable to explicitly define the attributes needed in a my.cnf
file. This is enabled by adding categories to the node['percona']['conf']
attributes. All keys found in the node['percona']['conf']
map will represent categories in the my.cnf
file. Each category contains a map of attributes that will be written to the my.cnf
file for that category. See the example for more details.
Example
node['percona']['conf']['mysqld']['slow_query_log_file'] = "/var/lib/mysql/data/mysql-slow.log"
This configuration would write the mysqld
category to the my.cnf
file and have an attribute slow_query_log_file
whose value would be /var/lib/mysql/data/mysql-slow.log
.
Example output (my.cnf)
[mysqld] slow_query_log_file = /var/lib/mysql/data/mysql-slow.log
Dynamically setting the bind address
There's a special attribute node['percona']['server']['bind_to']
that allows you to dynamically set the bind address. This attribute accepts the values "public_ip"
, "private_ip"
, "loopback"
, or and interface name like "eth0"
. Based on this, the recipe will find a corresponding ipv4 address, and override the node['percona']['server']['bind_address']
attribute.
MySQL Gems
This cookbook provides a MySQL and MySQL2 gem installer specifically designed for
use with Percona. Since they share namespaces with other providers you most
likely want to call them directly targeting the provider, example provided below:
mysql2_chef_gem 'default' do provider Chef::Provider::Mysql2ChefGem::Percona action :install end mysql_chef_gem 'default' do provider Chef::Provider::MysqlChefGem::Percona action :install end
Also keep in mind that since these providers are subclasses of the mysql_chef_gem
and mysql2_chef_gem cookbooks they need to be added to your metadata.rb file as
depends to ensure they pull in the needed resource files.
Goals
In no particular order:
- Be the most flexible way to setup a MySQL distribution through Chef
- Support for Chef Solo
- Support for Chef Server
- Support the following common database infrastructures:
- Single server instance
- Traditional Source/Replica replication
- Multi-source cluster replication
- Support the most recent Chef runtime environments
- Be the easiest way to setup a MySQL distribution through Chef
TODO
- Fully support all of the standard Chef-supported distributions
Contributing
- Fork it
- Create your feature branch (
git checkout -b my-new-feature
) - Commit your changes (
git commit -am 'Added some feature'
) - Push to the branch (
git push origin my-new-feature
) - Create new Pull Request
Contributors
This project exists thanks to all the people who contribute.
Backers
Thank you to all our backers!
Sponsors
Support this project by becoming a sponsor. Your logo will show up here with a link to your website.
Dependent cookbooks
openssl >= 0.0.0 |
yum-epel >= 0.0.0 |
chef-vault >= 0.0.0 |
line >= 0.0.0 |
Contingent cookbooks
percona Cookbook CHANGELOG
This file is used to list changes made in each version of the percona cookbook.
1.0.0 - 2020-08-14
Added
- Add support for Debian 10 for 5.7 only
- Add support for Ubuntu 20.04 for 5.7 only
- Add support for CentOS 8
- Add cluster suite and tests to test cluster recipe
- Add support for Percona 8.0 and default to that version
- Re-add ChefSpec tests
- Add ssl suite and tests for ssl recipe
- Add master suite and tests for testing the replication recipe
- Suite to test compatibility with Chef 13
Fixed
- Update apt gpg key
- Fixes for supporting 5.7
- Fix manage_symlink_source warning with template[/etc/mysql/my.cnf]
- Don't remove mysql-libs on RHEL
- jemalloc package installation and path setup for all platforms
- Fixed enabled ChefSpec tests
- Use the correct syntax on 8.0 for SSL replication
- Use correct cert path for master/slave
- Fix issue when trying to set node['percona']['version'] in a recipe
Changed
- Convert to InSpec tests and refactor test cookbook recipes
- Don't install abi_version packages on Debian/Ubuntu
- Standardise files with files in sous-chefs/repo-management
- Move client package installation for cluster to cluster recipe
Removed
- Remove support for Amazon Linux
- Remove support for OpenSUSE
- Remove support for Debian 8 (EOL)
- Remove support for Fedora / Scientific
- Remove support for CentOS 6
- Remove references to EOL 5.5 release
Deprecated
- Deprecate monitoring recipe
- Use new inclusive terminology and add deprecation warning for old terms
0.17.2 - 2020-08-06
Fixed
- Fix debian_password as a string for testing
- Fix idempotency issues with find_password method
0.17.1 - 2020-05-14
- resolved cookstyle error: recipes/access_grants.rb:28:40 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: recipes/access_grants.rb:28:41 refactor:
ChefModernize/FoodcriticComments
- resolved cookstyle error: recipes/configure_server.rb:102:25 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: recipes/configure_server.rb:102:26 refactor:
ChefModernize/FoodcriticComments
- resolved cookstyle error: recipes/configure_server.rb:170:42 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: recipes/configure_server.rb:170:43 refactor:
ChefModernize/FoodcriticComments
- resolved cookstyle error: recipes/replication.rb:28:35 convention:
Layout/TrailingWhitespace
- resolved cookstyle error: recipes/replication.rb:28:36 refactor:
ChefModernize/FoodcriticComments
0.17.0 - 2020-05-05
- resolved cookstyle error: attributes/default.rb:8:16 warning:
Lint/SendWithMixinArgument
- resolved cookstyle error: libraries/passwords.rb:23:16 refactor:
ChefModernize/DatabagHelpers
- resolved cookstyle error: recipes/ssl.rb:17:9 refactor:
ChefModernize/DatabagHelpers
- Removed unused use_inline_resources and whyrun_supported? methods from the resources
- Removed unused long_description metadata from metadata.rb
- Simplify platform checks inn only_if checks
- Remove the unused .foodcritic file
- Update metadata to point to Sous Chefs
- Migrate to github actions for testing
[0.16.5]
- Use latest percona GPG keys for yum repo. See New Percona Package Signing Key Requires Update on RHEL and CentOS
0.16.1 - 2015-06-03
- Many changes
Collaborator Number Metric
1.0.0 passed this metric
Contributing File Metric
1.0.0 passed this metric
Foodcritic Metric
1.0.0 failed this metric
FC075: Cookbook uses node.save to save partial node data to the chef-server mid-run: percona/recipes/configure_server.rb:55
Run with Foodcritic Version 14.3.0 with tags metadata,correctness ~FC031 ~FC045 and failure tags any
No Binaries Metric
1.0.0 passed this metric
Testing File Metric
1.0.0 passed this metric
Version Tag Metric
1.0.0 passed this metric
1.0.0 passed this metric
1.0.0 passed this metric
Foodcritic Metric
1.0.0 failed this metric
FC075: Cookbook uses node.save to save partial node data to the chef-server mid-run: percona/recipes/configure_server.rb:55
Run with Foodcritic Version 14.3.0 with tags metadata,correctness ~FC031 ~FC045 and failure tags any
No Binaries Metric
1.0.0 passed this metric
Testing File Metric
1.0.0 passed this metric
Version Tag Metric
1.0.0 passed this metric
1.0.0 failed this metric
Run with Foodcritic Version 14.3.0 with tags metadata,correctness ~FC031 ~FC045 and failure tags any
1.0.0 passed this metric
Testing File Metric
1.0.0 passed this metric
Version Tag Metric
1.0.0 passed this metric
1.0.0 passed this metric
1.0.0 passed this metric