Agenda

8h30 – Cadastramento

9h – Abertura: MySQL na Oracle e roadmap - Richard Mason, VP MySQL – Oracle

9h45 – Apresentação Targetware (Parceiro Patrocinador) - Rodrigo

10h – Sessão Técnica 1: MySQL 5.6 Com Recursos NoSQL - Airton Lastori, Consultor de Vendas Sênior - MySQL

Brasil

11h – Caso de uso: Claro - Melkih Oliveira

12h - Sessão Técnica 2: Instalação do MySQL:

Agenda

13h – Sessão Técnica 3: MySQL Cluster CGE - Wagner Bianchi - Oracle Ace Developer

14h – Caso de Uso: Reclame Aqui – Diego Campos, Diretor de TI

15h – Coffee Break

15h15 – Sessão Técnica 4: MySQL & Java – Técnicas de desenvolvimento e melhores práticas - Manuel Contreras,

Consultor de Vendas Sênior - MySQL América Latina

16h – Caso de Uso: Abril Mídia - Fernando Tralci,, Specialized Support

17h – Sessão Técnica 5: Replicação e Alta Disponibilidade em MySQL - Luis Soares, Engenheiro de Software Sênior –

MySQL Global Business Unit

17h45 - Conclusão - Richard Mason, VP MySQL – Oracle

State of the Dolphin

Sao Paulo, December 7, 2011

Rich Mason, Vice President, Linux, Virtualization & MySQL Sales

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

decision. The development, release, and timing of any

features or functionality described for Oracle’s products

remains at the sole discretion of Oracle.

MySQL Makes The Cover!

Best of Breed at Every Level

Built & Tested together

Managed together

Serviced together

Based on open standards

Lower cost

Lower risk

More reliable

Hardware and Software

Engineered to Work Together

MySQL Completes The Stack

Cloud

Web & Enterprise OEM & ISVs

Industry Leaders Rely on MySQL

UNMATCHED INVESTMENT

HUNDREDS OF EXPERTS

LARGEST MySQL ENGINEERING & SUPPORT ORGANIZATION

LINUX

WINDOWS

NoSQL

InnoDB

REPLICATION

MySQL CLUSTER

MySQL ENTERPRISE EDITION

PERFORMANCE IMPROVEMENTS

WORLD-CLASS SUPPORT WEB

CLOUD

EMBEDDED

STRATEGIC

More Product Releases Than Ever Before

Q2 CY2010 Q3 CY2010 Q4 CY2010 Q1 CY2011

• 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!

A Better MySQL

Q2-4 CY2011

• MySQL Enterprise Monitor 2.2

• MySQL Cluster 7.1

• MySQL Cluster Manager 1.0

All GA!

• MySQL Enterprise Backup 3.6

• Oracle VM Template for

MySQL Enterprise Edition

• MySQL Enterprise Oracle

Certifications

• MySQL Windows Installer

• New MySQL Enterprise

Commercial Extensions

*Development Milestone Release

• MySQL Database 5.6 DMR*

•MySQL Cluster 7.2 DMR

and MySQL Labs!

(“early and often”)

Driving MySQL

Innovation

All GA!

MySQL 5.6 builds on MySQL 5.5 by improving:

• Optimizer for better Performance, Scalability

• Performance Schema for better instrumentation

• InnoDB for better transactional throughput

• Replication for higher availability, data integrity

• “NotOnlySQL” options for better flexibility

MySQL 5.6: A Better MySQL

• Fast, simple access to InnoDB

• Accessed via Memcached API

• Use existing Memcached clients

• Bypasses SQL transformations

• NotOnlySQL access

• For key-value operations

• SQL for rich queries, JOINs, FKs, etc.

• Implementation

• Memcached daemon plug-in to mysqld

• Memcached protocol mapped to the

native InnoDB API

• Shared process space for ultra-low

latency

InnoDB Storage Engine

MySQL Server Memcached plugin

Application

SQL

(MySQL Client)

NoSQL

(Memcached

Protocol)

mysqld

MySQL Server – Key-value access for InnoDB NotOnlySQL: Memcached API

Try it now:

