skysql reference architecture (kaj arno)

35
Kaj Arnö EVP Products for High Availability SkySQL Reference Architecture HighLoad++ Moscow 3-4 Oct 2011 Oracle, MySQL and InnoDB are registered trademarks of Oracle and/or its affiliates. Other names may be trademarks of their respective owners. Leveraging the

Upload: ontico

Post on 01-Nov-2014

962 views

Category:

Technology


0 download

DESCRIPTION

 

TRANSCRIPT

Page 1: SkySQL Reference Architecture (Kaj Arno)

Kaj ArnöEVP Products

for High Availability

SkySQL Reference Architecture

HighLoad++ Moscow 3-4 Oct 2011

Oracle, MySQL and InnoDB are registered trademarks of Oracle and/or its affiliates.  Other names may be trademarks of their respective owners.

Leveraging the

Page 2: SkySQL Reference Architecture (Kaj Arno)

2

Intro toSkySQL

Page 3: SkySQL Reference Architecture (Kaj Arno)

SkySQL Ab

• Funded by:–MySQL AB founders Monty Widenius and David

Axmark–US Investment group OnCorps.org

• Operating in 13 countries, with 90% of the team ex-MySQL® AB employees

• Backed by:–Product Engineering MontyProgram Ab–Top Community contributors and End Users

3

Page 4: SkySQL Reference Architecture (Kaj Arno)

SkySQL Goals

• To be #1 worldwide provider of MySQL®-related offerings

• To build a profitable, sustainable commercial business while preserving open source values

• To raise the bar on the quality of MySQL® service and support

• To ensure and promote competition

4

Page 5: SkySQL Reference Architecture (Kaj Arno)

SkySQL Offering

• SkySQL Enterprise Subscriptions–Monitoring, Administration and End User tools–L0 to L3 Technical and Consultative Support on the

most famous and used MySQL® distributions and forks

• SkySQL Consulting–Top class team for MySQL® technology–Extended service offering from Health Check to

continuous administration

• SkySQL Training–MySQL® Training and Certification

5

Page 6: SkySQL Reference Architecture (Kaj Arno)

SkySQL Customer (shortlist)

6

“We chose to renew with SkySQL because it could offer us a more cost-effective, yet still highly competitive enterprise-class software and support solution for our MySQL databases…SkySQL offers MySQL customers like Easyflirt.com a highly compelling alternative to Oracle software, service, and support.”

“…We highly recommend SkySQL for their ability to quickly understand the domain they need to operate in and for their expertise in MySQL Cluster.”

“When MySQL became part of Oracle, we grew increasingly concerned in regards to future support services especially given Oracle’s pricing history,” said Thomas Waibel, CFO for BörseGo. “As we assessed alternatives, we were delighted to find SkySQL – a familiar team with a proven track record providing enterprise-class support and service at a compelling price point.”

Page 7: SkySQL Reference Architecture (Kaj Arno)

MySQL® Database“The world’s mostfamous open sourcedatabase”

Page 8: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

8

2001

Page 9: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

9

20012002

Page 10: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

10

200120022003

Page 11: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

11

2001200220032004

Page 12: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

12

20012002200320042005

Page 13: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

13

200120022003200420052006

Page 14: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

14

2001200220032004200520062007

Page 15: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

15

20012002200320042005200620072008

Page 16: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

16

200120022003200420052006200720082009

Page 17: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

17

2001200220032004200520062007200820092010

Page 18: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

18

20012002200320042005200620072008200920102011

Page 19: SkySQL Reference Architecture (Kaj Arno)

What a Journey!

19

20012002200320042005200620072008200920102011

Page 20: SkySQL Reference Architecture (Kaj Arno)

MySQL and Its Ecosystem Today

• A complete stack of innovative technologies

• An affordable solution for the Enterprise

• The de-facto standard for the Cloud• A vibrant community• An increasing number of technology providers

20

Page 21: SkySQL Reference Architecture (Kaj Arno)

SkySQL ReferenceArchitectureA new journey begins...

Page 22: SkySQL Reference Architecture (Kaj Arno)

22

Introducing SkySQL Reference Architecture

The Most Comprehensive

Architecture Around MySQL®

Scalable, Adaptable and Cloud-ready

Page 23: SkySQL Reference Architecture (Kaj Arno)

What is the SkySQL Reference Architecture?

• A conceptual structure and logical organisation of IT systems built around MySQL®

• An evolving set of products that fit together

• A partnership ecosystem with the best of breed from MySQL AB times

• A complete database solution available 23

Page 24: SkySQL Reference Architecture (Kaj Arno)

The SkySQL Reference Architecture

• Component selection and testing• Module integration• Provisioning• Simplified monitoring and administration• Technical services and support• Solutions validation• Improvements and new releases• Knowledge sharing

24

Implementation

Page 25: SkySQL Reference Architecture (Kaj Arno)

SkySQL Reference ArchitectureComponents

Reporting& DW

CRM

CMS

Web Apps &Frameworks

CustomApps

IntegrationToolsIntegrationToolsIntegrationTools Migration

ToolsMigrationToolsMigrationTools

MySQL® Database

Storage Engines&

ExtensionsPluginsPluginsPlugins

Infrastructu

25

Administration

Monitoring

Provisioning

Page 26: SkySQL Reference Architecture (Kaj Arno)

SkySQL Reference ArchitectureComponents

MigrationToolsMigrationTools

26

IntegrationToolsIntegrationTools

Page 27: SkySQL Reference Architecture (Kaj Arno)

SkySQL ReferenceArchitecture...SkySQL Provisioning

Page 28: SkySQL Reference Architecture (Kaj Arno)

SkySQLConfigurator

SkySQLTuner

SkySQL

28

SkySQL ProvisioningSkySQL

Manager

Page 29: SkySQL Reference Architecture (Kaj Arno)

SkySQL

29

SkySQL ProvisioningSkySQL

Manager

Configurator

Downloader

Knowledge

Sharing

Page 30: SkySQL Reference Architecture (Kaj Arno)

30

SkySQL Configuratorhttp://config.skysql.com

Page 31: SkySQL Reference Architecture (Kaj Arno)

31

SkySQL Configuratorhttp://config.skysql.com

Page 32: SkySQL Reference Architecture (Kaj Arno)

32

SkySQL Configuratorhttp://config.skysql.com

Page 33: SkySQL Reference Architecture (Kaj Arno)

33

SkySQL Configuratorhttp://config.skysql.com

Page 34: SkySQL Reference Architecture (Kaj Arno)

Stay Tuned!

• SkySQL Configurator–More options–Basic and advanced interface–Profiles

• SkySQL Tuner–More platforms–Selective download/updates–SkySQL Downloader

• SkySQL Manager–Administration/Monitoring/Support integration

–Provisioning Control System34

Page 35: SkySQL Reference Architecture (Kaj Arno)

Thank You!

IVAN ZORATTIField Services [email protected]