Dear Friends,
Considering what a backup is done with the method following:
1. One master server replicate to one slave server.
2. The master server handle all manipulations and transactions of
data (all tables are InnoDB type).
3. The slave server is exclusively used for to make backups.
4. The replication of the slave server is interrupted (stop slave
statement).
5. The slave server is correctly shutdown.
6. One copy of the MySQL's data directory is done via operating
system commands.
7. The slave server is started.
8. The replication of the slave server is started (start slave
statement).
In case problems with the master server, where is needed restore data from
backup, is done the following:
A. One copy is restored to MySQL's data directory in master server
and also in slave server.
B. The master server is started.
C. The slave server is started.
D. The replication of the slave server is started.
My questions are:
- The copy restored (A) will function in both servers?
- The restart of the slave's replication (D) must be done with reset slave
or start slave statement?
- Exist a better method (1-8) to make consistency backups of the
transactional databases without interrupt or block the master server and
without use the InnoDB Hot Backup tool?
All sugestions will be welcome.
Thanks in advance,
Renato Cramer.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
