Updating a mysql database
Then, Amazon RDS takes a snapshot of the source instance and creates a read-only instance from the snapshot.Amazon RDS then uses the asynchronous replication method for the DB engine to update the Read Replica whenever there is a change to the source DB instance.However, you can create a Read Replica that has a different storage type from the source DB instance based on the options listed in the following table. You cannot configure a DB instance to serve as a replication source for an existing DB instance; you can only create a new Read Replica from an existing DB instance.
Amazon RDS sets up a secure communications channel between the source DB instance and a Read Replica if that Read Replica is in a different AWS Region from the DB instance.The Read Replica operates as a DB instance that allows only read-only connections.Applications connect to a Read Replica the same way they do to any DB instance.This is a really stupid article, and the only reason I’m writing it is in the hopes that I’ll finally stop forgetting the syntax and having to google which order the My SQL REPLACE function’s arguments are supposed to go.And then when I do try to look it up, I almost always end up on the documentation page for My SQL’s other REPLACE command…. If you don’t know how to open a My SQL prompt, well, you probably shouldn’t be reading this article.
Hope his tutorial was useful and please feel free to comment and suggestions, questions or fixes.