简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

配置 MySQL 双机热备份_MySQL

WBOY
Release： 2016-06-01 14:03:09
Original
811 people have browsed it

双机热备份

1、mysql 数据库没有增量备份的机制，当数据量太大的时候备份是一个很大的问题。还好 mysql 数据库提供了一种主从备份的机制，其实就是把主数据库的所有的数据同时写到备份数据库中。实现 mysql 数据库的热备份。 U'YN?bqz?  
LZTS  
　　2、要想实现双机的热备首先要了解主从数据库服务器的版本的需求。要实现热备 mysql 的版本都要高于3.2，还有一个基本的原则就是作为从数据库的数据库版本可以高于主服务器数据库的版本，但是不可以低于主服务器的数据库版本。 dP9%x9y4O  
.Xq8-n  
　　3、设置主数据库服务器： Xo#S1  
"bC
Related labels：
mysql Synchronize backup database log server set up Configuration
source：php.cn
Previous article：教你怎样在两台MySQL数据库间实现同步_MySQL Next article：致初学者：PHP比ASP优秀的七个理由_MySQL
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
SASS styles take precedence over media queries I'm trying to use media queries to override styles for desktop devices but it doesn't seem...
From 2024-04-05 15:03:00
0
1
3396
PHP HTTP request ignores parameters Before I start asking questions, I should mention that I am re-learning PHP after a long t...
From 2024-04-05 10:54:48
0
1
3536
I need to have employees with same joining month and year CREATETABLE`staff`(`StaffID`intNOTNULLAUTO_INCREMENT,`Surname`varchar(40)DEFAULTNULL,`Give...
From 2024-04-04 20:28:20
0
2
352
Get browser notifications from anyone except the current authenticator. user I'm currently building a chat application with ReactJS and I've been going crazy with this...
From 2024-04-04 19:01:28
0
1
362
Challenges when using window.location.href to redirect to a new page I'm having trouble redirecting to a local domain php file, I've got it ready to redirect t...
From 2024-04-04 12:57:06
0
1
446
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
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！