Overview
The CC-IN2P3 offers several DataBase Management Systems (DBMS) and for each of them, experts provide backup management, platform security and training. The main DBMS available are:
Relational Database Management System:
MySQL
MariaDB / Galera
PostgreSQL
Oracle
NoSQL (“Not only SQL”) Database Management System:
MongoDB
Elastisearch
These services are managed by experts who can assist you in modeling and operating your databases.
Databases services
Hosting your database can be on a dedicated or shared instance and will essentially depend on your context. You will have all features and privileges you need to operate your database. The database service will provide the application maintenance of DBMS versions, backup and security management. We can also help you for an optimal and adapted use of your database.
Backups
By default, full backups are performed once a day and kept for 6 months. Their purpose is to protect your data from any hardware failures or human errors. For any major changes that you may apply to your data, such as updating your application, we strongly recommend to contact us via the user support so that a specific backup is scheduled before your intervention.
Security
CC-IN2P3 implements various measures to protect your data. DBMS and operating systems are updated regularly to ensure the best level of security. This implies that interventions may be programmed to apply these updates. These are usually 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.
Availability
Databases are often the heart of your applications and we are aware that their availability is critical. To answer to your needs, we offer different high availability solutions based on clustering systems such as Oracle Real Application Cluster, Oracle Dataguard, Mariadb cluster or Pacemaker.
Advice and Training
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
To host your database at CC-IN2P3, you will need to submit a request to user support. Access to this service is open to all CNRS agents and laboratories as well as to the scientific communities attached to or partners of the CNRS.
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.
According to the context, your database can be hosted on a dedicated or a shared instance. Once your request is processed, you will receive the login credentials for your database by e-mail.
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.
All advantages of hosting at CC-IN2P3 are described in the Databases services section.
Low volume databases
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)
Large volume databases
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 you have a database already hosted at CC-IN2P3, you can request the creation of additional accounts by contacting the 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
This section describes how to connect to your database either from tools provided by the CC or from your favorite software.
As a reminder, the databases are accessible both from outside and from the CC-IN2P3 internal network. However, access, both internal and external, is limited to the list of IPs specified during your database hosting request.
The login credentials for your database will be provided to you by email after your request has been accepted. Depending on the database management system used, some database clients are available.
Connection via a 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.
Simply complete the login credentials provided by email to take advantage of it.
Attention
This tool is not yet stable for MongoDB and Elasticsearch (Elias), 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. You will find many forums and tutorials on the internet for the different programming languages that will allow you to connect to your database.