Document Download

MySQL and MariaDB at Web-Scale: Enabling New Use Cases With MariaDB MaxScale, an Intelligent Proxy

The design and implementation of server-based applications has benefitted greatly from the evolution and maturation of open source operating systems, databases, and application frameworks. But there remain some significant challenges in ramping these mature, open source technologies to web scale. In particular, popular relational database technologies can struggle to meet web scale demands for availability, consistency, scalability, and development agility.

Imagine a modular infrastructure component sitting between clients and back-end databases that can hide the complexity of database clustering and dynamically translate requests and responses between disparate database technologies. A layer that can aggregate back-end resources in flexible ways, delivering:

  • High availability, including geographic replication for disaster resilience.
  • Combinations of read and write scalability clustering that can be tailored to different applications’ requirements, while pushing the complexity into the database layer and keeping application architectures simple.
  • Protocol translators, and filtering and transformation capabilities that lets database architects leverage the most appropriate technologies and more easily integrate the database layer into today’s most sophisticated application architectures.

MariaDB MaxScale, a new intelligent database proxy adds to the breadth and polish of the MySQL ecosystem, bringing these and other capabilities to the fore. An alpha-level open source project on GitHub, MaxScale is available today for database administrators, architects, DevOps engineers, and developers to explore and contribute to.

This report describes the challenges that MariaDB MaxScale addresses, its architecture, some useful clustering configurations available to try in the alpha, and a glimpse of future plans for this new technology. Read on for more information, and be sure to check out the MariaDB MaxScale code today, and discover new tools to help you deploy MySQL and MariaDB for the new, demanding use cases common in web scale, agile, and advanced enterprise IT applications.

IBM Power Systems solution for MariaDB

The performance results in this paper demonstrate how the MariaDB application and IBM® Power Systems™ perform using the Sysbench benchmark suite. This white paper details the results on the IBM Power® System S822L server running MariaDB 10.0 on Ubuntu 14.0.4 with IBM PowerKVM 2.1.0 and Sysbench1 as the benchmark test suite. The innovative design of the IBM POWER8™ processor technology is for very demanding, data-intensive applications making it well-suited for MariaDB customers. Built with a processor designed for such data workloads, the IBM Power Systems design combines the computing power, memory bandwidth, and I/O in ways that are easier to consume and manage; building on strong resiliency, availability and security, demonstrated by:

  • Computing power with 50% more cores and smart acceleration enabled by the Coherent Accelerator Processor Interface (CAPI).
  • Massive memory with over twice the bandwidth of prior generation servers to process data faster and achieve greater speed and efficiency for transactional applications such as MariaDB.
  • Systems that are easy to deploy and manage with open source technologies such as OpenStack, kernel-based virtual machine (KVM), simplified virtualization management, and flexible capabilities to drive rapid adoption and dramatically simplify IT consumption.
  • Better cloud economics for scale-out infrastructures, with price-performance advantages and security to confidently move data-centric applications to the cloud.

Best Practices IBM Power Systems Solution for MariaDB

Best Practices IBM Power Systems Solution for MariaDB

This white paper describes the installation and tuning of MariaDB version 10.0.14 on IBM Power Systems servers featuring the IBM POWER8 processor technology. The target audience is users and system integrators interested in using Linux on Power and MariaDB. Some familiarity with MariaDB, Linux on Power, and IBM PowerKVM might be helpful.

 

 

Turbo LAMP Whitepaper

The explosion in today’s application market is almost exclusively around applications that deliver information from troves of data to a myriad of end users devices. The information is personalized, localized, and curated for the user. Businesses are retrieving data from their systems of record—the ERP, SCM, HRM applications that have long run the business—and delivering it through systems of engagement.

The de facto standard for building systems of engagement is the LAMP stack, which consists of Linux as the operating system, an Apache web server, an open source relational database like MySQL or MariaDB, and PHP as the development language. The dominant solutions across several application categories such as ecommerce, content management, and analytics are all built on a LAMP stack. The open source software LAMP stack has become popular because each component can be theoretically interchanged and adapted without overt lock in to a specific vendor software stack. These components bundle a web application and service componentry stack built on open source technologies that are portable between Linux operating systems and platforms.

