anchor.diff:  table_open_cache                = <%= p('cf_mysql.mysql.table_open_cache') %>
   
   max_allowed_packet              = <%= p('cf_mysql.mysql.max_allowed_packet') %>
  -<% if_p('cf_mysql.mysql.skip_name_resolve') do |disable_dns| -%>
  +<% if_p('cf_mysql.mysql.skip_name_resolve') do |disable_dns| %>
   <%= "skip_name_resolve" if disable_dns %>
  -<% end -%>
  +<% end %>
   enforce_storage_engine          = InnoDB
   sql-mode                        = NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,STRICT_ALL_TABLES
   
  -<% if p('cf_mysql.mysql.enable_local_file') -%>
  +<% if p('cf_mysql.mysql.enable_local_file') %>
   local_infile                    = ON
  -<% else -%>
  +<% else %>
   local_infile                    = OFF
  -<% end -%>
  -<% if p('cf_mysql.mysql.binlog_enabled') -%>
  +<% end %>
  +<% if p('cf_mysql.mysql.binlog_enabled') %>
   log_bin                         = mysql-bin
   log_slave_updates               = 1
   expire_logs_days                = <%= p('cf_mysql.mysql.binlog_expire_days') %>
  -<% end -%>
  +<% end %>
   
   # Required for user to create triggers when binlog is enabled
   log_bin_trust_function_creators = 1
  
positive.code: server_audit_file_path          = /var/vcap/store/mysql_audit_logs/mysql_server_audit.log
  server_audit_excl_users         = <%= excluded_audit_users.join(',') %>
  server_audit_file_rotations     = 0
  <% end -%>
  
  # These are mandatory MySQL settings for MariaDB Galera to work
  binlog_format                   = ROW
  
negative.code:         raise "Only innodb-flush-method=O_DIRECT or unset is supported!"
      end
    end
  %>
  
  [client]
  port                            = <%= p('cf_mysql.mysql.port') %>
  