Scaling with MySQL using Materialized Views and a Shared Everything architecture

Storage Engine Development and Optimization
Location: Ballroom F Level: Novice

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

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

Moshe Shadmon


Moshe Shadmon is the founder and CTO of ScaleDB. Moshe is the creator of the ScaleDB indexing technology and has more than 20 years of experience in both technical and management roles. Moshe’s technical experience has been in the areas of high performance indexing solutions as well as the development of a unified solution for structured and semi-structured data. Since 2006, Moshe has become increasingly interested in the opportunity presented by the open source databases and founded ScaleDB to develop a database engine for MySQL targeting performance, efficiency and scalability with the largest data sets.

  • Kickfire
  • Zmanda, Inc.
  • Continuent
  • EDS
  • JasperSoft
  • Sun Microsystems
  • Symantec Anti-Virus Software
  • XAware
  • Data Direct Technologies
  • Dolphin Interconnect Solutions
  • Hewlett Packard
  • Infobright, Inc
  • Linagora
  • Microsoft
  • OpSource
  • Oracle
  • Pentaho
  • R1Soft
  • Red Hat
  • Ticketmaster
  • TechRepublic

Contact Us

View a complete list of MySQL contacts.