Hi, we got a "little problem" with a master-slave replication (both running MySQL 4.0.18) eating up our complete bandwidth. The slave is connected via a 2MBit-SDSL-Line which is also used to connect our Office-PCs with the internet so I get complaints about the "slow connection" which is caused by the huge amount of master-slave traffic through this line. Most of the replication traffic is caused by tables, which are only created once, used for further selects and then deleted. The tables can't be created as temporary tables (that's what our programmers are telling me - I'm only the Admin and don't know whether thei're right or wrong) but are completely useless for replication.
My first attempt to reduce traffic between master and slave was to set replicate-wild-ignore-table for the tables described above. Ok, after reading the MySQL-Manual several times I discovered that this was useless cause the insert, update and delete statements are transfered from master to slave before they are tested whether to be executed on the slave - it would be nice if this could be set in the master-config for every slave, so the useless sql-statements would'nt have to be transmitted. Now I want to test the "slave_compressed_protocol=1" to reduce traffic (meanwhile I estimated that app. 90% of the traffic between master and slave is "useless" for replication). First I want to test it out with another replication-slave where I set the variable and restarted the slave. Unfortunately I don't see any slave_compressed_protocol-Variable when I do a "mysqladmin variables" so I don't know whether the variable is recognized or not. Does anyone use the slave_compressend_protocol - variable successfully and can tell me, where I can see, whether the slave recognized this switch and do I have to set this switch on the server too? Greetings Lutz Maibach -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
