20100914 MiniKickoff ME

8/8/2019 20100914 MiniKickoff ME

http://slidepdf.com/reader/full/20100914-minikickoff-me 1/26

<Insert Picture Here>

Introducing MySQL Enterprise

Ivan Tu

MySQL Sales Consultant



2

• Subscription:• MySQL Enterprise

• License (OEM):

• Embedded Server • Support

• MySQL Cluster

Carrier-Grade•

Training• Consulting• NRE

Database

Monitoring

Support

• MySQL Enterprise Server

• Monthly Rapid Updates• Quarterly Service Packs• Hot Fix Program

• Global Monitoring of All Servers

• Web-Based Central Console• Built-in Advisors, Expert Advice• MySQL Query Analyzer • Specialized Scale-Out Help

• Online Self help Knowledge Base• 24 x 7 x 365 Problem Resolution• Consultative Help• High Availability and Scale Out

MySQL Enterprise: Subscription



3

Spend time to save money or Spend money tosave time?

Open Source

Benefits from testing by worldwide Community

Feature Releases Mature Mature

Benchmarked with 2,000+ connections

Rapid Update Service Pack Program

Quarterly Service Pack Program

Hot Fix Program

MySQL Enterprise Monitor and Advisors

MySQL Query Analyzer

Bug Escalation Privilege

Live feeds for Software/Support Status updates

Online Knowledge Base

24x7 Production/Consulting Support Services

Extended End-of-Life Support Policy

Legal indemnification

MySQL Enterprise vs Community Server



5

New and Improved Enterprise Monitor

New Flexible Options for Monitoring Query Performance

• New MySQL Enterprise Connector Plugins to Query Analyzer • MySQL Query Analyzer Advanced Search Options

• New Query Analyzer Execution Notices

Improved User and Security Model

• New Read Only User

• New LDAP Authentication

Improved Integration with MySQL

Support• New MySQL Support Diagnostic

Reports



6

New and Improved Enterprise Monitor

Improved Usability

• New Auto-closing Events• New Searchable Graphs

• New Custom Rule/Graph Import and Export

• New Intelligent Installation Options

• New Faster Purging of Repository Data

• New UI Session Management

Improved Advisor Rules and Graphs

• New Advisor Rules and Graphs



7

• Centralized monitoring of

Queries across all servers• No reliance on Slow Query

Logs, SHOWPROCESSLIST;, VMSTAT,etc.

• Aggregated view of queryexecution counts, time, androws

• Saves time parsing atomic

executions for total queryexpense

MySQL Query Analyzer



8

MySQL Architectrure



9

• Configuration• Advisor Scheduling• Alerts/Notifications• Visual Monitoring

• Query Analysis

Service Agent written in C

and supports all MySQL

Enterprise platforms

Service Manager written in

Java servlets exposed asweb services. Supports

Linux, Solaris, Mac OSX and

Microsoft Windows

Enterprise Dashboard

Web-based, written in JSP

Repository holds historical

performance data for

analysis

Individual Servers

w/Agent

Master-Slave ReplicationEnterprise

Dashboard

Service

Manager

Repository

Customer Datacenter

• Advisor Monitoring

• Event based Alerts• Advice/Corrective Actions

Collects MySQL and

OS specific metrics,

Query content/stats

Holds historical MySQL

and OS data, Query Statistics

Enterprise Monitor Architecture



10

Administration

• Monitors and Advises

on OptimalConfiguration and

Variable Settings• Ensures

Recoverability

Security

• Monitors and

Advises onUnplanned Security

Changes• Uncovers Security

loopholes

Upgrade


Bugs that affect currentinstallation

• Provides update path

to correcting

MRU/QSP

Replication


on Master/Slave

Latency Issues• Makes suggestions

for improving

replication design

Memory

Usage

• Monitors for optimal

use of memory/cache• Advises on memory

tuning for better

performance

Schema


on Unplanned Schema

Change• Uncovers Security

loopholes

Performance


on Optimal

Performance Variable

Settings• Identifies performance

bottlenecks

• Built by DBA toEnforce Organization

specific best practices.• Create New or Tailor

MySQL Advisors to fit

needs.

Custom

130+ Rule, 30+ GraphsWhy? Save you time writing, deploying, versioning,

maintaining custom scripts. Find problems and tuningopportunities you cannot find yourself.

Advisors, Rules and Graphs



11

Upgrade Advisor

