solidDB for MySQL Architecture Overview

enterprise.gif(24.5 K)

切换到幻灯片模式

solidDB for MySQL Architecture Overview
solidDB for MySQL is a turbo-charged version of MySQL database that leverages solidDB Storage Engine to support heavy transaction volumes and large numbers of concurrent users. MySQL users who desire additional performance and scalability for their transactional applications should consider solidDB for MySQL because it is:

Built on MySQL; Behaves like MySQL
Fast and Scalable
Designed for Transactional Applications
Easy to Manage
Robust and Reliable



solidDB for MySQL consists of MySQL Server and solidDB Storage Engine

Built on MySQL; Behaves like MySQL
solidDB for MySQL is a complete relational database management system (RDBMS) that combines MySQL Server, solidDB Storage Engine and MyISAM storage engine.The product that users install, configure and access is 100% compatible with MySQL because it includes exactly the same code as the regular MySQL database that users already know. As a result, application developers access solidDB for MySQL with the same MySQL drivers and tools that have been developed by MySQL AB, its ecosystem partners, and the community. solidDB Storage Engine provides a fast, scalable, transactional engine to store and manage data, while MySQL Server offers the "upper layers" of the database stack. These upper layers include the SQL interface, parser, optimizer, connection pool, management services and utilities as well as the database framework with configuration files, directory structure, and command line tools that MySQL users already know. MyISAM storage engine stores the data dictionary and provides an efficient engine for non-transactional applications.

^ Return to top



Fast and Scalable
solidDB for MySQL is designed to take advantage of multiprocessor/multi-core hardware configurations. Because it leverages the multi-threaded design of solidDB Storage Engine, it performs well with large numbers of concurrent users. The record performance and scalability of solidDB for MySQL on multiprocessor systems is demonstrated in TM1 Public Benchmark at www.solidDB.com/TM1Results.

Unique to solidDB for MySQL is the ability to implement both optimistic and pessimistic concurrency control. This lets application developers optimize performance of transactional applications that have large numbers of concurrent users.

Configurable logging and snapshot-consistent checkpointing in solidDB for MySQL allow users to balance the durability and performance of their database. solidDB for MySQL also offers a unique, memory-based differential index named "Bonsai Tree". This mechanism enables solidDB for MySQL to scale exceptionally well under "hot spot" database workloads when there are a large number of concurrent client connections and the database runs on multiprocessor/multi-core hardware configurations.

^ Return to top



Designed for Transactional Applications
solidDB for MySQL leverages solidDB Storage Engine, which is a multi-threaded, transactional storage engine for MySQL Server. It is designed for mission-critical implementations that require a robust, transactional database able to fully leverage multiprocessor environments to support heavy transaction volumes and large numbers of concurrent users. solidDB Storage Engine supports full ACID compliance with configurable transaction isolation levels, both optimistic and pessimistic concurrency control, Multi-Version Concurrency Control (MVCC) with non-blocking reads and writes, row-level locking, and support for foreign keys and referential integrity.

^ Return to top



Easy to Manage
A powerful utility included with solidDB for MySQL backs up solidDB tables consistently and efficiently. This SQL-based on-line utility doesn't interfere with normal business operations and safely runs while applications modify transactional data. Dynamic configuration parameters allow administrators to configure the server online to add data files, change logging level, modify checkpoint interval, set transaction lock timeouts, and specify backup directory location, without restarting the server. solidDB for MySQL can be monitored and managed using MySQL Network Monitoring and Advisory Service.

^ Return to top



Robust and Reliable
solidDB Storage Engine is based on the same code that has been shipping as part of Solid's database products since 1994. There are over 3,000,000 of instances running in world-wide production in applications such as class-5 switches, network management frameworks, trading room applications, retail point-of-sale systems, emergency location services, and storage systems. This proves that over 240,000 lines of solidDB Storage Engine code have met the requirements of mission-critical production deployments for more than a decade.

solidDB for MySQL Architecture Overview
The following illustration depicts how solidDB for MySQL is built.





solidDB Storage Engine is fully aligned with MySQL's storage engine integration framework-MySQL's Pluggable Storage Engine Architecture (PSEA). PSEA offers a standard set of interfaces that solidDB leverages to optimally integrate with the "upper layers" of MySQL Server. This alignment ensures an efficient and future-proof integration point between solidDB Storage Engine and MySQL Server.

Licensing and Support
solidDB for MySQL is licensed under GNU GPL. We encourage you to try it and provide feedback through Solid's Open Source Community. You can submit suggestions and questions through the Forums.

Download the datasheet >>

To download solidDB for MySQL, click here >>.

solidDB for MySQL is available under a free/libre open source license (GPL).

Solid offers MySQL Enterprise for solidDB to customers who wish to have production support for solidDB for MySQL.

文章来自: 本站原创
标签: mysql Architecture solidDB Overview