Databases

CC-IN2P3 offers its users several database management systems (DBMS), namely:

  • MySQL
  • MariaDB / Galera
  • PostgreSQL
  • Oracle
  • MongoDB

Request for hosting

To host your database at CC-IN2P3, you will need to formulate a “database” resource request to the user suport. The access to this service is open to all CNRS agents and laboratories as well as the scientific communities in which CNRS participates.

To facilitate the processing of your request and the understanding of your needs, we recommend to send us a set of information that you will find in the following sections, depending on your desired database volumetry.

Depending on your needs, your database can be hosted on a dedicated instance or on a shared server. Once your request has been processed, you will receive by e-mail the your database connection credentials.

Note

Whatever the type of hosting (dedicated or shared), the administration of the instances remains the responsibility of CC-IN2P3 database service administrators (backups, user accounts, configuration instances etc.).

In order to take advantage of the benefits of a database accommodation at CC-IN2P3, we invite you to take a look at the benefits of the database service 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 database concerned
  • DBMS used
  • name(s) 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)

The benefits

Your database can be hosted on a dedicated or a shared instance. You will get all the features that you have requested for the operation of your database. The database service will take care of the DBMS version maintenance, backup and security management. We will help you get an optimal and suited use of your database.

Maintenance of DBMS

For security and reliability reasons, we strive to maintain an up-to-date version of the DBMS. This implies that maintenance can be scheduled to apply updates. These are usually planned during the CC-IN2P3 quarterly downtimes and are organized to minimize unavailability.

Backups

Full backups are performed once a day and kept for a period of 6 months. Their purpose is to protect your data from any hardware failure or human error. For any major changes you might apply to your data, such as updating your CMS, we strongly recommend soliciting 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 highest level of security. In addition, we restrict outside access to identified servers to reduce attacks.

Availability

Databases are often the heart of applications and we understand that their availability is critical. To meet the different needs, we propose different high-availability solutions based on Clustering systems such as Oracle Real Application Cluster, Dataguard Oracle, Mariadb Cluster or Pacemaker.

Expertise and training

CC-IN2P3 database service is here to advise you on the organization and operation of your data if you need. We can offer our expertise on relational schema design and optimization of your queries.

Beginner and advanced level courses are regularly organized at CC-IN2P3 as part of knowledge sharing. These are usually scheduled once a year. For more detail on training dates, please contact the user support.

Access to the service

The databases are reachable from outside as well as from CC-IN2P3 internal network. External access is limited to the list of IPs specified during your database hosting request.

To access the service, login credentials have been sent to you with a connection string that determines the location of the service. By default, CC-IN2P3 interactive machines (cca.in2p3.fr) provide a client for each DBMS.

The mysql client for MySQL or MariaDB:

# replace the fields ​​with those provided to you
% mysql -h <service_name.in2p3.fr> -U <login> -p

The psql client for PostgreSQL:

# replace the fields ​​with those provided to you
% psql -h <service_name.in2p3.fr> -U <login> -W

The sqlplus client for Oracle:

# replace the fields ​​with those provided to you
% sqlplus <login> @ <service_name.in2p3.fr>

If you requested to open your database outside, you can access it from your own client, provided that you properly install it on your machine.

For clients providing HMI, we recommend that you install DBeaver on your machine. For MySQL/MariaDB databases, a web client is available at this address.