sampledoc

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]

Previous topic

motd

Next topic

test

This Page