Hi Kareem,
hope it's not a misunderstanding - the config below is for clustered JackRabbit
running on MySQL, not for clustered MySQL database.
I think there is a mistake in your config:
- cluster id should be a name, not just number, and
- schema prefix should be different, not version
Something like this should work:
<Cluster id="mclu1" syncDelay="2000">
<Journal class="org.apache.jackrabbit.core.journal.DatabaseJournal">
<param name="revision" value="${rep.home}/revision"/>
<param name="driver" value="com.mysql.jdbc.Driver"/>
<param name="url" value="jdbc:mysql://127.0.0.1:5000/clusterdb"/>
<param name="user" value="magnolia"/>
<param name="password" value="123456"/>
<param name="schema" value="mysql"/>
<param name="schemaObjectPrefix" value="JOURNAL_"/>
</Journal>
... i think MySQL also distinguishes between connecting over TCP (when you use
127.0.0.1 as address) or by sockets (when using localhost as address) ... not
that it matters for local testing.
HTH,
Jan
On Jan 4, 2011, at 4:34 PM, Kareem Al Jabr wrote:
> Hello Magnolians,
>
> I am trying to configured a clustered MySQL database in Magnolia author
> instance. But I get in the log that the cluster is <unset>. I have provided
> the cluster information in jackrabbit-bundle-mysql-search.xml as in the
> script below. I am wondering if I am missing something here. Because I didn't
> get the tables created.
>
> <PersistenceManager
> class="org.apache.jackrabbit.core.persistence.bundle.MySqlPersistenceManager">
> <param name="driver" value="com.mysql.jdbc.Driver" />
> <param name="url" value="jdbc:mysql://127.0.0.1:5000/clusterdb" />
> <param name="schema" value="mysql" /><!-- warning, this is not the
> schema name, it's the db type -->
> <param name="user" value="magnolia" />
> <param name="password" value="123456" />
> <param name="schemaObjectPrefix" value="version_" />
> <param name="externalBLOBs" value="true" />
> </PersistenceManager>
> </Versioning>
> <Cluster id="50" syncDelay="5">
> <Journal class="org.apache.jackrabbit.core.journal.DatabaseJournal">
> <param name="revision" value="${rep.home}/revision"/>
> <param name="driver" value="com.mysql.jdbc.Driver"/>
> <param name="url" value="jdbc:mysql://127.0.0.1:5000/clusterdb"/>
> <param name="user" value="magnolia"/>
> <param name="password" value="123456"/>
> <param name="schema" value="mysql"/>
> <param name="schemaObjectPrefix" value="version_"/>
> </Journal>
> </Cluster>
>
> Thanks,
> Kareem
----------------------------------------------------------------
For list details see
http://www.magnolia-cms.com/home/community/mailing-lists.html
To unsubscribe, E-mail to: <[email protected]>
----------------------------------------------------------------
