Presentation to SCO India

martencrushInternet and Web Development

Dec 8, 2013 (3 years and 9 months ago)

90 views

1

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


MySQL


and

2

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Objectives


Introduce MySQL the company



Outline the MySQL Business and Licensing Model



Outline the Agreement with SCO



Overview the product and the latest developments



SCAMP and MySQL

3

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


Introducing MySQL


4

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Forrester Research

"Organizations will double the number of databases they
run in the next five to seven years.“


--

Noel Yuhanna, senior analyst, Forrester Research


quoted in the Enterprise Open Source Journal March/April
2006




5

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


Founded in Sweden in 1995; Privately Owned


Employs over 300 people worldwide


Over 8,000,000 installations


70,000 web downloads/day


Part of a rapidly growing open source LAMP stack

The World’s Most Popular

Open Source Database

6

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Database Server


the 8million!

Free


Community Edition


Available under
GPL


Software tested by
Community + basic
MySQL AB testing


Release early & often
cycle (3 to 4 weeks)


Bleeding edge


No maintenance SLA


Not supported


No ISV certification

7

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Network

Free


Community Edition


Available under GPL


Software tested by
Community + basic MySQL
AB testing


Release early & often cycle
(3 to 4 weeks)


Bleeding edge


No maintenance SLA


Not supported


No ISV certification

Great for open source
developers &
technology
enthusisats

Supported

MySQL Network


Software fully tested, certified and
optimized by MySQL AB


Enterprise release cycles

(6 to 9 months)


Annual Subscription


Update Advisor


Technical Alert Advisor


Knowledge Base


Production Support


Indemnification

Great for enterprise
customers and supported by
MySQL

8

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Network

Basic

MySQL Network

Silver

MySQL Network

Gold

MySQL Network

Platinum

Software

MySQL Server

Pro

Pro

Pro

Pro

Certified, Optimized Software









Maintenance, Updates, Upgrades









Custom MySQL Builds

Option*

Advisors

Technical Alert Advisor









Update Advisor









Self Help Support

Knowledge Base









Problem Resolution Support

Number of Incidents

2

Unlimited

Unlimited

Unlimited

Web Access









Phone Access

8x5 (M
-
F)

24x7

24x7

Max Initial Response Time

2 bus. day

4 hours

2 hours

30 min

Emergency Resp. Time

30 min

30 min

9

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Sabre Holdings

Application


Air Travel Shopping Engine/Fare Search used
by Travelocity and others


Project


Sabre

swapped Oracle/Mainframe for
MySQL/Linux with HP Integrity servers.


Tested 5 hardware/database configs and
chose
top performing MySQL/Integrity


Key Business Benefit


More than
$10 million in savings

while scaling
to millions of transactions daily.


Estimated 40% TCO savings, actually achieved
80%


Why MySQL? Speed and scalability



“MySQL ran faster or as fast as any commercial
database we tested. It never crashed. It was the
fastest to get working.”

Alan Walker

Systems Architect

Sabre Holdings

10

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Data Warehouse Scale Out
-

Cox Communications

Application


MySQL powers a huge data warehouse for 10
million cable users. It includes 3,600 tables
and 2 billion rows of data with 4 million inserts
every 2 hours.


Key Business Benefit


Allows Cox to make informed business
decisions and greater customer care.
Savings
of more than $2 million.


Why MySQL?


Best Price / Performance



"In today's market, we are constantly striving
to keep costs down, Leveraging the MySQL
database allows us to save money without
sacrificing performance."

Mark Cotner, Manager

Network Application Development

Cox Communications

11

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Lycos Europe

Application


Lycos
-
Europe migrated all company portal
services to MySQL (100 servers) displacing
one of the leading proprietary databases.


Key Business Benefit


Reduced TCO by more than 90%
saving
more than


200K annually in less than 6
months

with no interruption in services.


Why MySQL? Lower TCO




With MySQL we were able to reduce our
annual database costs by more than 90%.
MySQL significantly reduced our license,
support and maintenance fees!”

Per Larsson

Lycos Europe


12

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Yahoo!

Application


MySQL powers over 200 Yahoo!
properties around the world including
Yahoo! Finance with 260 million rows.


Key Business Benefit


Low down time for high
-
volume, business
-
critical applications. Using MySQL has
reduced cost by more than $2 million.


Why MySQL? Mission
-
Critical Reliability



“We have used MySQL far more than
anyone expected. We went from
experimental to mission
-
critical in a
couple of months.”


Jeremy Zawodny

MySQL Database Expert

Yahoo! Finance

13

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Network Competitive Positioning


Lower cost as a technical advantage


Per
-
server pricing means more processors


Reduced server cost means more servers


Backups & hot spares on replicated slaves


Low cost farms & clusters



Low overhead


Better performance on the same hardware


