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. > Additionally, where does MySQL write it's transactions? To a transaction log. :-) > 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. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.13: up 22 days, processed 716,910,347 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
