本地数据库mysql配置文件_本地集群配置文件
本地数据库mysql配置文件用于设置单个mysql实例的参数，而本地集群配置文件则用于配置多个mysql实例之间的通信和负载均衡。
本地数据库mysql配置文件：
1、基本配置
[mysqld]
# 设置mysql服务器的基本设置
basedir = /usr/local/mysql
datadir = /var/lib/mysql
port = 3306
tmpdir = /tmp
# 设置字符集编码
charactersetserver = utf8mb4
collationserver = utf8mb4_unicode_ci
2、日志配置
[mysqld]
# 设置错误日志文件路径和级别
logerror = /var/log/mysql/error.log
logerrorverbosity = 2
# 设置慢查询日志文件路径和级别
slow_query_log = 1
slow_query_log_file = /var/log/mysql/slow.log
long_query_time = 2
3、innodb配置
[mysqld]
# 设置innodb缓冲池大小
innodb_buffer_pool_size = 1g
# 设置innodb日志文件路径和级别
innodb_log_file_size = 512m
innodb_log_buffer_size = 64m
innodb_flush_log_at_trx_commit = 1
innodb_lock_wait_timeout = 50
本地集群配置文件：
1、主节点配置
[mysqld]
# 设置主节点唯一标识符，用于区分其他从节点
serverid = 1
# 设置主节点二进制日志文件路径和保留时间
logbin = /var/log/mysql/binlog.log
binlogexpirelogsseconds = 7200
[mysqld]
# 设置主节点复制过滤规则，只允许特定ip或主机名的客户端连接
replicatedodb = mydb
replicateignoredb = testdb
replicatewildignoretable = mydb.%
replicatewildignoretable = %.testdb
replicatedotable = mydb.mytable
replicateignoretable = mydb.ignoretable
replicatedodb = mydb
replicateignoredb = testdb
replicatewildignoretable = mydb.%
replicatewildignoretable = %.testdb
replicatedotable = mydb.mytable
replicateignoretable = mydb.ignoretable
[mysqld]
# 设置主节点连接数限制和超时时间
max_connections = 1000
wait_timeout = 300
[mysqld]
# 设置主节点备份策略和备份位置
backupmethod = binary
backupdirectory = /var/backup/mysql/master/binlogs/daily/$(date %y%m%d)
[mysqld]
# 设置主节点自动提交事务间隔时间（秒）和事务日志刷新间隔时间（秒）
autocommit = 1000000000000000000000000000000000000000000000000000000000000000
expire_logs_days = 729654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321345678976543213456789765432134567897654321= #问题与解答：q: 如何修改mysql的主节点id？a: 在主节点的mysql配置文件中，找到[mysqld]部分，将serverid设置为一个唯一的标识符即可，serverid=1，q: 如何设置mysql的备份策略和备份位置？a: 在主节点的mysql配置文件中，找到[mysqld]部分，根据需要修改backupmethod和backupdirectory参数，backupmethod=binary，backupdirectory=/var/backup/mysql/master/binlogs/daily/$(date %y%m%d)。