Download - Mysql Technology Update Dec 2010
-
8/8/2019 Mysql Technology Update Dec 2010
1/40
MySQL Technology UpdateDecember 15, 2010
Tomas Ulin, VP of Engineering, MySQL
Rob Young, Sr. Product Manager, MySQL
-
8/8/2019 Mysql Technology Update Dec 2010
2/40
Oracles Strategy and Investment in MySQL
MySQL Technology Update
MySQL Database and MySQL Cluster
MySQL Workbench
MySQL Monitoring and Backup Tools MySQL 5.5: Production Ready
Learn More
Q&A
Agenda
-
8/8/2019 Mysql Technology Update Dec 2010
3/40
MySQL is Powering the Web
Enterprise 2.0SaaS, Cloud
Web OEM / ISVs
Telecommunications
Thanks to MySQL Customers
MySQL IS POWERING THE WEB
http://images.google.com/imgres?imgurl=http://www.infinitytechnology.com/uploadedImages/Home/TechFocus_News/AlcatelLucent_Hor_2col_lrg.gif&imgrefurl=http://www.infinitytechnology.com/phonesystems.aspx&h=251&w=720&sz=11&hl=en&start=4&sig2=urYvX47BOQRqvADY_UMA0w&um=1&tbnid=pA91nzVKrUFImM:&tbnh=49&tbnw=140&ei=94SgSOaRCaqkpATZu-jgBw&prev=/images?q=alcatel+lucent&um=1&hl=en&suggon=0&rls=com.microsoft:en-us&sa=N -
8/8/2019 Mysql Technology Update Dec 2010
4/40
Built togetherTested together
Managed together
Serviced together
Based on open standards
Lower cost
Lower risk
More reliable
Hardware and SoftwareEngineered to Work Together
MySQL Completes The Stack
-
8/8/2019 Mysql Technology Update Dec 2010
5/40
Oracle Database and MySQLComplementary
MySQL
ApacheGlassfish
Enterprise Applications(ERP, CRM, SCMetc)
Custom & DepartmentalEnterprise Applications
Datamarts & Analytics
Large OLTP Applications
Small to Medium OLTPApplications
Together servicing broader user needs
MySQL well suited for web-based apps, customdepartmental apps and embedded apps
Users can benefit by running MySQL and Oracletogether
-
8/8/2019 Mysql Technology Update Dec 2010
6/40
Investment in MySQLRapid 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
-
8/8/2019 Mysql Technology Update Dec 2010
7/40
MySQL on WindowsThe Right Choice
Significant Developer AdoptionWindows is the #1 development platform for MySQLMaking MySQL better on Windows
Performance & Scalability Improved on Windows MySQL 5.5 Benchmarks
Lower TCO More Affordable Easier to Administer
Ease of Use MySQL Workbench New Connector/NET 6.3
Cross-platform 20+ Platforms No Lock-in
-
8/8/2019 Mysql Technology Update Dec 2010
8/40
Making MySQL Better Today and Everyday
Announced Today
MySQL 5.5 is now GA!
-
8/8/2019 Mysql Technology Update Dec 2010
9/40
Better Performance, Scalability and Recovery
InnoDB Performance improvements Multiple Buffer Pool Instances Multiple Rollback Segments now supports 128Kconcurrent trxs Extended Change Buffering (with delete buffering, purge buffering) Improved Purge Scheduling Improved Log Sys mutex, Separate Flush List mutex Improved Recovery Times More
MySQL Performance Improvements 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 More
MySQL 5.5 Whats NewGA
-
8/8/2019 Mysql Technology Update Dec 2010
10/40
InnoDB becomes default storage engine
ACID Transactions, FKs, Crash Recovery
Improved Availability Semi-synchronous Replication
Replication Heartbeat
Replication Slave fsync options
Automatic Relay Log Recovery
Improved Usability SIGNAL/RESIGNAL
More Partitioning Options
Replication Server Filtering
Replication Slave Side Type Conversions Individual Log Flushing
Pluggable External Authentication, Audit interfaces
Better Instrumentation/Diagnostics New PERFORMANCE_SCHEMA
MySQL 5.5 Whats NewGA
-
8/8/2019 Mysql Technology Update Dec 2010
11/40
Im really blown away by MySQL 5.5s improvements.
- Don MacAskill, SmugMug
My expectations for 5.5 were not high. I am pleasantly
surprised!
- Mark Callaghan, Facebook, MySQL UC Keynote
"Oracle really did a great job with MySQL 5.5 -- in recordtime! It has lots of new features and performanceimprovements that our customers need andwant. We're very excited about this release."- Sheeri K. Cabral, Oracle AceDirector and Database Operations Manager, PalominoDB
MySQL 5.5 Early Adopters Speak!
-
8/8/2019 Mysql Technology Update Dec 2010
12/40
MySQL 5.5 SysBench BenchmarksLinux
Intel Xeon X7460 x86_64
4 CPU x 6 Cores/CPU
2.66 GHz, 32GB RAM
Fedora 10
MySQL 5.1.50(InnoDB built-in)
MySQL 5.1.50(InnoDB Plug-in)
MySQL 5.5.6(New InnoDB)
200% performance gainfor MySQL 5.5 over 5.1.50; at scale
GA
-
8/8/2019 Mysql Technology Update Dec 2010
13/40
MySQL 5.5 SysBench BenchmarksLinux
MySQL 5.1.50(InnoDB built-in)
MySQL 5.1.50(InnoDB Plug-in)
MySQL 5.5.6(New InnoDB)
Intel Xeon X7460 x86_64
4 CPU x 6 Cores/CPU
2.66 GHz, 32GB RAM
Fedora 10
370% performance gainfor MySQL 5.5 over 5.1.50; at scale
GA
-
8/8/2019 Mysql Technology Update Dec 2010
14/40
MySQL 5.5 Scales on multi coreSysBench Read Write GA
MySQL 5.1
MySQL 5.5.3
MySQL 5.5.4
AMD Opteron 7160 (Magny-Cours) @2100 MHz
64 GB memory
2 x Intel X25E SSD drives
OS is Oracle Enterprise Linux with the Enterprise Kernel4 sockets with a total of 48 cores.
Transactions/S
econd
-
8/8/2019 Mysql Technology Update Dec 2010
15/40
MySQL 5.5 Scales on multi core
AMD Opteron 7160 (Magny-Cours) @2100 MHz
64 GB memory
2 x Intel X25E SSD drives
OS is Oracle Enterprise Linux with the Enterprise Kernel
4 sockets with a total of 48 cores.
Sysbench OLTP: Read Only Performance
0
2000
4000
6000
8000
10000
12000
14000
16000
6 12 18 24 30 36
CPU Cores
TransactionsPer
Second
InnoDB
MyISAM
GA
-
8/8/2019 Mysql Technology Update Dec 2010
16/40
MySQL 5.5 SysBench BenchmarksWindows
MySQL 5.1.50
(InnoDB built-in)
MySQL 5.1.50(InnoDB Plug-in)
MySQL 5.5.6
(New InnoDB)
Intel x86_64
4 CPU x 2 Cores/CPU
3.166 GHz, 8GB RAM
Windows Server 2008
540% performance gainfor MySQL 5.5 over 5.1.50; at scale
GA
-
8/8/2019 Mysql Technology Update Dec 2010
17/40
MySQL 5.5 SysBench BenchmarksWindows
MySQL 5.1.50
(InnoDB built-in)
MySQL 5.1.50(InnoDB Plug-in)
MySQL 5.5.6
(New InnoDB)
Intel x86_64
4 CPU x 2 Cores/CPU
3.166 GHz, 8GB RAM
Windows Server 2008
1560% performance gainfor MySQL 5.5 over 5.1.50; at scale
GA
-
8/8/2019 Mysql Technology Update Dec 2010
18/40
Crash Recovery
0
50
100
150
200
250
Total Scanning Log Applying
Minu
tes
plugin 1.0.6
InnoDB 1.1
Improved Recovery PerformanceGA
5.1 5.1 5.1
5.5 5.5 5.5
Intel Xeon X7460 x86_64
4 CPU x 6 Cores/CPU
2.66 GHz, 32GB RAM
Fedora 10
50 warehouses
Database=9800MB
Innodb_log_file_size=2x1950MB
Buffer_pool-12GB
Started tested, killed server@5 mins
> 10x recovery performance gain
for MySQL 5.5 over 5.1
-
8/8/2019 Mysql Technology Update Dec 2010
19/40
Improved Administration NDBINFO: Real time status & usage statistics MySQL Cluster Manager
Higher Performance
MySQL Cluster Connector for Java Native Java & OpenJPA access to MySQL Cluster
Carrier Grade Availability & Performance Shared nothing, distributed design for 99.999% availability
Sub-Second Failover & Self Healing Recovery On-Line Scaling and Maintenance
Parallel Multi-Master Architecture
Low Latency, Real Time Responsiveness
MySQL Cluster 7.1Whats New GA
-
8/8/2019 Mysql Technology Update Dec 2010
20/40
MySQL Workbench 5.2
SQL Development
SQL Editor - Color Syntax Highlighting
Object Management - Import/Export, Browser, Edit
Connection Management - Wizard, SSH Tunnel
Database Administration
Status, Configuration, Start/Stop, Replication Users, Security, Session Management
Import/Export Dump Files
Data Modeling
Visual Design Forward/Reverse Engineer
Schema Validation, Schema Doc
Scripting & Plug-in Support
GA
-
8/8/2019 Mysql Technology Update Dec 2010
21/40
Absolutely loving the MySQL Workbench!
MySQL Workbench is freaking awesome. It makes my life awhole lot easier.
@MySQL Workbench is awesome! Microsoft could learnfrom this product! LIVE database changes are so quick to
synch with local model!
MySQL Workbench Tweetsfrom Users!!
-
8/8/2019 Mysql Technology Update Dec 2010
22/40
MySQL: Still Free, Open to the Community
mysql.com/downloads/
Available to download and use under the GPL:
MySQL Database (Community Server)
All 5.5 features, all storage engines
MySQL Cluster
MySQL Workbench Community Edition
MySQL Connectors
MySQL Proxy
Documentation
Forums
-
8/8/2019 Mysql Technology Update Dec 2010
23/40
Making MySQL Better Today and Everyday
Monitoring & Backup Tools
-
8/8/2019 Mysql Technology Update Dec 2010
24/40
MySQL Server Feature Requests
0%
5%
10%
15%
20%
25%
30%
35%
40%
How would you rank the following upcoming MySQL capabilities in terms of importance?Results "Extremely Important"
- Online Backup is the #1 most requested feature for MySQL Users and Customers
-
8/8/2019 Mysql Technology Update Dec 2010
25/40
MySQL Enterprise Backup
Online Backup for InnoDB & MyISAM
High Performance Backup & Restore Full, Incremental, Partial Backups
Compressed Tables
Partition files
In-memory database
Compression
Point in Time Recovery
Metadata on status, progress, history
Unlimited Database Size
Cross-Platform
Windows, Linux, Unix
GA
MEB BackupFiles
MySQLDatabase Files
mysqlbackup
-
8/8/2019 Mysql Technology Update Dec 2010
26/40
High Performance Backups
0
5
10
15
20
25
30
26GB - 8 Tables 32GB - 33 Tables
Minutes
Backup Target
Backup
mysqldump
MySQL Enterprise Backup
Backups are up to 3.5x Faster than mysqldump
GA
-
8/8/2019 Mysql Technology Update Dec 2010
27/40
-
8/8/2019 Mysql Technology Update Dec 2010
28/40
Backup Compression Storage Savings
0
5
10
15
20
25
30
35
22 GB - sysbenchdb
26GB - 8 Tables 32GB - 33 tables
GB
Backup Compression
Uncompressed
Compressed
Backup size reduced from 65% up to 93%
GA
-
8/8/2019 Mysql Technology Update Dec 2010
29/40
Single, consolidated view into entireMySQL application developmentenvironment
Auto-discovery of MySQL servers,replication topologies
Automated, customizable rules-
based monitoring, tuning,SNMP/SMTP alerts
Query Analyzer for querymonitoring, analysis, tuning, sourcecode tracing
Application Tuning duringDev/QA/Roll out
Reduces risk of problems afterapps are deployed A Virtual MySQL Tuning Assistant!
MySQL Enterprise Monitor
-
8/8/2019 Mysql Technology Update Dec 2010
30/40
Centralized monitoring ofQueries across all servers
No reliance on Slow QueryLogs, SHOW PROCESSLIST;,VMSTAT, etc.
Aggregated view of query
execution counts, time, and rows Integrated with Monitor graphs
so work loads can correlatedwith query activity
Traces queries back to sourcecode
Saves time parsing atomicexecutions for total queryexpense
MySQL Query Analyzer
-
8/8/2019 Mysql Technology Update Dec 2010
31/40
MySQL Enterprise Monitor 2.3Whats New
New Cluster Advisor and Graphs
Monitoring of Data Nodes
Up/down status
Memory
undo/redo buffer, logs
Improved Advisors and Graphs
Monitoring of transactions
Binlog cache and space usage
Disk space, I/OIntegrated with My Oracle Support
Query monitoring via Connectors
GA
-
8/8/2019 Mysql Technology Update Dec 2010
32/40
Integrated with My Oracle Support
Collect MySQL diagnostics and upload to MOS SR
Track SRs from Enterprise Dashboard
Create/maintain SRs (CY 2011)
Saves DBA time
collecting data for Support team, tracking status
-
8/8/2019 Mysql Technology Update Dec 2010
33/40
The MySQL Enterprise Monitor and Query Analyzerallow us to quickly identify and optimize our most
expensive queries so that we can constantly improveour platform and scale more efficiently.
Jeff FreundCEO,
Clickability
mysql.com/products/enterprise/testimonials/
-
8/8/2019 Mysql Technology Update Dec 2010
34/40
-
8/8/2019 Mysql Technology Update Dec 2010
35/40
Oracle + MySQL Customers
Product Integrations in Progress
Oracle GoldenGate (MySQL Capture is now GA!) Oracle Enterprise Linux + Oracle VM
Oracle Fusion Middleware Certifications
Oracle Secure Backup
Oracle Audit Vault
Oracle Enterprise Manager
Support Leverage 24x7, World-Class Oracle Support
My Oracle Support
-
8/8/2019 Mysql Technology Update Dec 2010
36/40
COMPANY OVERVIEW
Ticketmaster is one of the world's largest e-commerce and ticketing sites online,operating in 18 global markets, and with 19worldwide call centers.
APPLICATION
Ticketmaster.com is an e-commercewebsite selling tickets for live concerts,professional and college sports teams,museums and theaters.
SOLUTIONS MySQL Enterprise Edition Oracle Database Enterprise Edition
KEY BUSINESS BENEFIT
By migrating from MicrosoftSQL Server to MySQL andOracle, Ticketmaster.comscales 4 times better and growsthe number of customers from10 million to 100 million.
WHY MySQL+ ORACLE?
"At Ticketmaster, we use MySQLand Oracle to complement eachother. The end result is a highly-distributed, optimal-performingdatabase environment that powersone of the largest e-commerce andticketing sites in the world.Ed Presz Sr. Director Database Engineering
Ticketmaster/Live Nation Entertainment, Inc.
TicketmasterCustomer Success Profile
-
8/8/2019 Mysql Technology Update Dec 2010
37/40
MySQL Product ReleasesContinuous Innovation
Q1 CY2010 Q2 CY2010 Q3 CY2010 Q4 CY2010
MySQL Enterprise Monitor 2.2
GA
MySQL Workbench 5.2
GA
MySQL Database 5.5
MySQL Enterprise Backup 3.5 MySQL Enterprise Monitor 2.3
MySQL Cluster Manager 1.1
All GA now!
MySQL Cluster 7.1
GA
A Better MySQLMySQL Cluster Manager 1.0
GA
-
8/8/2019 Mysql Technology Update Dec 2010
38/40
MySQL 5.5 is GA! Delivers Performance & Scalability
New Value Added Features in MySQL Enterprise Edition
Oracle is making MySQL a better MySQL
Summary
-
8/8/2019 Mysql Technology Update Dec 2010
39/40
Additional Resourcesmysql.com
Download 5.5 GA
Whats New in 5.5 WP
MySQL Products and Editions
TCO calculator
Upcoming Events
Customer success stories
dev.mysql.com
Documentation
Developer Zone Articles, How tos
-
8/8/2019 Mysql Technology Update Dec 2010
40/40
Thanks for attending!
Tomas Ulin - [email protected] Young [email protected]