Over a million developers have joined DZone.
{{announcement.body}}
{{announcement.title}}

Red Hat Open-Source Databases in Beta: PostgreSQL 10, MongoDB 3.6, and MySQL 5.7

DZone's Guide to

Red Hat Open-Source Databases in Beta: PostgreSQL 10, MongoDB 3.6, and MySQL 5.7

Learn about new versions of compiler toolsets, scripting languages, open-source databases, and web tools so that you have access to the latest stable versions.

· Database Zone ·
Free Resource

Download Microservices for Java Developers: A hands-on introduction to frameworks and containers. Brought to you in partnership with Red Hat.

Twice a year, Red Hat distributes new versions of compiler toolsets, scripting languages, open-source databases, 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

New Addition: MongoDB 3.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 datasets 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

Download Building Reactive Microservices in Java: Asynchronous and Event-Based Application Design. Brought to you in partnership with Red Hat

Topics:
database ,red hat ,open source ,postgresql ,mongodb ,mysql

Published at DZone with permission of

Opinions expressed by DZone contributors are their own.

{{ parent.title || parent.header.title}}

{{ parent.tldr }}

{{ parent.urlSource.name }}