Today, many websites use InnoDB for OLTP with Memcached as a caching layer to reduce latency and increase performance. But, Memcached is not ACID and the application is responsible for ensuring that the cached data is consistent with the database of record.
Now, you can combine the ease of use of Memcached, with the power of MySQL Cluster. Using the standard Memcached API, the application sends reads and writes to the Memcached process, which in turn invokes the Memcached Driver for NDB (which is part of the same process). This calls the NDB API, providing very quick access to the data held in MySQL Cluster's data nodes, completely bypassing the SQL layer.
The solution has been designed to be very flexible, allowing the application architect to find a configuration that best fits their needs. It is possible to co-locate the Memcached API in either the data nodes or application nodes, or alternatively within a dedicated Memcached layer.
Partager