Tips in using MySQL in AWS{Comments Off on Tips in using MySQL in AWS}


The next generation of storing data is in cloud computing. Amazon cloud offers these kinds of services few things can be done to overcome most of the performance issues. Amazon uses elastic book storage (EBS) which appropriates network resources to its users and which has performance that varies depending on availability; this is their greatest weakness. Ways to mitigate this is taking advantage of the cache in browsers, objects, queries, and data. Many MySQL settings can be tuned for performance benefits such as increasing buffer sizes and even things like using a high-performance file system like XFS. In addition to performance benefits, DBA’s need to ensure data redundancy taking use of multiple data centers spread across the globe so as to have options for when a server goes down; recovery is equally important where DBA’s need to automate getting their servers back up and running. Some companies like Netflix even run programs that randomly take out servers during the day so as to test out their ability to stay on-line.

Currently DBA’s should be looking into alternate routes for data centers, specifically into the cloud; its the future of databases despite the current problems it poses. Even testing cloud services out and collecting information regarding user experiences with low performance can set the groundwork into implementing a fully operational cloud based data center in the future.

Colleges and classes as well should update their curriculum to reflect this change in the model for data centers. Though the basic operations remain the same, specifically concepts and syntax in using SQL, alternatives to the current implementation of these systems should be looked into so as to be prepared for the future.

References

Hull, Sean. (2012, April 30). Master MySQL in the Amazon Cloud. Retrieved May 6, 2012, from http://www.pcworld.com/businesscenter/article/254706/master_mysql_in_the_amazon_cloud.html