Newsql is the abbreviation for a variety of new scalable/high-performance databases, which not only have NoSQL storage management capabilities for massive amounts of data, but also maintain a legacy database that supports acid and SQL features. Newsql is a new type of relational database management system that seeks to provide the same extended performance as the NoSQL system for OLTP (read-write) workloads, and still maintains features such as acid and SQL (scalable and acid and relational and/or sql-access)). The term "historical newsql" is presented Newsql by 451 Group's analyst Matthew Aslett in his research paper. It refers to a new type of database system that challenges established database vendors. Development trends NoSQL Curtain Call, Newsql debut [1] nosql will change the scope of the data definition. It is no longer the original data type, such as Integer, floating point. The data may be the entire file. NoSQL may scare DBAs because they are worried about losing their own field. NoSQL databases are non-relational, horizontally extensible, distributed, and open source. MongoDB founder Dwight Merriman says NoSQL can be used as a Web application server, Content Manager, structured event log, server side of mobile applications, and fallback storage for file storage. Voltdb, the chief technology officer of the distributed Database company, Michael Stonebraker, says that NoSQL databases provide good scalability and flexibility, but they also have their own shortcomings. Because the Sql,nosql database system is not used, it does not have the features of highly structured queries. Other NoSQL issues include operations that do not provide acid (atomicity, consistency, isolation, and persistence). In addition, different NoSQL databases have their own query language, which makes it difficult to standardize the application interface. Stonebraker indicates that the lag of a database system can often be attributed to a number of factors. A buffer pool maintained by the database system for the purpose of recovering the log, as well as managing locked and locked data fields. These behaviors were found to consume 96% of the system's resources in VOLTDB tests. Examples of [2] existing NEWSQL system vendors include (sequential random) Clustrix, Geniedb, Scalarc, schooner, Voltdb, Rethinkdb, Scaledb, Akiban, CodeFutures, Scalebase, Translattice and Nimbusdb, and drizzle, MySQL cluster with NDB and MySQL with Handlersocket。 The latter includes Tokutek and Justone DB. The related "Newsql as a Service" category includes the Amazon relational database service, Microsoft Sqlazure,xeround and Fathomdb. [3] System Classification Newsql System Although the internal structure varies greatly, but they have two significant common characteristics: (1) They all support relational data model, (2) They all use SQL as their main interface. The first known newsql system is called H-store, which is a distributed parallel memory database system. At present, the Newsql system is broadly divided into three categories: the new architecture of the first type of NEWSQL system is a new database platform, they have adopted different design methods. They are roughly divided into two categories: (1) This type of database works on a node of a distributed cluster, where each node has a subset of data. A SQL query is executed on a node that is divided into query fragments sent to its own data. These databases can be scaled linearly by adding additional nodes. The existing databases are: Google spanner, Voltdb, Clustrix, NuoDB. (2) These database systems usually have a single primary node of the data source. They have a set of nodes that are used for transaction processing, which, after being connected to a particular SQL query, takes all the data it needs from the primary node and executes the SQL query before returning the result. The second class of SQL engine is a highly optimized SQL storage engine. These systems provide MySQL with the same programming interface, but the scalability is better than the built-in engine InnoDB. This kind of database system has: Tokudb, Memsql. Transparent shards such systems provide the middleware layer of the Shard, and the database is automatically segmented to run on multiple nodes. This kind of database package expands: Scalebase,dbshards, Scalearc. Transfer from: Baidu Encyclopedia
newsql--optimized SQL Storage engine (TOKUDB, memsql) +?
