Upgrade alfresco 5.0 to 6.0

[sanjaybandhaniya]

Hi,

I want to upgrade alfresco 5.0 to 6. 0, What Step I have to follow?

Steps given in https://docs.alfresco.com/6.0/tasks/upgrade-process.html is enough to proceed?

The code customization is in sdk2(5.0) so for that what steps I have to follow?

[kintu_barot · Accepted solution]

Hi Sanjay,

- Install the Alfresco 6.0 first and do not start it.

- Take a dump of database of 5.0

- Point to the alf_data folder of 5.0 by making changes in the alfresco-global.properties file in 6.0

- Restore the dump to 6.0

- start the 6.0 server check whether the contents and other properties are properly working or not.

- Try to apply the customizations - (This may require little changes in your custom code)

- If they are working well then you're lucky else you might need to prepare your package using compatible sdk.

[dba100]

hi,

it seems this platform can be run on MySQL 8 too ? no tools from Alfresco to migrate data from PostgreSQL to MySQL and make sure once data and table migrated, alfresco will work immediately ?

[dba100]

"Take a look at the supported platforms."

how about percona pxc  ? percona pxc actually MariaDB with percona tools!

How about we use MariaDB galeria cluster? so we aan scale out the DB tier ? 

by this sense we dont' have to pay for the additional DB tier too ?

[EddieMay]

Hi @dba100 

I suppose some of these might be possible but are not supported OOTB. There are obviously limits to the number and type of DB options any software project is able to support. That said, I'm sure you could find others to help support your efforts if you started a project to enable percona pxc support for Alfresco Community Edition.

[dba100]

"I suppose some of these might be possible but are not supported OOTB."

sorry, what is OOTB? 

"There are obviously limits to the number and type of DB options any software project is able to support."

I am very ok on this.

"I'm sure you could find others to help support your efforts if you started a project to enable percona pxc support for Alfresco Community Edition."

you mean a SI vendor? any procedure or instruction on how to set it up in MySQL / MariaDB?

[EddieMay]

Hi @dba100 

Sorry - OOTB = "out of the box" = does not come with the software.

No, not an SI vendor - I meant that if you required a specific setup - such as "MariaDB galeria cluster" - that if you started an open source project to add that capability to Alfresco, then perhaps others would be able to help you.

[dba100]

hi,

tks.

but we will setup mariaDB ourselves if it is possible! any doc to show us how to setup Alfresco on mariaDB ?

a guide to:

1) how to allow all new content to mariaDB in another box.

2) migrate existing postgreSQL to the new mariaDB

3) any Alfresco backup and restore after all new content goes to mariaDB DB?

[dba100]

Can Alfresco community 6.0/6.2 run on top of MariaDB community edition ?

 I am not sure if the Software has to run on top of MariaDB enterprise edition ?

can Alfresco community 5.2/6.2 run on top of SQL server 2016-2019 standard or enterprise edition ?

[EddieMay]

Hi @dba100 

Alfresco Community Edition can be configured to use Maria DB.

No, Community Edition can not run against SQL Server. The Enterprise ACS can use SQL Server.

Regards,

[dba100]

hi,.

tks

so it doesn't matter it is a MySQL innodB cluster or Maria Galeria cluster?

can both platform runs on Windows server 2019 and still stable ?

[EddieMay]

Hi @dba100 

Community Edition doesn't support clustering OOTB.

Enterprise supported platforms information is here. ACS 7 supports Window server 2019.