View
215
Download
0
Embed Size (px)
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
