Re: problems w/ Replication over the Internet

2008-04-25 Thread Jan Kirchhoff
Hmmm... no more ideas or suggestions anybody? :( -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: problems w/ Replication over the Internet

2008-04-22 Thread Jan Kirchhoff
Eric Bergen schrieb: > TCP checksums aren't as strong as encryption. It's rare but corruption > can happen. > But it happens every other day? that means at least one error in 4GB of data (I have around 2GB of binlogs/day)? Every DVD-ISO you download would be corrupt (statistically)? > Where are

Re: problems w/ Replication over the Internet

2008-04-21 Thread Eric Bergen
TCP checksums aren't as strong as encryption. It's rare but corruption can happen. Where are you reading the positions from and how are you taking the snapshot to restore the slave? On Mon, Apr 21, 2008 at 12:30 AM, Jan Kirchhoff <[EMAIL PROTECTED]> wrote: > Eric Bergen schrieb: > > > Hi Jan, >

Re: problems w/ Replication over the Internet

2008-04-21 Thread Jan Kirchhoff
Eric Bergen schrieb: > Hi Jan, > > You have two separate issues here. First the issue with the link > between the external slave and the master. Running mysql through > something like stunnel may help with the connection and data loss > issues. > I wonder how any corruption could happen on a TCP

Re: problems w/ Replication over the Internet

2008-04-20 Thread Eric Bergen
Hi Jan, You have two separate issues here. First the issue with the link between the external slave and the master. Running mysql through something like stunnel may help with the connection and data loss issues. The second problem is that your slave is corrupt. Duplicate key errors are sometimes

problems w/ Replication over the Internet

2008-04-15 Thread Jan Kirchhoff
I have a setup with a master and a bunch of slaves in my LAN as well as one external slave that is running on a Xen-Server on the internet. All servers run Debian Linux and its mysql version 5.0.32 Binlogs are around 2 GB per day. I have no trouble at all with my local slaves, but the external one