Scaling with MySQL using Materialized Views and a Shared Everything architecture

ScaleDB is a transactional storage engine for MySQL. It is based on innovative indexing technology that provides high performance for large, disk based data sets. It provides for MySQL the functionality of Materialized Views and as it operates over the source data, it obviates the need to maintain a replica and synchronize between the source data and the replica.

ScaleDB’s architecture is a Shared Everything architecture that allows multiple servers to access a single database in a way that updates to the database are synchronized among the servers. Whenever a server queries data, it is guaranteed that it will receive the current version. This approach supports growth in the data size or growth in the number of users by adding additional servers to the cluster with no disruption to existing processes. It eliminates the need to partition the data.

In this session, we will demonstrate how views can be materialized using MySQL and ScaleDB. We will also demonstrate a Shared Everything architecture with MySQL and ScaleDB. The demo will show access to a database from multiple servers on a cluster thus providing parallel computing power at low cost.