Enabling Enterprise Web 2.0 With MySQL Enterprise

1
Enabling Your Business With Open Source
Solutions
Enabling Enterprise Web 2.0With MySQL Enterprise
How Web 2.0 Can Transform Your Business
Page 1
2
Enabling Your Business With Open Source
Solutions

• Enabling Web 2.0 With MySQL Enterprise
• Presenters
• Jimmy Guererro MySQL / Sun Database Group
• Tim Geary Unisys Open Source SI Services
• Todays Discussion
• Unisys and MySQL
• Enabling Web 2.0 With MySQL
• Use Case Examples
• Unisys Open Source SI Services

Page 2
3
Unisys and MySQL / Sun

• Unisys Resells MySQL Subscriptions and Provides
  Support
• Unisys incorporates MySQL into our industry
  solutions
• Next Gen Messaging
• AirCore
• Unisys Resells Sun Intel Platforms
• Joint Successes
• Reuters
• US Navy
• Sprint

Page 3
4
Benefits of Open Source

• Best way to address ? budgets and ? expectations
• Reduce IT costs
• Preserve and enhance legacy solutions
• Provide greater flexibility and agility
• Deliver faster time to market
• Improve operational efficiency
• Facilitates consolidation of IT infrastructure

overall adoption of open source is strong The
adoption of MySQL. . .is increasing . .
Gartner, State of Open Source 2008
Page 4
5
Survey Question

• Has your organization downloaded the community
  edition of MySQL for testing, evaluation or
  production?
• ? YES
• ? NO

Page 5
6
Enabling Enterprise Web 2.0 With MySQL
Enterprise How Web 2.0 Can Transform Your
Business
Jimmy Guerrero Sr Product Marketing Manager Sun
Microsystems Database Group jimmy_at_mysql.com
Page 6
07/30/08
7

• Sun MySQL Overview
• Introduction to Enterprise 2.0
• Web 2.0 Technologies
• Example Architectures
• Solutions
• Case Studies
• Next Steps plus Q A

8
Sun Acquires MySQL

• MySQL Helps Sun...
• Grow in a 15B database market
• Reach new customers
• Position its offerings for Web companies
• Deliver innovation to community customers
• Complete its software platform offerings
• Sun Helps MySQL
• Expand market reach and revenue opportunities
• Enhance enterprise appeal with global services
• Enhance performance and integration
• Resources for accelerated growth

Page 8
9
About MySQL

• 12 years old
• 400 employees
• 750 partners
• 60K downloads/day
• Customers across every major operating system,
  hardware vendor, geography, industry, and
  application type

Leadership Innovation Open
Ubiquitous
Page 9
10
Established Emerging Companies
Web 2.0
Enterprise 2.0
craigslist
SaaS
Telecom
OEM ISV
11
Web 2.0 The Web is the Platform

• Web is becoming the principle programming
  platform
• Historical evolution of the platform
• Mainframe to Client/Server
• PC to Web
• Migration of the desktop to the browser related
  devices
• Emergence of Cloud computing

Feeds Blogs Social Networking Wikis
Mashups Tags
Page 11
12
Web 2.0 An Architecture of Participation

• Intentionally designed for contribution from
• Developer communities individual users
• Emphasis on empowerment and openness
• What prevents or fosters it?
• Proprietary products and companies vs. open
  source
• Complex APIs
• Release early, release often
• Perpetual Beta
• Contribution of user data to the system as a
  whole
• Engages users and encourages collaboration
• Creates unique and difficult to replicate data

Page 12
13
Web 2.0 Enabling Enterprise 2.0
Applications

Technology
Communities Open Source Linux Apache
Lighttpd memcached MySQL PHP/Perl/Python Ruby on
Rails/AJAX
Wikis Blogs Social Bookmarking Mashups Feeds Tags
Page 13
14
Enterprise 2.0 Overview

• Leveraging Web 2.0 technologies and online
  architectures enables businesses to deliver the
  benefits of Software as a Service to business
  users
