MySQL Tech Tour Nov, 2013
-
Upload
mysql-latinoamerica -
Category
Technology
-
view
447 -
download
3
description
Transcript of MySQL Tech Tour Nov, 2013
![Page 1: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/1.jpg)
MySQL OEM Tech Tour, Lima Perú — Noviembre 2013
** https://www.flickr.com/photos/bainro/11093732325/sizes/c/in/photostream/
![Page 2: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/2.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
MySQL OEM Team – LAD
[email protected] ~ Senior Field Rep, MySQL LAD
[email protected] ~ Inside Sales Rep, MySQL LAD
[email protected] ~ Senior Consultant, MySQL LAD
!!!!
![Page 3: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/3.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
MySQL Direct Team – [email protected] Strategic Accounts, Latinoamérica & El Caribe
[email protected] Software Consultant, Latinoamérica & El Caribe
[email protected] Corporate Sales Manager, Latinoamérica & El Caribe
[email protected] Corporate Sales, Centroamérica, México, Colombia & El Caribe
[email protected] Corporate Business Rep., Argentina, Chile, Paraguay & [email protected] Team Lead | Corporate Sales, Latinoamérica & El Caribe !!!
![Page 4: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/4.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
1. Menor footprint que otras sistemas de base de datos 2. Instalación express en 15 minutos 3. Soporte 24x7 “Oracle Premier Support” 4. Mejor TCO que otros RDMS comerciales 5. Desempeño, 1 billion+ de QPM - NDBCluster 6. Multi-plataforma ( Hardware, OS ) 7. Basado en estándares GPL 8. Adopción basada en comunidades - 80k downloads por día - 9.Integración con Oracle DB suite: Oracle Enterprise Manager, Oracle
Linux, Golden Gate, etc… 10. Opciones de Clustering & MySQL Replication flexibles
Top 10 Razones del por que usar MySQL
![Page 5: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/5.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
Tendencias MySQL & Oracle
![Page 6: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/6.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved. Copyright 2012, Oracle and/or its affiliates. All rights reserved.
MySQL & Grandes Vólumenes de Información
![Page 7: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/7.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
![Page 8: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/8.jpg)
5
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
CommunityEnterprise MySQL
Ediciones de MySQL Enterprise y Open Source
![Page 9: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/9.jpg)
6
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Funcionalidades Standard SE Enterprise EE Cluster CGE
MySQL Database ✔ ✔ ✔
MySQL Connectors ✔ ✔ ✔
MySQL Replication ✔ ✔ ✔
MySQL Partitioning ✔ ✔
MySQL Workbench SE ✔ ✔ ✔
Storage Engine: MyISAM ✔ ✔ ✔
Storage Engine: InnoDB ✔ ✔ ✔
Storage Engine: NDB ✔
MySQL Enterprise Monitor ✔ ✔
MySQL Enterprise Backup ✔ ✔
MySQL Cluster Manager ✔
MySQL Enterprise Security ✔ ✔
MySQL Enterprise Scalability ✔ ✔
Disponible sólo en la edición comercial.✔
MySQL Ediciones
![Page 10: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/10.jpg)
7
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
Oracle Premier Lifetime Support
Oracle Product Certifications/Integrations
MySQL Enterprise High Availability
MySQL Enterprise Security
MySQL Enterprise Scalability
MySQL Enterprise Backup
MySQL Enterprise Monitor/Query Analyzer
MySQL Workbench
MySQL Enterprise Audit
MySQL Enterprise Edition Los Niveles más altos en Seguridad, Rendimiento y Disponibilidad.
![Page 11: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/11.jpg)
Vista única consolidada del ambiente MySQL
Auto descubrimiento de servidores MySQL, replicación y topologías
Alertas y monitoreo adaptable y basado en reglas
Identificación de problemas antes de que ocurran
Reducción de riesgo y tiempo de inactividad
Facilidad para escalamiento horizontal sin requerir más DBAs
http://mysql.com/products/enterprise/monitor.html
MySQL Enterprise Monitor
![Page 12: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/12.jpg)
![Page 13: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/13.jpg)
MySQL Enterprise Monitor Deployment
![Page 14: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/14.jpg)
MySQL Enterprise Edition
MySQL Community Server
MySQL Enterprise - Performance
20x Mejor escalabilidad MySQL Enterprise MySQL 5.5.16
Oracle Linux 6.1, Unbreakable Kernel 2.6.322 sockets, 24 cores, 2 X 12-coreIntel(R) Xeon(R) X5670 2.93GHz CPUs72GB DDR3 RAM2 X LSI SCSI Disk (MR9261-8i) (597GB)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
![Page 15: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/15.jpg)
Default Connection Pool
Users/Clients
Connection 1
Default Connection Pool
Connections /statements assigned to Threads
for life
Connection 1 Execution Thread
Connection 2 Connection 2 Execution Thread
Connections assigned to 1 thread for the life of the connection Same thread used for all connection statement executions (single threaded)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
![Page 16: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/16.jpg)
With Thread Pool Enabled
Thread Pool (and thread groups) Connection 1 Execution Threads
Users/Clients
Connection 1
Connection 2
Connection 1
Threads 1 - 4096Connection 2
Threads 4097 - 8193
Connection 2 Execution Threads
Pool contains configurable number of thread groups (default = 16), each manages up to 4096 re-usable threads Each connection assigned to thread group via round robin
Connection N
Threads 8194 - N
Ensures better, sustained performance as user loads continue to grow.
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
![Page 17: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/17.jpg)
13
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
2. User Joe Connects and Queries Server1
MySQL Enterprise Audit Flow
1. DBA Enables on Server1Server1
3. Joe’s connection, query logged
![Page 18: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/18.jpg)
14
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
MySQL Enterprise Security
![Page 19: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/19.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
Ap
ps TAdministration
Database
Storage
Operating System
Hardware
Pla
tfo
rms
ETL/ Replication
Application Development
App – Web Servers & Load Balancers
Content Management
Session Management
User Directory
Blogs & Forums
Search Engines
eShop & Commerce
Business Intelligence
MySQL Ecosistema
![Page 20: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/20.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
Centralized monitoring of Queries across all servers
No reliance on Slow Query Logs, SHOW PROCESSLIST;, VMSTAT, etc.
Aggregated view of query execution counts, time, and rows
“Grab and go” integration with Monitor graphs so work loads can be correlated with query activity
Traces queries back to source code
Saves time parsing atomic executions for total query expense
MySQL Query Analyzer
![Page 21: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/21.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
MySQL Enterprise BackupHigh 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
MEB BackupFiles
MySQL Database Files
mysqlbackup
![Page 22: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/22.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
High Performance Backups
Backups are up to 3.5x Faster than mysqldump
![Page 23: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/23.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
High Performance Restore
Restore is up to 16x Faster than mysqldump
![Page 24: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/24.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
Backup Compression Storage Savings
Backup size reduced from 65% up to 93%
![Page 25: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/25.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved. 32© 2012 Oracle Corporation – Proprietary and Confidential
MySQL Workbench 6.0
“MySQL Workbench is the best SQL applicationI’ve ever used! The modeling stuff is so sick!”
“MySQL Workbench – I think I love you. Exporting backups and managing mass connections is so simple. Bootiful!”
“Absolutely loving MySQL Workbench!”
![Page 26: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/26.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
MySQL Workbench
SQL Development SQL Editor - Color Syntax Highlighting
Object Management - Import/Export, Browser, Edit
Connection Management - Wizard, SSH Tunnel
Multi-Pane Results View, In-grid data edits
Data Modelling
Visual Design
Forward/Reverse Engineer
Database Administration
Status, Configuration, Start/Stop, Replication
Users, Security, Session Management
Import/Export Dump Files
New! Database Migration Wizard
for SQL Server, Sybase, PostgreSQL
![Page 27: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/27.jpg)
MySQL – High Availability
![Page 28: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/28.jpg)
Copyright © 2013, Oracle and/or its affiliates. All rights reserved.
MySQL Replication
Clustering & Virtualization
Clustering & Geo Replication
DRBD
TCO
& M
ore
Com
plex
Alta Disponibilidad
%9 9 9935 dias 4 days 50 min 5 min8 horas
eCommerce Telecoms, Militar
.94 dias
ISPs & Corporativo
On-Line Services
![Page 29: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/29.jpg)
!29
Mapping Applications to HA Technology
![Page 30: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/30.jpg)
MySQL + Java
![Page 31: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/31.jpg)
Recap: MySQL – Replicación Master – Slave
![Page 32: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/32.jpg)
JDBC | Java Database Connectivity
JDBC – MySQL Master, Slave1, Slave2, SlaveN – Round Robin !!
Prácticas Recomendadas para Java Developers
- Balanceo de Lectura en servidores Slave - Servidor Master para Read & Writes - Slaves para Read Only - JDBC Connector automáticamente, selecciona un Slave de la lista de Slaves
h
![Page 33: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/33.jpg)
JDBC | Java Database ConnectivityPrácticas Recomendadas para Java Developers
h- Import de Librerías
- Configura Driver para uso en RoundRobin Load Balancing
![Page 34: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/34.jpg)
JDBC | Java Database ConnectivityPrácticas Recomendadas para Java Developers
h- Insert Datos en Master ( Read Only False )
![Page 35: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/35.jpg)
JDBC | Java Database ConnectivityPrácticas Recomendadas para Java Developers
h- Select Datos en uno de los Slaves ( Read Only True )
![Page 36: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/36.jpg)
MySQL + Windows ( .NET )
![Page 37: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/37.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
MySQL – OEM
h
![Page 38: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/38.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
Top 10 Reasons to Use MySQL as an Embedded Database:!http://www.mysql.com/why-mysql/white-papers/top-10-reasons-to-use-mysql-as-an-embedded-database/!!!!Guide to MySQL as an Embedded Database:!http://www.mysql.com/why-mysql/white-papers/guide-to-mysql-as-an-embedded-database/!
!!MySQL Enterprise Monitor for ISVs & OEMs:!http://www.mysql.com/why-mysql/white-papers/mysql-enterprise-monitor-for-isvs-and-oems/! !
!
sGracias
![Page 39: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/39.jpg)
MySQL OEM Tech Tour, Lima Perú — Noviembre 2013
** https://www.flickr.com/photos/bainro/11093732325/sizes/c/in/photostream/
![Page 40: MySQL Tech Tour Nov, 2013](https://reader034.fdocument.pub/reader034/viewer/2022052617/546d6537af795980298b52f4/html5/thumbnails/40.jpg)
Copyright © 2013 Oracle and/or its affiliates. All rights reserved.
Como ser un socio ISV