magnolia on mysql or other databases

Discussion:

Claudio Greuter

2006-05-24 07:40:33 UTC

As one of the most important features of Magnolia is the JCR interface,
I crawled the web a bit and read up a little on Jackrabbit.

Does anyone know if it is possible to configure jackrabbit to store the
magnolia contents in mysql. Perhaps someone already did this? I saw that
there are config files for other databases, but in our Project setup
Mysql would be interesting.

Cheers
Claudio

***********************************************
IPH Informatik AG
Herr Claudio Greuter
Lagerhausstrasse 9
8400 Winterthur
Tel: +41 (052) 233 94 72
Fax: +41 (052) 233 94 71
c.gr-4Z+***@public.gmane.org
***********************************************

----------------------------------------------------------------

Nicolas Modrzyk

2006-05-24 07:45:41 UTC

Permalink

Hi Claudio,

I am actually running some magnolia tests on mysql these days.

It's definitely faster and lighter than derby.

You should write a jackrabbit-mysql-search.xml file in magnolia/WEB-
INF/config/repo-conf

and change the necessary line in magnolia/WEB-INF/config/default/
repositories.xml

The configuration can be found in the simpledbpersistence manager:
http://jackrabbit.apache.org/api-1/org/apache/jackrabbit/core/state/
db/SimpleDbPersistenceManager.html

and the mysql driver can be found on the maven ibiblio site:
http://www.ibiblio.org/maven/wadi/dependencies/maven2/mysql/mysql-
connector-java/3.1.11-bin/

They also have a newer one on the mysql website.

I'd be interested to get your feedback as well.

So far, I haven't run into any problem, and the memory usage has
dropped by around 40M on the java side. (and it grew on the mysql
side by about 15M)

Hope this helps,

Regards,

Nicolas,

Post by Claudio Greuter
As one of the most important features of Magnolia is the JCR
interface,
I crawled the web a bit and read up a little on Jackrabbit.
Does anyone know if it is possible to configure jackrabbit to store
the
magnolia contents in mysql. Perhaps someone already did this? I saw
that
there are config files for other databases, but in our Project setup
Mysql would be interesting.
Cheers
Claudio
***********************************************
IPH Informatik AG
Herr Claudio Greuter
Lagerhausstrasse 9
8400 Winterthur
Tel: +41 (052) 233 94 72
Fax: +41 (052) 233 94 71
***********************************************
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------

----------------------------------------------------------------

Keith Kowalczykowski

2006-05-24 07:57:03 UTC

Permalink

Nicolas,

Could you provide an example your jackrabbit-mysql-serach.xml and
the modifications you made to repositories.xml? Thanks.

--Keith

Post by Nicolas Modrzyk
Hi Claudio,
I am actually running some magnolia tests on mysql these days.
It's definitely faster and lighter than derby.
You should write a jackrabbit-mysql-search.xml file in magnolia/WEB-
INF/config/repo-conf
and change the necessary line in magnolia/WEB-INF/config/default/
repositories.xml
http://jackrabbit.apache.org/api-1/org/apache/jackrabbit/core/state/
db/SimpleDbPersistenceManager.html
http://www.ibiblio.org/maven/wadi/dependencies/maven2/mysql/mysql-
connector-java/3.1.11-bin/
They also have a newer one on the mysql website.
I'd be interested to get your feedback as well.
So far, I haven't run into any problem, and the memory usage has
dropped by around 40M on the java side. (and it grew on the mysql
side by about 15M)
Hope this helps,
Regards,
Nicolas,

----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------

Claudio Greuter

2006-05-24 08:24:40 UTC

Permalink

Hi Nicolas

Thanks for the fast reply. If you could provide the xml files to me too
this would just be great and it would help me setting up and testing the
environment faster.

Of courso I will provide feedback of my experience with this setup.
Actually I think we could/should post this to the wiki after we know the
"how" and the possible existing issues.

***********************************************
IPH Informatik AG
Herr Claudio Greuter
Lagerhausstrasse 9
8400 Winterthur
Tel: +41 (052) 233 94 72
Fax: +41 (052) 233 94 71
c.gr-4Z+***@public.gmane.org
***********************************************

-----Original Message-----
From: user-list-O8DnXSz/wDok+I/***@public.gmane.org [mailto:user-list-O8DnXSz/wDok+I/***@public.gmane.org]
Sent: Mittwoch, 24. Mai 2006 09:57
To: user-list-O8DnXSz/wDok+I/***@public.gmane.org
Subject: Re: [magnolia-user] magnolia on mysql or other databases

Nicolas,

Could you provide an example your jackrabbit-mysql-serach.xml and
the modifications you made to repositories.xml? Thanks.

--Keith

--
Keith Paul Kowalczykowski
Email: Primary: keithpk-***@public.gmane.org Secondary: kkowalcz-XkckGZ689+***@public.gmane.org
ICQ#: 41537706
SN: kowalczykowski

----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------

----------------------------------------------------------------

Nicolas Modrzyk

2006-05-24 08:38:27 UTC

Permalink

The mysql config file is in the svn:
http://svn.magnolia.info/svn/magnolia/trunk/magnolia/src/main/webapp/
WEB-INF/config/repo-conf/jackrabbit-mysql-search.xml

You need to change the parameter config file in the repositories.xml:

...
<param name="configFile" value="WEB-INF/config/repo-conf/jackrabbit-
mysql-search.xml" />
...

And to include the jar file with the url I've pointed before:
http://www.ibiblio.org/maven/wadi/dependencies/maven2/mysql/mysql-
connector-java/3.1.11-bin/

If you can, let me know if/when you have this working.

Regards,

Nicolas,

Post by Claudio Greuter
Hi Nicolas
Thanks for the fast reply. If you could provide the xml files to me
too
this would just be great and it would help me setting up and
testing the
environment faster.
Of courso I will provide feedback of my experience with this setup.
Actually I think we could/should post this to the wiki after we
know the
"how" and the possible existing issues.
***********************************************
IPH Informatik AG
Herr Claudio Greuter
Lagerhausstrasse 9
8400 Winterthur
Tel: +41 (052) 233 94 72
Fax: +41 (052) 233 94 71
***********************************************
-----Original Message-----
Sent: Mittwoch, 24. Mai 2006 09:57
Subject: Re: [magnolia-user] magnolia on mysql or other databases
Nicolas,
Could you provide an example your jackrabbit-mysql-serach.xml and
the modifications you made to repositories.xml? Thanks.
--Keith

--
Keith Paul Kowalczykowski
ICQ#: 41537706
SN: kowalczykowski
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------
----------------------------------------------------------------
for list details see
http://www.magnolia.info/en/magnolia/developer.html
----------------------------------------------------------------

----------------------------------------------------------------