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

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

May 12, 2017 0 Comments
New Hybrid Support for MySQL CE, MariaDB, Percona and MemSQL_870_220

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

MySQL CE Forks

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.

Try Hybrid Data Pipeline for Free
Nishanth-Kadiyala

Nishanth Kadiyala

Nishanth Kadiyala is a Technical Marketing Manager at Progress. He got his B.Tech degree from IIT Guwahati and his MBA from UNC Chapel Hill. He has worked on several technologies including database designing, SQL querying and Cloud Computing in the past. Currently, he is committed to educating enterprises about standards based connectivity via ODBC, JDBC, ADO.NET and OData. He is also proficient with DataDirect Hybrid Connectivity Services – DataDirect Cloud and Hybrid Data Pipeline. You can stay in touch with him through Twitter.

Read next Tutorial: Using Impala JDBC and SQL with Apache Kudu
Comments
Comments are disabled in preview mode.