数据库（MYSQL）运维要点 - 读书笔记


https://cloud.tencent.com/developer/article/1579285

 数据库复制技术

  • 异步复制  - 
    • 应用 发起更新 -->  Master 执行操作 ->  Master响应应用 ->  Master 向Slave 复制
  • 半同步复制
    • 应用 发起更新 -->  Master 执行操作 ->  Master 向Slave 复制 ->   slave接收数据 ->  Slave写到Relay Log里面，但不执行 -> Slave 响应Master  ->  Master响应应用 
  • 同步复制
    • 应用 发起更新 -->  Master 执行操作 ->  Master 向Slave 复制 ->   slave接收数据 ->  Slave执行更新 -> Slave 响应Master  ->  Master响应应用 
    • 至少两个Slave，来保证Slave高可用

高可用


binlog 日志用于记录所有更改数据的语句，俗称二进制日志，主要用于复制和即时点恢复。主从复制也是依赖于 binlog 的。类似于 Oracle 的 archivelog，Mongodb的oplog，所有和写有关或者可能有关的语句，都会记录在 binlog 文件中。


慢查询
慢查询就是执行数据库查询时消耗时间比较大的 SQL 语句。MySQL CPU 利用率过高，大部分原因与低效 SQL 有关系，通过优化低效 SQL 基本可以解决大部分问题。


Comments

Post a Comment

Popular posts from this blog

Such a cold summer

I almost did not wear the t-shirt alone this summer, always have a jacket on when I went outside. Most of time the temperature is lower than 20 c-degree. Totally did not get the feeling of summer. What a pity.
Read more

My Unsolve Questions

How to reduce the admin work for tester? test Measurement, Management, Communication, Automation.  Agile: Test Might take longer time than development.  How to solve that in Agile? how to make exp test efficient in scurm. does tester be scurm master better sit with developer or tester in scrum should we can Quality advisor Automation test negitive test?
Read more

My interview questions to a company using SAFe.

What is the setup of your QA team?  What is the ratio of Test vs Developer Do you have the system layer test?  Do you have the non function test layer?  How do you divide the train, do you have plat form team, and do they have their own train? Any support work in the team` What is the good part, and what is the bad part How long does the team learn how to do PI planning.  What is the biggest challenge you meet,  Did you have any challenge when you split up the team?  Any suggestion on how to devide the team, and what is the practise in lego.  In the new setup, is it possible different team work on a same product of same feature?  BDD:  In which level do you apply the BDD, how do you use it in integration level? who responsible for design and implemented BDD? Agile: What is your product, do you have technical(platform) team, how do you make them work in the agile framework.  Special list can swap among ...
Read more