labs.mysql.com

MySQL Cluster 7.1 High Write Scalability, Real Time Performance, 99,999% Uptime

Copyright 2011 Oracle Corporation 13

• Telecoms

• Subscriber Databases (HLR/HSS)

• Service Delivery Platforms

• VoIP, IPTV & VoD

• Mobile Content Delivery

• On-Line app stores and portals

• IP Management

• Payment Gateways

• Web • User profile management

• Session stores

• eCommerce

• On-Line Gaming

• Application Servers

GA

MySQL Cluster 7.2: DMR 2

• 70x Higher Complex Query Performance: Adaptive Query Localization

• Native memcached API

• MySQL 5.5 Server Integration

Enabling Next Generation Web Services

• Multi-Site Clustering

• Simplified Active / Active Replication

Enhancing Cross Data Center Scaling

• Consolidated Privileges

Simplifying Provisioning & Administration

Voices from the Community

“Version 5.5 of the MySQL database is probably is the best

MySQL version ever produced, and the upcoming version

5.6 is looking strong as well.” Mårten Mickos

“If you are using MySQL today, and you need a solid path

forward on it as a platform? I’d stick with what Oracle is

creating.” Brian Aker

"From an engineering standpoint, Oracle is doing the best

work on MySQL that's ever been done. Oracle is doing

good, formal software engineering.” Baron Schwartz

New Applications with the LAMP Stack

• Highly Popular for Web and

Cloud Based Applications

• Integration between LAMP

Components

• Ease of Use For Rapid

Results & Short Time to

Market

• Scalability to Grow With the

Needs

• Simple Integration With

Existing IT Infrastructure

L

A

M

P

The Most Complete LAMP Stack Support Across the LAMP Stack from Oracle

L

A

M

P/J

Oracle VM Template for MySQL Integrated & Tested OS, VM and Database Stack

Deploy virtualized, cloud-ready

MySQL instances, certified for production use

• Rapid DEPLOYMENT

• Increased RELIABILITY

• Higher AVAILABILITY

• Lower COST

Oracle VM Servers

Oracle VM Server Pool

Oracle VM

Oracle VM

Oracle VM

MySQL on Windows

Lower TCO

• More Affordable

• Easier to Administer

(Replication…etc)

• TCO Calculator

Cross-Platform

• 20+ Platforms

• No Lock-in

• Flexibility to Choose LAMP for

Web Applications

Performance & Scalability

• Improved on Windows

• MySQL 5.5 Benchmarks

• Continued Investment

Ease of Use

• New Installer - Now 3 min!

• Windows Env. Integration

• MySQL Tools

MySQL vs. Microsoft SQL Server

3 Year TCO

$0

$100.000

$200.000

$300.000

$400.000

$500.000

$600.000

$700.000

$800.000

MySQL Enterprise Edition Microsoft SQL Server

Enterprise Edition

$60.000

$769.860

- Term: 3 Years

- Users: Unlimited (web)

- MySQL EE

- Microsoft SQL EE

- Hardware: Intel x86

- Servers: 4

- Sockets/Server: 4

- Cores/Socket: 4

..version of MySQL to run?

…servers down?

…will systems scale?

…security policies, change?

…performance issues?

Where/When/How to Tune?

…expensive, slow queries?

…Replication synch issues?

…managing Oracle and MySQL databases?

…Developers productive?

…can I recover?

Tough Questions

Oracle Premier Support

MySQL Enterprise Oracle Certifications

MySQL Enterprise High Availability

MySQL Enterprise Security

MySQL Enterprise Scalability

MySQL Enterprise Backup

MySQL Enterprise Monitor/Query Analyzer

MySQL Workbench

MySQL Enterprise Edition

Highest levels of MySQL Scalability, Security &

Uptime

MySQL Enterprise Edition

A Virtual MySQL Tuning Assistant!

MySQL Enterprise Monitor • Global view of MySQL

environment

• Automated, rules-based monitoring and alerts (SMTP, SNMP enabled)

• Query capture, monitoring, analysis and tuning, correlated with Monitor graphs

• Visual monitoring of “hot” applications and servers

