_OBCI(MySQL).ppt

Transcription

1 <Insert Picture Here> Web MySQL & memcached MySQL MySQL Principal Sales Consultant, Asia Pacific & Japan

2 Copyright 2010, Oracle. All rights reserved. 2

3 The world's most popular open source database

4 MySQL 60.5% PostgreSQL 51.9% : 3 (2009 PostgreSQL MySQL Oracle SQL Server MySQL PostgreSQL IBM DB2 : ITmedia 6 DBMS ITmedia ITR

5 MySQL: The World s Leading On-Line Database Powering 9 of the top 10 most trafficked sites on the web* *

6 MySQL Web / Web 2.0 OEM / ISV's On Demand, SaaS, Hosting Telecommunications Enterprise 2.0 Web

7 MySQL" "

8 MySQL MySQL Community Server MySQL Cluster (Community Edition) MySQL GUI MySQL (JDBC, ODBC, etc) MySQL Enterprise MySQL Enterprise Unlimited MySQL Embedded Server MySQL Cluster Standard Edition Carrier Grade Edition GPL

9 MySQL Enterprise MySQL Enterprise (OEM): MySQL Cluster Carrier Grade Edition NRE

10 Investment in MySQL Rapid Innovation Make MySQL a Better MySQL #1 Open Source Database for Web Applications Most Complete LAMP Stack Telecom & Embedded Develop, Promote and Support MySQL Improve engineering, consulting and support Leverage 24x7, World-Class Oracle Support MySQL Community Edition Source and binary releases GPL license

11 Oracle + MySQL Customers Product Integration Oracle GoldenGate (Complete!) Oracle Enterprise Linux + Oracle VM (CY 2011) Oracle Secure Backup (CY 2011) Oracle Audit Vault (CY 2011) Oracle Enterprise Manager (CY 2011) Support Leverage 24x7, World-Class Oracle Support MyOracle Support

12 MySQL 5.5 InnoDB ACID /CPU RC (Semi-synchronous) SIGNAL/RESIGNAL PERFORMANCE_SCHEMA

13 MySQL InnoDB Multiple Buffer Pool Instances Multiple Rollback Segments Extended Change Buffering (with delete buffering, purge buffering) Improved Purge Scheduling Improved Log Sys mutex Separate Flush List mutex RC MySQL Better Metadata Locking within Transactions Split LOCK_open mutex Eliminated LOCK_alarm mutex as bottleneck Eliminated LOCK_thread_count as bottleneck Improved Performance/Scale on Win32, 64 10

14 MySQL 5.5 Sysbench RC MySQL (New InnoDB) MySQL (InnoDB Plug-in) MySQL (InnoDB built-in) Intel Xeon X7460 x86_64 4 CPU x 6 Cores/CPU 2.66 GHz, 32GB RAM Fedora 10

15 MySQL 5.5 Sysbench RC MySQL (New InnoDB) MySQL (InnoDB Plug-in) MySQL (InnoDB built-in) Intel Xeon X7460 x86_64 4 CPU x 6 Cores/CPU 2.66 GHz, 32GB RAM Fedora 10

16 MySQL Server InnoDB Plugin MySQL 5.1 InnoDB Plugin ( ) InnoDB InnoDB Plugin : / Google GA

17 Asynchronous Replication 17

18 Semi-Synchronous Replication 18

19 memcached

20 Using Data Stores to Achieve HA & Scale

21 memcached A high-performance, distributed memory object caching system, generic in nature, but intended for use in speeding up dynamic web applications by alleviating database load * * " " Web

22 memcached Web memcached CPU OS CPU - BSD 1.4.x API Perl, Python, Ruby, Java, C#, C, Lua, MySQL,.

23 memcached LiveJournal 1 2, Web

24 memcached 800 memcached 40 memcached 140 MySQL 70 web 14 memcached 166 MySQL 244 web 79 memcached 30 MySQL

25 memcached: What is *not* ACID

26 memcached Server Slab allocator - memcached Chunk Chunk LRU(Least Recently Used) libevent

27 Basic memcached Example X Y Z mc hash server list select server ms connect set key value mc ms mc A B C key = value foo = seattle get key connect get value ms X 1) foo seattle 2) 3) B 4) B Z 5) foo 6) B 7) foo seattle

28 memcached get/gets : set/add/replace : append/prepend : incr/decr : / cas : (compare and swap atomic) stats : memcached

29 memcached memcached

30 memcached & MySQL

31 : memcached memcached memcached

32 MySQL memcached MySQL UDF( ) libmemcached memcached SQL CREATE FUNCTION memc_servers_add RETURNS INT SONAME "libmemcached_functions_mysql.so";

33 memcached UDF UDF

34 Memcached & MySQL read write Web Servers Application Servers Memcached Clients mc mc mc Memcached Servers ms ms ms cache update MySQL Server

35 MySQL & memcached Facebook - 4 SNS MySQL memcached ( ) * * MySQL 1,300 3, IOPS

36 MySQL Cluster

37 MySQL Clusterのアーキテクチャ SPOF(単一障害点)の無いデータベースクラスタ Clients MySQL Cluster Application Nodes MySQL Cluster Mgmt MySQL Cluster Mgmt MySQL Cluster Data Nodes

38 MySQL Cluster & & ACID Web SQL C++ Java API SQL Based Applications MySQL Server Data Node Data Node JDBC/ODBC/etc C++/Java Applications MySQL Cluster LDAP Data Node Data Node NDB API NDB API Management Client MGM API Management Node

39 MySQL Cluster SQL Node ( MySQL ) NDB API ( Application ) Data Node ( Engine (NDB Storage Management Node SQL C++ API ( / ) & "Arbitration" 2

40 NDB API NDB API = C++ API ACID SQL SQL Node (MySQL) X NDB API Data Node (NDB Storage Engine)

41 MySQL Cluster Connector for Java MySQL Cluster Connector for Java Java SQL MySQL Cluster Java API : API Cluster/J Java JPA O/R MySQL Cluster Plug-in for OpenJPA Cluster/J JDBC > 10 >Java

42 JDBC Cluster/J Measured as CPU time on a single host

43 Geographical Replication - Cluster 1 MyISAM MyISAM InnoDB Cluster 2 (MySQL Cluster ) MySQL

44 Aviation Data Management and Control System (ADMACS) MySQL Cluster 4 Linux

45 NEC 3G SQL API 2,000 2,400TPS MySQL Cluster

46 MySQL Server - RC InnoDB (Semi-synchronous) MySQL Server - GA InnoDB Plugin Web MySQL Enterprise Monitor MySQL Query Analyzer SQL

47 MySQL + memcached MySQL Cluster NDB API MySQL MySQL