mysql配置+使用(不定時更新)

標籤：

1.my.cnf配置

添加：

[client]

default-character-set = utf8user = root　

[mysqld]

binlog_format=ROWbind-address=0.0.0.0default_storage_engine=InnoDBinnodb_autoinc_lock_mode=2innodb_flush_log_at_trx_commit=0innodb_buffer_pool_size=122Minnodb_locks_unsafe_for_binlog=1wsrep_provider=/usr/lib/libgalera_smm.sowsrep_cluster_address=gcomm://192.168.189.24,192.168.189.25,192.168.189.30wsrep_cluster_name=Yuqing_DB_Clusterwsrep_node_address=192.168.189.24wsrep_node_name=Yuqing_DB_Node001wsrep_sst_method=rsyncwsrep_slave_threads=4explicit_defaults_for_timestamp=1default-time-zone = ‘+8:00‘

注釋：

bind-address=127.0.0.0

　　

mysql配置+使用(不定時更新)