Database Storage Engine

Database storage engine is a mechanism employed by database management software that defines how it stores and handles data. Different DBMS have different approaches to working with underlying HDD files and memory. Technically, storage engines can be compared by the following parameters:

  • Supported types of data. When comparing supported data types, you need to remember two things. Firstly, databases perform very differently when managing large objects, such as CLOB (character large object), BLOB (binary large object) and other. Some DBMS, such as Oracle, are optimized for working with them, but for most systems reading and writing large objects is slower than storing them as simple HDD files (but of course the latter requires more programming on client side). Secondly, different database management systems may have different names for similar types of data. This is especially important to keep in mind if you are planning migration between two DBMS.
  • Support for transactions. Transaction is an operation that is made of multiple SQL statements, and succeeds only if each statement succeeds. For example, purchasing an item in a shop requires you to add a record into the ORDERS table and update the STOCK table. If one of the operations fails, you need to undo the other one – that’s what transaction-safe storage engines do automatically.
  • Indexing. The key idea of indexing is increasing database reading speed by creating an additional data structure that contains sorted values and can be searched through using binary search. Storage engines may have very different implementations of indexing techniques, but the basic idea is always the same: indexing increases data retrieval and improves general performance of the database. The downside of indexing is that indexed tables occupy more disk space.
  • Locking types. Locking prevents the database from being corrupted when there are multiple users trying to concurrently update it. There are several mechanisms and levels of locking: some storage engines lock only specific rows, while the other lock tables completely.

Handy Backup has a number of database backup plug-ins designed for safeguarding databases of different types. For example, the MySQL Backup plug-in can back up data from any MySQL storage engines including MyISAM, InnoDB and other. To learn about it, please refer to MySQL Backup.

Handy Backup Small Server

Version 8, built on 4 March, 2019. 104 MB
Backup Software from Novosoft LLC. 249 USD per license.

Handy Backup Small Server

With the Small Server edition of our utility you can back up and restore MySQL, MSSQL, Oracle and other databases. Try free for 30 days!

Each storage engine used in a database must be chosen with regard to the application’s design. For example, non-transaction-safe engines, such as MyISAM in MySQL, usually provide higher reading speed than transaction-safe engines, and can be a better choice if your tables don’t get updates simultaneously with reads.

Database Storage Engines and Replication

Replication is a process of automated synchronization of two databases that allows distributing database load and optimizing the way application reads, writes and processes information. The beauty of this technology is that it doesn’t expect Master database (the one acting as a source of data) and Slave database (the one synchronized) to share identical storage engines.

In a Master-to-Slave replication configuration it is recommended to assign each database its own role, and have one optimized for storing and processing data, and the other for retrieval. To learn the recommendations for MySQL database, please see MySQL Replication.

Download Handy Backup

Version 8, built on 4 March, 2019
104 MB

See also:

See all terms from Databases...

Backup Terms Glossary

Contact Us

support@handybackup.net

sales@handybackup.net

+1 (707) 703-13-11

Term of the Day

  • Glossary Category: Software
    “In the “Software” category you can find meanings of different software-related terms and descriptions of popular software used by Windows...”

Backup Software Glossary

Current glossary explains various terms that you may come across while working with Handy Backup or other backup software.

Handy Backup is a backup utility for Windows Servers and PCs that is famous for its flexibility and ease of use.

The glossary contains 179 terms. The current section Databases contains 18 terms.

Other “Databases” Terms

  • MyISAM: Definition of MyISAM, Target Uses of the MyISAM Storage Engine
    “MyISAM is a storage engine employed by MySQL database that was used by default prior to MySQL version 5.5 (released in December, 2009). It is based...”
  • What Is phpMyAdmin
    “phpMyAdmin is a free web application that provides a convenient GUI for working with the MySQL database management system. It is the most popular...”
  • MySQL Clustering
    “MySQL clustering is a technology that allows distributing the MySQL database across multiple independent nodes, to eliminate every possibility of...”

Who uses our backup software?