18 Sep
2010
18 Sep
'10
4:30 p.m.
Has anyone ever performed a migration that could give me some advice on
how it's done and if what I asked about below is possible?
I have checked out this:
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup
which suggests to backup the database but doesn't give any clue to
Postgresql!
Also is Xwiki content stored in a database or in the /webapps/xwiki
instance??
So if I simply backed up and restored the database and copied the xwiki/
dir across to a different platform the system should work?? Even if
going from Tomcat to Glassfish or so??
Thanks and regards,
Kaya
-------- Original Message --------
Subject: Migrating Xwiki
Date: Fri, 17 Sep 2010 14:16:08 +0300
From: Kaya Saman <kayasaman(a)gmail.com>
To: XWiki Users <users(a)xwiki.org>
Hi,
I'm wondering if it's possible to migrate Xwiki from one system to another??
I currently run Xwiki on a FreeBSD 8.0 RELEASE x64 platform with 4GB RAM
in a dedicated FreeBSD Jail, however I'm having an issue with Java
spinning up the CPU to 100% rendering Xwiki inoperable!
If I migrate it would be from FreeBSD to either a dedicated FreeBSD
system or an OpenSolaris based system on Nexenta.
Currently I run Tomcat6 coupled with Postgresql, but would migrate to
Glassfish and MySQL.
Is it just a matter of backup the Xwiki from the web GUI then restore
under Glassfish and convert database from Postgresql to MySQL then
attach at other end?
Or can I just simply dump the /webapps/xwiki folder into Glassfish or
another instance of Tomcat?
Thanks for any advice!!
Regards,
Kaya
18 Sep
18 Sep
11:30 p.m.
Hi Kaya,
Kaya Saman wrote:
Has anyone ever performed a migration that could give
me some advice on
how it's done and if what I asked about below is possible?
I have checked out this:
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup
which suggests to backup the database but doesn't give any clue to
Postgresql!
Also is Xwiki content stored in a database or in the /webapps/xwiki
instance??
So if I simply backed up and restored the database and copied the xwiki/
dir across to a different platform the system should work?? Even if
going from Tomcat to Glassfish or so??
Yes, I think it is possible to perform a migration, even thought I've
never done that. But, yes, I've moved XWiki installations from one
server to the other without much difficulty. Provided both systems run
the same XWiki release, the problems could only arise from the
conversion of the Postgresql database to MySQL. I don't think the
servlet container will do a difference once you adjust hibernate.cfg.xml
accordingly.
A typical XWiki installation, whatever applications you install with it,
is divided between file system contents and database contents. All file
system contents are locate under /xwiki (though now it is possible to
choose the name of its root directory or even call it root) in the
applications folder of your servlet container. In the case of Tomcat, it
is /webapps. Configuration files (two of them must be surely tweaked,
xwiki.cfg and hibernate.cfg.xml) are at /webapps/WEB-INF.
Also, stored in the file system are the core libraries, plugins, skins,
Velocity templates,... look at this...
http://ftp.ebiotic.net/onXWiki/xwiki-platform-eBioTIC.png
I've only picked up the XWiki Platform's Architecture illustration from ...
http://platform.xwiki.org/xwiki/bin/view/DevGuide/Architecture/WebHome
... and added a box under the components always stored in the database.
Note than each time more and more components and configuration settings
are being moved to the database or, in the case of configuration
settings, could be modified by values in properties of classes stored in
the database.
Thus, by fully backing up your database and once converted to the system
of your choice and by moving the concerned /webapps directory to the new
servlet container, functioning must be restored with a minor number of
adjustments.
Please, take into account that I've never moved XWiki installation
across systems, only between boxes running the same servlet containers
and relational database manager systems. Many times, different releases
of those, but always the same products (MySQL and Tomcat here). I'm sure
developers and/or more skilled users will correct this contents and add
useful information.
Hope this helps!
Ricardo
--
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems
20 Sep
20 Sep
9:03 a.m.
Many thanks for the response Ricardo :-)
On 19/09/2010 00:30, [Ricardo Rodriguez] eBioTIC. wrote:
Hi Kaya,
Kaya Saman wrote:
I can keep the Postgres database that isn't a problem as it's available
on all platforms. However, when you say that Xwiki should be the same
release I was hoping to just copy the webapps/xwiki container as if I'm
not mistaken the xwiki.war file that I'm using gets extracted by
Tomcat/Glassfish or other which fully contains the Xwiki instance minus
the DB??.....
Moving that should keep everything in check with a few additions to the
hibernate.cfg.xml file if changing database! .....I presume as I need to
test this out fully first before things blow up in my face!
[...]
Yes, I think it is possible to perform a migration, even thought I've
never done that. But, yes, I've moved XWiki installations from one
server to the other without much difficulty. Provided both systems run
the same XWiki release, the problems could only arise from the
conversion of the Postgresql database to MySQL. I don't think the
servlet container will do a difference once you adjust hibernate.cfg.xml
accordingly.
[...]
Thus, by fully backing up your database and once converted to the system
of your choice and by moving the concerned /webapps directory to the new
servlet container, functioning must be restored with a minor number of
adjustments.
Ok, so I think you are explaining exactly the same thing as I've just
put above; meaning that I've got the right strategy in mind.
Please, take into account that I've never moved
XWiki installation
across systems, only between boxes running the same servlet containers
and relational database manager systems. Many times, different releases
of those, but always the same products (MySQL and Tomcat here). I'm sure
developers and/or more skilled users will correct this contents and add
useful information.
I'll attempt with Glassfish but since I don't have any experience with
it, I don't know exactly how it deals with applications installed in it.
If not I'll switch back to Tomcat/Postgres combo but I'm sure running
the system on Solaris or Linux will be much better then my current BSD
install as Java seems to spin up the CPU to 100% meaning that from what
I've read and the 'top' code of uxtn that I'm getting, tells me that the
threads are getting stuck, not being able to address the memory
properly. Means I'll have to file a bug report with ISC and then debug
Java - something which I'm not really capable of doing since I'm not a
programmer and have no idea about Java.
Hope this helps!
Ricardo
Yep it helps a lot :-)
Thanks again,
Kaya
7:08 p.m.
Hi!
Kaya Saman wrote:
I can keep the Postgres database that isn't a
problem as it's available
on all platforms. However, when you say that Xwiki should be the same
release I was hoping to just copy the webapps/xwiki container as if I'm
not mistaken the xwiki.war file that I'm using gets extracted by
Tomcat/Glassfish or other which fully contains the Xwiki instance minus
the DB??.....
Minus the DB, and any edit file! Be careful with xwiki.cfg,
hibernate.cfg.xml, any edit Velocity (*.vm) template and any library you
have copied to WEB-INF/lib (for instance, MySQL connector must be copied
there to allow XWiki to access a MySQL database).
Moving that should keep everything in check with a few
additions to the
hibernate.cfg.xml file if changing database! .....I presume as I need to
test this out fully first before things blow up in my face!
I insist: remember to back-up xwiki.cfg and take not of what
extra-libraries you are using!
Cheers,
Ricardo
--
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems
21 Sep
21 Sep
9:22 a.m.
Many thanks Ricardo!!
Let me play around first and see how this thing handles then hopefully
I'll have a properly functioning wiki after the migration :-)
The howto will be posted on it directly as are many other howto's
already......
Best regards,
Kaya
On 20/09/2010 20:08, [Ricardo Rodriguez] eBioTIC. wrote:
Hi!
Kaya Saman wrote:
I can keep the Postgres database that isn't a
problem as it's available
on all platforms. However, when you say that Xwiki should be the same
release I was hoping to just copy the webapps/xwiki container as if I'm
not mistaken the xwiki.war file that I'm using gets extracted by
Tomcat/Glassfish or other which fully contains the Xwiki instance minus
the DB??.....
Minus the DB, and any edit file! Be careful with xwiki.cfg,
hibernate.cfg.xml, any edit Velocity (*.vm) template and any library you
have copied to WEB-INF/lib (for instance, MySQL connector must be copied
there to allow XWiki to access a MySQL database).
Moving that should keep everything in check with
a few additions to the
hibernate.cfg.xml file if changing database! .....I presume as I need to
test this out fully first before things blow up in my face!
I insist: remember to back-up xwiki.cfg and take not of what
extra-libraries you are using!
Cheers,
Ricardo
10:22 a.m.
Welcome!
Kaya Saman wrote:
Many thanks Ricardo!!
Let me play around first and see how this thing handles then hopefully
I'll have a properly functioning wiki after the migration :-)
The howto will be posted on it directly as are many other howto's
already......
Don't forget to have a lot to ...
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Installation#HUpgrading…
It's "our" responsibility to have these documents updated and make them
as useful as possible!
Greetings,
Ricardo
--
Ricardo Rodríguez
CTO
eBioTIC.
Life Sciences, Data Modeling and Information Management Systems
5206
days inactive
5209
days old
5 comments
2 participants
participants (2)
-
[Ricardo Rodriguez] eBioTIC. -
Kaya Saman