![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数据库
落雨听虹
爬弱
展开
-
数据库简单语句-去重
简单数据库语句记了又记 :0、 select peopleId,count() from people group by peopleId having count() >1;“`1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断 select * from people where peopleId in (select peopleId from peop原创 2017-03-23 14:19:12 · 2603 阅读 · 0 评论 -
MySQL的几类Multi-Master架构分析之Group Replication
背景我们使用过的、构建过的MySQL服务绝大多数都是Single-Master,整个拓扑中只有一个Master承担写请求。比如,基于主从复制的Master-Slave架构,Master与Slave之间share nothing;或者是类似Aurora基于计算与存储分离的Writer-Reader架构,Writer与Reader之间share storage。然而,由于种种原因,我们可...转载 2018-09-18 11:04:57 · 1590 阅读 · 0 评论