Database servers

We can help you install, configure, troubleshoot your database especially on MySQL and PostgreSQL.

MySQL and MariaDB

MySQL and MariaDB are a system for managing relational databases available both in Linux and Unix and on Windows.

Many systems use these databases as the so-called LAMP or WAMP systems and also many CMS (such as Magento, WordPress, Joomla! and Drupal) are born with the preferred support towards MySQL or MariaDB.

MariaDB is a fork of MySQL born in 2009 after it was acquired by Sun Microsystem.

  • MySQL or MariaDB installation;
  • phpMyAdmin installation for web management;
  • import and export of databases;
  • master and slave configuration;
  • restore the database from a specific point in time after a crash or disaster;
  • development of automatisms to check the operating status and to anticipate possible problems.

PostgreSQL

PostgreSQL also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. It was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.

  • PostgreSQL installation;
  • pgAdmin or phpPgAdmin installation for web management;
  • import and export of databases;
  • master and slave configuration;
  • restore the database from a specific point in time after a crash or disaster;
  • development of automatisms to check the operating status and to anticipate possible problems.

BaseX database

We have also worked on databases for managing XML files or documents such as BaseX, creating the IGCyr and GVCyr website.

Service and data Backup

For security reasons and to ensure the continuity of your services, it is necessary to have a backup system that allows you to restore the service to a given moment of time identified as stable and not corrupted.

The backup can be implemented in different ways based on the customer’s choice such as:

  • backup to local disk (but in this way we will be at operator risk and viruses or hardware problems);
  • backup to corporate or remote NAS;
  • remote backup via software such as NetBackup or similar;
  • on a cloud space such as Amazon S3 or Glacier or others.

System monitoring

To understand in advance a problem that could occur or in any case to be able to quickly intervene on a malfunction it is necessary to have a monitoring system.

In the simplest cases, monitoring could only be internal to the server while in all other cases it would be useful to provide for both internal and external monitoring that includes notifications to the manager.

  • monitoring via cron of the operating system;
  • preparation of internal monitoring scripts;
  • monitoring by external service such as Icinga;
  • timely intervention to restore the problem detected.

IT consulting as System Administrator

For any need relating to your server we are at your complete disposal with immediate IT assistance for:

  • new installation;
  • update;
  • internal and external monitoring;
  • system backup;
  • remote scheduled backup;
  • any other need.