Outline of MySQL: Difference between revisions

Revision as of 06:09, 10 June 2015

Revision as of 06:33, 10 June 2015

Line 60:

** [[MySQL Cluster]] – technology providing shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.[2] MySQL Cluster is implemented through the NDB or NDBCLUSTER storage engine for MySQL ("NDB" stands for Network Database).

** [[MySQL Federated]] – allows a user to create a table that is a local representation of a foreign (remote) table. It utilizes the MySQL client library API as a data transport, treating the remote data source the same way other storage engines treat local data sources whether they be MYD files (MyISAM), memory (Cluster, Heap), or tablespace (InnoDB).

* [[NDB Cluster]] – storage engine for storing tables of rows. NDB Cluster can concurrently support access from many types of API processes including from a MySQL server, Memcached, JavaScript/Node.JS, Java, JPA and HTTP/REST. All API processes can operate on the same tables and data stored in the NDB Cluster.

** sequence –

** SphinxSE –

Line 72 ⟶ 73:

* [[Infobright]] –

* [[MySQL DataController]] –

* [[NDB Cluster]] –

* [[Peewee ORM]] –

* [[Toad Data Modeler]] –