Until now, the target hardware platform for LAMP stack solutions has been Intel processors. For years, Intel had a price advantage with low-end servers, where LAMP stack had its open source beginnings. But the POWER processor family has steadily improved its price performance, and entry-level Power Systems with POWER8 processors are affordable for any business. At the same time, LAMP stack solutions have grown to support many business critical systems of engagement, where more powerful, scalable, and reliable hardware systems are required.

Whitepaper published in collaboration with IBM, Zend, Ubuntu and Mellanox

What’s New in MariaDB 10

Engineered by some of the world’s leading database experts, including MySQL founder, Michael ‘Monty’ Widenius, MariaDB has been enthusiastically adopted by a fast-growing eco-system including influential Linux distributions like Red Hat Enterprise Linux, SUSE, Centos, Debian, Fedora and Ubuntu. MariaDB 10 includes numerous innovations developed with and for web-scale players like Google, Fusion-IO and Taobao such as:

Replication

  • MariaDB 10 sets a new standard in performance. It is many times faster than previous generations of MariaDB and especially legacy database
  • MySQL thanks to new features including parallel replication and a further advanced group commit. Also, the replication slaves are now crash-safe.
  • It’s also now possible to replicate data from multiple master servers giving a complete view of the distributed data across big datasets for real-time analytical purposes via the multi-source replication feature.

NoSQL Capabilities

  • The CONNECT engine enables dynamic access to diverse data sources dynamically, including unstructured files such as log files in a folder, or any ODBC database, from within MariaDB 10. Great for ETL (Extraction, Transformation and Load) and Real-Time analysis.
  • Dynamic Columns store disparate labelled data objects in each row of a table in much the same way as NoSQL technologies.
  • Access data from Cassandra data directly inside MariaDB 10, and interoperate directly with a widely adopted Big Data technology.

Sharding

  • MariaDB 10 includes built-in sharding in the form of the SPIDER engine, allowing big database tables to be split across multiple servers, for performance and scale. MariaDB combines sharding with the new replication features to provide true high availability.

High Availability (HA) Solutions and Roadmap

The MariaDB Team provides MySQL and MariaDB software and services to the market. One of the hot topics for MySQL environments right now is High Availability and the MariaDB Team has long experience with this and has several solutions for different needs.

The MariaDB Team has long experience in High Availability and is developing and supporting several components in the area. This section outlines the High Availability options supported by the MariaDB Team.
 
 

MariaDB and MySQL Clustering with Galera

A short white paper on the need for high availability solutions and how it can be solved with Galera Cluster for MariaDB and MySQL.
 
 
 
 

MariaDB vs MySQL

The purpose of this document is to compare MariaDB and MySQL®, noting their similarities and their differences. From September 2012.
 
 
 
 

Monitoring Galera with MONyog

This white paper introduces the drawbacks of traditional MySQL High Availability set ups and suggests a modern, best-in-class High Availability solution utilising MONyog and Galera. The basics of Galera and MONyog are explained, and the steps to setting up the combined solution is gone through step-by-step.
 
 
 
 

What is MariaDB 5.5?

White paper from October 2012: MariaDB 5.5 is the current stable, generally available (GA) release of MariaDB. It builds upon — and includes several major new features and changes on top of — MySQL®. It is a compelling and attractive upgrade for all MySQL users, large and small.
 
 

MySQL Cluster Internal Architecture

MySQL Cluster is tightly linked to the MySQL server, yet it is a separate product. Due to its distributed nature, MySQL Cluster has a far more complicated architecture than a standard MySQL database.

This presentation and white paper describes the internal architecture of the MySQL Cluster product and the different mechanisms and process that exists to insure the availability of the cluster.

It also takes a close look at the data and message flow that takes place between the nodes in the cluster during different types of operations.

 

Introducing Severalnines ClusterControl

Severalnines has built ClusterControl™ to help organizations with clustered database platforms by automating development and deployment, as well as enabling management, monitoring and scaling via a graphical interface. Severalnines is today recognized globally by thousands of organizations, with its products being used in different applications in a number of industries.
 
 

MariaDB CONNECT Storage Engine

