.. -*- mode: rst -*-

my.cnf
======

The following template generates a ``server-id`` based on the last two
numeric parts of the IP address. The "slave" portion of the configuration
only applies to machines in the "slave" group::

    {% python
    import socket
    parts = socket.gethostbyname(metadata.hostname).split('.')
    server_id = parts[2] + parts[3]
    %}\
    [mysqld]

    # [snip]

    server-id = ${server_id}

    # Replication configuration

    {% if "slave" in metadata.groups %}\
    relay-log = /data01/mysql/log/mysql-relay-bin
    log-slave-updates = 1
    {% end %}\
    sync-binlog = 1
    #read-only = 1
    #report-host = <server fqdn>

    # [snip]