搭建mysql主从错误集合

最新推荐文章于 2024-04-14 12:40:46 发布

一个java开发

最新推荐文章于 2024-04-14 12:40:46 发布

阅读量248

点赞数

文章标签： mysql 数据库

本文链接：https://blog.csdn.net/hebian1994/article/details/134481338

版权

文章讲述了如何解决MySQL中关于目录路径错误、字符集不匹配的问题，以及对binlog、replication配置的调整，包括server_id、binlog-do-db和replicate-ignore-db等关键设置。同时提到从库MySQL的内存占用情况。

摘要由CSDN通过智能技术生成

mysqld --verbose --help --log-bin-index=/tmp/tmp.Frnt2oibYI mysqld: Can't read dir of '/etc/mysql/conf.d/'

my.cnf是在/etc/mysql/conf.d/文件夹下，所以挂载的时候不要写/etc/mysql

COLLATION 'utf8_unicode_ci' is not valid for CHARACTER SET 'latin1'

配置文件改下字符集

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation-server=utf8_general_ci
character_set_server=utf8
skip-character-set-client-handshake
skip-name-resolve

server_id=1
log-bin=mysql-bin
read-only=0
binlog-do-db=gulimall_ums
binlog-do-db=gulimall_pms
binlog-do-db=gulimall_oms
binlog-do-db=gulimall_sms
binlog-do-db=gulimall_wms
binlog-do-db=gulimall_admin
replicate-ignore-db=mysql
replicate-ignore-db=sys
replicate-ignore-db=information_schema
replicate-ignore-db=performance_schema

一个从库MYSQL占用内存大概250M