cookbook 'mw_mysql', '= 0.1.2'
mw_mysql (4) Versions 0.1.2 Follow3
Installs/Configures mw_mysql
cookbook 'mw_mysql', '= 0.1.2', :supermarket
knife supermarket install mw_mysql
knife supermarket download mw_mysql
Personalized mysql server cookbook
The mw_mysql
cookbook provides recipes for installing mysql server as a
standalone instance, or acting as master or slave instance. Another feature
provided is the fact that integrates with mysql_tuning
cookbook.
Requirements
- Chef 12+
Platform support
The following platforms have been tested with test kitchen
- Debian 7.8
- Debian 8.2
- Ubuntu 14.04
- Centos 6.7
- Centos 7.2
Cookbook dependencies
- mysql
- mysql_tuning
- chef-sugar
Other cookbooks may be required depending on the platform used:
- apt/yum so packages are updated if ubuntu/debian/centos/rhel
Usage
Place a dependency on the mw_application cookbook in your cookbook's metadata.rb
depends 'mw_mysql', '~> 0.1.0'
Then, in a recipe you can use provided recipes or helper functions
Attributes
-
default['mw_mysql']['enable_tmpdir']
: enable tmpdir for mysql temporay dir. It will mount a ram disk to speed up mysql file operations. It will not enabled by default -
default['mw_mysql']['tmpdir']
: directory to mount temporary RAM disk -
default['mw_mysql']['tmpdir_size']
: RAM disk size -
default['mw_mysql']['charset']
: default server charset -
default['mw_mysql']['collation']
: default server collation. -
default['mw_mysql']['max_connections']
: number of max connections allows. If nil, it will be calculated by mysql_tuning cookbook based on hardware specs -
default['mw_mysql']['expire_logs_days']
: number of binary logs to be kept
Recipes
Recipes provided are only provided as examples so, not use them in prduction.
Mysql server installed will used default password
mw_mysql::client
Installs mysql client command line
mw_mysql::default
Installs a mysql server with root password set as change me
Helpers
mw_mysql_server
This helper receives two arguments:
- Mysql instance name
- Hash with options where:
- root_password: is the root password
- port: specifies mysql instance tcp port. Defaults to 3306
Example usage
mw_mysql_server('main', root_password: 'some_password', port: 3307) mw_mysql_server('other', root_password: 'some_password', port: 3308)
Will install two mysql instances: one named main which listens on port
3307 and other which listens on port 3308
mw_mysql_master_server
This helper receives only a hash with options, where the same options specified
for mw_mysql_server
helper are supported, but other ones are available:
-
replication_password
: password used for the replication user -
server_id
: id of the mysql instance
Example usage
mw_mysql_master_server root_password: 'master', port: 3306, replication_password: 'replication'
mw_mysql_slave_server
This helper receives only a hash with options, where the same options specified
for mw_mysql_server
helper are supported, but other ones are available:
-
replication_password
: password used for the replication user -
server_id
: id of the mysql instance -
master_host
: ip address of mysql master server. Required -
master_port
: port of mysql master server
Example usage
mw_mysql_slave_server root_password: 'slave', port: 3307, replication_password: 'replication', master_host: '127.0.0.1'
Kitchen testing
Travis will use default .kitchen based on Docker driver.
If you prefer to test recipe for all platforms, run:
KITCHEN_LOCAL_YAML=.kitchen_vagrant.yml
Dependent cookbooks
mysql ~> 6.1.0 |
mysql_tuning ~> 0.4.0 |
chef-sugar >= 0.0.0 |
Contingent cookbooks
There are no cookbooks that are contingent upon this one.
Foodcritic Metric
0.1.2 passed this metric
0.1.2 passed this metric