The EMBL-EBI is an international scientific organisation using open source and commercial technologies: in the database backend, open source SQL and NoSQL DBMSs such as PostgreSQL, MySQL and MongoDB are in use alongside the well consolidated Oracle RDBMS.
Throughout the years the overall number of instances has grown notwithstanding a background program of retirement of any instance reaching the end of its lifecycle: on this basis the investigation of the costs related to support, maintenance, operations across all database technologies is of strategic importance for the institute.
We will discuss the activity we conducted within the Oracle backend over the last 12 months and that lead to the migration of ca 30 Oracle instances to open source suitable alternative platforms. Some proof of concepts and side investigations have been dedicated to solve specific issues (access to oracle via Foreign Data Wrapper, Disaster Recovery, monitoring, data loading, dev/test cloning and data release deployment).
We will illustrate the overall approach, some interesting use cases, tools, technical challenges and adopted solutions and lesson learned, in the context of the evolving EMBL-EBI infrastructure.
The following slides have been made available for this session: