You are here

MySQL Architectures Overview

Database Architecture & Design

Application logic in the middle tier?

Reduce money spent on software licenses by moving logic to the middle tier. This means moving stored procedures into the application server or web server layer where it is much cheaper to scale out. Reducing or eliminating business logic running in the DB may reduce Database CPU utilisation and hence save support costs for the DB Portability is key! [1]

The complete Open Source MySQL High Availability and Scale-Out Architecture Stack

Click on the map to get to you favourite mater...

Architecture StackJob SchedulerReporting ClusterReportingMySQL read slavesMySQL Replication SlavesApacheLighttpdDRBDLVMI/O deviceMySQL Failover ClusterApplication ServerLinux Virtual Server Load BalancerMySQL SQL nodesMySQL NDB ClusterMySQL ClusterCactiNagiosmon

Legend