Less disk usage is faster disk usage



Low maintenance


We have far more servers than DBAs


MySQL Administration Not Rocket Science

14

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


MySQL Cluster


Fault
-
tolerant database clustering for 99.999% availability


“Shared nothing” architecture; no shared disk required


MySQL Cluster Jumpstart program available


MaxDB™ by MySQL


SAP certified for the most demanding applications including R/3


MySQL Graphical Tools


MySQL Administrator


MySQL Query Browser


MySQL Connector Drivers


Connector/J, Connector/MXJ


Connector/ODBC


Connector/Net


Other MySQL Products

15

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Professional Services


Packaged Solutions


MySQL Architecture & Design


MySQL Performance Optimization


MySQL Migration Jumpstart


MySQL Cluster Jumpstart


Custom Consulting Projects


Application Design


Application Development


Enhancements & Extensions


16

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Training & Certification


Public and Onsite Courses


Introduction to Databases


Using and Managing MySQL


MySQL Cluster for High Availability


Using and Developing with MaxDB


Developing Dynamic Web Applications


Storing Sensitive Information


Certification Programs


Professional and Core levels


3000 Pearson VUE centers

17

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Training & Certification


Public and Onsite Courses


Introduction to Databases


Using and Managing MySQL


MySQL Cluster for High Availability


Using and Developing with MaxDB


Developing Dynamic Web Applications


Storing Sensitive Information


Certification Programs


Professional and Core levels


3000 Pearson VUE centers

18

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Strengths



Still the choice of web properties


Google, Yahoo, Netflix, Friendster, Amazon...


Run for years without DBA intervention



Strengths


Ease of Install


Small footprint


High performance, extremely fast


Low maintenance



The “easy choice” for low
-
cost development


19

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


MySQL Commercial Licenses

20

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Business Model

Free


Community Edition


Available under
GPL


Software tested by
Community + basic
MySQL AB testing


Release early & often
cycle (3 to 4 weeks)


Bleeding edge


No maintenance SLA


Not supported


No ISV certification

Supported

MySQL Network


Software fully tested,
certified and optimized by
MySQL AB under
GPL


Enterprise release cycles

(6 to 9 months)


Annual Subscription


Update Advisor


Technical Alert Advisor


Knowledge Base


Production Support


Indemnification

License

Commercial
License


Sales to OEMs/ISVs
and Enterprises


Frees them from
applying GPL rules to
their own code and
IP

21

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL’s OEM/ISV Business


OEM has been our primary business and continues to
grow at roughly 2x rate year over year



Enterprise penetration is critical to the long
-
term
prospects of MySQL




We will continue to emphasize execution strategies on
OEM


22

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

OEM/ISV Options


Scenario


Commercial licenses
(OEM)

MySQL Network
Certified Partner
Program

MySQL Embedded

(non visible to end
customer)



MySQL Bundled

(visible to end
customer)



MySQL Supported as
external DB
, no client
libs shipped



MySQL supported as
external DB
, client libs
shipped



23

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Typical Applications


Network appliances


Security appliances


Monitoring


Business intelligence


CD ROM directories


Point of Sale systems


Retail kiosks


Hosted enterprise applications


Email systems


Anti
-
spam software


And more…


24

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


The Agreement

25

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

SCO Agreement with MySQL


Signed 31
st

August 2005


Initial 18 month period


Worldwide Coverage


Products Covered

1.
MySQL Network (Basic, Silver, Gold and Platinum)
Resale


2.
Support Delivery


Level 1 and Level 2 on the above


3.
Commercial Licenses and Support to ISVs

26

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database



MySQL Product Overview


Ivan Zoratti

Systems Engineer

27

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Technology Stacks



MySQL

Open Server

Apache

MySQL

Unix Ware

Apache

Tomcat

JBoss

Java

Perl

SCAMP

J2EE

28

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Software Priorities

Lower

TCO

* Robert Lemos CNET News.com Feb 4, 2005

Reliability

Study found
comparatively fewer
bugs in MySQL*

Ease of Use

15 Minute Rule

Up and running in 15 minutes

Performance

MySQL, Sun and BEA WebLogic Set
New World Records for Speed &
Price/Performance in SPEC
Benchmarks

29

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Server Architecture

30

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

What’s New?



MySQL 5.0



Stored Procedures



Cluster query push down



Query optimizations



Archive Engine



InnoDB storage improvements



SQL Mode



Triggers



Views



Precision Math



Distributed Transactions



Cluster object support



Instance Manager



Information Schema



Cursors



Enhanced GUI Tools



Migration Toolkit


Faster Better Increased


Manageability

Ease of Use

Reliability

Performance

‘Most Important Ever’ MySQL 5.0

