Oracle has MySQL Cluster 7.2 was released. The new MySQL version for clusteromgevingen offers a memcached api, and it would be complex queries faster than it can process. Therefore it must be better able to compete with NoSQL.
MySQL Cluster is an Oracle-developed version of the open-source MySQL database and is made suitable to run on various servers within a cluster. The software is redundant: if one of the servers fails, the cluster will continue to run. Also, can a MySQL Cluster, in theory, infinitely be scaled thanks to this ‘shared nothing’architecture.
To clusteromgevingen which databases based on MySQL Cluster running better performance, has Oracle in version 7.2 support for the memcached api to the software are added. Memcached, which is a bsd-licensed, offers the possibility of small pieces of information by using a hash table to store in ram.
Via the memcached-cachingmechanisme, among others, by sites like Facebook, Reddit and Twitter is being used, the access to databases considerably be accelerated. With the support for the api, which is completely open, would developers MySQL Cluster according to Oracle to a the same level of performance able to lift as NoSQL databases.
Oracle promises in MySQL Cluster 7.2 also improved performance by means of “query-localisation’. This would be complex queries involving data from multiple tables is requested, up to seventy times faster can be processed. The performance gains would be achieved by individual nodes within a cluster, a large part of such ‘cross-table’queries to execute before the result is forwarded to the server that the query originally was offered.
In MySQL 7.2 must also have the scalability are improved. This allows Oracle that databasenodes within a cluster now in multiple data centers. It is also the management tool, MySQL Cluster Manager is updated. MySQL Cluster is free to be downloaded. Who want support from Oracle will the bag need to attract: Carrier Grade Edition-supportlicenties start at $ 10,000.