安装:https://www.cnblogs.com/brianzhu/p/8575243.html
这时候有可能会遇到包冲突:
file /usr/share/mysql/slovak/errmsg.sys from install of mysql-community-common-5.7.13-1.el7.x86_64 conflicts with file from package mariadb-libs-1:5.5.41-2.el7_0.x86_64
如果有冲突的话直接卸载掉冲突的包:yum remove mariadb-libs-1*
再继续执行yum -y install mysql-community-server进行安装即可
使用前需要先修改数据库密码和授权可视化工具访问(上面的链接里有)
我们把数据分到两个分表中去(取余或哈希这种方式分表如果拓展表会影响原来业务的查找逻辑,最好直接用id的范围进行分表(或参考一致性哈希)):
insert into tb_member1(id,name,sex) select id,name,sex from member where id%2=0;
insert into tb_member2(id,name,sex) select id,name,sex from member where id%2=1;