My master has two databases: channel and hardware. I'm only interested in replicating hardware, so I set up replicate-do-db=hardware on the slaves.

However, I am having problems because of giant LOAD DATA operations performed nightly on channel. Replication blows up with "max packet exceeded" errors. Due to this weird java program we have to use to load data from our partner, I can't just make the packet size really large on the master and slave and be done with it. I tried doing that, but the java program freaks out if i set mysql's packet size too big for the java heap. (I hate java so much.) So, my questions are:

- does anyone know how to make java not care how big the mysql packet is?

- is there any way to have the mysql master just not even send big packets to the slaves?

- is there any way to make the mysql slaves ignore too-big packets? they are only happening on a database that i don't want to replicate anyway.

thanks
-jsd-


-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]



Reply via email to