• Can enable information access across the
  enterprise regardless of how or where the data is
  stored, through a network of tightly and loosely
  integrated applications, services and devices
• Major challenge is enabling applications who need
  structured data to leverage unstructured data

Page 14
15
Benefits of Enterprise 2.0

• Many available applications are low cost and open
  source
• Applications can be developed and deployed using
  open source components, COTS hardware with less
  risk
• Scalability can be achieved in an on-demand
  fashion
• Encourages employees, partners and customers to
  take control and add value at the same time
• The more collaborative a company is the more
  success they will have in leveraging the benefits
  of the technology

Page 15
16
Enterprise 2.0 Challenges

• Delivering on SLAs with corporate end-users
• Uptime availability
• Application performance responsiveness
• On-demand scalability
• Integration with other systems
• Releasing control to end-users
• Keeping infrastructure costs low
• Proactive monitoring

Page 16
17
Example Architectures
Page 17
18
Client/Server Architecture
LAN
Page 18
19
SaaS Architecture
Managed Hosting
Page 19
20
Enterprise 2.0 Architecture
LAN
Page 20
21
Contrasting SaaS and ASP

• Host third-party or customized customer
  applications in their own data centers
• In general, cannot provide the required technical
  expertise to host a variety of applications
  without specializing in a particular vertical
• Hosted applications are not architected for a
  shared environment
• Customer must still retain application expertise
  in-house
• High profile bankruptcies difficulty in
  delivering on SLAs

Page 21
22
MySQL Solutions Overview
Page 22
23
Benefits of Open Source and LAMP

• LAMP software stack running on COTS hardware
  lowers initial startup costs
• Perfect for on-demand Scale-Out environments
• Open Source freedom and no vendor lock-in

Scale-Up
Scale-Out
vs
Page 23
24
MySQL Enterprise

Enterprise database and monitoring software, plus
production support delivered in an annual
subscription
MySQL Enterprise
MySQL Enterprise Server
MySQL Enterprise Monitor
24x7 Production Support
MySQL Enterprise Unlimited
Deploy and monitor an unlimited number of servers
for the price of a single CPU of Oracle
Page 24
25
Why MySQL Enterprise?

• Deliver on SLAs
• Increase availability
• Optimize performance
• Effectively monitor scale-out environments
• Faster time to launch
• Develop deliver on proven open source
  components
• Keep costs predictable

Page 25
26
MySQL Enterprise Monitor

• Consolidated view of entire MySQL environment
• Auto discovery of MySQL Servers replication
  topologies
• Over 100 customizable rules for monitoring and
  alerting
• Identifies problems before they occur
• Reduces risk of downtime
• Improve delivery of SLAs
• Scale-out with less DBAs

Page 26
27
On-Demand Scalability for MySQLMySQL Replication

• Designed for on-demand read scalability
• Cost-effective alternative to Scale-Up
• Asynchronous replication
• Statement or row-level replication support
• No special networking components
• Fully-supported via MySQL Enterprise subscription
• Enterprise Monitor discovers and monitors
  replication topologies

Page 27
28
MySQL Replication Scale-Out
MySQL Replication
writes
MySQL Replication
reads
reads
Page 28
29
Scalability MySQL Partitioning
MySQL Partitioning
Cust_id 1-999
Cust_id 1000-1999
Cust_id 2000-2999
Page 29
30
Scalability Sharding
Sharding Architecture
Cust_id 1-999
Cust_id 1000-1999
Cust_id 2000-2999
Page 30
31
Scalability Virtualization
Virtualization Architecture
VM 1
VM 2
VM 3
Page 31
32
MySQL Replication High Availability
MySQL Replication
writes
Active Servers
reads
MySQL Replication
Standby Server
Page 32
33
High Availability for MySQLDistributed
Replicated Block Device (DRBD)

