Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1

[Kumar, Piyush]

Hi Vincent,



As per your suggestion in below answer I went through the page 
“http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup#HUsingtheXWikiExportfeature”

For Xwiki  export and database backup to migrate to new version. I still have 
one doubt that we are using virtual wikis and currently we have one DB created 
for one virtual Wiki. So We have one DB for main Wiki as Xwiki and multiple DBs 
for multiple created virtual Wikis. In the above referred page it only talks 
about main Wiki page export and main Xwiki DB backup. I would like to know that 
what should we do for our virtual Wikis and their DBs ?



Do we need to export each virtual Wiki and its created DB separately ?



Also Please suggest on DB indexing part as asked in below email as well.



Thanks a lot Vincent for your help.



Thanks & Regards,

Piyush



-Original Message-
From: Kumar, Piyush
Sent: Wednesday, September 28, 2016 8:04 PM
To: XWiki Users
Subject: RE: [xwiki-users] I would like to migrate my xwiki application from 
4.2 to 8.2.1



Hi Vincent,



Regarding DB indexing I would like to tell you that I already created below 
indexes as per the page 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration to 
deal with performance but could not get any benefit. Sice we are having 4.2 
version at production, we created below mentioned indexes in our MySQL DB.





Indexes for XWiki Enterprise versions after 3.2 create index xwl_value on 
xwikilargestrings (xwl_value(50)); create index xwd_parent on xwikidoc 
(xwd_parent(50)); create index xwd_class_xml on xwikidoc (xwd_class_xml(20)); 
create index xws_number on xwikistatsdoc (XWS_NUMBER); create index 
xws_classname on xwikistatsdoc (XWS_CLASSNAME); create index xwr_number on 
xwikistatsreferer (XWR_NUMBER); create index xwr_classname on xwikistatsreferer 
(XWR_CLASSNAME); create index xwr_referer on xwikistatsreferer 
(XWR_REFERER(50)); create index xwv_user_agent on xwikistatsvisit 
(XWV_USER_AGENT(255)); create index xwv_cookie on xwikistatsvisit 
(XWV_COOKIE(255)); create index xwv_classname on xwikistatsvisit 
(XWV_CLASSNAME); create index xwv_number on xwikistatsvisit (XWV_NUMBER); 
create index ase_requestid on  activitystream_events (ase_requestid(200)); 
create index ase_page_date on  activitystream_events (ase_page, ase_date); 
create index xda_docid1 on xwikiattrecyclebin (xda_docid); create index 
ase_param1 on activitystream_events (ase_param1(200)); create index ase_param2 
on activitystream_events (ase_param2(200)); create index ase_param3 on 
activitystream_events (ase_param3(200)); create index ase_param4 on 
activitystream_events (ase_param4(200)); create index ase_param5 on 
activitystream_events (ase_param5(200));





Thanks & Regards,

Piyush



-Original Message-

From: users [mailto:users-boun...@xwiki.org] On Behalf Of Vincent Massol

Sent: Friday, September 23, 2016 6:33 PM

To: XWiki Users

Subject: Re: [xwiki-users] I would like to migrate my xwiki application from 
4.2 to 8.2.1





> On 23 Sep 2016, at 14:49, Kumar, Piyush 
> <piyush.ku...@atos.net<mailto:piyush.ku...@atos.net>> wrote:

>

> Hi All,

>

