cookbook 'mysql', '= 5.2.2'
mysql
(182) Versions
5.2.2
-
-
11.1.6
-
11.1.5
-
11.1.4
-
11.1.3
-
11.1.2
-
11.1.1
-
11.1.0
-
11.0.15
-
11.0.14
-
11.0.13
-
11.0.12
-
11.0.11
-
11.0.10
-
11.0.9
-
11.0.8
-
11.0.7
-
11.0.6
-
11.0.5
-
11.0.4
-
11.0.3
-
11.0.2
-
11.0.1
-
11.0.0
-
10.1.4
-
10.1.3
-
10.1.2
-
10.1.1
-
10.1.0
-
10.0.2
-
10.0.1
-
10.0.0
-
9.0.0
-
8.7.4
-
8.7.3
-
8.7.2
-
8.7.1
-
8.7.0
-
8.6.0
-
8.5.1
-
8.5.0
-
8.4.0
-
8.3.1
-
8.3.0
-
8.2.0
-
8.1.1
-
8.1.0
-
8.0.4
-
8.0.3
-
8.0.2
-
8.0.1
-
8.0.0
-
7.2.0
-
7.1.2
-
7.1.1
-
7.1.0
-
7.0.0
-
6.1.3
-
6.1.2
-
6.1.1
-
6.1.0
-
6.0.31
-
6.0.30
-
6.0.29
-
6.0.28
-
6.0.27
-
6.0.26
-
6.0.25
-
6.0.24
-
6.0.23
-
6.0.22
-
6.0.21
-
6.0.20
-
6.0.19
-
6.0.18
-
6.0.17
-
6.0.16
-
6.0.15
-
6.0.14
-
6.0.13
-
6.0.12
-
6.0.11
-
6.0.10
-
6.0.9
-
6.0.8
-
6.0.7
-
6.0.6
-
6.0.5
-
6.0.4
-
6.0.3
-
6.0.2
-
6.0.1
-
6.0.0
-
5.6.3
-
5.6.2
-
5.6.1
-
5.6.0
-
5.5.4
-
5.5.3
-
5.5.2
-
5.5.1
-
5.5.0
-
5.4.4
-
5.4.3
-
5.4.2
-
5.4.1
-
5.4.0
-
5.3.6
-
5.3.4
-
5.3.2
-
5.3.0
-
5.2.12
-
5.2.10
-
5.2.8
-
5.2.6
-
5.2.4
-
5.2.2
-
5.2.0
-
5.1.12
-
5.1.10
-
5.1.8
-
5.1.6
-
5.1.4
-
5.1.2
-
5.1.0
-
5.0.6
-
5.0.4
-
5.0.2
-
5.0.0
-
4.1.2
-
4.1.1
-
4.1.0
-
4.0.20
-
4.0.18
-
4.0.14
-
4.0.12
-
4.0.10
-
4.0.8
-
4.0.6
-
4.0.4
-
4.0.2
-
4.0.0
-
3.0.12
-
3.0.10
-
3.0.8
-
3.0.6
-
3.0.4
-
3.0.2
-
3.0.0
-
2.1.2
-
2.1.0
-
2.0.2
-
2.0.0
-
1.3.0
-
1.2.6
-
1.2.4
-
1.2.2
-
1.2.1
-
1.0.8
-
1.0.7
-
1.0.6
-
1.0.5
-
1.0.4
-
1.0.3
-
1.0.2
-
1.0.1
-
1.0.0
-
0.24.4
-
0.24.3
-
0.24.2
-
0.24.1
-
0.24.0
-
0.23.1
-
0.23.0
-
0.22.0
-
0.21.5
-
0.21.3
-
0.21.2
-
0.21.1
-
0.21.0
-
0.20.0
-
0.15.0
-
0.10.0
Follow782
- 11.1.6
- 11.1.5
- 11.1.4
- 11.1.3
- 11.1.2
- 11.1.1
- 11.1.0
- 11.0.15
- 11.0.14
- 11.0.13
- 11.0.12
- 11.0.11
- 11.0.10
- 11.0.9
- 11.0.8
- 11.0.7
- 11.0.6
- 11.0.5
- 11.0.4
- 11.0.3
- 11.0.2
- 11.0.1
- 11.0.0
- 10.1.4
- 10.1.3
- 10.1.2
- 10.1.1
- 10.1.0
- 10.0.2
- 10.0.1
- 10.0.0
- 9.0.0
- 8.7.4
- 8.7.3
- 8.7.2
- 8.7.1
- 8.7.0
- 8.6.0
- 8.5.1
- 8.5.0
- 8.4.0
- 8.3.1
- 8.3.0
- 8.2.0
- 8.1.1
- 8.1.0
- 8.0.4
- 8.0.3
- 8.0.2
- 8.0.1
- 8.0.0
- 7.2.0
- 7.1.2
- 7.1.1
- 7.1.0
- 7.0.0
- 6.1.3
- 6.1.2
- 6.1.1
- 6.1.0
- 6.0.31
- 6.0.30
- 6.0.29
- 6.0.28
- 6.0.27
- 6.0.26
- 6.0.25
- 6.0.24
- 6.0.23
- 6.0.22
- 6.0.21
- 6.0.20
- 6.0.19
- 6.0.18
- 6.0.17
- 6.0.16
- 6.0.15
- 6.0.14
- 6.0.13
- 6.0.12
- 6.0.11
- 6.0.10
- 6.0.9
- 6.0.8
- 6.0.7
- 6.0.6
- 6.0.5
- 6.0.4
- 6.0.3
- 6.0.2
- 6.0.1
- 6.0.0
- 5.6.3
- 5.6.2
- 5.6.1
- 5.6.0
- 5.5.4
- 5.5.3
- 5.5.2
- 5.5.1
- 5.5.0
- 5.4.4
- 5.4.3
- 5.4.2
- 5.4.1
- 5.4.0
- 5.3.6
- 5.3.4
- 5.3.2
- 5.3.0
- 5.2.12
- 5.2.10
- 5.2.8
- 5.2.6
- 5.2.4
- 5.2.2
- 5.2.0
- 5.1.12
- 5.1.10
- 5.1.8
- 5.1.6
- 5.1.4
- 5.1.2
- 5.1.0
- 5.0.6
- 5.0.4
- 5.0.2
- 5.0.0
- 4.1.2
- 4.1.1
- 4.1.0
- 4.0.20
- 4.0.18
- 4.0.14
- 4.0.12
- 4.0.10
- 4.0.8
- 4.0.6
- 4.0.4
- 4.0.2
- 4.0.0
- 3.0.12
- 3.0.10
- 3.0.8
- 3.0.6
- 3.0.4
- 3.0.2
- 3.0.0
- 2.1.2
- 2.1.0
- 2.0.2
- 2.0.0
- 1.3.0
- 1.2.6
- 1.2.4
- 1.2.2
- 1.2.1
- 1.0.8
- 1.0.7
- 1.0.6
- 1.0.5
- 1.0.4
- 1.0.3
- 1.0.2
- 1.0.1
- 1.0.0
- 0.24.4
- 0.24.3
- 0.24.2
- 0.24.1
- 0.24.0
- 0.23.1
- 0.23.0
- 0.22.0
- 0.21.5
- 0.21.3
- 0.21.2
- 0.21.1
- 0.21.0
- 0.20.0
- 0.15.0
- 0.10.0
Provides mysql_service, mysql_config, and mysql_client resources
cookbook 'mysql', '= 5.2.2', :supermarket
knife supermarket install mysql
knife supermarket download mysql
MySQL cookbook
The MySQL cookbook exposes the mysql_service
and mysql_client
resources. These resources are utilized by the mysql::client
and mysql::server
recipes, or can be consumed in other recipes by
depending on the MySQL cookbook.
This cookbook does its best to follow platform native idioms at all
times. This means things like logs, pid files, sockets, and service
managers work "as expected" by an administrator familiar with a given
platform.
Scope
This cookbook is concerned with the "MySQL Community Server",
particularly those shipped with F/OSS Unix and Linux distributions. It
does not address forks and value-added repackaged MySQL distributions
like Drizzle, MariaDB, or Percona.
This cookbook does not try to encompass every single configuration
option available for MySQL. Instead, it provides a "just enough" to
get a MySQL server running, then allows the user to specify additional
custom configuration.
Requirements
- Chef 11 or higher
- Ruby 1.9 (preferably from the Chef full-stack installer)
Resources
The resources that ship in this cookbook are examples of 'singleton
resources'. This means that there can only be one instance of them
configured on a machine. The providers that handle the implementation
of the mysql_service
and mysql_client
resources do so by following
platform native idioms. These usually only allow for one instance of a
service to be running at a given time.
mysql_service
The mysql_service
resource configures the basic plumbing
needed to run a simple mysql_service with a minimal configuration.
Example
mysql_service 'default' do
version '5.1'
port '3307'
data_dir '/data'
template_source 'custom.erb'
allow_remote_root true
root_network_acl ['10.9.8.7/6, '1.2.3.4/5']
remove_anonymous_users false
remove_test_database false
server_root_password 'decrypt_me_from_a_databag_maybe'
server_repl_password 'sync_me_baby_one_more_time'
action :create
end
The version
parameter will allow the user to select from the
versions available for the platform, where applicable. When omitted,
it will install the default MySQL version for the target platform.
Available version numbers are 5.0
, 5.1
, 5.5
, and 5.6
,
depending on platform. See PLATFORMS.md for details.
The port
parameter determines the listen port for the mysqld
service. When omitted, it will default to '3306'.
The data_dir
parameter determines where the actual data files are
kept on the machine. This is useful when mounting external storage.
When omitted, it will default to the platform's native location.
The template_source
parameter allows the user to override the
default minimal template used by the mysql_service
resource. When
omitted, it will select one shipped with the cookbook based on the
MySQL version.
The allow_remote_root
parameter allows the user to specify whether
remote connections from the mysql root user. When set to true, it is
recommended that it be used in combination with the root_network_acl
parameter. When omitted, it will default to false.
The remove_anonymous_users
parameter allows the user to remove
anonymous users often installed by default with during the mysql db
initialization. When omitted, it defaults to true.
The remove_test_database
parameter allows the user to specify
whether or not the test database is removed. When omitted, it defaults
to true.
The root_network_acl
parameter allows the user to specify a list of
subnets to accept connections for the root user from. When omitted, it
defaults to none.
The server_root_password
parameter allows the user to specify the
root password for the mysql database. This can be set explicitly in a
recipe, driven from a node attribute, or from data_bags. When omitted,
it defaults to ilikerandompasswords
. Please be sure to change it.
The server_debian_password
parameter allows the user to specify the
debian-sys-maint users password, used in log rotations and service
management on Debian and Debian derived platforms.
The server_repl_password
parameter allows the user to specify the
password used by 'repl'@'%'
, used in clustering scenarios. When
omitted, it does create the repl user or set a password.
The mysql_service resource supports :create, :restart, and :reload actions.
mysql_client
The mysql_client
resource installs or removes the MySQL client binaries and
development libraries
Recipes
mysql::server
This recipe calls a mysql_service
resource, passing parameters
from node attributes.
mysql::client
This recipe calls a mysql_client
resource, with action :create
Usage
The mysql::server
recipe and mysql_service
resources are designed to
provide a minimal configuration. The default my.cnf
dropped off has
an !includedir
directive. Site-specific configuration should be
placed in the platform's native location.
run_list
Include 'recipe[mysql::server]'
or 'recipe[mysql::client]'
in your run_list.
Wrapper cookbook
node.set['mysql']['server_root_password'] = 'yolo'
node.set['mysql']['port'] = '3308'
node.set['mysql']['data_dir'] = '/data'
include_recipe 'mysql::server'
template '/etc/mysql/conf.d/mysite.cnf' do
owner 'mysql'
owner 'mysql'
source 'mysite.cnf.erb'
notifies :restart, 'mysql_service[default]'
end
Used directly in a recipe
template '/etc/mysql/conf.d/mysite.cnf' do
owner 'mysql'
owner 'mysql'
source 'mysite.cnf.erb'
notifies :restart, 'mysql_service[default]'
end
mysql_service 'default' do
version '5.5'
port '3307'
data_dir '/data'
template_source 'custom.erb'
action :create
end
Attributes
default['mysql']['service_name'] = 'default'
default['mysql']['server_root_password'] = 'ilikerandompasswords'
default['mysql']['server_debian_password'] = 'postinstallscriptsarestupid'
default['mysql']['data_dir'] = '/var/lib/mysql'
default['mysql']['port'] = '3306'
### used in grants.sql
default['mysql']['allow_remote_root'] = false
default['mysql']['remove_anonymous_users'] = true
default['mysql']['root_network_acl'] = nil
License & Authors
- Author:: Joshua Timberman (joshua@opscode.com)
- Author:: AJ Christensen (aj@opscode.com)
- Author:: Seth Chisamore (schisamo@opscode.com)
- Author:: Brian Bianco (brian.bianco@gmail.com)
- Author:: Jesse Howarth (him@jessehowarth.com)
- Author:: Andrew Crump (andrew@kotirisoftware.com)
- Author:: Christoph Hartmann (chris@lollyrock.com)
- Author:: Sean OMeara (someara@opscode.com)
Copyright:: 2009-2014 Chef Software, Inc Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at http://www.apache.org/licenses/LICENSE-2.0 Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.
Dependent cookbooks
This cookbook has no specified dependencies.