« Previous 1 2 3
A storage engine for every use case
Data Machine
Final Words
The MySQL default storage engine InnoDB is fast, feature-rich, extremely advanced, and normally the best choice for most tables.
Companies like Facebook that use MySQL on a very large scale and with intensive workloads have developed storage engines that are more tailored to their needs (e.g., to optimize physical and system resource usage). The same optimizations can prove useful for much smaller companies if the code is released as open source.
When it comes to deciding what data to write and how, you have a great deal of freedom in the choice of storage engines, many of which have been designed for specific needs, such as a very high compression ratio or importing and exporting data to different technologies.
Storage engines make MySQL extremely flexible, and exploring them can open interesting possibilities.
Infos
- MySQL bugs: http://bugs.mysql.com
- Apache Thrift: https://thrift.apache.org
« Previous 1 2 3
Buy this article as PDF
(incl. VAT)
Buy ADMIN Magazine
US / Canada
UK / Australia
Related content
-
MariaDB vs. MySQL
MariaDB is a cousin of MySQL – but not an identical twin.
-
Speed up your MySQL database
Sometimes, the throughput or response time of your MySQL database does not meet expectations. In this article, we show how you can handle some MySQL performance problems. -
PowerDNS Authoritative server high availability with MariaDB Galera
Combining the PowerDNS Authoritative server daemon with MariaDB's multiprimary Galera cluster allows a simple yet robust solution for your DNS needs. -
MySQL is gearing up with its own high-availability Group Replication solution
Oracle recently introduced Group Replication as a trouble-free high-availability solution for the ubiquitous MySQL. -
New features in MariaDB 10.3
What lacked maturity in MariaDB 10.2 has now been sorted out in version 10.3. We look at the benefits you can reap now.