Re: [Postgres-xc-general] [ANNOUNCE] Release of Postgres-XC 1.0.0

[Michael P. <mic...@gm...>]

On Mon, Jun 11, 2012 at 9:02 PM, Fernando Lozano <fer...@lo...>wrote:

>  Hi,
>
> I spent half an hour browsing the website, wiki and docs and could not
> find where I read that postgresql-xc should be transparent to libpq
> clients. Will keep looking later.
>
Thanks.
Please keep me updated if you find anything. Improving documentation is a
nerver-ending task
Regards,


>
>
> []s, Fernando Lozano
>
>
>   Hi,
>
>  You should avoid sending responses to Postgres announce mailing lists
> people are going to complain. Better to use the MLs dedicated to xc.
> Please find my answers below.
>
>  On 2012/06/09, at 1:54, Fernando Lozano <fer...@lo...> wrote:
>
>   Hi Michael,
>
> Very interesting, but the docs states that it is "transparent" only for
> libpq clients. This means Java clients (using the type 4 JDBC driver) can't
> use PostgreSQL XC?
>
> Documentation is wrong. We tested with many drivers like php, ruby, perl,
> jdbc, ecpg, etc.
> And the only problems we saw was with odbc because it uses returning and
> ctid. The rest was working well.
> Could you indicate in which page the error is located?
>
>
> Also, as far as I understand the docs, I need something external do
> implement failover if I connect to a database server which comes offline
> (JBoss AS HA Datasources comes to mind), and there's no balancer included.
> Am I right?
>
> Yes you are right. There is a kind of load balancing between Datanodes and
> Coordinators by design thanks to the distributed nature of tables and the
> possibility to control read for replicated tables on specific nodes.
> However it might be preferable to have load balancing from something
> external.
>
>  Regards,
>
>  Michael
>
>
>
> []s, Fernando Lozano
>
>  Hi all,
>
> Postgres-XC, read&write-scalable multi-master symmetric cluster based on
> PostgreSQL, version 1.0.0 is released.
> This project is seen as an open-source alternative to costly products such
> as OracleRAC. Postgres-XC is based on the code of PostgreSQL, so it can
> naturally use all its technologies, which are enhaunced to have a
> shared-nothing multi-master PostgreSQL-based database cluster.
>
> This first stable version is based on PostgreSQL 9.1.4. All the patches in
> PostgreSQL 9.1 stable branch have been merged up to commit 873d1c1 (1st of
> June 2012).
> This includes the security fix related to pg_crypto dated of 30th of May.
> You can download the source tarball directly from here:
> https://sourceforge.net/projects/postgres-xc/files/latest/download
> This tarball contains all the HTML and man documentation.
>
> 30 bug fixes have been made since release of beta2, with some notable
> enhancements:
> - Support for EXTENSION is fixed
> - Stabilization of the use of slave nodes in cluster
> - Fix of a bug related to read-only transactions, improving performance by
> 15%.
> - Support of compilation for MacOSX
> About the scalability of this release, Postgres-XC 1.0.0 scales to a
> factor of 3 when compared to a standalone server PostgreSQL 9.1.3 on 5
> nodes using a benchmark called DBT-1.
>
> Compared to version Postgres-XC 0.9.7, the following features have been
> added:
> - Fast query shipping (FQS), quick identification of expressions in a
> query that can be pushed down to remote nodes
> - SERIAL types
> - TABLESPACE
> - Utility to clean up 2PC transactions in cluster (pgxc_clean)
> - Utility for initialization of GTM (global transaction manager, utility
> called initgtm)
> - Relation-size functions and locking functions
> - Regression stabilization
>
> The documentation of 1.0, including release notes, is available here:
> http://postgres-xc.sourceforge.net/docs/1_0/.
>
> The project can be followed on Source Forge:
> http://postgres-xc.sourceforge.net/.
> And a couple of GIT repositories are used for development:
> - SourceForge:
> http://postgres-xc.git.sourceforge.net/git/gitweb.cgi?p=postgres-xc/postgres-xc;a=summary
> - Github: https://github.com/postgres-xc/postgres-xc
>
> The core team is currently working in the addition of new features for the
> next major release including:
> - Merge with PostgreSQL 9.2
> - Data redistribution functionality, changing table distribution in
> cluster with a simple ALTER TABLE
> - New functionalities related to online node addition and deletion for a
> better user experience
> - Triggers
> - Planner improvements
> - Global constraints.
> The roadmap of the project is located here =>
> http://postgres-xc.sourceforge.net/ in section Roadmap.
>
> The project is under the same license as PostgreSQL, now managed under a
> single entity called "Postgres-XC Development Group".
> In order to keep in touch with the project, whose development follows the
> same model as PostgreSQL, you can register to the following mailing lists:
> - pos...@li..., for general questions.
> Registration can be done here:
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
> - pos...@li.... hachers mailing list.
> Registration can be done here:
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
> See you soon on the project mailing list, and have fun with this stable
> release.
> --
> Michael Paquier
> Member of core team of Postgres-XC, and Postgres-XC Development Group
>
>
>
>
>
>


-- 
Michael Paquier
http://michael.otacoo.com