Author: Pavel Zimahorau

Lead Database Developer at Epam

Using Different MySQL Storage Engines in Database Design

Any database architect designing a MySQL database faces the issue of selecting the proper storage engine. Usually, an application uses only one engine: MyISAM or InnoDB. But let’s try to be a little more flexible and imagine how different storage engines can be used. The Initial Data Model To begin, let’s build a simplified data model for a CRM (customer relationship management) system that we’ll use to illustrate the point.