Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Compressing from mysqldump on the fly?

Posted on 2006-04-20
4
Medium Priority
?
1,245 Views
Last Modified: 2012-05-05
I am running mysqldump from a remote database server (doing a local dump is not possible) for backup purposes. This is done daily and the bandwidth usage is a bit of a problem.

Is there a way to compress the output of mySQL dump but have that compression happen on the mySQL server as opposed to the server which is running mysqldump, because by the time the data has got to that server compressing it is no longer any use.

Thanks.
0
Comment
Question by:thepadders
  • 3
4 Comments
 
LVL 15

Accepted Solution

by:
m1tk4 earned 2000 total points
ID: 16496210
-C|--compress  Use compression in server/client protocol.

(mysqldump option).
0
 
LVL 15

Expert Comment

by:m1tk4
ID: 16496214
note - this will compress the communication between mysqldump and the server, you'll need to compress the output of mysqldump yourself ( | gz or something like that)
0
 

Author Comment

by:thepadders
ID: 16496256
Oh great, thank you.

Do you happen to know how "good" the compression is, what sort of reduction you get generally?
0
 
LVL 15

Expert Comment

by:m1tk4
ID: 16496304
Hard to tell, the protocol is pretty efficient (low overhead) so it really depends on your data.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this blog post, we’ll look at how ClickHouse performs in a general analytical workload using the star schema benchmark test.
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month15 days, 17 hours left to enroll

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question