In 4, its a pain to restart replication as writes have to be stopped. Binary logs have to copied over and then restarted. I heard google submitted some changes to improve replication though. Maybe its better now. Daily would be very easy as you could simply write a bash script to scp a db dump over. Brock On 8/10/07, jason reynolds <jeruvin at gmail.com> 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 > >