The State of the Dolphin
Airton Lastori
[email protected]
junho-2015
Safe Harbor Statement
The preceding 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. |
Edward Screven & Tomas Ulin no Open World 2014
Oracle Chief Corporate Architect & VP of MySQL Engineering
• [video]
youtube.com/watch?v=fzCpd4j72jA
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Best Choice for Next Generation Web & Cloud Applications
Strong MySQL Momentum
World’s Most Popular Open
Source Database
Leading Open Source
Database for Web
Applications
#1 Open Source Database
in the Cloud
Integrated with Hadoop in
Big Data Platforms
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
4
MySQL Architecture
Focus on Web, Cloud, Embedded
• Architecture Improvements
– Improved Modularity
– Refactoring Optimizer, Parser, Runtime
• Web Scale Performance & Scalability
– Optimizer Cost Model
– InnoDB & Replication Improvements
• Management & Security
– Data Dictionary
– MySQL Enterprise Encryption
– Oracle Enterprise Manager for MySQL
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
6
Oracle elevando o nível
Um MySQL cada vez melhor, 5 anos de investimento
2x Engineering Staff
3x QA Staff
2x Support Staff
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Breve histórico: 2010 - 2015
MySQL Enterprise Monitor 2.2
Oracle Products Certifications
MySQL Database 5.6
MySQL Cluster 7.1
MySQL Windows Installer & Tools
MySQL Cluster 7.4
MySQL Cluster Manager 1.0
MySQL Enterprise Security
MySQL Enterprise Monitor 3.0
MySQL Workbench 5.2
MySQL Enterprise Scalability
MySQL Enterprise Backup 3.12
MySQL Database 5.5
MySQL Enterprise Audit
MySQL Fabric
MySQL Enterprise Backup 3.5
MySQL Cluster 7.2
MySQL Workbench 6.3
MySQL Enterprise Monitor 2.3
MySQL Cluster Manager 1.3
MySQL Enterprise Encryption
MySQL Cluster Manager 1.1
MySQL Utilities
MySQL Enterprise Backup 3.7
MySQL Workbench 6.0
Todos GA, prontos para !
Todos GA!
Todos GA!
MySQL Database 5.7 RC
labs.mysql.com
Disponível agora!
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Central @ Oracle Open World 2014
Alguns cases apresentados...
• [slides]
oracle.com/openworld/mysql
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Improves Mobile to Mobile Communications
Challenges
 Implement new messaging
system to improve mobile to
mobile communications
management.
 User facing application with the
following requirements:
Solution
 Evaluated several alternatives & selected MySQL: Very low latency
variations, optimized with Flash, proven technology at Facebook.
 Highly valued the new MySQL 5.6 features: GTIDs & Multi-threaded
Slaves improving write scalability, and leverages semi-synchronous
replication, improving reliability.
Benefits
 Very high reliability
 Very low response times
 Consistency across devices
 New IRIS application in production handling several millions of
mobile to mobile messages/sec.
 “No Data Loss” system and 10X improvement in write scalability.
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Scales with MySQL Embedded
Challenges
 Deliver patient privacy monitoring
solutions for electronic health
records
 Customer Average of 700K events
processed daily
 Customers manage up to 1TB of
new data each month, resulting in
14+TB deployments
 250 Billion events under
management
 Compatibility with 250+ healthcare
applications
Solution
 MySQL as embedded database, and recently upgraded to MySQL
5.6 to benefit from improvements in InnoDB and the MySQL
Performance Schema
 Leverage MySQL Enterprise Monitor & MySQL Enterprise Backup to
save time, ensure optimal performance and high availability
Benefits
 Delivering high performance, extremely reliable and “zero admin”
patient privacy monitoring solutions to thousands of hospitals and
clinics
 Ability to scale to meet customers’ growing demands with few
