InfiniDB iis a software-only, modular solution. The two core modules are the User Module and the Performance Module:
- User Module: The User Module is made up of a small MySQL instance and a number of InfiniDB processes that handle concurrency scaling. The User Module is also responsible for breaking down SQL requests and distributing the various parts to one or more Performance Modules that actually retrieve requested data from either memory caches or disk. Finally, the User Module assembles all the query results from the various participating Performance Modules to form the complete query result set that is returned to the user. Note there can only by one User Module in the InfiniDB Community Edition and more than one User Module in an InfiniDB Enterprise configuration, which provides a high availability configuration and a method for query workload balancing.
- Performance Module: The Performance Module is responsible for storing, retrieving, and managing data, processing block requests for query operations, and passing it back to the User Module(s) to finalize query requests. The Performance Module selects data from disk and caches it in a shared nothing data cache that is part of the server on which the Performance Module resides. There is only one Performance Module in the InfiniDB Community Edition. InfiniDB Enterprise accomplishes its MPP benefits by allowing the user to configure as many Performance Modules as they would like; each additional Performance Module adds more cache to the overall database as well as more processing power.The end result is linear performance gains as more Performance Modules are added
Starting with User Module and Performance Module building blocks, with InfiniDB Enterprise, you can configure your system in any combination to meet your user, data, and performance requirements. The more User Modules you add, the more concurrect connections are supported, and you have the opportunity to configure a high-availability setup. The more Performance Modules you add, the more you are able to scale performance and database size.
