Auto Backup for MySQL vs. MySQL Data Access Components vs. Oracle Data Access Components vs. memcached Comparison Chart

Enjoy the highest performance and unlimited possibilities when working with MySQL. MySQL Data Access Components (MyDAC) is a library of components that provides direct access to MySQL and MariaDB from Delphi and C++Builder, including Community Edition, as well as Lazarus (and Free Pascal) on Windows, Linux, macOS, iOS, and Android for both 32-bit and 64-bit platforms. Applications based on MyDAC can connect directly to MySQL server or work through the MySQL client library. MySQL Data Access Components are designed to help programmers develop MySQL database applications faster and easier. MyDAC is a complete replacement for standard MySQL connectors and presents an efficient alternative to the Borland Database Engine (BDE) and standard dbExpress driver for access to MySQL.

You can think of it as a short-term memory for your applications. memcached allows you to take memory from parts of your system where you have more than you need and make it accessible to areas where you have less than you need. The first scenario illustrates the classic deployment strategy, however you'll find that it's both wasteful in the sense that the total cache size is a fraction of the actual capacity of your web farm, but also in the amount of effort required to keep the cache consistent across all of those nodes. With memcached, you can see that all of the servers are looking into the same virtual pool of memory. Also, as the demand for your application grows to the point where you need to have more servers, it generally also grows in terms of the data that must be regularly accessed. A deployment strategy where these two aspects of your system scale together just makes sense.