Overview
The CC-IN2P3 offers several DataBase Management Systems (DBMS). The DBMS available are:
MySQL
MariaDB / Galera
PostgreSQL
Oracle
MongoDB
Elastisearch
Databases services
Hosting your database on a dedicated or shared instance will essentially depend on your context. We will provide application maintenance for DBMS versions, backup management and security.
Full backups are performed once a day and kept for 6 months. For any major changes that you may apply to your data, we strongly recommend to contact the user support so that a specific backup will be scheduled before your intervention.
DBMS and operating systems are updated regularly to ensure the best level of security. Maintenance operations are generally scheduled during CC-IN2P3 quarterly maintainance and are organized to minimize downtime. In addition, all access from oustide CC-IN2P3 are limited to identified servers in order to reduce external attacks.
To meet different needs, we offer different high availability solutions based on clustering systems such as Oracle Real Application Cluster, Oracle Dataguard, Mariadb cluster or Pacemaker.
Note
CC-IN2P3 database administrators are available to advise you on your data model and operational questions.
Beginner and advanced level training are organized at CC-IN2P3. You can view past trainings, as well as the provisional calendar of upcoming trainings in the paragraph Training at CC-IN2P3.
Hosting request
Access to this service is available to all collaboration supported by CC-IN2P3.
According to the context, your database can be hosted on a dedicated or a shared instance. In order to process your request quickly and to better define your needs, a set of information is necessary to provide you the best service.
Note
Whatever the type of hosting (dedicated or shared), the management of backups, accounts and instance configuration will be managed by CC-IN2P3 databases administrators.
To host your database at CC-IN2P3, your collaboration contact will need to submit a request to user support. Once the request is processed, they will receive the login credentials for your database by e-mail.
Low volume databases represent less than 10 GB of storage space. In your request, please specify the following information:
general information
the person(s) responsible for the database
a brief description of your use case
characteristics
database usage: test, development, production
desired name for your database
type of DBMS
MariaDB, MySQL, PostgreSQL, Oracle or MongoDB
if your application is agnostic to the version of the DBMS
name of the desired account(s), possibly specifying their particularity
read only or owner
IP of the machines that will be authorized to use this/these account(s)
High volume databases represent more than 10 GB of storage space. In your request, please specify the following information:
General information
The person(s) responsible for the database
If your database is part of a resource request associated to an experiment or laboratory and if so, which one
A brief description of your use case
Characteristics
Database usage: test, development, production
Desired name for your database
Type of DBMS
MariaDB, MySQL, PostgreSQL, Oracle or MongoDB
Indicate if the DBMS is a mandatory pre-requisite
If your application is agnostic to the version of the DBMS
The version of the DBMS desired and any necessary options or libraries
Name of the desired account(s), possibly specifying their particularity
Read only or owner
IP of the machines that will be authorized to use this/these account(s)
Evolution of the database volume over 1 year, 3 years and 5 years
Level of availability
LOW: the database can be unavailable for more than 24 hours without impacting your business
MEDIUM: the database can be unavailable for a maximum of 8 hours without impacting your business
HIGH: the database can be unavailable for a maximum of 1 hour without impacting your business (please describe the impact)
Type of load submitted on the database
Used by the computing platform, a website…
Estimation of the maximum number of simultaneous connections
Maximum expected bitrate in reading and writing
Account creation
If your collaboration has a database already hosted at CC-IN2P3, your collaboration contact can request the creation of additional accounts to user support. This request will have to contain the following information:
Name of the related service (“connection chain” or
<serveur.in2p3.fr:port-number>)Name of the database in question
DBMS used
Name(s) of the desired account(s), possibly specifying their particularity
Access type: read only or owner
IP of the machines that will be authorized to use this/these account(s)
Connect to a CC database
As a reminder, the databases are accessible both from outside and from the CC-IN2P3 internal network, but are limited to the list of IPs specified during your database hosting request.
The login credentials for your database will be provided by email after your request has been accepted.
Connection via graphical client
Even if the command line SQL clients installed on the interactive servers make it easy to access your database, readability is still limited. To facilitate your experience with databases, a web interface is available at the following url.
Attention
This tool is not yet stable for MongoDB and Elias (Elasticsearch), therefore its use is not recommend for these technologies.
If the proposed tool does not suit you, you have the option to directly install on your workstation graphical clients as:
Oracle, Postgres, Mysql APIs
All database management systems provide programming interfaces for most known languages: JAVA, Pyton, C , C++…
It is therefore possible to connect to your database with your favorite programming language in order to process your data as desired.