Forums / Extensions / Support for Oracle Extension in eZPublish4.0

Support for Oracle Extension in eZPublish4.0

Author Message

SatyaPrasad Alamuru

Monday 12 November 2007 7:17:19 am

We are developing a website for one of our clients using eZ Publish 3.9.3 and have to migrate to PHP5. We want to find out about the effort involved in migrating eZ Publish from 3.9.3 to 4.0 (as it is supposed to work with PHP5). Currently we are using the extension “Oracle Database 1.4” as the DB is Oracle.

Will Oracle be supported by eZ Publish 4.0, as it is stated in the migration steps from 3.10 to 4.0 as “The eZ Publish Extension for Oracle® Database v1.5 and earlier (plus the upcoming version 1.6) do not work with eZ Publish 4.0.0 alpha2. Do not upgrade to 4.0 if your site makes use of this extension.” (mentioned in the URL - http://ez.no/doc/ez_publish/upgrading/upgrading_to_4_0/from_3_10_0_to_4_0_0)

Any response to the above question will be highly appreciated.

Gaetano Giunta

Monday 12 November 2007 1:32:40 pm

We are currently working on a new version of the ezOracle extension, that will provide many bugfixes and improvements and possibly also with the new 3.10 cluster mode.

Once that is released, focus will be on version 2.0 of the oracle extension, that will be compatible with eZ Publish 4.

Principal Consultant International Business
Member of the Community Project Board

Michael Lee

Wednesday 28 May 2008 3:42:34 am

Hi Gaetano,

Thanks for your information. We want to develop web sites with eZ publish 4.0 and Oracle, but that's impossible for this moment, right?

Besides, could you please let me know if the eZ Oracle extension can work with the RAC - "Real Application Clusters" or any other failover & scalability solutions in Oracle?

I know that eZ publish is not working for MySQL Cluster (maybe I am wrong), but we couldn't find any useful information about the MySQL Cluster in the forum.

And the MySQL Slave Servers can only be used for "read-only" site access, that's not enough in most cases. Because the "master" server does not support failover.

I don't know if this is the right place to ask questions about Oracle Clusters and MySQL clusters. But I really appreciate for your feedbacks.

Kind regards,

Michael

Michael Lee | Managing Director | ZerusTech Ltd | www.zerustech.com

Skype: zerustech

Gaetano Giunta

Wednesday 28 May 2008 2:43:32 pm

<i>Thanks for your information. We want to develop web sites with eZ publish 4.0 and Oracle, but that's impossible for this moment, right?</i>

Right now, it is.
We will release eZ Oracle 2.0 together with eZ Publish 4.1, quite soon

eZP 4.0 will not be officially supported, at least for now, but if you do not use the eZ cluster functionality, the eZ Oracle extension should work flawlessly (ie. there have been API changes in the cluster code between eZP 4.0 and 4.1 but not in other parts of the code related with the db layer).

We might one day release fully supported, backward-compatible versions of the oracle connector, for eZP 3.9, 3.10 and 4.0. But I would really suggest you upgrade to 4.1 instead.

<i>Besides, could you please let me know if the eZ Oracle extension can work with the RAC - "Real Application Clusters" or any other failover & scalability solutions in Oracle?</i>

It "should" work out of the box.
This means the RAC changes are implemented at the level of the oci client, and not exposed to php or eZP - RAC is completely transparent to an eZP install.
Having said that, we did not (yet) test the eZ Oracle extension against a RAC setup, so we can not yet certify it (testing is the only way to make sure there are no regressions at all, even when there "should" be none)

<i>I know that eZ publish is not working for MySQL Cluster (maybe I am wrong), but we couldn't find any useful information about the MySQL Cluster in the forum.
And the MySQL Slave Servers can only be used for "read-only" site access, that's not enough in most cases. Because the "master" server does not support failover.
I don't know if this is the right place to ask questions about Oracle Clusters and MySQL clusters. But I really appreciate for your feedbacks.</i>

I am not a mysql guru.

Master-slave setup with one rw and many ro databases is a common setup for mysql web clusters, given usage patterns and mysql strenghts/weaknesses. That's why it has been implemented in eZP.
Afaik you can set up a single active mysql db with failover on a standby replicated instance, and I think you can even set up a master to fail over to a replicated slave, which would then become the new master.
I am pretty sure that there are other replication solutions for mysql that are completely transparent to eZP. They might be available as non-free or non-oss, and require different setups.

Principal Consultant International Business
Member of the Community Project Board

Gaetano Giunta

Tuesday 26 August 2008 10:13:31 am

For all interested parties: there is code in the ezoracle svn (on projects.ez.no) that is meant for eZ Publish 4.0.1 - look for the 1.8 branch.

It is not yet released in a bundle, but the goal is to provide support for oracle with eZ Publish 4.0.x, with x > 0 (there have been a few oracle-related bugs fixed in the base eZ Publish 4.0.1 code).
The only "partially supported" feature is the eZ Publish cluster: to have it working you will need to copy the patched files from ezoracle into your eZPublish kernel.

Principal Consultant International Business
Member of the Community Project Board