Replication Advisor

Security Advisor

Replication Monitor

Memory Usage Advisor

Schema Advisor

Performance Advisor

Administration Advisor

Custom Advisors

Notifications and Alerts

Web-based Enterprise

Dashboard

Enterprise

Platinum

Enterprise

Gold

Enterprise

Silver

Enterprise

BasicEnterprise Monitor

Query Analyzer/Graph Corr.

Advisors by Subscription Level



12

Support

Platinum

Gold +

• Query Review• Schema Review• PerformanceTuning

• Custom CodeReview

• Highest 24x7SLA

• NewPerformance,Schema Advisors

•

New Graphs

Gold

Silver +

• Advanced Server • Query Analyzer

/Graph Correlation• Replication Monitor • Hot Fix builds• Partitioning Review• Replication Review• RemoteTroubleshooting

• DRBD for MySQL• Memcached for MySQL

• Indemnification(option)

• 24x7 Support

Silver

Basic +

EnterpriseMonitor

ExtendedLifecycle Support

Business Hour

Phone Support Live Feeds for Product andSupport Updates

InstallationAdvantage

Basic

Pro Server MRU/QSPs New Update Service Knowledge Base 2 Incidents viaemail support

Subscription Level Upgrades



13

MySQL Enterprise Customer Site

http://c/Solaris_disk/MySQL/MySQL%20enterprise.ods

http://c/Solaris_disk/MySQL/MySQL%20enterprise.ods



15

New Connector Plugins to Query Analyzer

• Enable Query Analyzer without need for MySQL Proxy

• More configuration options• Less overhead than proxied connection to database

• Proxy for dev/QA, Connectors for production

• Adds query collection to Connector components used by

most/all MySQL applications• Plugins available for:

• Connector/J

• Connector/Net

• Connector/PHP, C - TBD



16

Monitoring Queries with MySQL Proxy

1. MySQL Enterprise Monitor & Query Analyzer

2. MySQL Proxy & Agent

List of components to download & configure:

Application Server MySQL Database

(SQL statements & result sets)

3306

18080

2. MySQL Proxy

& MySQL Agent **6446

(MySQL, OS monitoring data, SQL performance data: statements,

examples, EXPLAINs, aggregated stats)

1. MySQL Enterprise Monitor (Service Manager, Dashboard)

** MySQL Proxy is optionally deployed and

configured as a plugin with the MySQL Agent



17

Monitoring Queries with Connector/J, NET

1. MySQL Enterprise Monitor & Query Analyzer

2. MySQL Agent

3. Connector/J v5.1 or newer/ Connector/NET v6.2 or newer

4. New! MySQL Enterprise Plugin for Connector/J, NET

List of components to download & configure:

MySQL Database

(SQL statements & result sets)

(MySQL & OS monitoring data)

3. Connector/J, NET

4. Plugin for Connector/J,NET

(SQL performance data: statements,examples, EXPLAINs, aggregated

stats)

3306

18080

2. MySQL Agent

1. MySQL Enterprise Monitor (Service Manager, Dashboard)

Application Server



18

New Query Analyzer Global Search Options

• New filters for queries that performed

• Full table scans• Full table scans using bad indexes



19


• New LDAP Authentication

• Integrates with existing directories (SSO)



20


• New Read Only User

• Can view monitored data but cannot make any changes



21

Improved Integration with MySQL Support

• New MySQL Support Diagnostic Reports

• Quickly collects/packages MySQL, OS and query diagnostics intoportable report for MySQL Support

• Attach to new or existing support issues

• Quicker diagnosis/fixing of problems



22

MySQL Workbench SE

http://d/Ivan.Tu/MySQL/MySQL_Workbench_SE.ods

http://d/Ivan.Tu/MySQL/MySQL_Workbench_SE.ods



23

MySQL Workbench Visual DB Design



24

MySQL Workbench SQL Editor



25

MySQL Workbench DB Administrator



26

• See it in action!• http://mysql.com/products/enterprise/demo.html

• Upcoming MySQL Live Webinars• http://mysql.com/news-and-events/web-

seminars/index.html

• White Papers, Customer Success Stories, etc

• www.mysql.com/products/enterprise/

• Free 30 day trial• www.mysql.com/trial

Learn More

http://www.linuxjournal.com/article.php?sid=7029










20100914 MiniKickoff ME

Documents

Transcript of 20100914 MiniKickoff ME