New Hybrid Support for MySQL CE, MariaDB, Percona and MemSQL

Get firewall-friendly connectivity to any databases compatible with the MySQL wire protocol using standard interfaces of Hybrid Data Pipeline 4.1.

With release 4.1, Progress DataDirect Hybrid Data Pipeline supports MySQL Community Edition (CE). We now provide firewall-friendly on-premises connectivity over standard SQL (ODBC, JDBC), and REST (OData) to any databases that are compatible with the MySQL Client.

How Big is the MySQL Client Ecosystem?

MySQL is the most popular open source RDBMS. MySQL, originally created by a Swedish company called MySQL AB, was first acquired by Sun Microsystems in 2008. MySQL later became a part of Oracle when Oracle bought Sun Microsystems in 2010.

During these acquisitions, the MySQL community began to worry about the future of MySQL. At this point, several active contributors started forking the project. The day Oracle announced the purchase of Sun Microsystems, Michael Widenius forked MySQL and launched MariaDB, taking a swath of MySQL developers with him. Some of the other major forks from the MySQL codebase are MySQL Community Edition, Percona Server, WebScale and Drizzle. All these forks support the MySQL wire protocol.

Thanks to MySQL's popularity, many other databases like MemSQL and are also designed to be compatible with MySQL Client/ MySQL wire protocol. This led to a huge ecosystem of databases that are based on MySQL Client. Going forward, we will refer to all these databases as “MySQL CE” in this blog to refer to all of these databases.

Hybrid Data Pipeline Now Supports MySQL CE

Until today, Hybrid Data Pipeline only supported the MySQL Enterprise Edition. With version 4.1, the solution supports the Community Edition as well, based on customer feedback. This means you can use the open source MySQL CE JDBC driver to plug into Hybrid Data Pipeline. Once you plug it in, you can:

• Produce OData from (RESTify) your MySQL CE database
• Provide a secure data gateway to access an on-premises MySQL CE instance from the cloud
• Provide a single interface to any cloud data source
• Open your cloud application based on MySQL CE via ODBC/JDBC/OData for open analytics

Support for MySQL CE Means Support for MariaDB, MemSQL, Drizzle and Many More

As noted above, many are MySQL wire-compliant. So, you can now connect to any of these databases with Hybrid Data Pipeline:

• MySQL Community Edition
• MariaDB
• Drizzle
• Percona
• MemSQL
• Webscale
• InfoBright
• Amazon Aurora
• Amazon RDS
• InfiniDB
• OurDelta
• Clustrix
• ClearDB
• ParaSQL
  

Please note that this is just a part of the huge list of databases that support the MySQL wire protocol (MySQL Client).

Important Features of Hybrid Data Pipeline 4.1

In this release, we are also adding features that make Hybrid Data Pipeline even more robust:

• Flexible Deployment: In addition to supporting MySQL CE data sources, the 4.1 release expands support for the local configuration database to run on MySQL Community Edition.
• Throttling: We have incorporated several throttling capabilities such as limiting the number of rows returned per query. Companies can now control how the resources are used by their consumers.
• Load Balancing: Hybrid Data Pipeline Server can now be installed on any number of nodes behind a commercial load balancer that can route requests to an available server node.
• Enhanced Silent Installer: The latest enhancements to the silent installer for Hybrid Data Pipeline Server make it easy for DevOps to deploy a new server node by supplying the input file to the installer.

Next Steps

Our hybrid connectivity services enable organizations like BOARD International (a visionary in the Magic Quadrant for CPM Suites) to expose their databases and securely access data behind customer firewalls. If you want to play with our product, you can easily register for a trial version and get started with our tutorials on AWS, Azure, Google, Digital Ocean or other clouds.