> I am currently using XWiki 4.2  war deployed on apache-tomcat and also using 
> MySQL DB.  I am using XWiki clustered 2 based on network events distribution. 
>  I am also using A multi-tenant setup ( "virtual mode", "multi-wiki" or "farm 
> mode") which allows us to have several wikis running on the same XWiki 
> instance (i.e. in the same JVM). I also configured Scheduled jobs to empty 
> trash and getting it triggered via cron expression.

>

> I am facing serious performance issue as Xwiki application has become very 
> slow and  frequently results in timeout.

>

> To resolve the performance issue I would like to migrate my XWiki application 
> from version 4.2 to 8.2.1.

>

> Is it a good decision?



Reply from Vincent :  It is. Actually what you’ve done (stay very long on a 
very old version is not such a good idea ;) (will make the upgrade a lot more 
complex).



Since you’re using a very old version you may want to export your data, install 
XWiki 8.2.1 and import your data. However see the limitations at 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup#HUsingtheXWikiExportfeature



> If now which version can be relatively cater more performance? Also if anyone 
> can share the high level steps which must be followed while migration, would 
> be great help.



Reply from Vincent :  Re performance you can get good perf in 4.2 too. If I had 
to guess I’d say you’re missing indexes in the DB, see 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances



Thanks

-Vincent



Reply from Vincent :  PS: Since this is a complex operation, I’d highly suggest 
that you hire some xwiki experts. There are companies offering such expertise 
and that are sponsor

Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1

[Kumar, Piyush]

Hi Vincent,

Regarding DB indexing I would like to tell you that I already created below 
indexes as per the page 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Database+Administration to 
deal with performance but could not get any benefit. Sice we are having 4.2 
version at production, we created below mentioned indexes in our MySQL DB.


Indexes for XWiki Enterprise versions after 3.2
create index xwl_value on xwikilargestrings (xwl_value(50));
create index xwd_parent on xwikidoc (xwd_parent(50));
create index xwd_class_xml on xwikidoc (xwd_class_xml(20));
create index xws_number on xwikistatsdoc (XWS_NUMBER);
create index xws_classname on xwikistatsdoc (XWS_CLASSNAME);
create index xwr_number on xwikistatsreferer (XWR_NUMBER);
create index xwr_classname on xwikistatsreferer (XWR_CLASSNAME);
create index xwr_referer on xwikistatsreferer (XWR_REFERER(50));
create index xwv_user_agent on xwikistatsvisit (XWV_USER_AGENT(255));
create index xwv_cookie on xwikistatsvisit (XWV_COOKIE(255));
create index xwv_classname on xwikistatsvisit (XWV_CLASSNAME);
create index xwv_number on xwikistatsvisit (XWV_NUMBER);
create index ase_requestid on  activitystream_events (ase_requestid(200));
create index ase_page_date on  activitystream_events (ase_page, ase_date);
create index xda_docid1 on xwikiattrecyclebin (xda_docid);
create index ase_param1 on activitystream_events (ase_param1(200));
create index ase_param2 on activitystream_events (ase_param2(200));
create index ase_param3 on activitystream_events (ase_param3(200));
create index ase_param4 on activitystream_events (ase_param4(200));
create index ase_param5 on activitystream_events (ase_param5(200));


Thanks & Regards,
Piyush

-Original Message-
From: users [mailto:users-boun...@xwiki.org] On Behalf Of Vincent Massol
Sent: Friday, September 23, 2016 6:33 PM
To: XWiki Users
Subject: Re: [xwiki-users] I would like to migrate my xwiki application from 
4.2 to 8.2.1


> On 23 Sep 2016, at 14:49, Kumar, Piyush <piyush.ku...@atos.net> wrote:
>
> Hi All,
>
> I am currently using XWiki 4.2  war deployed on apache-tomcat and also using 
> MySQL DB.  I am using XWiki clustered 2 based on network events distribution. 
>  I am also using A multi-tenant setup ( "virtual mode", "multi-wiki" or "farm 
> mode") which allows us to have several wikis running on the same XWiki 
> instance (i.e. in the same JVM). I also configured Scheduled jobs to empty 
> trash and getting it triggered via cron expression.
>
> I am facing serious performance issue as Xwiki application has become very 
> slow and  frequently results in timeout.
>
> To resolve the performance issue I would like to migrate my XWiki application 
> from version 4.2 to 8.2.1.
>
> Is it a good decision?

It is. Actually what you’ve done (stay very long on a very old version is not 
such a good idea ;) (will make the upgrade a lot more complex).

Since you’re using a very old version you may want to export your data, install 
XWiki 8.2.1 and import your data. However see the limitations at 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup#HUsingtheXWikiExportfeature

> If now which version can be relatively cater more performance? Also if anyone 
> can share the high level steps which must be followed while migration, would 
> be great help.

Re performance you can get good perf in 4.2 too. If I had to guess I’d say 
you’re missing indexes in the DB, see 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances

Thanks
-Vincent

PS: Since this is a complex operation, I’d highly suggest that you hire some 
xwiki experts. There are companies offering such expertise and that are 
sponsoring the development of the xwiki project. See 
http://www.xwiki.org/xwiki/bin/view/Main/Support#HProfessionalSupport

> Thanks & Regards,
> Piyush

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1

[Vincent Massol]

Hi,

> On 28 Sep 2016, at 15:31, Kumar, Piyush <piyush.ku...@atos.net> wrote:
> 
> 
> Hi Vincent,
> 
> I apologize for sending it three times. I thought this message has not 
> delivered as on delivery I was expecting that it will come in my inbox as 
> well.
> Will take care of this.:)

ok!

Have you seen the answer that I had sent back then:
http://markmail.org/message/wekcctzz2zdoffit

?

Thanks
-Vincent

> 
> Thanks & Regards,
> Piyush
> -Original Message-
> From: users [mailto:users-boun...@xwiki.org] On Behalf Of Vincent Massol
> Sent: Wednesday, September 28, 2016 7:00 PM
> To: XWiki Users
> Subject: Re: [xwiki-users] I would like to migrate my xwiki application from 
> 4.2 to 8.2.1
> 
> 
>> On 28 Sep 2016, at 15:29, Vincent Massol <vinc...@massol.net> wrote:
>> 
>> See http://markmail.org/message/wekcctzz2zdoffit
>> 
>> Please don’t send the same mail several times… :)
> 
> You already sent it 3 times…
> 
> -Vincent
> 
>> Thanks
>> -Vincent
>> 
>>> On 28 Sep 2016, at 15:26, Kumar, Piyush <piyush.ku...@atos.net> wrote:
>>> 
>>> Hi All,
>>> 
>>> I am currently using XWiki 4.2  war deployed on apache-tomcat and also 
>>> using MySQL DB.  I am using XWiki clustered 2 based on network events 
>>> distribution.  I am also using A multi-tenant setup ( "virtual mode", 
>>> "multi-wiki" or "farm mode") which allows us to have several wikis running 
>>> on the same XWiki instance (i.e. in the same JVM). I also configured 
>>> Scheduled jobs to empty trash and getting it triggered via cron expression.
>>> 
>>> I am facing serious performance issue as Xwiki application has become very 
>>> slow and  frequently results in timeout.
>>> 
>>> To resolve the performance issue I would like to migrate my XWiki 
>>> application from version 4.2 to 8.2.1.
>>> 
>>> Is it a good decision? If now which version can be relatively cater more 
>>> performance? Also if anyone can share the high level steps which must be 
>>> followed while migration, would be great help.
>>> 
>>> Thanks & Regards,
>>> Piyush
> 
> ___
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users
> 

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1

