MySQL Data Storage & Redundancy
Summary
MySQL is a relational database management system that stores and maps data in an organized, strategic method. MySQL is one of the most well respected, highly used, and secure database management systems available on the market. It runs as it's own server, allowing for constant optimization and tweaking for the highest performance requirements.
Integration
Our decision to use MySQL as our storage engine was made carefully based on some other major storage engines on the market. We decided to go with it, and integrated it into our platform core, due to it's power and general community. It's ability to be optimized for specific query types, it's security against large scale denial of service attacks, as well as it's data integrity and ability to be fitted well for caching mechanisms led as our primary reasons.
With our platform's infrastructure, we're able to optimize our database for the highest level of performance due entirely to our multiple layers of caching that sit before any query that hits our system. Additionally, we've set up our system with master, slave and redundant database servers for the highest level of data integrity.
Finally, in order to partition client data to the highest possible level, our system has been setup for remote database connections, allowing clients to move their database to their own MySQL database engine with little to no effort. This capability comes from the way we designed our database infrastructure to be reliant on a skeletal approach which maps empty tables for new clients.
Result
A large part of the planning and development of the Clearmix PlatformTM was centered around the database, and how to optimize it, normalize it, and make it so flexible that we never reach a peak or data intensive threshold that we can't handle.
Our system supports full UTF8 Unicode, ensuring there are no limits on what type of content your community can create, and sits behind thoughtful layers of caching that optimize your database for very little stress, even with the highest levels of traffic.
