Andreas Magnusson 5 Years Ago Hello Alberto, I tested out your step-by-step-guide for merging the sharded databases and almost got to the finish line. I did hit a speed bump at the ResourcePermisson-table though... When comparing the tables from my two shards I see that roughly the first 200 entries have the same resourcePermissonId, but different data in all the other columns. So it isn't that clear which ones I can delete without removing important data. Do you have any clue to how to think when deciding which ones that needs to go? How important are these entries to the Liferay portal? Thank you for any input in this matter! Regards, Andreas Please sign in to reply. Reply as... Cancel Alberto Chaparro Andreas Magnusson 5 Years Ago Hi Andreas, Apologize about the delay, I didn't subscribe myself to the comments and i've just realized about this message. In the case you have mentioned I would insert those 200 entries in the resourcePermission table with a different resourcePermissonId. For that you can create an script which reads thos records and generate the new records so that you use the Counter table to get the new ids. I hope it helps, maybe is late for you :-( but at least for others. Best regards. Please sign in to reply. Reply as... Cancel
Alberto Chaparro Andreas Magnusson 5 Years Ago Hi Andreas, Apologize about the delay, I didn't subscribe myself to the comments and i've just realized about this message. In the case you have mentioned I would insert those 200 entries in the resourcePermission table with a different resourcePermissonId. For that you can create an script which reads thos records and generate the new records so that you use the Counter table to get the new ids. I hope it helps, maybe is late for you :-( but at least for others. Best regards. Please sign in to reply. Reply as... Cancel