IT organizations produce a lot of data. Currently most of the data is in flat files formats. To access this data fora Business Intelligence purpose a lot of effort has to be done. This effort involves expertise and complex processes with ETL and database loading. Not everyone can afford this effort just to query day to day data. In many cases this data remains unused or is not queried in a consolidated way. The main use case of the CONNECT Storage engine is to ease access to this category of data. It offers access to various flat files format, to ODBC data sources and to remote MySQL databases.
 
 

MariaDB MaxScale

MariaDB MaxScale is an open-source, database-centric proxy that works with MariaDB Enterprise, MariaDB Enterprise Cluster, MariaDB 5.5, MariaDB 10 and Oracle MySQL®. It’s pluggable architecture is designed to increase flexibility and aid customization. Built upon a lightweight, high-speed networking core designed to facilitate throughput. MariaDB MaxScale runs between the client application and the database cluster offering connection and statement-based load balancing. MariaDB MaxScale allows scaling of an organization's database infrastructure while keeping the needs of DBAs, Developers and Data Architects in mind.

MariaDB Enterprise

MariaDB Enterprise Cover

MariaDB Enterprise extends MariaDB with certified binaries and continuous value delivery to optimize MariaDB for the most challenging use cases. We support MySQL® too!

 

 

 

 

 

MariaDB Enterprise Notification Service

The MariaDB Enterprise Notification Service creates custom email notices when new releases become available or security vulnerabilities come to light. Using data on the specific versions and features you are using in your unique deployment of the database, this service filters the change logs of new versions of MariaDB to show you just the changes that matter to you.

With this new feature, you’ll understand how new versions and security issues affect you, and can quickly make informed decisions on updates and fixes. No more reading detailed change logs and doing manual research - let the new MariaDB Enterprise Notification Service spell out the value of each update and fix to you.

MariaDB Enterprise Cluster

MariaDB Enterprise Cluster Cover

MariaDB Enterprise Cluster is an easily deployed HA solution that gives you true competitive advantages, by helping your enterprise to achieve service level objectives for high availability in the most cost-effective manner.
 
 
 
 

MariaDB and MySQL Consulting

From High Availability to Performance Tuning - all the MariaDB & MySQL® expertise you need.
 
 
 
 

MariaDB Feature Development

MariaDB Feature Development Cover

As the main commercial backers of the MariaDB project our team is uniquely positioned to develop new features in MariaDB. These features then become part of the standard MariaDB server so that you don’t need to pay any maintenance for them separately.Let us create, test, and manage your upstream contributions to the MariaDB project code.
 
 
 
 

MariaDB and MySQL Remote DBA

MariaDB and MySQL Remote DBA Cover

The MariaDB and MySQL Remote DBA service provides you with MariaDB and MySQL experts who manage and maintain your databases. If you don’t have a full time DBA on staff or if your DBA is overloaded then the MariaDB and MySQL Remote DBA Service is for you.
 
 
 
 

MariaDB and MySQL Training

MariaDB and MySQL Training

Our expert trainers deliver a complete MariaDB and MySQL training program that will help you get the most from your database deployments.
 
 
 
 

Subscription Pricing and Plans for MySQL

See this datasheet for subscription plans on MySQL. Subscription plans that cover both MySQL and MariaDB can be found on mariadb.com.

 

 

 

 

MariaDB Audit Plugin - Getting Started Guide

MySQL is used in a broad range of environments, but if you needed to record user access to be in compliance with auditing regulations for your organization, you would previously have had to use other database solutions. To meet this need, though, the developers of Monty Program AB and SkySQL Ab have developed the MariaDB Audit Plugin. Although the MariaDB Audit Plugin has some unique features available only for MariaDB, it can be used also with MySQL.
 
 

A Quick Start Guide to MONyog Ultimate Enterprise Monitor

MONyog Ultimate Enterprise Monitor (MUEM) is an efficient and easy to use monitoring tool used by thousands of Database Administrators (DBAs) to analyze their MariaDB and MySQL® Databases every day. This quick guide is aimed at providing users with information on MUEM - specifically its main features - and advice on how it can be used in real life situations.

 

 

 

A Quick Start Guide to Backup Technologies

