mysql配置主从导致部分sql语句无法使用

love5783

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
    
14. 
    
15. 
    
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
    
25. 
    
26. [mysqld_safe]
    
27. log-error=/var/log/mysqld.log
    
28. pid-file=/var/run/mysqld/mysqld.pid
    
29. default-character-set = utf8
    
30. 
    
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
    
16. 
    
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
    
27. 
    
28. 
    
29. [mysqld_safe]
    
30. log-error=/var/log/mysqld.log
    
31. pid-file=/var/run/mysqld/mysqld.pid
    
32. default-character-set = utf8
    
33. 
    
34. [client]
    
35. default-character-set = utf8

复制代码

启动主从之后，状态都是OK的，就是程序中有些sql不可用了。
我是一个运维人员，对数据库不太懂，希望大神们帮忙分析下原因，还需要什么信息我在发上来、

love5783

操作系统版本：RHEL65
数据库版本：mysql-5.1.71