• UID623
  • Fans2
  • Follows1
  • Posts72

Seven things you have to know about RDS

More Posted time:Dec 8, 2016 10:15 AM
Seven things you have to know about RDS
1. Notes for RDS instance upgrading
There will be a transient disconnection of up to 30 seconds while upgrading RDS instances. You need to prepare for the flash in advance and set the program to auto reconnect to the RDS to avoid glitches and service downtime.
2. Risks of RDS network switching
In the process of switching between intranet and internet, RDS will be disconnected from the server. After the switch, update the connection address in the program in a timely manner. The switch between the intranet and internet will also lead to a change in the IP address.
3. RDS rollback risks
RDS supports data rollback, but only for the entire instance, not a single table or database. It is important to make backups of crucial data before the rollback to prevent data loss. Creating a temporary instance is recommended for rolling back part of the data or data in some tables. You can import the required data back to the production databases from the temporary instance.
4. Policy of RDS locking mechanism
RDS has a locking mechanism. If the storage space of your instance is full, the system will lock your instance in read-only status. It is recommended to conduct periodic checks on storage space usage. SMS alerts can also be configured in the RDS console.
5. RDS failover
RDS adopts a primary/standby mode to ensure high availability. When the primary database fails, RDS will switch to the standby database within 30 seconds. In the failover process, there will be an inaccessible period of (less than or equal to) 30 seconds. You need to set auto-reconnect of your program with RDS to avoid service downtime.
6. Data synchronization mode of RDS for MySQL
RDS for MySQL 5.1 synchronizes data between the primary and the standby databases in an asynchronous mode. This mode boasts high performance but with a certain possibility of data inconsistency between the primary and standby databases.
RDS for MySQL 5.5 adopts a semi-synchronous mode for data synchronization between the primary and standby databases. This mode decreases the write performance but greatly lowers the possibility of data inconsistency. If you have a very high requirement on data reliability (for example, financial systems), it is suggested that you purchase RDS for MySQL 5.5 or above.
7. What should I do after purchasing RDS?
After purchasing an RDS instance, you do not need to conduct basic database O&M (such as high availability, backup, and security patches). However, the following things are worth noting:
1) Check whether the CPU, IOPS, space, the number of connections of your RDS instance are adequate. If not, they need to be optimized or upgraded.
2) Check whether your RDS instances have performance problems, whether there are a large number of slow SQL queries, whether the SQL statements need optimization, and whether there are excess or missing indexes.
3) Check whether your RDS instances have web SQL injection warnings. If so, your database may be vulnerable to web SQL injection attacks. You need to modify the application to prevent such attacks.

Latest likes:

JeremyJeremy ElizabethElizab...