by Arlyn R
MySQL’s answer to NoSQL competitors in the big data web market: MySQL Cluster 7.2. Joab Jackson (2012) authored, “Oracle Preps MySQL Cluster for Web Use,” documenting some of the features that is expected to boost performance for the open-source DBMS. A significant feature of the upgrade allows query workload execution to occur on a server local to the data (adaptive query localization). Thus, intensive join queries that include multiple tables will compute and return results substantially faster; per Oracle’s claim, “…70 times faster than what previous versions of MySQL Cluster could do” (as cited by Jackson, 2012). Another benefit to the upgrade is the ability to shard across individual data nodes located in varying data centers, which contributes to the performance boost upgrade. MySQL Cluster 7.2 will also include an application programming interface, Memcached. This API allows for easier and rapid access to frequently used queries by storing the common key-value calls in RAM. Memcached extends MySQL Cluster’s usability since the API is also utilized by firms that deal with large data sets such as Facebook. In conclusion, MySQL Cluster 7.2 has leveraged the benefits of both SQL and NoSQL databases by increasing usability, scalability and overall performance.
As we learn to transform the conceptual model of a database to a relational model, reading about real-world applications of databases helps solidify concepts and terms. Industry related articles are helpful to keep abreast on current events that can give us insight on the future of database models and applications. I liked this article in particular because it provides examples of how a DBMS can increase scalability and performance. NoSQL is a term recently used for open-source non-relational databases that utilize unstructured query language. NoSQL databases are widely implemented in web applications because of the emphasis on speedier run-time performance in large-scale data sets.
MySQL uses structured query language and the relational model. Furthermore, MySQL Cluster increases scalability by allowing configuration onto any number of nodes. With the 7.2 update, data centers can store individual data nodes, promoting further scalability features. Although MySQL Cluster 7.2 may seem like a defensive move to NoSQL’s offense, I think it is aligning itself, Oracle, well into the web application and telecommunications market.
Jackson, J. (2012, February 15). Oracle Preps MySQL Cluster for Web Use. PC World. Retrieved April 14, 2012 from http://www.pcworld.com/businesscenter/article/250005/oracle_preps_mysql_cluster_for_web_use.html#tk.mod_stln