DBAs
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Database
Rápida retrospectiva
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Qual versão do MySQL Database você usa?
SELECT @@version;
+---------------------------------------+
| @@version
|
+---------------------------------------+
| 5.6.25-enterprise-commercial-advanced |
+---------------------------------------+
1 row in set (0,00 sec)
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Evolução da escalabilidade vertical do MySQL
2008
Até 4 CPU/cores
MySQL AB
MySQL 5.0
2009
Até 16 CPU/cores
Sun Microsystems
MySQL 5.1 (InnoDB
Plugin)
2010
Até 32 CPU/cores
Oracle
MySQL 5.5
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
2013
Up to 48 CPU/cores
Oracle
MySQL 5.6
Atualize!
MySQL 5.6 e InnoDB
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
20
No Windows: MySQL Installer
Next, Next... Finish!
dev.mysql.com/downloads/windows/installer
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
No Linux: repositórios YUM e APT para MySQL
Maneira simples e conveniente de instalar e atualizar produtos MySQL
• Suporta as distribuições Enterprise Linux
– RedHat Enterprise/Oracle Linux
– Fedora
– Debian/Ubuntu
• Inclui os pacotes mais atuais
– MySQL Database
– MySQL Workbench
– MySQL Connectors
– MySQL Utilities
Mais de 50% dos downloads
para Fedora/RedHat já são
feitos do repositório
www.alastori.com.br/2014/05/tutorial-deinstalacao-do-mysql-56-e.html
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
…ou manualmente via binários pré-compilados
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Convertendo tabelas para InnoDB
Mais confiabilidade e escalabilidade
• [documentação]
mysql.com/doc/refman/5.6/en/converting
-tables-to-innodb.html
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Database 5.7 RC
Disponível para download e testes, ainda não recomendado para produção
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
25
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... http://mysqlserverteam.com/the-mysql-5-7-7-release-candidate-is-available/
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
28
MySQL 5.7: Sysbench: Read Only
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. |
29
MySQL 5.7: InnoDB, NoSQL With Memcached
6x Faster than MySQL 5.6
1 Million QPS
Thank you, Facebook
MySQL 5.7 vs 5.6 - InnoDB & Memcached
Queries per Second
1,200,000
1,000,000
MySQL 5.7
800,000
600,000
400,000
MySQL 5.6
200,000
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. |
30
MySQL 5.7: Connections per Second
1.7x Faster than MySQL 5.6
2.5x Faster than MySQL 5.5
67,000 Connections/Sec
Connections Per Second
80,000
Connections/Second
70,000
60,000
50,000
MySQL 5.5
40,000
MySQL 5.6
30,000
MySQL 5.7
20,000
10,000
0
MySQL 5.5
MySQL 5.6
MySQL 5.7
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
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
31
MySQL 5.7: InnoDB
Diversas Melhorias
• Sempre Online
– InnoDB Buffer Pool dinâmico, UNDO tablespace separado e auto-truncation,
Renomear índice, mudar varchar, mais variáveis de config. dinâmicas
• Melhorias para SSD (especialmente FusionIO)
– Quando DirectFS for detectado, Doublewrite buffer desabilitado automaticamente
– “Dirty Page” Flushing paralelizado
– Maior throughput, performance e escalabilidade
• Particionamento nativo
– Elimina limitações anteriores, melhora utilização de recursos, TTS para partições
individuais
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7: InnoDB
Diversas Melhorias
• Improved support for cache preloading
• General Tablespace support
– Store multiple tables in user defined shared tablespaces
• Physical storage improvements
– Transparent page compression
– Support for 32K and 64K pages (use with transparent page compression for very high compression
ratios)
– Configurable fill-factor (allows for improvements in storage footprint)
• Improved bulk load performance
• High priority transactions (support for MySQL Group Replication)
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL HA & Scaling Solutions
MySQL
Replication
MySQL
Fabric
Oracle VM
Template
Oracle
Clusterware
Solaris
Cluster
Windows
Cluster
DRBD
MySQL
Cluster
App Auto-Failover
✖
✔
✔
✔
✔
✔
✔
✔
Data Layer Auto-Failover
✖
✔
✔
✔
✔
✔
✔
✔
MySQL 5.7
MySQL 5.7
✔
✔
✔
✔
✔
✔
Platform Support
All
All
Linux
Linux
Solaris
Windows
Linux
All
Clustering Mode
Master +
Slaves
Master +
Slaves
Active/Pas
sive
Active/Passi
ve
Active/P
assive
Active/Pas
sive
Active/P
assive
MultiMaster
N/A
Secs
Secs +
Secs +
Secs +
Secs +
Secs +
< 1 Sec
Reads
✔
✖
✖
✖
✖
✖
✔
N/A
✖
N/A
N/A
N/A
N/A
N/A
✔
Transparent routing
✖
For HA
✔
✔
✔
✔
✔
✔
Shared Nothing
✔
✔
✖
✖
✖
✖
✔
✔
Storage Engine
InnoDB+
InnoDB+
InnoDB+
InnoDB+
InnoDB+
InnoDB+
InnoDB+
NDB
✔
✔
✔
✔
✔
✖
✔
✔
Zero Data Loss
Failover Time
Scale-out
Cross-shard operations
Single Vendor Support
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7: Replication Improvements
• GTID enhancements
– On-line, phased deployment of GTIDs
– Binary logging on slave now optional
• Enhanced Semi-synchronous replication
– Write guaranteed to be received by slave
before being observed by clients of the master
– Option to wait on Acks from multiple slaves
• Multi-Source Replication
– Consolidate updates from multiple Masters
into one Slave
• Dynamic slave filters
• 8-10x Faster slave throughput
– Often removes slave as a bottleneck; keep pace
with master with 8+ slave threads
– Option to preserve Commit order
– Automatic slave transaction retries
250%
Slave throughput vs. 96 Thread Master
200%
150%
100%
50%
0%
1
8
24
48
Slave Threads
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
42
MySQL 5.7: Replication Improvements
• Multi-Source Replication
– Consolidate updates from multiple
Masters into one Slave
• Consolidated view of all shards
• More flexible topologies
• Centralized point for backups
– Compatible with Semi-Sync Replication
& enhanced MTS
• Performance Schema tables for
monitoring slave
• Online Operations: Dynamic
Replication Filters, switch master
Master 1
Master 2
…
Master N
Binlog
Binlog
…
Binlog
IO 1
IO 2
…
IO N
Relay 1
Relay 2
…
Relay N
Coordinator
Coordinator
Coordinator
Coordinator
W1 W2
…
WX
W1 W2
…
WX
Slave
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
W1 W2
…
WX
W1 W2
…
WX
EAF: Group Replication
labs.mysql.com
• Multi-master update anywhere
– Conflict detection and resolution (transaction rollback)
– Optimistic State Machine Replication
Application
MySQL
Server
API
MySQL Masters
Replication
Plugin
• Automatic group membership management and failure
detection
– No need for server fail-over
– Elastic scale out/in
– No single point of failure
– Automatic reconfiguration
Group Comms
• Well integrated
– InnoDB
– GTID-based replication
– PERFORMANCE_SCHEMA
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7 Parser & Optimizer Refactoring
Improves readability,
maintainability and stability
Parser
SQL DML query
Optimizer
Resolver:
Semantic check,name resolution
– Cleanly separate the parsing,
Logical transformations
optimizing, and execution stages
Cost-based optimizer:
Join order and access methods
– Allows for easier feature additions,
Plan refinement
with lessened risk
Query execution
plan
Query result
Query execution
Storage Engine
InnoDB
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MyISAM
Optimizer Cost Model: Performance Improvements
DBT-3 (Size Factor 10)
CPU bound
Disk bound
100
80
60
5.6
40
5.7
20
0
Q2
Q18
Execution time relative to 5.6 (%)
Execution time relative to 5.6 (%)
100
80
60
5.6
40
5.7
20
0
Q2
Q18
2 out of 22 queries get a significantly improved query plan (others remain the same)
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7: Query Rewrite Plugin
• New pre and post parse query rewrite APIs
– Users can write their own plug-ins
• Provides a post-parse query plugin
– Rewrite problematic queries without the need to make application changes
– Add hints
– Modify join order
– Many more …
• Improve problematic queries from ORMs, third party apps, etc
• Eliminates many legacy use cases for proxies
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7: Optimizer
• JSON EXPLAIN Expandido
– Agora inclui toda informação de custo
– Usado no Visual Explain do Workbench 6.1
"query_block": {
"select_id": 1
"cost_info": {
"query_cost": "1.00“
},
...
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7: Optimizer
EXPLAIN de queries em execução
• Problema:
Uma query em uma sessão está rodando há um longo tempo
• Nova opção: EXPLAIN FOR CONNECTION de outra sessão
EXPLAIN [FORMAT=(JSON|TRADITIONAL)] FOR CONNECTION <id>;
– Descubra a causa-raíz do atraso
– Otimize a query
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
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... http://mysqlserverteam.com/the-mysql-5-7-7-release-candidate-is-available/
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
58
MySQL 5.7: Performance Schema
Uso da Memória
• Instrumentos para Memória
– Adicionados mais de 200 Memory Types
• Agregação de estatísticas
– Tipo de memória (cache, interna buffer, …)
– Thread/usuário/host gerando operações
indiretas na memória
• Atributos incluem
– Memória usada (bytes), Operações
(counts), máximo/mínimo histórico
Instrumentação de Statements
• Instrumentação ampliada de statements
– Stored Procedures e Stored Functions
– Prepared Statements
– Transações
Outros Dados adicionais
 Métricas e instrumentações adicionais
– Status dos Slaves
– MDL lock
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL SYS Schema
Views simplificadas na Performance Schema & Information Schema
• Desenvolvimento guiado pelo feedback positivo no ps_helper
– Mais de 80 views, versionadas, auto-atualizáveis e de acordo com a versão do server
– Suporta MySQL 5.5, 5.6, and 5.7
• SYS é similar a:
– Oracle V$ catalog views
– Microsoft SQL Server DMVs (Dynamic Management Views)
– IBM DB2 SYSIBM catalog
• Disponível no Workbench 6.1+ ou via GitHub
– Workbench inclui “one click” reports
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7: Security - Encryption, Passwords, Installation
• AES 256 Encryption
– Default in MySQL 5.7
• Password rotation policies
– Can be set globally, and at the user level
• Deployment: enable secure unattended install by default
– Random password set on install
– Remove anonymous accounts
– Deployment without test account, schema, demo files
• Easier instance initialization and setup: mysqld –initialize
• New detection and support for systemd
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
64
MySQL 5.7: Security – SSL, Proxy User
• SSL
– Enabled by default
– Auto-detection of existing keys and certs
– Auto generation of keys and certs when needed
– New helper utility: mysql_ssl_rsa_setup
• Extended Proxy User Support
– Added Built-in Authentication Plugins support for Proxy Users
– Allows multiple users to share a single set of managed privileges
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
65
labs.mysql.com
MySQL 5.7: JSON
• Native JSON data types
– Native internal binary format for efficient processing & storage
• Built-in JSON functions
– Allowing you to efficiently store, search, update, and manipulate Documents
• JSON Comparator
– Allows for easy integration of Document data within your SQL queries
• Indexing of Documents using Generated Columns
– InnoDB supports indexes on both stored and virtual Generated Columns
– New expression analyzer automatically uses the best “functional” index available
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
66
labs.mysql.com
HTTP Plugin for MySQL
• Server Plugin adds HTTP(S) endpoints to MySQL
• Results are serialized to JSON format encoded as UTF8
• Provides 3 choices of User Endpoint Types
– SQL
– CRUD - Key-Value
– JSON - Document
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7: Syslog Support for Linux/Unix platforms
Thank you, Simon Mudd at booking.com
• Native support for syslog
• Simple option to (re)direct log output to native syslog facility
• Start-up server configuration option
• Dynamically in the running server
– System variable log_syslog (ON/OFF, defaults to OFF).
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.7: GIS Improvements
• Replaced custom code with Boost.Geometry
–
–
–
–
For spatial calculations
For spatial analysis
Enabling full OGC compliance
We’re also Boost.Geometry contributors!
• InnoDB R-tree based spatial indexes
– Full ACID, MVCC, & transactional support
– Index records contain minimum bounding box
• GeoHash
• GeoJSON
• Helper functions such as ST_Distance_Sphere() and ST_MakeEnvelope()
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
75
MySQL 5.7: GIS - InnoDB Spatial Indexes
• R-tree based
– Full transactional support
– Predicate locking to prevent phantoms
– Records contain minimum bounding box
• Small and compact
– Currently only supports 2D data
• We would like to add 3D support in the future
– Supports historical spatial index DDL syntax
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
76
Saiba mais...
Detalhes sobre “O que há de novo no MySQL 5.7 (até agora)
• [blog post]
http://www.alastori.com.br/2014/11/oque-ha-de-novo-no-mysql-5.html
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Utilities & Fabric 1.5
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
78
MySQL Utilities 1.5
Útil para DevOps e gerenciamento automatizado do MySQL
• Automatiza tarefas comuns de DevOps
– Replication: provisionamento, teste, monitoramento e failover
– Comparação de Databases: verificação de consistência
– Manutenção: users, connections, tables
– Auditoria
• Scripts em Python
– Pacote standalone ou via MySQL Workbench
– Extensíveis para incluir scripts customizados (usa Python library)
• Novo: Cloud integration: Openstack Nova, “Server providers”
https://oracleus.activeevents.com/2014/connect/fileDownload/session/CF4F217F7E733EF6066ED14D5CB7371C/CON5636_KindahlMySQLFabricElasticityOOW2014.pdf
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Fabric 1.5 (MySQL Utilities)
Alta-disponibilidade + escalabilidade de escrita com sharding
• Alta disponibilidade:
Application
– Monitoramento do Server com failover automático
e transparente para aplicação
Connector
SQL
MySQL Fabric
• Sem Proxy, sem latência extra e SPoF
• Escalabilidade de escrita com sharding:
– Aplicação define a shard key (Range ou Hash)
– Ferramentas para re-sharding
– Tabelas globais & global updates
Read-slaves
Read-slaves
HA group
HA group
• Conectores devem ser “Fabric-aware”:
– Java, Python, PHP
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Cluster 7.4
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
82
Soluções de HA homologadas pela Oracle
MySQL
Replication
MySQL
Fabric
Oracle VM
Template
Oracle
Clusterware
Solaris
Cluster
Windows
Cluster
DRBD
MySQL
Cluster
App Auto-Failover
✖
✔
✔
✔
✔
✔
✔
✔
Data Layer Auto-Failover
✖
✔
✔
✔
✔
✔
✔
✔
MySQL 5.7
MySQL 5.7
✔
✔
✔
✔
✔
✔
Platform Support
All
All
Linux
Linux
Solaris
Windows
Linux
All
Clustering Mode
Master +
Slaves
Master +
Slaves
Active/Pas
sive
Active/Passi
ve
Active/Pa
ssive
Active/Pass
ive
Active/Pa
ssive
MultiMaster
N/A
Secs
Secs +
Secs +
Secs +
Secs +
Secs +
< 1 Sec
Reads
✔
✖
✖
✖
✖
✖
✔
N/A
✖
N/A
N/A
N/A
N/A
N/A
✔
Transparent routing
✖
For HA
✔
✔
✔
✔
✔
✔
Shared Nothing
✔
✔
✖
✖
✖
✖
✔
✔
Storage Engine
InnoDB+
InnoDB+
InnoDB+
InnoDB+
InnoDB+
InnoDB+
InnoDB+
NDB
✔
✔
✔
✔
✔
✖
✔
✔
Zero Data Loss
Failover Time
Scale-out
Cross-shard operations
Single Vendor Support
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Cluster 7.4 GA
• 200 Million NoSQL
Reads/Sec
• 2.5M SQL Ops/Sec
• 50% Faster Reads
• 40% Faster Mixed
• Active-Active
Geographic
Redundancy
• Conflict
Detection/Resolution
• 5X Faster
Maintenance Ops
• Detailed Reporting
Performance
Active-Active
Management
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Copyright 2015, oracle and/or its affiliates. All rights reserved
85
MySQL Cluster 7.4
GA
Better performance and operational simplicity
• Performance gain over 7.3
– 50% (Read-Only)
– 40% (Read-Write)
• Faster maintenance operations
– Nodal & Rolling restarts
– Upgrades
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
86
MySQL Cluster: Active-Active Geo-Replication
• Asynchronous replication between MySQL Clusters
• Active-Active
– Update anywhere
– Conflict detection
• Application notified through exception tables
• Can opt to have conflicts resolved automatically
– Auto-conflict-resolution
• Conflicting transaction and dependent ones are rolled-back
• No required changes to app schema
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
88
MySQL Workbench 6.3
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
89
MySQL Workbench 6.3
GA
• Fabric
– Add node, browse, view, connect
• Performance Dashboard
– Performance Schema Reports & Graphs
• Visual Explain
• GIS Viewer
• Migration
– New: Microsoft Access
– Microsoft SQL Server, Sybase,
PostgreSQL, SQLite
• New Easy to Use Wizards for
– Fast Data Migration
– Table<->File Data Import/Export (like Excel)
– SSL Certificate Creation
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
91
MySQL Workbench 6.1
Dashboards: Performance & Status
Network, Server, InnoDB
Analyze hotspots, costly SQL statements, wait times,
locks, InnoDB stats, and more
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
95
MySQL Enterprise
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
97
MySQL Enterprise Edition
Suporte + Backup + Monitor + Workbench + Plug-ins
Escalabilidade
Segurança
Firewall
Auditoria
Criptografia
Oracle Enterprise Manager
for MySQL
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Oracle Premier Support para MySQL
Engenheiros MySQL como parte do seu time
• Acesso direto 24 x 7 x 365
• Número ilimitado de incidentes
• Base de conhecimento, Hot fixes, Patches
• Tradução para o Português
• Suporte Consultivo
• Maior time de especialistas MySQL no mundo
• Suportados pelos próprios Desenvolvedores do MySQL
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Suporte Consultivo MySQL
Portfolio de serviços
• Troubleshooting remoto
• Revisões: Replicação, Particionamento, Schema, Queries
• Performance Tuning
• Revisão de Código gerado pelo cliente: Client APIs, User Defined
Functions, Server Extensions, Stored Routines (Triggers, Procedures,
Functions)
• Suporte remoto à instalação e upgrades
https://www.mysql.com/support/consultative.html
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Enterprise Backup
• Backup online para InnoDB, tamanho ilimitado
• Backups automatizados: completos, incrementais, parciais
• Compressão, Criptografia AES256
• Metadados de status, progresso e histórico
mysqlbackup
• Recovery: Point in Time, Parcial ou Completo
• Multi-Plataforma: Windows, Linux, Unix
MEB
Backup
Files
• Compatível MMS: Oracle Secure Backup, SBT
• Suporte Cloud: Open Stack, Amazon S3
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL
Database
Files
MySQL Enterprise Backup
Menor tempo em backups e restores, menos downtime
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
New! Oracle Enterprise Manager for MySQL
• Availability monitoring
• Performance monitoring
• Configuration monitoring
• All available metrics collected
– Allowing for custom threshold
based incident reports
• MySQL auto-detection
Security
Performance
Availability
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
111
MySQL Enterprise Monitor 3.0
• Monitoramento em tempo real da
•
•
•
•
performance e disponibilidade
Encontre e corrija problemas
visualmente
Monitore discos e faça capacity
planning
Comece a monitorar em 10 minutos
Arquitetura que não exige agentes
• Agente remoto monitora SO
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
114
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Capacity Planning
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Enterprise
Extensões comerciais para o MySQL Database
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
121
Enterprise Scalability com Thread Pool
60x Melhor Escalabilidade comThread Pool
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.6.11
Oracle Linux 6.3, Unbreakable Kernel 2.6.32
4 sockets, 24 cores, 48 Threads
Intel(R) Xeon(R) E7540 2GHz CPUs
512GB DDR3 RAM
Enterprise Scalability com Thread Pool
18x Melhor Escalabilidade comThread Pool
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL 5.6.11
Oracle Linux 6.3, Unbreakable Kernel 2.6.32
4 sockets, 24 cores, 48 Threads
Intel(R) Xeon(R) E7540 2GHz CPUs
512GB DDR3 RAM
Plugins Comerciais para Segurança
MySQL Enterprise Secutiry
MySQL Enterprise Firewall
• External Authentication Plugins
• Bloqueio online de ameaças
• Delega autenticação para diretório de usuários,
como AD, LDAP
• Transparente para Aplicação
• Linux e Windows
• Alertas & Logs
MySQL Enterprise Audit
MySQL Enterprise Encryption
• Implementa logs de auditoria com um único
comando de instalação
• Funções do OpenSSL via SQL
• Flexibilidade na configuração
• Aderente às principais normas de regulação
• Gerenciamento de Certificados
• Criptografia Assimétrica
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
124
Enterprise Security com External Authentication
Usuário/senha definidos no diretório
Privilégios definidos no MySQL e
mapeados para usuários/grupos do diretório
PAM / Windows
Auth
LDAP/AD
Authenticate
CREATE USER win_joe
IDENTIFIED WITH authentication_windows
AS ‘joe';
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Enterprise Audit
3. Log de conexões e queries
1. DBA habilita Audit plugin
2. Usuário conecta e executa query
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
126
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
127
Enterprise Firewall
Select *.* from employee where id=22
Select *.* from employee where id=22 or 1=1
Applications
• Construção automática de
Whitelists
• Bloqueio online de ameaças
White List
Allow & Log
Block & Log
• Alertas & Logs
• Transparente para Aplicação
• Alta performance & Escalável
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL Enterprise Encryption
Criptografia simétrica ou assimétrica baseada em chave pública/privada
• MySQL encryption libraries
– Symmetric encryption AES256
– Public-key / asymmetric cryptography
• Key management
– Public & private keys
– Key exchange methods: RSA, DSA, DH
• Sign & verify data
– Cryptographic hashing: digital signing, verification, & validation
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
MySQL & Oracle Product Integrations
• Oracle Linux
• Oracle VM
• Oracle Solaris
• Oracle Clusterware
• Oracle OpenStack for Oracle
Linux
• Oracle Enterprise Manager
• Oracle Secure Backup
• Oracle Fusion Middleware
• Oracle GoldenGate
• Oracle Audit Vault & Database Firewall
• MyOracle Online Support
MySQL Integrates into your Oracle Environment
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
133
MySQL Enterprise Edition
Contatos comerciais
Marcos Trujillo
Enterprise Sales, Oracle
[email protected]
Alison Rabelo
OEM/ISV Sales, Oracle
[email protected]
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Treinamentos e certificações
MySQL DBA
MySQLDeveloper
Certificações
MySQL for
Beginners Ed 3
Introduction to
MySQL 5.5
Oracle Certified
Professional, MySQL 5.6
DBA
MySQL for Database
Administrators Ed 3.1
MySQL for
Beginners Ed 3
MySQL Performance
Tuning
MySQL and PHP
Developing Dynamic Web
Applications
MySQL High Availability
Oracle Certified
Professional, MySQL 5.6
Developer
Oracle Certified Expert,
MySQL Cluster DBA
MySQL for Developers Ed 2
MySQL Cluster
MySQL Developers
Techniques
MySQL Advanced Stored
Procedures
Opcional
Necessário
education.oracle.com/mysql
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Sumário
• Há muito investimento da Oracle no MySQL com foco em Aplicações
Web e Embarcadas.
• A edição Community ganha mais velocidade e qualidade.
• O MySQL Enterprise Edition aumenta a disponibilidade, o
desempenho e a segurança através de ferramentas, extensões
comerciais e suporte.
• Se a aplicações é de missão crítica ou tem potencial para ser a Oracle
pode ajudar profissionalizando seu ambiente com o MySQL Enterprise
Edition.
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Obrigado!
Copyright
© Oracle
2015 Oracle
and/or
its affiliates.
All rights
reserved. |
Copyright
© 2014,
and/or
its affiliates.
All rights
reserved.
@MySQLBR
facebook.com/MySQLBR
meetup.com/MySQL-BR
pt.planet.mysql.com
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |
Perguntas?
The State of the Dolphin
Contato:
[email protected]
twitter.com/mysqlbr
facebook.com/mysqlbr
Copyright © 2015 Oracle and/or its affiliates. All rights reserved. |