17 Apr
2014
17 Apr
'14
7:20 p.m.
On 04/17/2014 10:18 AM, max_allan wrote:
Hello,
I can only find one suggestion about migrating between databases, it's from
2006 that refers to an export tool that only works in Firefox.
Is there a better way yet? I've got quite a lot of content and users and
more importantly than the volume of data I'd like to retain "ownership"
metadata and history etc..
But then read a bit about it and thought "Do I need to migrate". I'm
assuming if the wiki is not being accessed then a simple filesystem backup
will be consistent and recoverable?
Should there be any extra indexes or anything else to do for performance
tweaks?
Would MySQL give me any advantage over HSQLDB?
(I'm on 5.0.3 and want to update to 5.4.4 soon.)
I distrust a database if I haven't got a whole pile of command line tools I
can poke at it with...
Max
Personally I'm thinking of going the other way around. Although MySQL is
probably the most popular RDBMS, HSQLDB is faster, closer to SQL
standards, has more features, offers better support for Unicode and
variable length fields, and many other advantages... The reason why
XWiki recommends MySQL is that there is more knowledge about it, thus
it's easier to find guides, or to find a sysadmin that can set up a
database.
However, it is true that the default HSQLDB database shipped with XWiki
is NOT optimized for performance, and it doesn't support larger volumes
of data.
--
Sergiu Dumitriu
http://purl.org/net/sergiu