Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > 什么情况下需要做数据库主从备份,该如何解决

什么情况下需要做数据库主从备份,该如何解决

WBOY
Release： 2016-06-13 13:41:42
Original
1209 people have browsed it

什么情况下需要做数据库主从备份
我只知道可以用来做热备份。
另外mysql读写分离和mysql主从备份有什么区别呢

------解决方案--------------------
我们项目虽然用到主从同步，但是没有听说涉及备份……DBA的事吧……
------解决方案--------------------

探讨

当然如果多台从服务器，而且读操作大于写操作的话，是可以想象到可以提高负载的能力的。
如果多台从服务器可以执行自定义的分配算法吗,还是mysql会默认处理
Related labels：
dba mysql
source：php.cn
Previous article： 新手请问个PHP查找TXT内容并输出的有关问题 Next article： 图片上传有关问题
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to display only the lowest value from a result set (MYSQL) I have the following statement: selectDATE(recieved_on)asDay,round(count(*)/24)AS'average'...
From 2024-04-06 21:44:19
0
1
603
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
MySQL: "Select text from... as <variable here or subquery>" I have the following table with the following data: id text language 1 german text german ...
From 2024-04-06 19:25:54
0
2
529
How to group and count in MySQL? I'm trying to write a query that extracts the total number of undeleted messages sent to f...
From 2024-04-06 18:30:17
0
1
353
MySQL gets data from multiple tables I have a eg_design table which contains the following columns: and eg_domains table which ...
From 2024-04-06 18:42:44
0
2
479
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template