[xwiki-users] GlassFish + MySQL + Xwiki
Hi, ** Not sure if i'm posting this in correct place, as this is my 1st post. ** I have installed GlassFish v 3.1.2.2 + MySQL 5.6 + Xwiki-enterprise-web-5.0.war Not sure if I’m using the correct Java container and DB... I will be using Xwiki with large DB. Have i choose the correct Container and DB? what do you recommend I should use. I don’t have any coding experience at all. Many Thanks, H -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] GlassFish + MySQL + Xwiki
Recommendations about DB Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to file-system attachments storage or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and lightness ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results more speed you can get with more simple hardware software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p7584388.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] GlassFish + MySQL + Xwiki
Hirji, Running MySQL is good enough I feel. Using Jetty makes it very easy to start just xwiki because of the packaging. Otherwise, using other servlet containers should work. Many have been using tomcat. We, at curriki, employ the Sun Java Application Server, which is a version earlier than Glassfish, and it is serving very well. My experience was however that exploding the war is necessary in almost all cases (and Glassfish supports this) so as to configure things. paul On 20 mars 2013, at 14:12, Hirji.patel wrote: Hi, ** Not sure if i'm posting this in correct place, as this is my 1st post. ** I have installed GlassFish v 3.1.2.2 + MySQL 5.6 + Xwiki-enterprise-web-5.0.war Not sure if I’m using the correct Java container and DB... I will be using Xwiki with large DB. Have i choose the correct Container and DB? what do you recommend I should use. I don’t have any coding experience at all. Many Thanks, H -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ 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] GlassFish + MySQL + Xwiki
Thanks, Which Servlet Container should I be using? My DB will have large attachments and images. Regards, H -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: users@xwiki.org Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Recommendations about DB Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to file-system attachments storage or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and lightness ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results more speed you can get with more simple hardware software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p758438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] GlassFish + MySQL + Xwiki
You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well. I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-) BR, Jeremie 2013/3/20 Hirji Patel hirji.pa...@akt-uk.com Thanks, Which Servlet Container should I be using? My DB will have large attachments and images. Regards, H -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: users@xwiki.org Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Recommendations about DB Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to file-system attachments storage or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and lightness ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results more speed you can get with more simple hardware software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p758438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___ 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] GlassFish + MySQL + Xwiki
Hi, At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory. Regards, Sorin B. On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET jeremie.bousq...@gmail.com wrote: You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well. I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-) BR, Jeremie 2013/3/20 Hirji Patel hirji.pa...@akt-uk.com Thanks, Which Servlet Container should I be using? My DB will have large attachments and images. Regards, H -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: users@xwiki.org Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Recommendations about DB Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to file-system attachments storage or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and lightness ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results more speed you can get with more simple hardware software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p758438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___ 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 ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
Re: [xwiki-users] GlassFish + MySQL + Xwiki
Thank you for helping me out here. Xwiki will be in production with large files. 15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL? Regards, Hirji -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Hi, At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory. Regards, Sorin B. On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET jeremie.bousq...@gmail.com wrote: You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well. I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-) BR, Jeremie 2013/3/20 Hirji Patel hirji.pa...@akt-uk.com Thanks, Which Servlet Container should I be using? My DB will have large attachments and images. Regards, H -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: users@xwiki.org Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Recommendations about DB Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to file-system attachments storage or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and lightness ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results more speed you can get with more simple hardware software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p75 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk ___ 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] GlassFish + MySQL + Xwiki
Hi, Just installed Tomcat + Xwiki using link below, but it does not tell me to install MySQL? Its telling me to install Nginx, should I be doing this? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat#H InstallationSteps This is what I have done so far... Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file) What's Next.. to get my xwiki going? Install Mysql? Regards, Hirji -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Thank you for helping me out here. Xwiki will be in production with large files. 15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL? Regards, Hirji -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Hi, At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory. Regards, Sorin B. On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET jeremie.bousq...@gmail.com wrote: You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well. I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-) BR, Jeremie 2013/3/20 Hirji Patel hirji.pa...@akt-uk.com Thanks, Which Servlet Container should I be using? My DB will have large attachments and images. Regards, H -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: users@xwiki.org Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Recommendations about DB Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to file-system attachments storage or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and lightness ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results more speed you can get with more simple hardware software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p75 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users This e-mail has been scanned for all viruses by Star. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk
Re: [xwiki-users] GlassFish + MySQL + Xwiki
You should follow http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationWAR http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat is just one step On Wed, Mar 20, 2013 at 6:16 PM, Hirji Patel hirji.pa...@akt-uk.com wrote: Hi, Just installed Tomcat + Xwiki using link below, but it does not tell me to install MySQL? Its telling me to install Nginx, should I be doing this? http://platform.xwiki.org/xwiki/bin/view/AdminGuide/InstallationTomcat#H InstallationSteps This is what I have done so far... Windows 2008 server. Created folder in c:\Tomcat_Home (copied files from Zip) Created folder Xwiki C:\Tomcat_Home\webapps\xwiki (copied files from War file) What's Next.. to get my xwiki going? Install Mysql? Regards, Hirji -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Hirji Patel Sent: 20 March 2013 16:39 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Thank you for helping me out here. Xwiki will be in production with large files. 15000 Pages... that's a lot of pages... ours will be much less then that. So Tomcat sounds good, but dot sure what you mean by filesystem attachments? How does that work or can that be done at later stage with Tomcat + MySQL? Regards, Hirji -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Sorin Burjan Sent: 20 March 2013 16:23 To: XWiki Users Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Hi, At the moment the safest way to go is Tomcat + MySQL. If you go with Tomcat, make sure you set it to use UTF8 encoding, since the default configuration of Tomcat is not UTF8. The standalone jetty+hsqldb is not good in production/large wikis because it uses an in memory hsqldb database, meaning that all your database is loaded at startup into your RAM memory. Regards, Sorin B. On Wed, Mar 20, 2013 at 6:17 PM, Jeremie BOUSQUET jeremie.bousq...@gmail.com wrote: You didn't tell us if this wiki will be in production (ie, available to many users, requiring to be up most of the time, with proper backup of data, etc...) or if it's only a test wiki for you, for example. If it's only for tests, the standalone wiki with jetty + hsqldb is good enough, for production jetty is not recommended by xwiki I believe. I can only give you a personal feedback : I have a wiki (in production) with Tomcat 6 + MySql 5.1, with db attachments. The wiki has around 15000 pages now, and 1,6Go of attachments content in db (including all versions of course). I plan to move to filesystem attachments, because during the course and upgrades (this wiki started several years ago with version 0.9), some attachments got corrupted for any reason, and it might be easier to avoid/detect/repair with filesystem based attachments than db. Apart from that, it works pretty well. I don't think servlet container will have a big impact on the way big attachments are managed, apart from possible limitations specific to each container if they exist. The link I provided gives you what is supported by xwiki, and with what it has been tested, but we can't decide for you what container or rdbms to choose in the end :-) BR, Jeremie 2013/3/20 Hirji Patel hirji.pa...@akt-uk.com Thanks, Which Servlet Container should I be using? My DB will have large attachments and images. Regards, H -Original Message- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Eugen Colesnicov Sent: 20 March 2013 13:46 To: users@xwiki.org Subject: Re: [xwiki-users] GlassFish + MySQL + Xwiki Recommendations about DB Container depend on Your scenario of XWiki using ... For example, if you will have many and large attachments - need to switch XWiki to file-system attachments storage or to use another database (not MySQL) - this is my opinion. My experience with big attachments - from the begging I have Windows + Glassfish + Oracle (attachments stored in DB), after I migrated for Linux + MySQL + Tomcat, but with file-system attachments storage - and right now I prefer this variant - more speed and lightness ... But, in any case, Your selection is not bad variant for production using (for example comparative to other java servlets). Also you should understand, that XWiki - it is not a BIG-BIG system, for example, likes MS SharePoint. Same results more speed you can get with more simple hardware software... -- Best regards Eugen Colesnicov -- View this message in context: http://xwiki.475771.n2.nabble.com/GlassFish-MySQL-Xwiki-tp7584387p75 8438 8.html Sent from the XWiki- Users mailing list archive at Nabble.com. ___ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users