MySQL professionell betreibenMario BeckOctober, 2010
MySQL Kunden
MySQL ist die treibende Kraft fr das Web
Enterprise 2.0TelekommunikationOn Demand, SaaS, Hosting
Web / Web 2.0 OEM / ISV's
Puma
AnwendungOnline Shop; Verwaltung von Produkt- und Kundendaten
sowie Warenkrben
HauptvorteilGeringe Kosten, einfache Installation und
Nutzung
Warum MySQL? MySQL Enterprise mit dem MySQL
Enterprise Monitor und den umfangreichen Dienstleistungen ist fr
uns eine optimale Lsung zum Betrieb und Ausbau unseres
Online-Shops.
Christian BurgerIT Manager
Puma
Cashpoint
AnwendungPortal fr Online-Wetten und -Spiele auf MySQL Cluster
& MySQL Enterprise
HauptvorteilHhere Performanz und Skalierbarkeit. Zuvor
eingesetzte Sybase Datenbank gengte den Anforderungen nicht
mehr.
Warum MySQL? Neben einer jhrlichen Einsparung von
250.000 Euro fr Lizenzen konnte Cashpoint 150.000 Euro an
Server- und 90.000 Euro an Personalkosten einsparen.
Thomas SchlinkSystemadministrator
Cashpoint Agentur & IT Service GmbH
RZ der Finanzverw. Nordrhein-Westfalen
AnwendungSteuer- und Finanzwanwendungen, derzeit ber 260 MySQL
Server im Einsatz
HauptvorteilNiedrige Kosten, einfache Nutzung, hohe
Zuverlssigkeit
Warum MySQL? Mit MySQL Enterprise knnen wir
kosteneffizient neue Anwendungen entwickeln, betreiben sowie
alle relevanten Datenbankfunktionen bersichtlich und sehr einfach
berwachen.
Guido KutasiDezernent Datenbanken
RZ der Finanzverw. Nordrhein-Westfalen
Security
Performance
Availability
Maximum Performance per Server
Low Ressource Consumption
Scaling Options
Stable Software
HA Options for different Needs
Find Problems BEFORE they occur
Correct Code
Only Authorized Access
Up-to-date Security Fixes
MySQL Professional Requirements
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Proactive Monitoring
BestPractices
7x24Support
OnlineBackup
KnowledgableConsultants
Easy QueryAnalysis
EasyDevTools
Revenue and Productivity
Applications/Users/Customers
1 minute downtime = Lost $ DBA/Dev time on strategy/projects
- eCommerce Times
Ill fix it myselfSpend time, save
money
Ill hire more DBAs!
Spend more time, save less
money
Outage = Loss
We need help!Spend money,
save time
What is at risk?
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Proactive Monitoring
BestPractices
7x24Support
OnlineBackup
KnowledgableConsultants
Easy QueryAnalysis
EasyDevTools
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Proactive Monitoring
BestPractices
OnlineBackup
KnowledgableConsultants
Easy QueryAnalysis
EasyDevTools
Premium Support
Self Help Support Service Online Knowledge Base
Problem Resolution Service Seasoned Support Team 24 X 7
email/phone access
Consultative Support Services Remote Troubleshooting Service
Configuration and Tuning Services Customer Code Review Services
Production Support from Oracle
Premium Support
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Proactive Monitoring
BestPractices
OnlineBackup
Easy QueryAnalysis
EasyDevTools
Professional Service
MySQL High Availability Solutions MySQL Scale-Out, HA and
Replication Jumpstart MySQL Architecture & Design MySQL
Cluster Jumpstart MySQL Project
Implementations/Migrations
MySQL Professional Services
Professional Service
Premium Support
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Proactive Monitoring
OnlineBackup
Easy QueryAnalysis
EasyDevTools
Knowledge Base
MySQL Knowledge Base
Written and reviewed by MySQL experts Best practices, How-tos,
Performance Tuning, ... Fully categorized with easy search
capabilities Integrated with Monitoring and Advisory Service
Failing over a Slave SQL Node to another SQL Master
nodeHeartbeat ConfigurationDRBD ConfigurationCan I use LVM on top
of DRBD?Advanced MySQL Replication TechniquesHow can a slave be set
to not replicate DROP and DELETE statements?How to restore a
Cluster Slave using its own backups.How do I check if Master and
Slave are in sync?How do I configure a slave if the master is
running and I do not want to stop it?How do I replicate a
cluster?How do I convert a CSV table to another table type?How can
MS Access be used as a front-end for MySQL?How do I Migrate Data
From Microsoft Access to MySQL?How do I import data into MySQL from
a simple text file?Debugging InnoDB Locks using the new InnoDB
Plugins Information Schema TablesHow can I add to an existing
InnoDB data file?How can I determine how much disk space an InnoDB
table uses?How do I tune the MyISAM key buffer and InnoDB buffer
pool in MySQL?Using Replication-Aware Connections with MySQL and
Connector/JShould I use Connector/NET or Connector/ODBC to develop
my application?Understanding and using connection pooling...
Knowledge Base
Professional Service
Premium Support
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Proactive Monitoring
OnlineBackup
Easy QueryAnalysis
Workbench SE
MySQL Workbench Home Screen
MySQL Workbench Home Screen
MySQL Workb
ench
fr Einsteiger
16:00, Raum
Krakau
Workbench SE
Knowledge Base
Professional Service
Premium Support
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Proactive Monitoring
Easy QueryAnalysis
Enterprise Backup
MySQL Enterprise Backup
Formerly InnoDB Hot BackupOnline, non-locking backup &
recovery
Tables, Indexes Server, database, or object-level
Logical and physical backupsFull or incremental
backupsPoint-in-time recoveryCompressed backupsAlso provides backup
& recovery for MyISAMCross-Platform (Windows, Linux, Unix)
Enterprise Backup
Workbench SE
Knowledge Base
Professional Service
Premium Support
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Easy QueryAnalysis
Enterprise Monitor
Single, consolidated view into entire 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 MyOracle Support
A Virtual MySQL DBA Assistant!
MySQL Enterprise Monitor
MEM Deployment DiagramMySQL Enterprise Monitor Deployment
Monitoring with Rules
MySQL Expert Advisors
Save you time writing, deploying, versioning, maintaining custom
scripts. Visualize problems and tuning opportunities you cannot
find yourself.
140+ Rules, 40+ Graphs
Administration Monitors and Advises on
Optimal Configuration
Security Monitors and Advises
on Unplanned Security Changes/Loopholes
Upgrade Monitors and Advises on
Bugs/Upgrades that affect current installation
Replication Monitors and Advises on
Master/Slave Latency.
Memory Usage
Monitors and advises on optimal memory/cache settings
Schema Monitors and Advises
on Unplanned Schema Change
Performance Monitors and Advises
on Optimal Performance Variable Settings
Built by DBA to Enforce Organization specific best
practices.
Custom
MySQL Cluster Monitors and Advises on
status/ performance of MySQL Cluster Data Nodes.
Saves you time monitoring and collecting replication
status/synch data from MySQL command line.
Auto-detects, groups/maintains Master/Slave topologies
Consolidated, real time
status/synch check Notifications on Synch
Issues
Automated Replication Monitor
Graphs
- 40+ graphs immediately visualize system behaviour- MySQL and
OS data available
Integration with MyOracle Support
MySQL Enterprise Monitor Collect MySQL diagnostics and upload to
MOS SR Track SRs from Enterprise Dashboard Saves DBA time
collecting data for Support team, tracking status
Enterprise Monitor
Enterprise Backup
Workbench SE
Knowledge Base
Professional Service
Premium Support
What Pros are dreaming of...
Open-source serverwith pluggable APIs
Query Analyzer
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 Saves time parsing atomic
executions for total query expense Visual grab and go
correlation with Monitor graphs
MySQL Query Analyzer
Architecture
3. MySQL Connector
4. Connector Plugin
Query Execution Drill Downs Example query exec
with variable substitution
Trace query exec back to source code
Full exec EXPLAIN
Relief for Administrators
Easy browser UI and Integration in SNMP frameworks quick
overview, easy to use, same tools as always140+ pre-defined rules
enforce best-practice administration No more waste of time to
develop monitoring, adapt to new version, Regular rule updates to
monitor new features Fast adoption of new features without much
effort Comrehensive documentation Assistance for junior MySQL
adminsQuery Analyzer Easier to spot application problemsSupport
integration Save time in handling support issues, faster solution,
better uptime
What Pros are dreaming of...
Open-source serverwith pluggable APIs Premium Support
Professional Service
Knowledge Base
Enterprise Backup
Enterprise Monitor
Workbench SE
Query Analyzer
Oracle + MySQL Customers
Product Integration Oracle GoldenGate (Complete!) Oracle
Enterprise Linux + Oracle VM (CY 2011) Oracle Secure Backup (CY
2011) Oracle Audit Vault (CY 2011) Oracle Enterprise Manager (CY
2011)
Support Leverage 24x7, World-Class Oracle Support MyOracle
Support
[email protected]
Thank You!
Slide 1MySQL CustomersSlide 3Slide 4Slide 5Slide 6MySQL
Enterprise FeaturesWhat is at risk?Slide 9Slide 10Production
Support from OracleSlide 12MySQL Professional ServicesSlide 14Slide
15Slide 16MySQL Workbench Home ScreenSlide 18Slide 19MySQL
Enterprise BackupSlide 21Slide 22Slide 23Slide 24Slide 25Automated
Replication MonitorSlide 27Slide 28Slide 29MySQL Query
AnalyzerSlide 31Query Execution Drill DownsSlide 33Slide 34Slide
35Slide 36
