TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Fast MySQL Backup and Restore Using Mydumper and Myloader

66 点作者 lyri787w将近 8 年前

9 条评论

dexterbt1将近 8 年前
There are no benchmark numbers to back the claim that it&#x27;s fast. At least the OP should have done some measurements; I&#x27;m interested in anything that will speed up our DB&#x27;s 300+M record tables.<p>The article also does not link to the official maintainer page&#x2F;github page.
评论 #14830829 未加载
wanderr将近 8 年前
How does this compare to the percona tools?
评论 #14830768 未加载
评论 #14831585 未加载
whatnotests将近 8 年前
1. Shows password on CLI<p>2. Segfaults for me<p>I&#x27;ll be using mysqldump for now...but doing a flush+lock+copy the innodbdata file(s) seems like it would be much, much faster.
评论 #14832673 未加载
lathiat将近 8 年前
Watch out last time I looked most of these tools miss some things like stored procedures, though I haven&#x27;t checked mydumper specifically recently. mysqlpdump certainly did, and I think I tried mydumper.<p>There&#x27;s also other things to potentially worry about; events, functions, etc.
评论 #14831221 未加载
评论 #14831211 未加载
falcolas将近 8 年前
One of my colleagues from my time at Percona worked fairly extensively on Mydumper and Myloader; making the locking semantics better and the segemented files work. It&#x27;s a pretty amazing tool, since it lets you dump tables in parallel, with very granular locks (something mydumper does not allow).<p>As a logical backup tool, it&#x27;s invaluable. When combined with binary logs and regular binary backups, it makes for a nice and comprehensive MySQL backup solution. It even works with managed DB services like RDS.<p>YMMV of course, but given how easy it is to test for your own use cases, it&#x27;s absolutely worth taking a look at.
roselan将近 8 年前
Note that with 5.7 there is a new tool, &quot;mysqlpump&quot; that can do parallel export&#x2F;import and direct compression.<p>I haven&#x27;t test it yet because mysqldump is enough for our needs.
评论 #14831350 未加载
jaequery将近 8 年前
this is not really new as this has been out for atleast 7 years now. but this really is fast. i think atleast five times faster from what i remember.
alexcroox将近 8 年前
What tool would you recommend to easily take frequent backups and pump them to S3 glacier storage for example? I don&#x27;t want to spend hours configuring something as it&#x27;s only for a small personal server.
评论 #14832952 未加载
boznz将近 8 年前
Nice for my Linux (and possibly BSD) customers but some of my customers use MySQL on Windows servers, it would be nice to give them some love every now and then :-)
评论 #14830834 未加载
评论 #14830565 未加载
评论 #14831191 未加载