“The open source database company says it is 'fixing 10 years of
criticism in one release', and is aiming at boosting enterprise
take
-
up. David Axmark, a co
-
founder of MySQL, says the
enterprise functionality MySQL has lacked in the past has been
added to MySQL 5.0.”

ZDNet

31

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Scale
-
Out Comparison



Vertical Scale
-
Up



Expensive SMP hardware



Closed source software



Platform lock
-
in



“Fork Lift” to increase
capacity





Horizontal Scale
-
Out



Commodity Intel / AMD



Open source software



Platform freedom



Add commodity servers


to increase capacity

32

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


High Availability Solutions: Replication







Replicate data from one MySQL server/storage
engine combination to a different MySQL
Server/storage engine combination


Perform backups using a slave server and
continue to process updates on the master
while the backup is being made on the slave


Extremely simple configuration to enable very
robust replication


Multiple replication topologies supported



Achieve higher availability with a master/slave
setup


In the event of problems with the master, you
can switch to the slave as a backup


Better response time by splitting the load for
processing queries between the master and
slave


SELECT queries may be sent to the slave to
reduce the query processing load of the
master


Enabled for all storage engines


Application

Slave

Master

33

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


High Availability Solutions: Shared Disk Cluster




Active/Passive server or process
configuration


Links servers with 3rd party software and virtual IP


Reliability


Commonly used solution


Fault Tolerance


No single point of failure with appropriate hardware


High Availability


Data handled by a SAN and always available


Automatic fail
-
over


Simplified Management


Cluster management utilities

MySQL

Server Nodes

Shared Storage

Applications


Reliant
-
HA



34

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


High Availability Solutions: MySQL Cluster



Applications

MySQL Server Nodes

Data Nodes

Management

Server & Client


Cost


Use commodity hardware to
accommodate the growth of users,
traffic, and data


Fault Tolerance


No single point of failure



High Availability


Data is replicated across nodes and
always available


Automatic fail
-
over


Scalability


Distributes large workloads


Replicas for Read


Partitions for Write


Supports “Scale Out”


High Performance


Load balanced


Memory based storage engine


Designed to handle thousands of requests
per second


Simplified Management


Cluster management utilities


Commodity components

35

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database



Business Intelligence/Data Warehousing



Table/Index Partitioning



Full Text Search Enhancements



Better XML Handling


XPath



Archive engine enhancements

High Availability



Disk
-
based Cluster



Row
-
based Replication



Cluster replication

Easier Manageability



Task Scheduler



Pluggable storage engine architecture enhancements



Transaction support for Federated Engine

Higher Performance



Faster alter table



Faster add/drop index for MySQL Cluster



Better problem SQL identification



New Performance/Load Testing Utility



New MyISAM memory option

36

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

MySQL Network

Performance Monitoring/Analysis Service

Global Monitoring/Analysis Service:
the service is built to
automatically monitor and track all the MySQL servers in the
enterprise, allowing complete coverage.

Robust Alerts:

notifies staff in advance of major problem; reduces
downtime and performance problems.

Advisors/Rules:
informs staff about problems


such as performance
issues and security loopholes
-

and recommends solutions; helps
those not familiar with MySQL.

Customizable Framework:

customers can add custom alerts and
advisors; helps enforce organization’s unique standards and best
practices.

Unattended Operations:

no need for manual intervention; no
productivity drain on staff.

Historical data collection and trending:
performance statistics can
be collected and graphed over time; provides trend analysis for
pinpointing performance issues.

Multi
-
platform support:
support monitoring of all MySQL platforms
allows complete coverage; central management server supported on
Linux and Windows. MySQL versions 4.x
-
5.x supported.

37

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database


Solid Storage Engine


Falcon Project/Netfrastructure


MOLAP Storage Engine and MDX
extensions



Projects on:


CRM (SugarCRM)


BI (Business Objects, Jaspersoft,
Pentaho, Thinking Networks,
OLAP4All, Innovent)


Content Management (Alfresco)


Monitoring (Moods/SNMP)


Design (Embarcadero, Quest)


Data Storage (EMC
2
, CleverSafe)


Connectivity (Dolphin, DataDirect)

What’s on and Coming Soon...

38

Copyright 2006 MySQL AB

The World’s Most Popular Open Source Database

Future Developments


Stay True to Our Mission


Performance


Reliability


Ease of Use


Continue Adding Enterprise Capabilities


Ship rock solid MySQL 5.0


Better replication


Online backup


Cluster disk support


Merlin capabilities


Expand Ecosystem


More third party support


More channel marketing

‘Most Important Ever’ MySQL 5.0

“The open source database company says it is
'fixing 10 years of criticism in one release', and
is aiming at boosting enterprise take
-
up. David
Axmark, a co
-
founder of MySQL, says the
enterprise functionality MySQL has lacked in
the past has been added to MySQL 5.0.”

ZDNet