Thanks much... Does this work with InnoDB tables as well as MyISAM? ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Mauro Marcellino" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, November 01, 2003 2:47 AM Subject: Re: Offline Replication with MySQL
> On Fri, Oct 31, 2003 at 01:45:09PM -0500, Mauro Marcellino wrote: > > I currently have systems on multiple networks that are only connected via FTP. > > > > On one network (network 1) I have replication running with one > > master and one slave (Both running Windows 2000 Server) > > > > On another network (network 2) I have s Sun V880 running Solaris 8 > > and it is only connected to network 1 via FTP. What are my options > > with MySQL to keep the box on netowork 2 somewhat in synch with > > those on network one? I know MS SQL server has something called log > > shipping to do updates with this scenario, does MySQL have something > > similar? > > You could FTP completed binary logs from the master and replay them on > the Solaris box. It'd take a bit of scripting, but it should work. > > Jeremy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 4.0.15-Yahoo-SMP: up 48 days, processed 1,806,304,337 queries (432/sec. avg) > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