This guide presents the most used backup and recovery techniques available for MariaDB and MySQL databases and helps the evaluation of the best backup solution, according to the organization hardware infrastructure, quality of service and resource availability.
 
 

InfiniDB Storage Engine

InfiniDB is a MariaDB and MySQL storage engine specially designed to handle complex queries on Gigabytes or Terabytes of data.

 

 

 

 

MariaDB

MariaDB is an enhanced, drop-in replacement for the MySQL database server and is available under the GPL v2 license. It is developed by the MariaDB community with the MariaDB Foundation as its main steward.
 
 
 
 

MHA

MHA (Master High Availability) is an automated master failover and slave promotion software package that drops in and runs on top of existing MySQL and MariaDB installations. It uses standard MySQL or MariaDB replication both asynchronous and semi-synchronous.
 
 
 
 

MONyog Ultimate Monitor

MONyog is a “DBA in a box” that helps DBAs monitor, manage, tune and correct problems on their MariaDB or MySQL-based database applications. It is used by tens of thousands of companies and millions of users and provided as part of MariaDB Enterprise.
 
 
 
 

MySQL Cluster

MySQL Cluster meets the needs of next generation web and telecommunications database challenges. MySQL Cluster is a write-scalable, real-time, ACID-compliant transactional database. It is open source and extensively deployed providing 99.999% availability.
 
 
 
 

Percona XtraBackup

Percona XtraBackup is an open-source, hot backup solution that performs non-blocking backups for MySQL servers running InnoDB. Percona XtraBackup makes MySQL hot backups for all versions of MySQL, MariaDB and Percona Server. It also performs streaming, compressed, and incremental backups.
 
 
 
 

Shared Storage

Shared Disk refers to a SAN (Storage Area Network) or a NAS (Network Attached Storage) with a shared storage disk file system to provide direct disk access from multiple computers at block level.
 
 
 
 

Sphinx

Sphinx is an open source full text search server, designed from the ground up with performance, relevance and integration simplicity in mind.
 
 
 
 

Visual Editor SQLyog

SQLyog is a GUI tool for MariaDB and MySQL developed by Webyog, Inc.
 
 
 
 

Zmanda Backup

The SkySQL Backup and Recovery Manager is a backup and recovery solution for the MariaDB and MySQL database powered by Zmanda, the industry’s leading provider of enterprise and cloud-based backup and disaster recovery solutions.
 
 
 
 

MariaDB Aria Storage Engine

Aria is a new storage engine for MySQL and MariaDB which was developed with the goal of being the default transactional AND non-transactional storage engine for MariaDB and MySQL.
 
 
 
 

MariaDB CONNECT Storage Engine

The CONNECT storage engine give you access to various external data sources be they either local or remote. This includes files in various formats such as DBase, CSV, DOS, FMT and XML. It also includes access to remote MySQL tables and almost any other data-source through an ODBC supported target.
 
 
 
 

MariaDB External Authentication

PAM is short for Pluggable Authentication Modules and is an authentication framework used by Linux, FreeBSD, Solaris, and other operating systems. Pluggable authentication modules (PAM) are a mechanism to integrate multiple low-level authentication schemes into a high-level application programming interface (API). It allows programs that rely on authentication to be written independent of the underlying authentication scheme.
 
 
 
 

MariaDB Thread Pool

The main goal of scalable server software is to maintain optimum performance in spite of an ever increasing number of clients. MySQL traditionally assigned a thread for every client connection, and as the number of concurrent users grows this model exhibitsperformance limitations. MariaDB 5.5 implements a dynamic/adaptive pool that itself takes care of creating new threads in times of high demand and retiring threads if they have nothing to do.
 
 
 
 

Cluster Control

ClusterControl is a database management tool used to deploy, monitor and scale database clusters. The easy to use web graphical interface to manage, monitor and autoscale clustered databases supports Galera Cluster, MySQL Replication and MySQL Cluster.

 

 

 

 

DRBD

DRBD (Distributed Replicated Block Device) is a block device used to create highly available data clusters. This is done by mirroring a whole block device via an assigned network. DRBD can be compared to a network based raid-1.
 
 
 
 

Newsletter Signup

Subscribe to get MariaDB tips, tricks and news updates in your inbox: