Provider for MySQL Server

Provides read/write access to feature data in a MySQL-based data store. Supports spatial data types and spatial query operations. Infra Suite can gather information, transmit exceptions, list data stores, and create connection objects. MySQL architecture supports various storage engines, characteristics, and capabilities.

Supported Versions

Infra Suite supports following MySQL Server versions:

• MySQL Server 5.0
• MySQL Server 5.1

Server Storage Engines

The MySQL architecture supports different storage engines. Choose an engine as needed, depending on its characteristics and capabilities, such as the following:

• MyISAM is a disk-based storage engine. It does not support transactions.
• InnoDB is a disk-based storage engine. It has full ACID transaction capability.
• Memory (Heap) is a storage engine utilizing only RAM. It is very fast.
• NDB is the MySQL Cluster storage engine.
• MERGE is a variation of MyISAM. A MERGE table is a collection of identical MyISAM tables, which means that all tables have the same columns, column types, indexes, and so on.