MySQL
Introduction
Ivan Ma
[email protected]
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
Safe Harbor Statement
The following is intended to outline our general product direction. It is intended for
information purposes only, and may not be incorporated into any contract. It is not a
commitment to deliver any material, code, or functionality, and should not be relied upon
in making purchasing decisions. The development, release, and timing of any features or
functionality described for Oracle’s products remains at the sole discretion of Oracle.
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
3
Next Generation Financial Services
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
4
facebook
Application
Facebook is a social networking site that connects people
with friends and others who work, study and live around
them.
Key Business Benefit
MySQL has enabled facebook to grow to 1+ Billion users.
Why MySQL?
“We are one of the largest MySQL web sites in production.
MySQL has been a revolution for young entrepreneurs.”
Facebook
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
eBay
Application
Real-time personalization platform to display advertising to more
relevant buyers and conduct more effective merchandizing.
Key Business Benefits
Highly scalable and cost-effective system that handles all of
eBay’s personalization and session data needs. Manages 4 billion
requests per day of 50/50 read/write operations.
Why MySQL Enterprise?
• Cost-effective
• Performance: 13,000 TPS on Sun Fire x4100
• Scalability: Designed for 10x future growth
• Monitoring: MySQL Enterprise Monitor
Chris Kasten,
Kernel Framework Group, eBay
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
PayPal
Application
Distributed global Fraud Detection application with 99.999%
availability.
Key Business Benefit
MySQL Cluster provides real-time analysis of user transaction
history. PayPal manages 40TB of data and achieved 3x higher
performance than the original design goal.
Why MySQL? Scalability & Lower Costs
“Technologies such as MySQL Cluster enables users to get the
best of both world’s…the agility of NoSQL systems with the
trust, maturity and reliability of the SQL model."
Daniel Austin
Chief Architect, PayPal
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.6: A Better MySQL
• Performance and Scalability
• Optimizer for better query execution times, diagnostics
• Performance Schema for better instrumentation
• InnoDB for better transactional throughput
• NoSQL API for better flexibility
• Replication largest set of enhancements ever released!
• Fabric for sharding and High Availability
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
8
MySQL 5.6 SysBench Benchmarks
3x Faster than MySQL 5.5
Transactions per Second
MySQL 5.6 vs. 5.5 - Read Only (Linux)
18,000
16,000
14,000
12,000
10,000
8,000
6,000
4,000
2,000
0
MySQL 5.6.10
MySQL 5.5.29
32
64
128
Connections
256
512
Oracle Linux 6
Intel(R) Xeon(R) E7540 x86_64
MySQL leveraging:
- 48 of 96 available CPU threads
- 2 GHz, 512GB RAM
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
9
MySQL 5.7 Release Candidate Available!
RC
Performance & Scalability
Manageability
2 X Faster than MySQL 5.6
Performance Schema Improvements
Enhanced InnoDB: faster online & bulk
load operations
MySQL SYS Schema
Replication Improvements (incl. multisource, multi-threaded slaves...)
Improved Security: safer initialization,
setup & management
New Optimizer Cost Model: greater user
control & better query performance
NEW! JSON Support (now in labs)
And many more new features and enhancements…
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
10
MySQL 5.7: Sysbench Benchmark
2x Faster than MySQL 5.6
3x Faster than MySQL 5.5
645,000 QPS
MySQL 5.7: Sysbench Read Only (Point Select)
700,000
MySQL 5.7
Queries per Second
600,000
500,000
400,000
MySQL 5.6
300,000
200,000
100,000
MySQL 5.5
0
8
16
32
64
128
Connections
256
512
1,024
Intel(R) Xeon(R) CPU E7-4860 x86_64
4 sockets x 10 cores-HT (80 CPU threads)
2.3 GHz, 512 GB RAM
Oracle Linux 6.5
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
11
The #1 Database in the Cloud
SaaS
Hosting
IaaS, PaaS
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
12
Best Choice for Next Generation Web & Cloud Applications
Strong MySQL Momentum
World’s Most Popular open
Source Database
Leading Database for Web
Applications
#1 Database in the Cloud
Integrated with Hadoop in
Big Data Platforms
#2 Most Popular DBMS *
#1 Linux Career IT skill **
* Based on the DB Engine Ranking in Aug 2014 ** Source: Linux Career IT Skills Watch update July 2014
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
13
Why MySQL Enterprise Edition?
All the Database Features You Love
InnoDB
Improved Throughput
Default
Online DDL
Full Text Search
NoSQL Access
Optimizer:Faster
Query Execution and
Better Diagnostics
Performance
Schema
GIS
Security
Replication
EXPLAIN
MySQL Utilities
Partitioning
Lossless Semi-Synchronous
GTIDs
Crash Safe
Time Delayed
Multi-threaded
Multi-Source
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
14
MySQL Enterprise Edition
Advanced Features
• Scalability
• High Availability
• Security
• Audit
• Firewall
Management Tools
• Monitoring
• Backup
• Development
• Administration
• Migration
Support
• Technical Support
• Consultative Support
• Oracle Certifications
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
15
MySQL Enterprise Edition:
Management Tools
Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |
16
MySQL Enterprise Monitor
Application
Big Fish Games is a global leader in the online games industry
and distributes more games worldwide than any other online
site.
Key Business Benefit
MySQL Query Analyzer provides a consolidated view of query
activities and execution details, and has enabled Big Fish
Games to quickly identify poorly running queries and tackle
the root causes directly in the SQL code.
Why MySQL?
“With the MySQL Query Analyzer, we were able to identify and
analyze problematic SQL code, and triple our database
performance. More importantly, we were able to accomplish
this in three days, rather than taking weeks.”
Keith Souhrada, Software Development Engineer, Big Fish Games
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
17
MySQL Enterprise Edition
• MySQL Enterprise Authentication
– External Authentication Modules
• Microsoft AD, Linux PAMs
• MySQL Enterprise Encryption
– Public/Private Key Cryptography
– Asymmetric Encryption
– Digital Signatures, Data Validation
• MySQL Enterprise Monitor
– Changes in Database Configurations, Users
Permissions, Database Schema, Passwords
• MySQL Enterprise Backup
– Securing Backups, AES 256 encryption
• MySQL Enterprise Firewall
– Query Monitoring, White List Matching,
• MySQL Enterprise Audit
– User Activity Auditing, Regulatory Compliance
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
18
MySQL Enterprise Monitor
• Start monitoring MySQL in 10 minutes
• Real-time MySQL performance and
availability monitoring
• Visually find & fix problem queries
• Disk monitoring for capacity planning
• Cloud friendly architecture
– No agents required
• Optional agent option provides
advanced Host/OS monitoring
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
19
Oracle Enterprise Manager for MySQL
Single Dashboard to manage Oracle stack for Web & Cloud
• An estimated 70% of Oracle customers also use MySQL
– For Web, custom, departmental and embedded applications
– #1 Requested integration
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
20