• Runs over standard IP networks
• Distributed storage
• Similar to network RAID
• Synchronous replication
• No special networking components
• Excellent performance (blocks vs. rows of data)?
• Manages inconsistencies of data during a failure
• Hides the complexity of many recovery actions
• Linux heartbeat manages fail over and virtual IPs
• Fully-supported add-on to MySQL Enterprise
  subscription

Page 33
34
DRBD Architecture
MySQL and DRBD
Active Master
Synchronous Block Replication
Virtual IP Management
Passive Master
Page 34
35
MySQL High Availability Scale-Out
DRBD MySQL Replication
reads
reads
Active Master
writes
Synchronous Block Replication
Virtual IP Management
Passive Master
Page 35
36
Summary How does MySQL Enable Enterprise 2.0?

• Deliver on SLA commitments to business users
• Ensure availability, performance and on-demand
  scalability
• Leverage low, predictable costs and the benefits
  of open source

Page 36
37
Unisys Open Source ServicesTying it all Together
Page 37
Page 37
38
Use Case Example

• Reuters
• Designed and implemented Web portal for
  distribution of Reuters news stories on the web
  (7 x 24).
• Improved response time by 75
• Over 10 million hits per day on portal
• Clustering, Replication, Fault Tolerant
• B2B Offerings
• WebServices Yahoo, MSN, Google
• Infopoint (Signage)
• RSS Feeds Virgin Radio, BT Business, Fark
• IDS AOL
• B2C Offerings
• 18 Country Sites in 12 different Languages
• RSS Feeds News Video
• Mobile News Video
• Pictures
• Audio / Video Podcasting
• SecondLife News Video

39
Use Case Example

• US Navy
• Working with NavAIR we provided design
  consulting, performance analysis and tuning
  services to assist in delivering the Navys
  Aviation Data Management and Control Systems
  (ADMACS) tactical data management system which
  supports the real time operations of aircraft
  carriers.

In the grand scheme of things, your service has
not only helped to improve the RAS of our system
that we are delivering to the fleet, but has
actually contributed to the defence of our entire
nation. Timothy P. Woolverton Program
Manager, U.S. Navy
40
Use Case Example

• Unisys Vertical Industry Solutions
• NextGen Messaging
• AirCore
• University Web Portals Content Management

07/30/08
Page 40
41
Unisys Open Source Services

• OpenSource Consulting Services
• Open Source Assessment Services
• Enterprise Business Consulting
• Architecture Design and Optimization Using 3D
  Blueprinting
• Open Source High Availability and Scalability
  Services
• Open Source Benchmarking and POC Services
• Open Source Portal Security Services
• SOA Consulting Services
• Open Source Virtualization

Page 41
07/30/08
42
Unisys Open Source Services

• System Tuning Services
• Business Modernization Services
• Portals Collaboration
• Web 2.0 Integration
• System Integration Services
• Integrating MySQL with your legacy systems
• See Unisys Web Site
• http//www.unisys.com/services/open__source.htm

Page 42
07/30/08
43
Unisys Open Source and Application Services
OFFERINGS
44
Unisys Global Delivery Model
The Unisys Global Delivery Model is based on a
four-tiered model utilizing onsite, onshore,
near-shore and offshore resourcing that leverages
multiple skill centers to provide services and
solutions

• Over 25 years experience in offshore development
  and support
• Over 7000 of our delivery resources are in
  low-cost countries
• Global management processes, procedures and
  tools covering all aspects of services delivery
• Standardizing on the CMMI framework and URUP
• Global communication infrastructure that enables
  global service delivery and tools to manage
  global engagements
• Clear communications
• Continued investments in training tooling, and
  equipment
• Involving our clients in the definition of
  service delivery

45
Questions
Unisys
07/30/08
Page 45
46
Next Steps More Information

• Schedule a Detailed Presentation / Demo of MySQL
• Schedule a Detailed Overview of Unisys Open
  Source Services
• For More Information Contact
• open.source_at_unisys.com
• jimmy_at_mysql.com
• 1-800-228-9088 x2347

Page 46
Page 46
47
Thank You
Page 47
Page 47