NXTEO
MySQL / Mariadb SERVICES
SERENITY Pack or ASSURITY Pack
Our basic offer for all packs
Managing physical spaces
Management of different storage engines (MyISAM, InnoDB, etc.)
Managing the volume of data files
Managing the distribution of data files
Management of specific base settings
Object management
Reconstruction / reorganisation of tables and indexes
Checking object status*
Creating, modifying and deleting objects in a database
Partition management
Availability management
Check the perimeter to ensure that all bases are UP*
Check that the mysqld daemon is UP*.
Corruption management*
Lock management*
Error management
Temporal trigger management*
Error management - general, error log, slow queries*
Modification of a database parameter when an alert threshold is reached
Safety management
User and password management
Checking the backup*
Backup / restore of a basic backup of less than 200GB
Feeding an application schema (from files generated by mysqldump)
Application of MySQL security patches in accordance with the Oracle schedule
Performance management
Relaunch of statistical processing of a database
Analysis of sessions and consumer requests
Identification of CPU, memory, network and disk I/O restrictions
Additional operations
Distribution and reorganisation of databases (schemas) between different servers
Our additional options
SERENITY packs only
UNLIMITED option
Safety management
Management and implementation of backup strategy + binlog
Backup / restore of a backup greater than 200GB
Performance management
Detailed analysis of CPU, memory, network and disk I/O constraints
New monitoring tool under study and development
Replication management*
* master / master or master / slave
Checking the transfer and application of binlogs to slaves*
Switchover of a master on scheduled technical maintenance
Master failover in the event of a major incident
GG operations management*
* GG : Golden Gate (or equivalent)
Verification of lag to target base(s)*
Checking the configuration of the EXTRACT and/or REPLICAT processes on a change of structure from source to target - mapping schema, tables*
Additional operations
Migration of a database on the same server
Duplicating/moving a database to another server
ON-CALL DUTY option
ON-CALL DUTY management
Full scope of NWH incidents taken into account
NWH : Non Working Hours, 24/7/365, including public holidays
SUPERVISION option
Supervision management
Remote supervision of the perimeter, reduced GRT*
*GRT: Guaranteed Response Time
LINUX / REDHAT option
OS* operations management
* Linux or RedHat OS only
File System check*
Checking system error messages*
Preparing devices for LVM enlargement / reduction
Managing local server accounts
Check server memory usage*
* : Possible corrective action
