# # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) should see # # See the examples of server my.cnf files in /usr/share/mysql/ # [mysqld_multi] mysqld = /usr/bin/mysqld_safe mysqladmin = /usr/bin/mysqladmin [mysqld1] user = mysql pid-file = /var/lib/mysql/mysql.pid socket = /var/lib/mysql/mysql.sock port=3306 datadir=/var/lib/mysql server_id=1 #log-bin=mysql-bin skip-log-bin binlog_format=mixed lower_case_table_names=1 [mysqld2] user = mysql pid-file = /var/lib/mysql/mysql2.pid socket = /var/lib/mysql/mysql2.sock port=3307 datadir=/var/lib/mysql2 server_id=2 skip-log-bin lower_case_table_names=1 [mysqldump] quick max_allowed_packet = 16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [myisamchk] key_buffer_size = 20M sort_buffer_size = 20M read_buffer = 2M write_buffer = 2M [mysqlhotcopy] interactive-timeout