mysql主从复制和读写分离.doc

:..Mysql主从复制和读写分离mysql主从复制:1、安装mysql-server包yuminstallmysql-server*2、开启二进制文件:Vim/etc/flog-bin=mysql- server-id=13、开启服务:/etc/、分别对主从服务器进行以下操作:mysql主服务器配置() Mysql-predhat登陆mysql 给从服务器赋权:mysql>grantreplicationslaveon*.*to'my'@''identifiedby'redhat'; 对表进行锁定mysql>flushtableswithreadlock;mysql>showmasterstatus\g|File|Position|Binlog_Do_DB|Binlog_Ignore_DB|+------------------+----------+-------+|mysql-|241||查看mysql-bin的序列号slave服务器中配置:()mysql>changemastertomaster_host='',master_user='my',master_password='redhat',master_log_file='mysql-',master_log_pos=241;mysql>startslave;Slave_IO_Running:YesSlave_SQL_Running:Yes如果出现了以下内容:ERROR2002(HY000):Can'tconnecttolocalMySQLserverthrougtsocket'/var/lib/mysql/'(2)说明mysql服务没有开启。读写分离mysql-proxy(1)安装前的准备: 安装:gcc、gcc-c++、autoconf*、automake*、zlib*、libxml*、ncurses-devel*、libtool*、libmcrypt*、flex*、pkgconfig*、glib*(2)编译lua---,使"INSTALL_TOP=/usr/local/lua",这样做的目的是为了是lua的所有文件都安装在目录/usr/local/lua/vimsrc/Makefile在CFLAGS=-O2-Wall$(MYCFLAGS)这一行记录里加上-fPIC,更改为CFLAGS=-O2-Wall-fPIC$(MYCFLAGS)来避免编译过程中出现错误。当提示以下错误时:[******@sswans154lua-]#makePleasedomakePLATFORMwherePLATFORMisoneofthese:/usr/lib64/pkgconfig(3)编译libeve