The current situation of database cluster technology

Status cluster is not a new technology, each database vendors have their own mature solution, the current database cluster system is more successful application, the scope of application is more extensive: Oracle company ORACLE9 and IBM company DB2. Oracle9 using Shared-storage technology, DB2 chose Shared-nothing Technology, both of them have the length.

The most recent database cluster system is based on distributed computing, distributing data to each node, and all compute nodes process the data in parallel and summarize the results. Such a way is undoubtedly the most perfect. However, it is still not possible to achieve full functionality.

Oracle's current cluster scheme is RAC, the full name real application clusters, translated as "real-time application cluster", mainly supports oracle9i, 10g, 11g version.

The DB2 cluster scenario is PureScale, DB2 PureScale is a new DB2 optional feature that allows you to extend a database to a set of servers through a "two-machine (active-active)" Configuration to deliver high levels of availability and scalability. In this configuration, the DB2 copy running on each host (or server) can read and write the same data at the same time.

The MySQL cluster scenario isMySQL Cluster, which allows the Cluster of an "in-memory" database to be deployed in a system that is not shared. With no shared architecture, the system can use inexpensive hardware and has no special requirements for hardware and software. In addition, because each component has its own memory and disk, there is no single point of failure. MySQL Cluster is made up of a group of computers, each running a variety of processes, including MySQL servers, NDB Cluster data nodes, Management servers, and (possibly) specialized data access programs. About the relationships of these components in Cluster.

The current situation of database cluster technology