Documentation Database Servers Beat

From FedoraProject

(Difference between revisions)
Jump to: navigation, search
(mysql: mention soname bump for libmysqlclient)
(postgresql: Replace warning about needing dump/restore with info about how to avoid it)
Line 20: Line 20:
 
== postgresql ==
 
== postgresql ==
  
{{package|postgresql}} has been updated from 8.4.4 to 9.0.3.  In addition to numerous security and other bugfixes, this release contains a number of new features:
+
{{package|postgresql}} has been updated from 8.4.7 to 9.0.3.  In addition to numerous security and other bugfixes, this release contains a number of new features:
* Built-in replication based on log shipping.ster with multiple read-only slave servers
+
* Built-in replication, based on log shipping, supports multiple read-only slave servers
 
* Easier database object permissions management
 
* Easier database object permissions management
 
* Broadly enhanced stored procedure support
 
* Broadly enhanced stored procedure support
Line 32: Line 32:
 
* New high-performance implementation of the LISTEN/NOTIFY feature
 
* New high-performance implementation of the LISTEN/NOTIFY feature
 
* New implementation of VACUUM FULL
 
* New implementation of VACUUM FULL
* New contrib module pg_upgrade to support in-place upgrades from 8.3 or 8.4 to 9.0
 
 
* Multiple performance enhancements for specific types of queries, including elimination of unnecessary joins
 
* Multiple performance enhancements for specific types of queries, including elimination of unnecessary joins
 
* EXPLAIN enhancements
 
* EXPLAIN enhancements
 
* hstore improvements
 
* hstore improvements
  
{{admon/note|Requires database dump|
+
In addition, there is a new contrib module pg_upgrade to support in-place upgrades from 8.4 to 9.0.  This means that you can upgrade from a Fedora 12 or later database without a database dump and restore.  To do that, install the postgresql-upgrade package and run '''service postgresql upgrade''' as root.  It's advisable to have a separate backup in case of trouble, but the actual database conversion requires only a few minutes with this approach.
Upgrading requires a dump/restore using pg_dump and pg_restore}}
+
  
 
{{admon/warning|Incompatible Changes|
 
{{admon/warning|Incompatible Changes|

Revision as of 15:58, 24 March 2011

DocsProject Header docTeam1.png


riak

Riak, a scalable and reliable data store, is available in Fedora 15.

Riak is a Dynamo-inspired key/value store, written in Erlang, that scales predictably and easily. Riak also simplifies development by giving developers the ability to quickly prototype, test, and deploy their applications.

A truly fault-tolerant system, Riak has no single point of failure. No machines are special or central in Riak, so developers and operations professionals can decide exactly how fault-tolerant they want and need their applications to be.


mysql

Package-x-generic-16.pngmysql has been updated to version 5.5.8. Included are improved scalability and performance. From the release announcement: "Higher availability: New semi-synchronous replication and Replication Heart Beat improve failover speed and reliability."

This update includes increasing the shared library version number of libmysqlclient, so applications using that library will need to be recompiled.

http://www.mysql.com

postgresql

Package-x-generic-16.pngpostgresql has been updated from 8.4.7 to 9.0.3. In addition to numerous security and other bugfixes, this release contains a number of new features:

  • Built-in replication, based on log shipping, supports multiple read-only slave servers
  • Easier database object permissions management
  • Broadly enhanced stored procedure support
  • More advanced reporting queries
  • New trigger features
  • Deferrable unique constraints
  • Mass updates to unique keys are now possible without trickery
  • Exclusion constraints
  • New and enhanced security features
  • New high-performance implementation of the LISTEN/NOTIFY feature
  • New implementation of VACUUM FULL
  • Multiple performance enhancements for specific types of queries, including elimination of unnecessary joins
  • EXPLAIN enhancements
  • hstore improvements

In addition, there is a new contrib module pg_upgrade to support in-place upgrades from 8.4 to 9.0. This means that you can upgrade from a Fedora 12 or later database without a database dump and restore. To do that, install the postgresql-upgrade package and run service postgresql upgrade as root. It's advisable to have a separate backup in case of trouble, but the actual database conversion requires only a few minutes with this approach.

Warning (medium size).png
Incompatible Changes
Version 9.0 contains a number of changes that selectively break backwards compatibility in order to support new features and code quality improvements. Refer to the release notes at http://www.postgresql.org/docs/current/static/release-9-0.html