apiVersion: v1
kind: ConfigMap
metadata:
  name: mysql-master
data:
  my.cnf: |-
    [client]
    port		                = 3306
    socket		              = /var/run/mysqld/mysqld.sock

    [mysqld_safe]
    socket		              = /var/run/mysqld/mysqld.sock
    nice		                = 0

    [mysqld]
    server-id               = 1
    log_bin                 = /var/log/mysql/mysql-bin.log
    skip-host-cache
    skip-name-resolve
    pid-file	              = /var/run/mysqld/mysqld.pid
    socket		              = /var/run/mysqld/mysqld.sock
    port		                = 3306
    basedir		              = /usr
    datadir		              = /var/lib/mysql
    tmpdir		              = /tmp
    lc_messages_dir	        = /usr/share/mysql
    lc_messages	            = en_US
    skip-external-locking
    max_connections		      = 100
    connect_timeout		      = 5
    wait_timeout		        = 600
    max_allowed_packet	    = 32M
    thread_cache_size       = 128
    sort_buffer_size	      = 4M
    bulk_insert_buffer_size	= 16M
    tmp_table_size		      = 32M
    max_heap_table_size	    = 32M
    myisam_recover          = BACKUP
    key_buffer_size		      = 128M
    table_open_cache	      = 400
    myisam_sort_buffer_size	= 512M
    concurrent_insert	      = 2
    read_buffer_size	      = 2M
    read_rnd_buffer_size	  = 1M
    query_cache_limit		    = 128K
    query_cache_size		    = 64M
    slow_query_log_file	    = /var/log/mysql/mariadb-slow.log
    long_query_time         = 10
    expire_logs_days	      = 10
    max_binlog_size         = 100M
    sql_mode                = STRICT_ALL_TABLES
    default_storage_engine	= InnoDB
    innodb_buffer_pool_size	= 256M
    innodb_log_buffer_size	= 8M
    innodb_file_per_table 	= 1
    innodb_open_files	      = 400
    innodb_io_capacity	    = 400
    innodb_flush_method	    = O_DIRECT

    [mysqldump]
    quick
    quote-names
    max_allowed_packet	    = 16M

    [mysql]
    #no-auto-rehash	# faster start of mysql but no tab completition

    [isamchk]
    key_buffer		          = 16M

    !includedir /etc/mysql/conf.d/