Versions Compared

Old Version 8

changes.mady.by.user Paul Allen

Saved on

compared with

New Version 9

changes.mady.by.user Paul Allen

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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).

Read Replicas

  • Making Snaps from Read Replicas may also be in the solution mix. However, be aware the creating a new read-replica is based on a snapshot, so getting a good snapshot with stable/valid MyISAM table also may be problematic. 
  • RDS documentation warns to be sure to monitor the ReplicaLag metric if you have read replicas setup for MySQL RDS DBs containing MyISAM tables.

 

 

Resources