mysql資料庫主從配置

標籤：window   blog   成功   檔案   mysq   cte   lin   code   word   

http://blog.csdn.net/l1028386804/article/details/48413681  錯誤分析

https://www.cnblogs.com/fyc119/p/7529902.html　　　　　　主從配置

測試了下主從分離的配置，基本是成功了，先記錄下流程

192.168.1.101主機配置

192.168.1.101的主機配置 windows環境[client]port=3306[mysql]default-character-set=utf8[mysqld]port=3306basedir="D:/phpStudy/MySQL/"datadir="D:/phpStudy/MySQL/data/"character-set-server=utf8default-storage-engine=MyISAM#支援 INNODB 引擎模式。修改為　default-storage-engine=INNODB　即可。#如果 INNODB 模式如果不能啟動，刪除data目錄下ib開頭的記錄檔重新啟動。sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"max_connections=512query_cache_size=0table_cache=256tmp_table_size=18Mthread_cache_size=8myisam_max_sort_file_size=64Gmyisam_sort_buffer_size=35Mkey_buffer_size=25Mread_buffer_size=64Kread_rnd_buffer_size=256Ksort_buffer_size=256Kinnodb_additional_mem_pool_size=2Minnodb_flush_log_at_trx_commit=1innodb_log_buffer_size=1Minnodb_buffer_pool_size=47Minnodb_log_file_size=24Minnodb_thread_concurrency=8log-bin=D:\phpStudy\MySQL\data\mysqllog-bin.logserver-id=10

192.168.1.91叢機配置[mysqld]datadir=/var/lib/mysqlsocket=/var/lib/mysql/mysql.sock skip-grant-tables  user=mysql  symbolic-links=0  tmpdir=/tmp server_id=2[mysqld_safe]log-error=/var/log/mysqld.logpid-file=/var/lib/mysql/mysqld.pidlog-bin = /var/lib/mysql/solve-bin.logCHANGE MASTER TOMASTER_HOST=192.168.1.101MASTER_USER=rootMASTER_PASSWORD=root

其它的都是按照網址上的流程操作的，此時的話主機上面添加資料已經可以在從機上面顯示了。

 

mysql資料庫主從配置