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 Stack Job Scheduler Reporting Cluster Reporting MySQL read slaves MySQL Replication Slaves Apache Lighttpd DRBD LVM I/O device MySQL Failover Cluster Application Server Linux Virtual Server Load Balancer MySQL SQL nodes MySQL NDB Cluster MySQL Cluster Cacti Nagios mon