galera.j2 914 B

123456789101112131415161718192021222324252627282930313233
  1. #
  2. # These groups are read by MariaDB server.
  3. # Use it for options that only the server (but not clients) should see
  4. # this is read by the standalone daemon and embedded servers
  5. [server]
  6. [mysqld]
  7. bind-address = {{ mariadb_bind_address }}
  8. port = {{ mariadb_port }}
  9. {% if mariadb_slow_query_log_enabled == true %}
  10. slow_query_log = 1
  11. long_query_time = {{ mariadb_slow_query_time }}
  12. {% endif %}
  13. default-storage-engine = innodb
  14. # Galera-related settings
  15. [galera]
  16. wsrep_provider = {{ galera_wsrep_provider }}
  17. wsrep_cluster_address = "gcomm://{% for host in groups['galera_cluster'] %}{{ hostvars[host]['ansible_default_ipv4']['address'] }},{% endfor %}"
  18. wsrep_node_name = {{ ansible_hostname }}
  19. wsrep_cluster_name = {{ galera_cluster_name }}
  20. wsrep_node_address = {{ ansible_default_ipv4.address }}
  21. binlog_format = row
  22. default_storage_engine = InnoDB
  23. innodb_autoinc_lock_mode = 2
  24. wsrep_on = ON
  25. [embedded]
  26. [mariadb]