ansible-role-percona-mysql

This role installs Percona Server for MySQL.

Requirements

Ansible 2.10 or newer.

Supported Platforms

• Debian - 11 (Bullseye)
• Debian - 12 (Bookworm)
• Ubuntu - 22.04 (Jammy Jellyfish)

Role Variables

Variable	Required	Default	Choices	Comments
mysql_package_version	true		string	See defaults/main.yml.
mysql_packages	true		list	See defaults/main.yml.
mysql_extra_packages	true		list	See defaults/main.yml.
mysql_packages_state	true	present	string
mysql_pip_packages	true		list	See defaults/main.yml.
mysql_user	true	mysql	string
mysql_group	true	mysql	string
mysql_installdir	true	/usr/sbin	string
mysql_datadir	true	/var/lib/mysql	string
mysql_tmpdir	true	/tmp/mysql	string
mysql_logdir	true	/var/log/mysql	string
mysql_plugindir	true	/usr/lib/mysql/plugin	string
mysql_keyringdir	true	/var/lib/mysql-keyring	string
mysql_sql_mode	true	''	string
mysql_charset	true	utf8mb4	string
mysql_collation	true	utf8mb4_general_ci	string
mysql_performance_schema	true	1	int
mysql_default_authentication_plugin	true	caching_sha2_password	string
mysql_authentication_policy	true	*,,	string
mysql_root_user	true	root	string
mysql_root_authentication_plugin	true		string	See defaults/main.yml.
mysql_root_password	true	root	string
mysql_root_salt	true	1234567890abcdefghij	string
mysql_root_privileges	true	*.*:ALL,GRANT	string
mysql_server_id	true	1	int
mysql_replication_role	true	''	string	master, slave or ''
mysql_replication_master_host	true	''	string
mysql_replication_master_user	true	repl	string
mysql_replication_master_password	true	repl	string
mysql_replication_options	true	{}	dict
mysql_relay_log_recovery	true	0	int
mysql_binlog_do_db	true	[]	list
mysql_binlog_expire_logs_seconds	true	2592000	int	Default to 30 days.
mysql_enable_bin_logs	true	true	boolean
mysql_databases	true	[]	list	Databases to create.
mysql_remove_databases	true	[]	list	Databases to remove.
mysql_users	true	[]	list	Users to create.
mysql_remove_users	true	[]	list	Users to remove.
mysql_innodb_buffer_pool_size	true	128M	string
mysql_innodb_flush_log_at_trx_commit	true	1	int
mysql_innodb_flush_method	true	O_DIRECT	string
mysql_innodb_io_capacity	true	200	int
mysql_innodb_print_all_deadlocks	true	0	int
mysql_innodb_read_io_threads	true	4	int
mysql_innodb_write_io_threads	true	4	int
mysql_max_allowed_packet	true	64M	string
mysql_max_connections	true	151	int
mysql_open_files_limit	true	5000	int
mysql_table_open_cache	true	4000	int
mysql_log_queries_not_using_indexes	true	0	int
mysql_long_query_time	true	10	int
mysql_slow_query_log	true	OFF	string
mysql_slow_query_log_file	true		string	See defaults/main.yml.
mysql_log_output	true	FILE	string
mysql_log_error	true		string	See defaults/main.yml.
mysql_log_error_suppression_list	true	[]	list
mysql_log_slow_admin_statements	true	OFF	string
mysql_log_slow_replica_statements	true	OFF	string
mysql_log_slow_rate_type	true	session	string
mysql_log_slow_rate_limit	true	1	int
mysql_slow_query_log_always_write_time	true	10	int
mysql_log_slow_verbosity	true	''	string
mysql_slow_query_log_use_global_control	true	''	string
mysql_tls_version	true	''	string
mysql_x_plugin	true	ON	string
mysql_systemd_override	true	{}	dict
mysql_load_tz_tables	true	false	boolean

Dependencies

• percona-release role

Example Playbook

- hosts: all
  roles:
    - role: ansible-role-percona-mysql

Testing

molecule test

License

MIT

Author Information

@boutetnico