Percona (MySQL) Blueprint¶

Fabric environment:

blueprints:
  - blues.percona

settings:
  percona:
    schemas:
      some_schema_name:    # The schema name
        user: foo          # Username to connect to schema
        password: bar      # Password to connect to schema
        host: 11.22.33.%s  # Allowed host mask to connect from (Default: 127.0.0.1)
    # bind: 0.0.0.0        # Set the bind address specifically (Default: 127.0.0.1)

client_exec(cmd, **kwargs)¶

configure¶: Configure Percona

dump¶

Dump and download a schema.

Parameters:	schema – Specific shema to dump and download. ignore_tables – Tables to skip, separated by \| (pipe)

generate_password(length=8)¶

grant(schema, user, password, privs='ALL', host='localhost')¶

install()¶

mysqltuner¶: Run mysqltuner

setup¶: Install, configure percona server and create schemas

setup_schemas¶

Create database schemas and grant user permissions

Parameters:	drop – Drop existing schemas before creation