MariaDB单机双实例主从复制.docxVIP

MariaDB单机双实例主从复制MariaDB其实和mysql一样，非有啥不一样那就是名字不一样~.~!开始～上篇实验是MariaDB的单机多实例安装双实例端口3307主库，3308从库3307主实例的mysqld配置?1234567891011121314151617[mysqld2]port=3307socket=/tmp/mysql3307.sockpid-file=/tmp/mysql3307.pidmax_allowed_packet=1Mnet_buffer_length=2ktable_open_cache=4sort_buffer_size=64kthread_stack=128kbasedir=/usr/local/mysqldatadir=/data/mydata2server-id=244log-bin?=?master3307-binlog-bin-index?=?master3307-bin.indexthread_concurrency=4innodb_file_per_table?=?1#mysql_pwd=teleframe3308从实例的mysqld配置?123456789101112131415161718[mysqld3]port=3308socket=/tmp/mysql3308.sockpid-file=/tmp/mysql3308.pidmax_allowed_packet=1Mnet_buffer_length=2ktable_open_cache=4sort_buffer_size=64kthread_stack=128kbasedir=/usr/local/mysqldatadir=/data/mydata3innodb_file_per_table?=?1server-id=245log-bin=mysql3308-binrelay-log?=?relay-logrelay-log-index?=?relay-log-indexthread_concurrency=4read-only?=?on开始主从配置步骤1、连接到主库上授权一个REPLICATION SLAVE 帐号，并且刷新授权表?????????????12345678910111213141516171819202122232425262728293031323334353637[root@e3?mysql]#?mysql?-uroot?-h127.0.0.1?-P3307?-pEnter?password:?Welcome?to?the?MariaDB?monitor.??Commands?end?with?;?or?\g.Your?MariaDB?connection?id?is?8Server?version:?10.0.15-MariaDB-log?Source?distribution?Copyright?(c)?2000,?2014,?Oracle,?SkySQL?Ab?and?others.?Type?help;?or?\h?for?help.?Type?\c?to?clear?the?current?input?statement.?MariaDB?[(none)]?show?databases;+--------------------+|?Database???????????|+--------------------+|?information_schema?||?mysql??????????????||?performance_schema?||?test???????????????||?test1??????????????|+--------------------+5?rows?in?set?(0.00?sec)?MariaDB?[(none)]?grant?replication?slave?on?*.*?to?repl@192.168.0.%?identified?by?repl;Query?OK,?0?rows?affected?(0.00?sec)?MariaDB?[(none)]?flush?privileges;Query?OK,?0?rows?affected?(0.00?sec)?MariaDB?[(none)]?show?master?status;+-----------------------+----------+--------------+------------------+|?File??????????????????|?Position?|?Binlog_Do_DB?|?Binlog_Ignore_DB?|+-----------------