Upload
nguyenliem
View
221
Download
0
Embed Size (px)
<Insert Picture Here>
MySQL professionell betreibenMario BeckOctober, 2010
MySQL Kunden
MySQL ist die treibende Kraft für das Web
Enterprise 2.0TelekommunikationOn Demand, SaaS, Hosting
Web / Web 2.0 OEM / ISV's
Puma
AnwendungOnline Shop; Verwaltung von Produkt- und Kundendaten sowie Warenkörben
HauptvorteilGeringe Kosten, einfache Installation und Nutzung
Warum MySQL? “MySQL Enterprise mit dem MySQL
Enterprise Monitor und den umfangreichen Dienstleistungen ist für uns eine optimale Lösung zum Betrieb und Ausbau unseres Online-Shops.“
Christian BurgerIT Manager
Puma
Cashpoint
AnwendungPortal für Online-Wetten und -Spiele auf MySQL Cluster & MySQL Enterprise
HauptvorteilHöhere Performanz und Skalierbarkeit. Zuvor eingesetzte Sybase Datenbank genügte den Anforderungen nicht mehr.
Warum MySQL? “Neben einer jährlichen Einsparung von
250.000 Euro für 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 Zuverlässigkeit
Warum MySQL? “Mit MySQL Enterprise können 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
“I’ll fix it myself”Spend time, save
money
“I’ll 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-to’s, Performance Tuning, ...• Fully categorized with easy search capabilities • Integrated with Monitoring and Advisory Service
Failing over a Slave SQL Node to another SQL Master node
Heartbeat Configuration
DRBD Configuration
Can I use LVM on top of DRBD?
Advanced MySQL Replication Techniques
How 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 Plugin’s Information Schema Tables
How 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/J
Should 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 Workbench
für 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 Backup”Online, 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 always
140+ 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 admins
Query Analyzer• Easier to spot application problems
Support 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