puppetlabs-mysql | MySQL Puppet Module / Manifests + Types & Providers | Configuration Management library
kandi X-RAY | puppetlabs-mysql Summary
kandi X-RAY | puppetlabs-mysql Summary
The mysql module installs, configures, and manages the MySQL service. This module manages both the installation and configuration of MySQL, as well as extending Puppet to allow management of MySQL resources, such as databases, users, and grants.
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of puppetlabs-mysql
puppetlabs-mysql Key Features
puppetlabs-mysql Examples and Code Snippets
Community Discussions
Trending Discussions on puppetlabs-mysql
QUESTION
I have been over several threads for issues related to puppetlabs-mysql module in last few hours to get a workaround on my issue.
MySQL installation on my agent node with this module is enabling the root user login without any password. But I see the credentials has been set for the root user, and can login using those credentials also.
What difference should I make in my manifest to disable MySQL password-less root login?
Manifest applied,
...ANSWER
Answered 2017-Feb-15 at 14:49What you are referring to as passwordless login is most probably .my.cnf saving the password in an optionfile.
So by setting $mysql::server::create_root_my_cnf to false you would disable this.
QUESTION
I'm create puppet configuration structure
...ANSWER
Answered 2017-Mar-13 at 06:51Puppetfiles are not interpreted or read by the puppet server or client code. They're there to help other tools effectively deploy the proper puppet modules.
In your case in order to take advantage of the Puppetfile you've written you would need to install and configure r10k. HERE are the basics from the Puppet Enterprise documentation. HERE is another great resource, the r10k GitHub page.
Once installed and configured, r10k
will read your Puppetfile and download+install the defined entries. In your case, it would install version 3.10.0
of puppetlabs-mysql
. This would be installed into your modules
directory and then you can execute the puppet agent run and take advantage of the newly installed modules.
In summary, Puppetfiles are not used by the client, they're used by code deployment software (r10k) to download and build the proper modules for the puppet server or agent to consume. Your options are to configure r10k to provision the modules as defined in the Puppetfile, or download the modules manually and eliminate the need for the Puppetfile.
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install puppetlabs-mysql
In this example, we'll use the latest stable (currently 10.3) from the official MariaDB repository, not the one from the distro repository. You could instead use the package from the Ubuntu repository. Make sure you use the repository corresponding to the version you want. Note: sfo1.mirrors.digitalocean.com is one of many mirrors available. You can use any official mirror. This example shows MariaDB server installation on Ubuntu Xenial. Adjust the version and the parameters of my.cnf as needed. All parameters of the my.cnf can be defined using the override_options parameter. The folders /var/log/mysql and /var/run/mysqld are created automatically, but if you are using other custom folders, they should exist as prerequisites for this code. All the values set here are an example of a working minimal configuration. Specify the version of the package you want with the package_ensure parameter. This example shows how to install the MariaDB client and all of the bindings at once. You can do this installation separately from the server installation. Specify the version of the package you want with the package_ensure parameter.
You can install MySQL Community Server on CentOS using the mysql module and Hiera. This example was tested with the following versions:.
MySQL Community Server 5.6
Centos 7.3
Puppet 3.8.7 using Hiera
puppetlabs-mysql module v3.9.0
Plugins can be installed by using the mysql_plugin defined type. See examples/mysql_plugin.pp for futher examples.
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page