引言:
双11,阿里云服务器打折,于是我忍不住又买了一台服务器,于是咱也是有两台服务器的爷们了,既然有了两台服务器,那么肯定要好好利用一下吧,那么就来玩玩mysql的主从配置吧。
准备
两台数据库服务器,从数据库服务器等级必须要大于等于主数据库服务器,
我的主服务器是mysql的版本是,mysql5.6.33,ip地址假定为192.168.10.10
从服务器是mysql5.7.15,ip地址假定为192.168.10.11
首先
因为mysql主从配置的原理是利用远程通信,读取二进制文件日志,然后从数据库按照日志进行响应的操作,因此第一件需要做的事情就是开启二进制日志
正常情况下,mysql 的配置文件的位置是/etc/my.cnf,使用命令
vim /etc/my.cnf
然后在[mysqld]下添加,(已经开启的情况下,就不用添加了)
server-id = 1 #server-id必须唯一,切记不能和从服务器相同,各个从服务器之间也不能相同
log_bin = mysql-bin
然后
因为我的数据不是空的,主从配置必须要两个数据库数据初始一直才可以配置
所以我要把数据导出,然后手动的导入到从数据库才可以( 如果两台数据库都是空的,则跳过这一步),由于主数据库可能会一直有写入数据的情况
所以配置之前,可能要选择宕机或者是迁移,我这里是选择了宕机维护
使用以下命令导出所有的数据库
mysqldump -uroot -p --all-databases>back.sql
然后使用scp 命令把备份文件拷贝到从数据库服务器
scp back.sql root@192.168.10.11:~/
接着在从服务器中,先使用mysql命令登陆数据库,然后使用source命令导入数据
source ~/back.sql
这样就保持两个数据库的数据一致了
接下来
在主数据库服务器中,使用grant命令添加从服务器帐号,grant命令就是mysql用来管理用户权限的
ps:其实直接对mysql数据库的user表进行操作也是可以的,只不过直接操作的用户需要重启mysql服务才会生效,而grant则不需要,添加直接就能用了
grant详细用法可以查询一下官方的手册,我这里就直接进行配置了(因为是服务器环境,所有所在的操作全在命令行执行,可视化工具有更简单的方法,这里不做介绍)
使用以下命令,添加从服务器,登陆账户为crisen,密码为123456,地址任意
GRANT REPLICATION SLAVE ON *.* to 'crisen'@'%' identified by ''
接着使用命令show master status 查看当前主数据库服务器的状态
show master status\G
这里只有两个字段需要注意一下,一个是File,另一个是Position,因为这两个数据是需要给从服务器配置的
aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAjoAAACcCAIAAAD58JZNAAAdFElEQVR4Ae2dS2/rSHbH617cb5DcRSAJjm+CoAOtkgBRFDg9VjCYPIZIkEALLXyXkyzsQRYC0jKQBNlZG+3kxSCZB2Jj4EwrmU6ivbwwYOgDCOhVGxe2Vv0dxjmnikUWxSJFUqJEin/idpssVp3Hr6g6PFUUJZrf+9vf/e7f/Md//d/7D58JbCAAAiAAAiBQSAJvf/WrVzKM/8MGAiAAAiAAAkUl8LaohsEuEAABEAABEPAJcLh6RXLlA8EeCIAACIBAEQm8pVj1qv4ronmwCQRAAARAAASYwFvEKlwIIAACIAACxSdQxLWr5vntzN1uz5tBhs6QzgydYOG2jqzC46zJrJg0hVzLLAwNQQAEQKAKBH7nT/+a/v1s8r/qQXYzGvDoHT+oGkM5RRFV1y/z26YbnUmCNSBZo8m2+yhSCVnlO7Sp1nRANtWWtP3OrEquKHnNpE6iHgiAQEkJvFu1e7lctk4cMZ0K56S+XK6eNo+b55ftx4vO9cIvpDF93H0Zdc6mQtBIM74VF2fmeb9m6j1n2K9PgtpSy0jQYDroiOGsP3SmA/IBGwiAAAiAQDEIyMlAWr/yt8fHOccrjlaPjy9czvlSILFwb3mPGzW/mdxrnrZry8mNGueng9G81j5dmc1baZH0sHnea83vzMgnjXDceUPfPCrWm07RImpKv9y6uqo0Z3ozkSE72rZUmRbj01tAz/Fa48N6nKHvasA+WfVcJcdKo9JlaveamoWqmsTWb4lad6xs9Sw16rplVJf2NGivYsAc98Bo7E7hRikyayo7I2pSsfaD27jqzea+RarUP7aZiDIQAIGyEODJwM5f/WzyP+5kIA0FNCAMHTku6sHRGBdk9NLjhRxRaHjTAwIf630C4DUzhpgEXKiZIUQ1CEuQuv2BTbZghdo2f99WUyZ/ZtWARs9ww1oq0/W5lKvo+U+jVniXtAdkyxo2k3yD/TsEt7FUxlJoJyxMStRVWDLZSYfK2mZT3y/wGdXYlRqylcpNF/m8UcQaZHsW5IqKtkcKT6HIZmdQv5Rot4jNtHGRUKxnXGH4AwIgUB4Cb+k59lVrpw/zVr9ff7z3ZvkW13fzVk899uB87L7oNIdmzni7eO7p8WtVVq7Hy8mVzLeent1JS8r3ltrsxf3jstY4VgaEalLy6KcS425N1I/0sJ7M5MX1GXl+JS7XBS1J04InZJLNePKMDTtuvMznakc8P0UZqPPaQBa6WBzL6DKbUe7kblEm6fP+3yhKy8mFnCslCnFzpskVCZudvh3r9iIUqU6Ks3CdYJwHARAoDAHr14Tpwy+8YV+ZShNkovvRodv7Xl3P9nlO0KhwIefPOG4Y4z4PwNGjq9d8bzvzkYy28n/ZltgWn3i6lGbQbPf2rl8qpquQvpq8rHOd5FPIdU7Ew+DhpX3qHAkdjde1dM9T2tEXyk3qIt0olUk2Si+fvFsZLdP6N7Eiu51WmdbCxIqsrVEIAiBQAgL8NeGwmfThXx2+VYJ1e+mnVsI59x8zV+tYXKnGUY03ejaitRL0wpqSllAg9FKl6DZcS6+WyXW06GDJIVknjKsCuen8If5JCzXPNDt5UBEv8g5eT3LxjT6t5el0b1UlHVuNJzPrvV6d/Hh6Fo2ThkgYJwz5+o5BdRGdSG6SiKNkqIjYTaGIJITsjJCqi50hZ8Vyi1KEyUANC39B4AAIvON3Wog3STyhBKs3bk+u/GG8QevyXbcp3YPLIXtwcXRLq/V9LqYy7+EIXsPXdWkqaTUarjOAA+GMpiOnnkBbC4oJo8ZMKzLVh2tPpaW6rjBsounO2nzkuxluS8PgpbjqdJKkGKeXs7F+JIUsihZrN56iVE3Oyy7EY33cfrwJWxNXIjtNOTmfTJbd/mwoONGzmkTBqd93ibj9aaMUpy94Lsr3sCKbnXxBWWpqI+eji0l93JAaoxQFzcERCIBAqQn89qnzW99xvEctYnyh+Zo0c1nyzjZNA081tbTOrZEB+mEBr+7Wd1iJ1Wqyylq+dQsgcIsE0GtbhAlRILBnAhSr6N9Pv3SfDLRaI+NExChubaALOWSlH+O5lbuFGucasqzC46zRfuJvMQlw31nvfIppLqwCARCIJZAkXMUKwEkQAAEQAAEQyJ1AEd8ZmLvTUAACIAACIFA2AghXZesx2AsCIAAClSSAcFXJbofTIAACIFA2AhHhitaoQ085lM21A7K3It1RETfzuDCBLg+qmWWiOzKji20YEa5i2+AkCIAACIAACOyYwBt6MpBU/tPFD/7xiy++/eZrevJXvyrAtUR+f1bwD4PoL7vqr9TSLQQKJSX3O8ZbB3J/ahL2VR1Yd1TETfqGO64Qd1Q50DEEV/LWI4K+YNRf/SD7V+qN7O5JJLNBSns+qkh3VMTNPC4moMuDamaZ6I7M6GIb8mSgfA9TbC2cBAEQAAEQAIG9EsDa1V7xQzkIgAAIgEBCAh8+/z79++mXwcnAhI1RDQRAAARAAAR2QgDZ1U4wQwkIgAAIgMBmBBCuNuOH1iAAAiAAAjshgHC1E8xQAgIgAAIgsBkBhKvN+KE1CIAACIDATgggXO0EM5SAAAiAAAhsRmCH4Qpfndusq9AaBEAABKpM4O1rlb2H7yAAAiAAAiUh8I7sDEYsSoK2+96nwHu0xrMuaXTfsVcSRjATBEAABEBg/wSOP/8+/dvF14QxGbj/3oYFIAACIFBWAjtcuyorItgNAiAAAiCwfwJuuArOB+7fLFgAAiAAAiAAAiYBXrva0ba4PjvbkSqoAQEQAAEQODACmAw8sA6FOyAAAiBwmAQQrg6zX+EVCIAACBwYgahw5QxnQye7r9R8dnve1AL4UG1GoT6Jv+sJbNgd6xXoGisdp4stf5PXtDSOKNrQzSQmcZ1DvBSBLuKa2k/xht2xH6ODWsmFLY7W/LmLEJdC0SZrV6Sm3zJcnI86g6k6ng467p48dg+pQc+oj92tEgh2h9EZabSsdBw15U57vji7XqyICddcqZDTYcDNoJdJTMrjUowxKQkEa3NrYRJpMXViZBYCnRDB/oxxJcdTVkrWwg2NCMjM2XfSZf0Ub+JC4Bu6uueiFCW5wNYbs0m4Iun4vu96xDusoa8ZvpB6581pKMbs0JYcVemrjj8aBfFSm8TkZ0Ph3bclpGBtrgu36WYeMhP6aK0mRzGG1rhLy8wqbzuFmlKgN3VhHt2xHbN3KYXRdF9GnTOVljSb3lRanlZsGK5CpkkvarJYj52hOn5Butp+O+zFE1h8ehHdxrEQlBLRp0vnwF6PGNz1Da1R5FXzmrbUy0hUXVtNNser7d8o8if7efTY7nfpktAf93jTU5xtHtXFywNnfXaT0mi3GG+IXS6XNfFoSTFD1i6urybt8YkjplMbkFD9lQK/uX/Cd9Mv23TPl1kcdKZPnlU++YjetHQcFZ08dB5O1HXvXc0RV4mpdnV/V93h65XuuCYzhLa+6jwi/qfLuEBZgGwlKakLlVvwTYDQA0DgU8wtbDK9svl8znUiNudjtzYfubGK6iwWC/96DyjyBJqGUwuvPF5RUH/U2lWwVvIjelq9Q9vFZLm+jTPk3uDqVL/e32StbL2yStVwTlpi/kD3PXRN9OsTn7GaPaZrje6L3M2dv7V1HN36djqjOQcaVVnWtdWMUETQa92euJJiat2PG6yGmv1X6455+emSBCvrrSZxi2TaIygN5e0je373ou7ATCOi9vlWoX7UtMuMauSXu825IOSmXyvzXkhmkdBpr2hg0BdogHyoNyMht/ocsQLjULbRJufu0B57f+kjN5q3+vQ5bZ5ferGKIoFlqGRMQn80O5HJqf1TzLeXYZks0h0aHoS50OMZqHb4dkcOMGa5XZH9AkuqyJRP+xuGK/fq58EjdbThMVW357cU0md8xTgcpiRAn1K5cYiSA/lxo7Z8vFfLTov7x2WNUy4xfaBPRJYuizbHrojqLydXckry6TnBDUy0/MAZN3zeNcZRq7e6ejLtVuO9kE+yCJiWmPSvVWbSxqpecjeTy00uc3/oIsmHTIqETG7qWyt1QyM2H22So0veHXr8Mx9DmA4uJqI7pliiPjkkzWq8xHSXeb7fJlOK5Ntc2hJe83THIIeciMcopKjw/zIokkI2nAykLgwvwoetiyzxM/XIKjiRnEBSnHQfpFKv2ay/aRcmt27bNaeD0cmsd9q8pomI4mz8SeQpykY2k3Rzv3UebuYh07d4/3svn2yXRNKPh2F/zt0R9+GTt5a+GyHj+cZzw21VZuLZD7naIKe8OXm65inIDU1J1nzD7CqZEnstDt8tWiq3n0XpNghQTlNrnyrEzdN2bfn8RDOE7rIoX2mjuUq4NlVmVbSp0HXteUpiG5vVeE4HW/SJpK153ouZGAlY4Az7reXkZiqsMgNVbQdec/PkttzMQ6bVzWzoPPOSN7dq9+QEdjKNNjvrDtNUd5KO5wT1jJXVeGuhJ4hn22JnsG3Nk5Of3kyWcs7SU5hqJ7mioNgNs6ugsJRHlPUe3Y7dVfwcluJTmnOI1SkijRozjZhupnjuoHl6ORvrS5nKVPIf5T5d1v2++aiFtaJVkbXmFgp5CqUr5dDdaebZEN8Qu/ESHc2Z9mlCczIXbb++Zc8zybtftpG3NFRF4eZU7hXy4uEW3GRV25a5KTr5aIFkIEnL230lMwl5u3YpLvS/NKONR8nrzRzQsYWeIj5g5/m5CKE+pjx30HefMrUabyv0Pq3zET0PMPZSfK/c1UOfeVtz+aBQEvKC0F8Ic/R+ZhfkHGKi4YKfSEqkSIl1//+Gfj2Edv/5hz/44ovBt998rU/SZURrle68ry7E330RqEh3FNVNmqDnh6z0w2aBq0COsIGSqAN/aDZqJG9uNLLsHig6l3weA1Elu8Ny5cQX5UrJVJ1I0T6zK9NY7INAwQjwSKnnU/gum29I12Si8R6oFcP4OodxdkN0luY5cKlOd2wCb2eUkilSP8/4ky+/ev/hs03cQlsQAAEQAAEQyI/ALh+1oHRPrx3m5xAkgwAIgAAIHCIB22SgmYuveQKCItDWX0V1iJjhEwiAAAiAwGYEwuFKfZtaPkK2mWi0BgEQAAEQAIFtEQiHK/qmuHAfSgwoMXIu+TST9yRH4A1RgSY4AAEQAAEQAIEtEbA8akGBSG7mQhOV6ddsUNzy1qCM4vX2UGVT5PoGqAECIAACIAACikA4u+Lvj8nndTkszfrqeyH8LpKaTqOo5ZLf7+e/IAQ0QQAEQAAEQCBXArZw5Sp0v7esfgyByrb1hcZc/YFwEAABEACBgyQQfpDdOfdf48frWHKzvWDqIHnAKRAAARAAgUISsGRXDe+NbEZGZXvBFE0GWl5FVUg3YRQIgAAIgEC5CYTDVdTLMGhusHMdcjaqdqgiCkAABEAABEAgO4HwZGB2WWgJAiAAAiAAAjkRCGdXOSkiscjE8mMLySAAAiBw4ASQXR14B8M9EAABEDgMAu9eX18PwxN4AQIgAAIgcMAEdHaFmHXAnQzXQAAEQKD8BHS4WvGE3mih37m0cgaHeyBQke6oiJt5XEBAlwfVzDLRHZnRxTaMCFexbXASBEAABEAABHZM4M1v/slfksp/+eHffTEYfPvN1/SeQP2D364l/Lvf18L4IXDvJ7DoFsL7dXAUXi/E1oHcn5qEZYccYndUxE1cIQc/XOBK3noXBwMihSv695NffPX+w2f+GSSzPosC7FWkOyriZh4XFNDlQTWzTHRHZnSxDTEZGIsHJ0EABEAABIpBAOGqGP0AK0AABEAABOIJ2CcD49vgLAiAAAiAAAjslgCyq93yhjYQAAEQAIFMBBCuMmFDIxAAARAAgd0SQLjaLW9oAwEQAAEQyETgLd4ZmIkbGoEACIAACOyUAGdXiFg7RQ5lIAACIAAC6Qm4k4GvIv933OKrc+m7By1AAARAAAQUAaxd4UoAARAAARAoAYHwrwlTErTd9z4F3qM1nnWJinzx3aIEeGAiCIAACIBAQQgcnfwF/fvxL34ZeGdgHsZhMjAPqpAJAiAAAtUggMnAavQzvAQBEACBkhNAuCp5B8J8EAABEKgGgfDaVW5+L67PznITDsEgAAIgAAIHTQDZ1UF3L5wDARAAgUMhgHB1KD0JP0AABEDgoAlEhStnOBs6e/Cc9Lrb7XkzVj/VjKrCQqLOxcos7Ml9dceOgVTEzTyoAl0eVDPLRHdkRhfXcIdrV3FmeOemg86UDqi3e15Z6h1XSOp23IA091u8Y343bOuFnsCgHta73S1SkfH1uvmoM5j6jrsGyFKjuSxeLfQhWWtSG6/cr7pdDyENBECgKgQivndFo8xesisXO6lflx4lqJK6D2kM13p98XkUOsN17gVtz9wdEYpIXkz/Wr8h5xdGyPQs9mta0Xn1wjuZ3QyLqloJ0BWqx9EduXRH1GTgemVyUDrnubuhw8OS/hsYh6nX5LGqoKb5/DBIZ92i4frwZLXoWCqWuvm8ocbXwjf4t+eOWzNg3orM5mm7Nr+7lq/bmD7Ma92PNB+aR+GK3l0fNs97rfmIMirr1jy/bD9eKQpeBWuhd9bcMWpa0Zl1sQ8CIAACiQlkD1ekotZtPHRG81b/UlxdTJb1I3F9NRFykJcG0LBYn/DA53zsvow67qaHSWfYp0FTFj4IOf+W2Gq3Yq3bE1ckgHS3erzURc/Kszw6XhGla47cGLRy2j08btSWz0/uwdPzUtSPmiKPQlJR6445VBtR1W7TxqUWRdIlERG/nY/hYEUdGCi0yNR2mjWt6HRF/AUBEACBVAQ2ClfLyY28Q9cZCWleXN/NVeigZQsKUipXoVSl1V8ZnJ2Tlpg/qDt8Oh9ntZE0kRA/P1rKWEhK7x+XtfZpzKMZuibHoCJstLqm4mq9n2/EilKk43dn9NIdGzHTGfaeVzMrSk8DhVEyCexKzSKghg0gAAIHQmCjcGVlML1RCZZMrVQ4E0KNcBfPvWC48VIZqySv0E2a5Ajf6ZytzFO51V4+bfzOXApmtcaxK49SA8Ey8yjUnnGclSmcLsjrb1iRvsXgOwVOIuVGCa9wJ0N9S6yFdDosc7WmFZ0vGHsgAAIgkILA9sOVm2DdXurUipZ/mmo45LBD03EqIvBY5mZEvJaSwmavqo4tlMYZs3je6TU7esHNr8YDsJcanrRU8phHoVbJizsyJuqCvP4GFXGIap2o7ylQkrt8vJeRXi5pufmuZ4i1UJ4NyuSFQ1oRCzS3ovMkYwcEQAAE0hDI5UF2SrB64/bkylvLP72cjWuuWbRcJcsXtM7VHssfFFlOJnPRTmO2qjsXJ7NZn/dJqD3nSieU4umoMVM/cuKJzKGQIqX7Iy30eLdey0tnarLaEYqmg4ujW1o7Y3aenxx+5ndenykFlsIImZaavJYY5pnMctQCARAAgRUCeTzIrp8HXFEVc5i+RYywAzxFfIwFpgN0ULlUETfz6D+gy4NqZpnojszo4hpuObuiXuIv2XLOsPFKUpzZOAcCIAACIFAxAhHZVcUowF0QAAEQAIFiE8jhUYtIh5EgR6LBCRAAARAAgXgCb19fX+Nr4CwIgAAIgAAI7J3ALrOrvTsLA0AABEAABMpKAOGqrD0Hu0EABECgUgQ4XGE+sFJdDmdBAARAoIwEdHaFBawy9h5sBgEQAIHKENDhqjIOw1EQAAEQAIEyEkC4KmOvwWYQAAEQqBwBhKvKdTkcBgEQAIEyEkC4KmOvwWYQAAEQqBwBhKvKdTkcBgEQAIEyEtjyK25jEdBvNK78PEVsdZwEARAAARAAAU2AXsKkd/EXBEAABEAABIpKAJOBRe0Z2AUCIAACIGAQQLgyYGAXBEAABECgqAQ4XFnmA+kHzm/Pm0U1unJ2VaQ7KuJmHpcv0OVBNbNMdEdmdLENkV3F4sFJEAABEACBYhB40/jjPydL/vUf/n5wefntN1+f3866tYBp9EP2Z9fi/Hbsl8uihaBbCBRKVnkBuT81CfuqDqw7KuLmdQ4fGaAr1BCE7th6dwSCkaBwRf9+/J+/fP/hM/8MklmfRQH2KtIdFXEzjwsK6PKgmlkmuiMzutiGmAyMxYOTIAACIAACxSCAcFWMfoAVIAACIAAC8QTsk4HxbXAWBEAABEAABHZLANnVbnlDGwiAAAiAQCYCCFeZsKERCIAACIDAbgkgXO2WN7SBAAiAAAhkIoBwlQkbGoEACIAACOyWAL2RHa9k3y1yaAMBEAABEEhPYIfZFb46l7570AIEQAAEQEAR4HBFCRYyLFwQIAACIAACRSYQ/jVhSoK2+96nwHu0xrMu4XDfsVdkMLANBEAABECgUARqf/S9evvP/n3lnYF5mIjJwDyoQiYIgAAIVIPADteuqgEUXoIACIAACORBwF27ykM0ZIIACIAACIDAtgiE1662JTkkZ3F9dhYqRAEIgAAIgAAIJCCgv3eFZwMTwEIVEAABEACBfRHAZOC+yEMvCIAACIBACgJudlWw7105w9ns9ryZwo/dVGW7ZkNnN8q2oaV0Bm/DacgAARA4TAK/8YffpX//dvff7z985nlIz5yXa1j2LE+zQ2N5ipgYGvllAYWv9UKsNa2FacxPWjdkeNKGqAcCIAACBSKg1660STJQzS4bL0tdgr9MwBn265OLzmDq4iBOsqDT6YxeupcxmaC1prUwJ9LTQWc0b/XLlBTmRAJiQQAEykxAr13pRy3o8T0agc9unhM4RbftNAbqLMEbDnWBnjejoXkliXGGKwWeMqrL+QpvnjyOFZTBOO6pqKZKhiHAlGAUS7nSxn5L1LrjkDbPGH+ned5rze+uF15J87Rd0wXTh3mt+zFqhtBa01roCQ/uGKbHeSQbmXXNytObybJ1EmViUB+OQAAEQKCQBN7R+wLfvHmT1bZWfyZGnc6AxsmPUgbtyKyDh3baH9+eP519eqmdHNNZfrvTy6gzeDqqv3zyh35TN0fLa9WyYZZTXOmJi05nQXGm/9G59rKcQCUKbB9Zw5nOgdyzznDcfrzoaJuGznQw6Ew5CvaeL86MKLQizTs8btSWz0/eoRCBgqfnpWgf0UqbzSd7TVNebPPkHrE/466gFNDi0OL+cTmmeDVdIWO4hF0QAAEQKDQBDldkYNZHLejlfzJyUJgZSD95dH68V+M2j5HdxrG4f172eDRvvMzndbkjnu9TUllOruQozGN7MJAFBFGm0+/PZv05RUVvZHZOKI1qqbcVcu1lVGgJiCrIQXKPjsnN+cgSqwriCcwAARAAgU0IuOGK3sqeSUpUlhQQtpDpldMQD4OHk9tTmpPSAS1QbSsHtFBDYUpOivXNF+kG4tfmmihq1igQq3yKQrSIBGGtaS2MsCqxR5zAYgMBEACBQyXgvjMwW7CyQOGBuH2qHkHnFRo5h0YZQr3Xq9N02tOzaJw0RMRUoEVeuqJmU2nmOcXRXAYUEkDqRasX8zTEWiU6vHgVOXHUIil5W05uVC4n46S5aiSsNa2FnnBzJ4VHcW7KxbIHL980NWAfBEAABEpB4N0rTQQawYrXm7o1ZTrPqgmaXzLm1db6RIFi1JjpiTdq607hiVqdU6qFeKzTOtLNWjkZK5xezsau9Wy4Oz5PBxdHt2NtlPfzJXKezS2N93JxfTefUcCbelNtpp/aS7vN1prWQmv7FB5FuEliaUmvNh8hWlkJoxAEQKAkBH7997/z/g9Of/Tzifm9q5LYvlMz5cOExuOKO1W+iTI2PP5xyk2koy0IgAAI7IYAf+9KPW2xG33l1UJrSJ2RoIyzTCGLQ1Wfnt1M8vhjebsGloMACFSCwK/93ueUYP3o518iu6pEf8NJEAABECgnAf1kYDmth9UgAAIgAAIVIaCfDDSetqiI53ATBEAABECgRAS87ArxqkS9BlNBAARAoHIE9DsDK+c4HAYBEAABECgTAUwGlqm3YCsIgAAIVJaAG64q6z8cBwEQAAEQKAWB/wcmGH8Un+PIyQAAAABJRU5ErkJggg==" alt="" />
最后
进入从服务器,先使用命令行登陆,然后使用命令
192.168.10.10是主数据库的地址,crisen则是之前创建的帐号,123456自然就是密码了,这里还有两个参数,则需要上一步中file的值 mysql-bin.000005,与position的值5677570
change master to master_host='192.168.10.10',master_user='crisen',master_password='',master_log_file='mysql-bin.000005',master_log_pos=5677570;
然后在使用start slave命令,启动从服务器即可
start slave;
接着使用命令 show slave status\G,查看从服务器状态
show slave status\G
如果出现下面两个字段都为yes
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
尾语
mysql数据库的主从配置很简单,只要linux下命令行操作以及一些mysql的基本知识就可以很轻松的完成了,但是想象永远都是想象,只有你亲自去尝试了,你才会明白的更加深刻
I hear I forget,I see I recongnised,I do I understand!