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
name of the collaboration associated with this request
name of database manager if different from collaboration contact
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
DBMS version, if required, 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)
High volume databases represent more than 10 GB of storage space. In your request, please specify the following information:
General information
name of the collaboration associated with this request
name of database manager if different from collaboration contact
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
is DBMS a mandatory pre-requisite?
DBMS version, if required, 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)
database volume evolution over 1 year, 3 years and 5 years
availability level
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
use of the computing platform, a website…
simultaneous connections maximum number estimate
maximum expected read and write speed
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.