Jasper Ideas

Hi there,

Current Scenario: we have the reports being shared by multiple channels.

1. storing content files in jasper UI and sending email links to users to download the file.

2. generating the content file in host file system and sending to shared Drive.

Problem Statement:

1. Mysql db size - due to the large number of reports being stored over the years in jasper - the mysql database size is grown beyond 600 GB + .

2. during upgrade we are not able to export due to the huge volume even for a single folder as well. we had to manually extract selected files and export from Jasper UI which is taking 2 to 3 months only for exports.

Solution we are looking at: we are looking at archival options as below.

1. how can we archive the files stored in UI and eventually in mysql database to a NFS - network file system and reduce db size.

2. unarchive when the users wanted . we can see that some applications provide options in UI itself to archive and placing the archive files on a NFS mount point and unarchive when needed.

if not above options: how can we archive the mysql database .