Akiban Server is a full-featured, Java-based, standalone relational database. However it can also be configured to augment existing MySQL deployments. The option to plug into MySQL infrastructure lets you solve tough MySQL problems:
- Queries that take MySQL seconds or even minutes are executed 10-100x faster, every time
- There is no need for database replacements or migrations
- The Akiban solution does not require changes to application or SQL code
- It can be deployed without risk, the solution works with replicated data and has options for failover and High Availability
Configure Akiban Server as a Replicated MYSQL Slave
Using the Akiban MySQL Adapter, Akiban Server can be set up as a slave replicating from a MySQL master.
The deployment topology for this option is as follows:
The Akiban MySQL Adapter is a MySQL storage engine that communicates between a MySQL server and the Akiban Server. Once configured, the Adapter replicates the MySQL master to Akiban Server, performing the conversion from tables to table-groups in real-time. The standard binlog replication ensures that the Akiban Server is kept up-to-date with your master MySQL database without any application modifications.
Once deployed, there is no need for you to modify the original database: just define a set of Akiban table-groups and run your problem queries against the Akiban slave to realize the performance benefits.
Application Integration
Your application redirects problem queries to the Akiban Server via a direct connection. This ensures a minimal impact to your application and operations – any write activity and queries that are performing satisfactorily continue to be sent to your current MySQL servers.
A failover capability provides security and peace of mind. Should a server lose power or network communication become unavailable, your application can fail over to the original server to avoid any disruption in service. Akiban Servers can also be deployed in HA configurations.
Monitoring and administering the Akiban MySQL Adapter is identical to MySQL. For example, various tools in Maatkit can be used to measure replication lag and make sure the Akiban slave is synchronized with the MySQL master, and Cacti and Nagios can be used for unattended monitoring and alerting.
