MySQL社区

标题: mysql配置主从导致部分sql语句无法使用 [打印本页]
作者: love5783    时间: 2015-6-27 10:13
标题: mysql配置主从导致部分sql语句无法使用
BDA大神们好：
我配置了一个主从数据库，主配置如下：
  1. [mysqld]
  2. datadir=/var/lib/mysql
  3. socket=/var/lib/mysql/mysql.sock
  4. user=mysql
  5. max_connections=1000
  6. # Disabling symbolic-links is recommended to prevent assorted security risks
  7. symbolic-links=0
  8. lower_case_table_names=1
  9. event_scheduler = 1
  10. default-character-set = utf8
  11. #mysql replication
  12. log-bin=mysql-bin
  13. server-id=1


  16. key_buffer_size = 1024M
  17. read_buffer_size = 16M
  18. thread_concurrency = 16
  19. thread_cache_size=128
  20. #wait_timeout = 16
  21. log-slow-queries = /var/log/mysql/mysql-slow.log
  22. max_allowed_packet = 64M
  23. innodb_buffer_pool_size = 1G
  24. innodb_additional_mem_pool_size = 256M

  26. [mysqld_safe]
  27. log-error=/var/log/mysqld.log
  28. pid-file=/var/run/mysqld/mysqld.pid
  29. default-character-set = utf8

  31. [client]
  32. default-character-set = utf8
复制代码
从节点配置如下：
  1. [mysqld]
  2. datadir=/var/lib/mysql
  3. socket=/var/lib/mysql/mysql.sock
  4. user=mysql
  5. max_connections=1000
  6. # Disabling symbolic-links is recommended to prevent assorted security risks
  7. symbolic-links=0
  8. lower_case_table_names=1
  9. event_scheduler = 1
  10. default-character-set = utf8
  11. #mysql replication
  12. log-bin=mysql-bin
  13. server-id=2   
  14. master-user=mysqlslave
  15. master-password=mysqlslave123qwe

  17. # Performance Adjusting Setting BY GUOJINWEI on 2014-6-27
  18. key_buffer_size = 1024M
  19. read_buffer_size = 16M
  20. thread_concurrency = 16
  21. thread_cache_size=128
  22. #wait_timeout = 16
  23. log-slow-queries = /var/log/mysql/mysql-slow.log
  24. max_allowed_packet = 64M
  25. innodb_buffer_pool_size = 1G
  26. innodb_additional_mem_pool_size = 256M


  29. [mysqld_safe]
  30. log-error=/var/log/mysqld.log
  31. pid-file=/var/run/mysqld/mysqld.pid
  32. default-character-set = utf8

  34. [client]
  35. default-character-set = utf8
复制代码
启动主从之后，状态都是OK的，就是程序中有些sql不可用了。
我是一个运维人员，对数据库不太懂，希望大神们帮忙分析下原因，还需要什么信息我在发上来、


作者: love5783    时间: 2015-6-27 10:15
操作系统版本：RHEL65
数据库版本：mysql-5.1.71



欢迎光临 MySQL社区 (http://www.mysqlpub.com/) Powered by Discuz! X3.2