Resource Type: proxy_mysql_user

Defined in:

lib/puppet/type/proxy_mysql_user.rb

Providers:

proxysql

Overview

Manage a ProxySQL mysql_user. This includes management of users password as well as privileges.

Properties

• active

  Is the user active or not.

  Supported values:

  • %r{[01]}
• backend (defaults to: 1)

  Backend or not.

  Supported values:

  • %r{[01]}
• default_hostgroup

  Default hostgroup for the user.

  Supported values:

  • %r{\d+}
• default_schema

  Default schema for the user.

  Supported values:

  • %r{\w+}
• ensure (defaults to: present)

  The basic property that the resource should be in.

  Supported values:

  • present
  • absent
• fast_forward

  Use fast forwrd or not.

  Supported values:

  • %r{[01]}
• frontend (defaults to: 1)

  Frontend or not.

  Supported values:

  • %r{[01]}
• max_connections

  Max concurrent connections for the user.

  Supported values:

  • %r{\d+}
• password

  The password of the user. You can use mysql_password() for creating a hashed password.

  Supported values:

  • %r{\w*}
• schema_locked

  Is the user locked in the default schema or not.

  Supported values:

  • %r{[01]}
• transaction_persistent

  Disable routing across hostgroups once a transaction has started for a specific user.

  Supported values:

  • %r{[01]}
• use_ssl

  Use ssl or not.

  Supported values:

  • %r{[01]}

Parameters

• encrypt_password (defaults to: true)

  Encrypt the users password (requires ProxySQL setting ‘admin-hash_password` = `true`)

  Supported values:

  • true
  • false
• load_to_runtime (defaults to: true)

  Load this entry to the active runtime.

  Supported values:

  • true
  • false
• name (namevar)

  The name of the user to manage.

• provider

  The specific backend to use for this ‘proxy_mysql_user` resource. You will seldom need to specify this — Puppet will usually discover the appropriate provider for your platform.

• save_to_disk (defaults to: true)

  Perist this entry to the disk.

  Supported values:

  • true
  • false