[Vincent Massol]

See http://markmail.org/message/wekcctzz2zdoffit

Please don’t send the same mail several times… :)

Thanks
-Vincent

> On 28 Sep 2016, at 15:26, Kumar, Piyush  wrote:
> 
> Hi All,
> 
> I am currently using XWiki 4.2  war deployed on apache-tomcat and also using 
> MySQL DB.  I am using XWiki clustered 2 based on network events distribution. 
>  I am also using A multi-tenant setup ( "virtual mode", "multi-wiki" or "farm 
> mode") which allows us to have several wikis running on the same XWiki 
> instance (i.e. in the same JVM). I also configured Scheduled jobs to empty 
> trash and getting it triggered via cron expression.
> 
> I am facing serious performance issue as Xwiki application has become very 
> slow and  frequently results in timeout.
> 
> To resolve the performance issue I would like to migrate my XWiki application 
> from version 4.2 to 8.2.1.
> 
> Is it a good decision? If now which version can be relatively cater more 
> performance? Also if anyone can share the high level steps which must be 
> followed while migration, would be great help.
> 
> Thanks & Regards,
> Piyush
___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1

[Vincent Massol]

> On 28 Sep 2016, at 15:29, Vincent Massol  wrote:
> 
> See http://markmail.org/message/wekcctzz2zdoffit
> 
> Please don’t send the same mail several times… :)

You already sent it 3 times…

-Vincent

> Thanks
> -Vincent
> 
>> On 28 Sep 2016, at 15:26, Kumar, Piyush  wrote:
>> 
>> Hi All,
>> 
>> I am currently using XWiki 4.2  war deployed on apache-tomcat and also using 
>> MySQL DB.  I am using XWiki clustered 2 based on network events 
>> distribution.  I am also using A multi-tenant setup ( "virtual mode", 
>> "multi-wiki" or "farm mode") which allows us to have several wikis running 
>> on the same XWiki instance (i.e. in the same JVM). I also configured 
>> Scheduled jobs to empty trash and getting it triggered via cron expression.
>> 
>> I am facing serious performance issue as Xwiki application has become very 
>> slow and  frequently results in timeout.
>> 
>> To resolve the performance issue I would like to migrate my XWiki 
>> application from version 4.2 to 8.2.1.
>> 
>> Is it a good decision? If now which version can be relatively cater more 
>> performance? Also if anyone can share the high level steps which must be 
>> followed while migration, would be great help.
>> 
>> Thanks & Regards,
>> Piyush

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users

Re: [xwiki-users] I would like to migrate my xwiki application from 4.2 to 8.2.1

[Vincent Massol]

> On 23 Sep 2016, at 14:49, Kumar, Piyush  wrote:
> 
> Hi All,
> 
> I am currently using XWiki 4.2  war deployed on apache-tomcat and also using 
> MySQL DB.  I am using XWiki clustered 2 based on network events distribution. 
>  I am also using A multi-tenant setup ( "virtual mode", "multi-wiki" or "farm 
> mode") which allows us to have several wikis running on the same XWiki 
> instance (i.e. in the same JVM). I also configured Scheduled jobs to empty 
> trash and getting it triggered via cron expression.
> 
> I am facing serious performance issue as Xwiki application has become very 
> slow and  frequently results in timeout.
> 
> To resolve the performance issue I would like to migrate my XWiki application 
> from version 4.2 to 8.2.1.
> 
> Is it a good decision?

It is. Actually what you’ve done (stay very long on a very old version is not 
such a good idea ;) (will make the upgrade a lot more complex).

Since you’re using a very old version you may want to export your data, install 
XWiki 8.2.1 and import your data. However see the limitations at 
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Backup#HUsingtheXWikiExportfeature

> If now which version can be relatively cater more performance? Also if anyone 
> can share the high level steps which must be followed while migration, would 
> be great help.

Re performance you can get good perf in 4.2 too. If I had to guess I’d say 
you’re missing indexes in the DB, see
http://platform.xwiki.org/xwiki/bin/view/AdminGuide/Performances

Thanks
-Vincent

PS: Since this is a complex operation, I’d highly suggest that you hire some 
xwiki experts. There are companies offering such expertise and that are 
sponsoring the development of the xwiki project. See 
http://www.xwiki.org/xwiki/bin/view/Main/Support#HProfessionalSupport

> Thanks & Regards,
> Piyush

___
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users