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? Consider that at least one table is InnoDB and does use transactions. There may be others as I develop the database further.
Additionally, where does MySQL write it's transactions? If the power to the box dies and the system crashes, What does MySQL do to "recover"? What about tables that are not InnoDB? Thanks. -- .''`. Carl B. Constantine : :' : [EMAIL PROTECTED] `. `' GnuPG: 135F FC30 7A02 B0EB 61DB 34E3 3AF1 DC6C 9F7A 3FF8 `- Debian GNU/Linux -- The power of freedom
pgp00000.pgp
Description: PGP signature
