[dspace-tech] Migrate DSpace in an hosting service provider

2020-03-23 Thread Paolo
Hello everyone,
We'd like to migrate our DSpace infrastructure into the cloud using, due to 
GDRP compliance, an European hosting provider with services such as server 
and performance optimization administration, DNS, load balancing, etc. Our 
infrastructure is composed by two separate servers: the front-end running 
DSpace 5.2 and the back-end with Oracle DB version 12.

Do you have any suggestions or experiences on this matter?
Thank you for the valuable collaboration

Keep safe!


Paolo Baglioni

Library Systems Analyst

European University Institute

50014 Firenze ITALY



-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/0b6dca64-eef9-4e61-8fe3-7e04675a072d%40googlegroups.com.


[dspace-tech] Maximum number of DB connections in pool

2020-02-17 Thread Paolo


Dear All,

I would like to submit you a fairly frequent problem in our cadmus.eui.eu 
repository.

Our DSpace 5.2 installation works as a front-end on a virtual machine with 
4 CPU and 8 GB RAM and the back-end with Oracle db on the Oracle enterprise 
installation in our University ICT environment. The access to the DMZ, 
where the front-end is located, is managed by linux server with an 
Apache httpd.conf configuration apparently not limited by the number of 
simultaneous connections. Our problem is the number of connections to the 
db that quite frequently reach 200 as configured in dspace.cfg.


#Maximum number of DB connections in pool 

db.maxconnections = 200


Unfortunately, despite the fact that the 200 connections are inactive, they 
blocked access to the server forcing tomcat to restart.

Please find attached the result of an SQL query for inactive connections


Any suggestions or previous experience in this regard are extremely welcome.

Best Regards


Paolo Baglioni

Library Systems Analyst

European University Institute

50014 Firenze ITALY

-- 
All messages to this mailing list should adhere to the DuraSpace Code of 
Conduct: https://duraspace.org/about/policies/code-of-conduct/
--- 
You received this message because you are subscribed to the Google Groups 
"DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/dspace-tech/79f1fd7c-b1e2-4279-9b83-a1de82e74f5f%40googlegroups.com.


inactive db connections.ods
Description: application/vnd.oasis.opendocument.spreadsheet