Managing MySQL

MySQL is a very widely used database server, and it's fairly certain you'll need to install and configure a MySQL server at some point. The puppetlabs-mysql module can simplify your MySQL deployments.

How to do it...

Follow these steps to create the example:

1. Install the puppetlabs-mysql module:

   t@mylaptop ~/puppet $ puppet module install -i modules puppetlabs-mysql
   Notice: Preparing to install into /home/thomas/puppet/modules ...
   Notice: Downloading from https://forgeapi.puppetlabs.com ...
   Notice: Installing -- do not interrupt ...
   /home/thomas/puppet/modules
   └─┬ puppetlabs-mysql (v2.3.1)
     └── puppetlabs-stdlib (v4.3.2)
   

2. Create a new node definition for your MySQL server:

   node dbserver {
     class { '::mysql::server':
       root_password    => 'PacktPub',
       override_options => { 
         'mysqld' => { 'max_connections' => '1024' } 
       }
     }
   }

3. Run Puppet to install the database server and apply the new root password:

   [root@dbserver ~]# puppet agent -t
   Info: Caching catalog...