-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 i havn't tried mysql 5.x but with 4.x a master/slave replica should work just fine - as long as you have bin-logging turned on. when the master can't see the slave, it just logs locally, then when it can see the slave, it dumps all the changes to it. it seems to work fine for me. i would also suggest using OPENVPN for the SSL VPN between sites, i used this in a similar situation and it was an extremely stable solution and could easily handle the 45mb DS3 we were trying to push to the main site - - just make sure you change the config from UDP to TCP for the SSL tunnel protocol - that worked a bit better for us. jason reynolds wrote: > I have not looked into replication yet (will do now). > > If it was realtime that would be amazing, but daily would be sufficient. > When you mention replication is a problem with a poor connection I was > looking more into what would happen if it went down. The internet connection > is a good one, but you never know what will happen. > jason > > On 8/10/07, Brock Noland <brockn at gmail.com> wrote: >> At least with Mysql 4, replication is a hassle to "sync" when the >> connection drops or a server crashes. If your expecting a someone >> unreliable connection, I doubt that will work. >> >> How current does the remote location need to be? >> >> Brock >> >> On 8/10/07, Andrew Zbikowski <andyzib at gmail.com> wrote: >>> Have you looked into MySQL Replication or Clustering? >>> >>> http://dev.mysql.com/doc/refman/5.0/en/replication-intro.html >>> >>> http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster.html >>> >>> >>> -- >>> Andrew S. Zbikowski | http://andy.zibnet.us >>> SELECT * FROM users WHERE clue >0; >>> 0 rows returned >>> >>> _______________________________________________ >>> TCLUG Mailing List - Minneapolis/St. Paul, Minnesota >>> tclug-list at mn-linux.org >>> http://mailman.mn-linux.org/mailman/listinfo/tclug-list >>> >> _______________________________________________ >> TCLUG Mailing List - Minneapolis/St. Paul, Minnesota >> tclug-list at mn-linux.org >> http://mailman.mn-linux.org/mailman/listinfo/tclug-list >> > > > ------------------------------------------------------------------------ > > _______________________________________________ > TCLUG Mailing List - Minneapolis/St. Paul, Minnesota > tclug-list at mn-linux.org > http://mailman.mn-linux.org/mailman/listinfo/tclug-list -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (GNU/Linux) iD8DBQFGvMFRvE9HrEfeE4cRAuEiAJ9mPw/lbO1VOwTFOaQnxSWhIAwWlgCghS9t LBb9RHtHfDUD/7lLZGZvy5E= =j5Df -----END PGP SIGNATURE-----