MySQL Forums
Forum List  »  Replication

my.cnf
Posted by: Christian Huck
Date: July 11, 2016 10:33AM

our my.cnf:

[mysqld]
datadir = /var/lib/mysql/live
log-error = /var/log/mysql/mysql.live.log
slow_query_log=1
slow_query_log_file=/var/log/mysql/mysql.live.slow.log
pid-file = /var/run/mysqld/mysql.live.pid
bind-address = 0.0.0.0
port = 3306
socket = /var/lib/mysql/mysql.live.sock
character-set-server = utf8
collation-server = utf8_general_ci
max_connections = 151
symbolic-links = 0
user = mysql
max_allowed_packet = 32M

# replication enabled
server-id = 2
binlog-ignore-db = mysql
replicate-ignore-db = mysql
enforce-gtid-consistency = true
gtid-mode = on
log-bin = /var/log/mysql/binlogs_live/mysql-bin
max_binlog_size = 500M
expire_logs_days = 10
relay-log = /var/log/mysql/relaylogs_live/mysql-relay
max_relay_log_size=500M

[mysqld_safe]
nice = 0

[client]
port = 3306
socket = /var/lib/mysql/mysql.live.sock

[mysqldump]
max_allowed_packet = 16M
quick
quote-names

Options: ReplyQuote


Subject
Views
Written By
Posted
1932
July 11, 2016 10:22AM
my.cnf
989
July 11, 2016 10:33AM
752
July 11, 2016 10:35AM
719
August 04, 2016 07:56AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.