* Jeremy Zawodny ([EMAIL PROTECTED]) wrote: > On Tue, Jun 24, 2003 at 09:14:18PM -0700, Carl B. Constantine wrote: > > I want to be able to take a database running on a primary server and > > duplicate/mirror it on a secondary server. I want to be able to update > > the secondary server on a selectable interval (every 15 mins, every > > hour, etc). What is the best way to accomplish this task? > > You'd need to start and stop replication on the slave using a bit of > custom code. > > See the the replication related commands in the manual.
Will do. thank you. Here is another question, is it possible for some people to work on the "master" and some on the slave, and then merge the data back and forth so that they are both the same or does it only work one way thus the DB's are out-of-sync? > > Additionally, where does MySQL write it's transactions? > > To a transaction log. :-) ha ha. I meant physically. > > If the power to the box dies and the system crashes, What does MySQL > > do to "recover"? What about tables that are not InnoDB? > > InnoDB tables scan the log for transactions that must be committed or > rolled back. MyISAM tables are not transactional. Ok, That confirms what I thought. Thanks. -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `' GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `- Debian GNU/Linux -- The power of freedom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
