App::Sqitch::Engine::mysql(3pm)

Usage

  my $mysql = App::Sqitch::Engine->load( engine => 'mysql' );

Overview

App::Sqitch::Engine::mysql provides the MySQL storage engine for Sqitch. It supports MySQL 5.1.0 and higher (best on 5.6.4 and higher), as well as MariaDB 5.3.0 and higher.

Interface

Instance Methods

"mysql"

Returns a list containing the "mysql" client and options to be passed to it. Used internally when executing scripts. Query parameters in the URI that map to "mysql" client options will be passed to the client, as follows:

`•`	`"mysql_compression=1"`: `"--compress"`
`•`	`"mysql_ssl=1"`: `"--ssl"`
`•`	`"mysql_connect_timeout"`: `"--connect_timeout"`
`•`	`"mysql_init_command"`: `"--init-command"`
`•`	`"mysql_socket"`: `"--socket"`
`•`	`"mysql_ssl_client_key"`: `"--ssl-key"`
`•`	`"mysql_ssl_client_cert"`: `"--ssl-cert"`
`•`	`"mysql_ssl_ca_file"`: `"--ssl-ca"`
`•`	`"mysql_ssl_ca_path"`: `"--ssl-capath"`
`•`	`"mysql_ssl_cipher"`: `"--ssl-cipher"`

"username"

"password"

Overrides the methods provided by the target so that, if the target has no username or password, Sqitch looks them up in the /etc/my.cnf and ~/.my.cnf files <https://dev.mysql.com/doc/refman/5.7/en/password-security-user.html>. These files must limit access only to the current user (0600). Sqitch will look for a username and password under the "[client]" and "[mysql]" sections, in that order.

Releases

6 releases since Debian 8 (Jessie); the text changed 5 times.

8
9
10
11
12
13