Red Hat open source databases in beta: Adds PostgreSQL 10, MongoDB 3.6; updates MySQL 5.7

Red Hat open source databases in beta: Adds PostgreSQL 10, MongoDB 3.6; updates MySQL 5.7

Twice a year, Red Hat distributes new versions of compiler toolsets, scripting languages, open source databases, and/or web tools, etc. so that application developers will have access to the latest, stable versions. These Red Hat supported offerings are packaged as Red Hat Software Collections (scripting languages, open source databases, web tools, etc.), Red Hat Developer Toolset (GCC), and the recently added compiler toolsets Clang/LLVM, Go, and Rust. All are yum installable, and are included in most Red Hat Enterprise Linux subscriptions and all Red Hat Enterprise Linux Developer Subscriptions. Most Red Hat Software Collections and Red Hat Developer Toolset components are also available as Linux container images for hybrid cloud development across Red Hat Enterprise Linux, Red Hat OpenShift Container Platform, etc.

Red Hat Software Collections 3.1 beta brings the following new/updated open source databases:

New addition:  PostgreSQL 10

PostgreSQL is a powerful, open source object-relational database system with more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. The following features are new in PostgreSQL 10:

  • Logical Replication – A publish/subscribe framework for distributing data
  • Declarative Table Partitioning – Convenience in dividing your data
  • Improved Query Parallelism – Quickly conquer your analysis
  • Quorum Commit for Synchronous Replication – Distribute data with confidence
  • SCRAM-SHA-256 authentication – Secure your data access

This release also marks the change of the versioning scheme for PostgreSQL to an “x.y” format. This means the next minor release of PostgreSQL will be 10.1 and the next major release will be 11.

What versions are available and where?

  • RHSCL includes PostgreSQL 9.2, 9.4, 9.5, and 9.6
  • RHEL 6 includes PostgreSQL 8.4
  • RHEL7 includes PostgreSQL 9.2

RHEL developers and users have the newest stable version of PostgreSQL for application development requiring a database.

The PostgreSQL 10 release includes significant enhancements to effectively implement the ability to distribute data across many nodes for faster access, management, and analysis, including native logical replication, declarative table partitioning, and improved query parallelism.

For RHEL7 Only

Package: rh-postgresql10

Linux container image: rhscl-beta/postgresql-10-rhel7

Everything you need to grow your career.

With your free Red Hat Developer program membership, unlock our library of cheat sheets and ebooks on next-generation application development.

SIGN UP

New addition:  MongoDB3.6

MongoDB 3.6 is the latest release of the leading database for modern applications, a culmination of native database features and enhancements that will allow you to easily evolve your solutions to address emerging challenges and use cases.

Allowing developers to persist rich, nested data without flattening it out is one of MongoDB’s defining strengths. Documents can model any kind of data: key value, graph, and relational data sets are as much at home in documents as heterogeneous, nested structures are. MongoDB Server 3.6, makes the query language much more powerful, with new array update operators that allow you to specify in-place updates to specific, matching array items, at any depth of nesting. Extensions to the $lookup aggregation stage now allow uncorrelated subqueries and multiple matching conditions, so referencing and joining documents in complex combinations can be handled in the database.

Modern applications need to respond instantaneously to changes, providing notifications to their users and interfaces that update live. To enable this, MongoDB 3.6 introduces Change Streams, which applications can use to get real-time notification of updates to collect data.

A key characteristic of robust systems is that they handle network outages gracefully, but the defensive coding to handle them can represent a significant burden on developers. MongoDB 3.6 alleviates that burden with Retryable Writes, a new feature ensuring that writes are performed exactly once, even in the face of outages.

As of this release, MongoDB Server itself will default to refusing all connections unless they are from a whitelisted IP.
The flexibility of documents is fully compatible with data validation, and MongoDB 3.6 improves on its previous capabilities with the introduction of JSON Schema. Using JSON Schema, you can specify (in JSON), on a per-collection basis, exactly what qualifies as a valid document, such as the types a field can have, whether it is required, and if a document permits fields not listed in the spec. With MongoDB 3.6, the schema isn’t a straightjacket, it’s framework of validation you can tune to exactly the degree you need.

The BI Connector, introduced last year, has been completely re-written for MongoDB 3.6 making it run much faster and easier to manage. The BI connector 2.0 is much better at translating SQL queries into MongoDB’s native aggregation framework, so it can push much more work directly down to MongoDB, instead of having to do it itself in memory.

What versions are available and where?

  • RHSCL includes MongoDB 2.4, 2.6, 3.2 3.4 and now 3.6.
  • MongoDB is not included in any version of RHEL.

For RHEL7 Only

Package name: rh-mongodb36

Linux container image: rhscl-beta/mongodb-36-rhel7

Updated: MySQL 5.7 for ppc64le, s390x, and aarch64

MySQL 5.7 is the latest version of the world’s most popular open source database. The new version delivers greater performance, scalability, and manageability, plus enhanced NoSQL capabilities with JSON support and MySQL Router, which makes it easy to connect applications to multiple MySQL databases. This release of Red Hat Software Collections makes the MySQL 5.7 collection available for ppc64le, s390x, and aarch64 architectures. Previously, MySQL 5.7 was available only for Intel x86_64.

What versions are available and where?

  • RHSCL includes MySQL 5.5, 5.6, and 5.7
  • RHEL6 includes MySQL 5.1
  • RHEL7 does not include MySQL.

For RHEL7 Only

Package name: rh-mysql57

REFERENCES:

 

Take advantage of your Red Hat Developers membership and download RHEL today at no cost.

Share