MySQL Cluster - Technocation, IncMySQL集群technocation，公司.ppt

* Monitoring Status Monitoring Recovery Automated Management Cluster-Wide Management Process Management On-Line Operations (Upgrades / Reconfiguration) HA Operations Disk Persistence Configuration Consistency HA Agent Operation MySQL Cluster Manager 1.0 Features MySQL Cluster Manager Current Development Projects On-line add-node mysql add hosts --hosts=5,6 mysite; mysql add package --basedir=/usr/local/mysql_7_0_7 –hosts=5,6 7.0; mysql add process --processhosts=mysqld@3,mysqld@4,ndbd@5,ndbd@6 mycluster; mysql start process --added mycluster; Restart optimizations Fewer nodes restarted on some parameter changes DataNode DataNode mysqld MgmtNode mysqld MgmtNode 31 32 33 34 DataNode DataNode mysqld mysqld 31 32 33 34 DataNode DataNode 35 36 mysqld MgmtNode mysqld MgmtNode Application: Service Delivery Platform Roaming platform to support 7m roaming subscribers per day FIFA World Cup 2010 Database supports AAA, routing, billing, messaging, signalling, payment processing MySQL Cluster 7.1 delivered 1k TPS on 1TB data with carrier-grade availability Key business benefits Local carriers to monetize new subscribers Users enjoy local pricing with full functionality of their home network Reduced deployment time by 75% * ”MySQL Cluster 7.1 gave us the perfect combination of extreme levels of transaction throughput, low latency carrier-grade availability. We also reduced TCO by being able to scale out on commodity server blades and eliminate costly shared storage” - Phani Naik, Head of Technology at Pyro Group * “Since deploying MySQL Cluster as our eCommerce database, we have had continuous uptime with linear scalability enabling us to exceed our most stringent SLAs” — Sean Collier, CIO COO, Shopatron Inc Shopatron: eCommerce Platform Applications Ecommerce back-end, user authentication, order data fulfilment, payment data inventory tracking. Supports several tho