• Real-time Replication Monitor with auto-discovery of master-slave topologies

• Integrated with MySQL Support

• MySQL Enterprise Security

• External Authentication for Windows and PAM

• Integrates MySQL apps with existing infrastructures

• MySQL Enterprise Scalability

• MySQL Thread Pool

• Improves sustained performance/scale as user connections grow

• 20x scale improvement in SysBench OLTP R/W benchmarks

• MySQL High Availability

• Oracle VM Template for MySQL

• Windows Clustering

MySQL Enterprise Edition

New Commercial Extensions

• Straight from the Source

• Largest Team of MySQL Experts

• Backed by MySQL Developers

• Forward Compatible Hot Fixes

• MySQL Maintenance Releases

• MySQL Support in 29 Languages

• Direct Access to MySQL Support Engineers

• 24/7/365

• Unlimited Incidents

• Knowledge Base

• MySQL Consultative Support

Oracle Premier Support for MySQL

Rely on The Experts - Get Unique Benefits

"The rep that assisted me was

simply outstanding. He immediately

recognized the cause of my problem

and provided the resolution."

-- (July 27, 2011)

mysql.com/support/quotes

Only From

Oracle

Oracle Fusion MiddleWare

• WebLogic Server

• Database Adapter for Oracle SOA Suite **

• Oracle Business Process Management **

• Oracle Virtual Directory

• Oracle Data Integrator

• Oracle Enterprise Performance Management **

• Oracle Identity Analytics

• Open SSO STS, Open SSO Fedlet

All ship with MySQL 5.x JDBC driver

** MySQL as a Metadata Repository option (in progress)

MySQL Enterprise Oracle Certifications

Completed

MySQL Enterprise Oracle Certifications

Completed

• Oracle Linux

• Oracle VM

• Oracle VM Template for

MySQL EE

• Oracle GoldenGate

• Oracle Secure Backup

• MyOracle Online Support

• Oracle Fusion MiddleWare • WebCenter Suite

• Enterprise Content Management

• Oracle Business Intelligence Suite

• Oracle Clusterware

• Oracle Database Firewall

• Oracle Audit Vault

• Oracle Enterprise Manager

• And More…

MySQL Enterprise Oracle Certifications

In Progress

..version of MySQL to run?

…servers down?

…will systems scale?

…security policies, change?

…performance issues?

Where/When/How to Tune?

…expensive, slow queries?

…Replication synch issues?

…managing Oracle and MySQL databases?

…Developers productive?

…can I recover?

Tough Questions, Real Solutions

• MySQL Enterprise Scalability

• MySQL Enterprise Monitor, Advisors, Query Analyzer

• MySQL Consultative Support

• MySQL Enterprise Monitor, Query Analyzer

• MySQL Enterprise Monitor, Advisors, Query Analyzer

• MySQL Consultative Support

• MySQL Enterprise Monitor, Replication Monitor

• Oracle Premier 7x24 Support

• MySQL Enterprise Scalability

• MySQL Enterprise Monitor, Advisors, Query Analyzer

• MySQL Consultative Support

• Oracle Premier 7x24 Support

• MySQL Enterprise Monitor, Advisors

• MySQL Enterprise High Availability

• MySQL External Authentication

• MySQL Enterprise Monitor, Security Advisor

• MySQL Workbench SE

• MySQL Enterprise Monitor, Query Analyzer

• Oracle Premier 7x24 Support

• MySQL Enterprise Backup

• MySQL Enterprise Oracle Certifications

Oracle Premier Support

MySQL Enterprise Oracle Certifications

MySQL Enterprise High Availability

MySQL Enterprise Security

MySQL Enterprise Scalability

MySQL Enterprise Backup

MySQL Enterprise Monitor/Query Analyzer

MySQL Workbench

MySQL Enterprise Edition

Highest levels of MySQL Scalability, Security &

Uptime

MySQL Enterprise Edition

Summary

Oracle is driving MySQL Innovation

“making MySQL a better MySQL”

Oracle has the largest MySQL

Engineering & Support Organization

MySQL Enterprise - highest levels of

Scalability, Security & Uptime

33