Mariadb skysql cloud data suite

MariaDB SkySQL Cloud Data Suite Enhanced, drop-in replacement for MySQL

A Highly Available Cloud Database with Monitoring and Management Tools

SkySQL Cloud Data Suite ● ●

●

●

Everything that runs in the cloud Predefined template in the cloud with all software installed ●

On Amazon an AMI

●

On OpenStack a Glance image

On Linux platforms a set of RPM/DEB packages All elements highly available

SkySQL Cloud Data Suite

SkySQL Provisioning

SkySQL Cluster

config.skysql.com

Admin.

Console

Replicator

Data Store

What runs in the cloud?

●

MariaDB database instances

●

Administration Console User Interface

●

RESTful Administration API

●

SkySQL Monitoring Server

●

MONyog

●

phpMyAdmin

MariaDB High Availability ●

Pacemaker resource agents ●

●

●

●

MHA resource agent ●

Replicated data

●

Hot standby server

●

Read load balancing

MariaDB Galera Cluster ●

Replicated data

●

Hot standby server

●

Read/write load balancing

Shared Storage ●

Replication via storage device

●

Cold standby server

Transparent access via virtual IP addresses

Support Software Pacemaker/Corosync

●

Apache Webserver

●

Tomcat servlet engine

●

Gluster distributed & replicated filesystem

●

Pacemaker/ CoroSync

Pacemaker/ CoroSync

Pacemaker/ CoroSync

Elastic IP

Master/Slave Resource Group MariaDB

MariaDB

MariaDB

Replication

Clone Resource Group Apache Web Server

Apache Web Server

Apache Web Server

Tomcat

MONyog

Admin Console

MONyog DB

Console REST API SkySQL Monitor

Admin DB Bound Resources

Bound Resources

Administration console

Monitoring

Provisioning system: config.skysql.com

Free trial from SkySQL team!

What is MariaDB? ●

●

●

MariaDB is an enhanced, drop-in, binary compatible replacement for MySQL created by several of the former core developers of MySQL including Monty is not just a set of patches applied on top of MySQL –

includes features which are similar to the corresponding features in MySQL, but the implementations differ, like for example the thread pool, microsecond support and query annotations in RBR binlog

–

includes a lot of features that are not in MySQL

See http://kb.askmonty.org/en/mariadb-versus-mysql-features/

MariaDB: key improvements ●

More Storage Engines

●

Speed improvements

●

Extensions & new features

●

Better Testing

●

Fewer warnings and bugs

●

Truly Open Source

Bugs and plans: https://mariadb.atlassian.net/secure/Dashboard.jspa https://kb.askmonty.org/en/development-plans/ About Community: https://kb.askmonty.org/en/mariadb-community/

–

all code in MariaDB is released under GPL, LPGL or BSD: no closed source modules

–

MariaDB includes test cases for all fixed bugs

–

All bugs and development plans are public

–

MariaDB is developed by the community in true open source spirit

MariaDB 10 ●

built on the MariaDB 5.5 series

●

backported features from MySQL 5.6

●

Re-implemented MySQL 5.6 features

●

entirely new features not found anywhere else

●

–

Multi-source replication

–

Even faster Group Commit

–

SHOW EXPLAIN

–

Cassandra Storage Engine

–

Improved Dynamic Columns

For all details see http://blog.mariadb.org/what-does-mariadb-10-0-1-include-availabl e-now/

MariaDB Foundation “The MariaDB Foundation promotes, protects, and advances the MariaDB codebase, community, and ecosystem.�

Www.mariadb.org

Info ●

Mariadb.org

●

kb.askmonty.org

●

montyprogram.com

●

Skysql.com

●

FRUCT13 Demo, Apr 25