Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 16th March 2007, 15:51
xomoxo xomoxo is offline
Junior Member
 
Join Date: Jan 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Lightbulb About slave_compressed_protocol in Mysql replication

Hi,

Today I read about slave_compressed_protocol, because I need to waste more bandwidth, but I have some questions that I can't find in the documentation:

- I have to put slave_compressed_protocol=1 in server and slave or only in slaves?
- How can I check it's working the compression?
- My server is 4.0.27, some slaves 4.0.27 and other 4.1.22, is the slave compatible with the mix off all this versions?

Thanks for all!
Reply With Quote
Sponsored Links
  #2  
Old 17th March 2007, 22:06
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
 
Default

As far as I understand from http://dev.mysql.com/doc/refman/5.0/...n-options.html , it must be set for both the master and the slave.
Quote:
- How can I check it's working the compression?
I think you can use
Code:
mysqladmin variables
or
Code:
mysqladmin extended-status
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Messed up ISPConfig-2.2.8 Upgrade Morons Installation/Configuration 4 29th November 2006 12:17
mysql replication issues Jamesk5 Server Operation 8 23rd September 2006 14:40
MySQL Replication neil6179 Server Operation 1 12th September 2006 15:50
ISPConfig server also a MySQL replication slave jamesh Installation/Configuration 1 2nd August 2006 09:59
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04


All times are GMT +2. The time now is 07:15.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.