...
Warning |
---|
We are in the process of understanding this process in greater detail. Initial trials suggest that this sequence, as recommended by AWS, does not work. We have found that the snapshot will not proceed until the MySQL session holding the locks releases the locks or exits (which releases the locks). Be aware that your database may have MyISAM tables in the internal schemas MySQL uses for operations. We are not sure what to do with those. It may be the case that trying to flush-and-lock them Initial trials suggest that flushing-and-locking those tables along with your own tables will block the snapshot from proceeding while flushing-and-locking just your own MyISAM tables will allow snapshotting to proceed as normal.
beginning (or at least completing). Snapshot creation times seem nominal if only your own MyISAM tables are flushed-and-locked, leaving out the internal MyISAM tables. Read Replicas
|
Resources
- Amazon Relational Database Service User Guide. This document has a fair amount to say about MyISAM tables–mostly warnings.
- AWS RDS FAQs. Search for MyISAM on the page)