Yoann BAUMERT - Portfolio

Script de rafraichissement de la base

"Reload" des données de la base

echo "SET FOREIGN_KEY_CHECKS=0;
TRUNCATE MDB_DATABASE;
TRUNCATE MDB_USERS;
TRUNCATE MDB_LABO;
SET FOREIGN_KEY_CHECKS=1;" |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

Chargement de la table "MDB_LABO"

echo "SET NOCOUNT ON
GO
SELECT 'insert into MDB_LABO (
lab_id,
lab_nom,
lab_tag,
lab_service_tag,
lab_activite,
lab_serlabgmidlet)
values (\"'||convert(varchar, serlabco)||'\",
\"'||serlabnom||'\",
\"'||sertag||'\",
\"'||serlabtag||'\",
\"'||convert(varchar, serlabuse)||'\",
\"'||serlabgmidlet||'\");' from Servicelabo
go " |/env/test/osef/sybase/sql -uutilisateur -SSYBASE_SERVEUR -b -Dbasedulims > ~baumert/SAUVEGARDE/MDB/MDB_LABO.txt

echo "source ~baumert/SAUVEGARDE/MDB/MDB_LABO.txt; " | /env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Chargement de la table "MDB_USERS"

echo "SET NOCOUNT ON
GO
SELECT \"insert into MDB_USERS (
u_id,
u_labo,
u_log,
u_nom,
u_prenom,
u_presence,
u_serco,
u_tel,
u_matricule)
values (\"||convert(varchar, perco)||\",
\"||isnull(convert(varchar, serlabco), 'NULL')||\",
'\"||perlog||\"',
'\"||pernom||\"',
'\"||perpren||\"',
\"||convert(varchar, perpre)||\",
\"||isnull(convert(varchar, serco), 'NULL')||\",
'\"||isnull(pertel, 'NULL')||\"',
\"||isnull(convert(varchar, perldapuid), 'NULL')||\");\" from Perint
go " |/env/test/osef/sybase/sql -uutilisateur -SSYBASE_SERVEUR -b -Dbasedulims > ~baumert/SAUVEGARDE/MDB/MDB_USERS.txt

echo "source ~baumert/SAUVEGARDE/MDB/MDB_USERS.txt; " | /env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Chargement de la table "MDB_DATABASE"

echo "show dbs;" |/env/test/osef/mongodb/bin/mongo serveur_mongodb1:20048/admin -uadmin -pPassword | sed 's/GB//g' > ~baumert/SQL/ETNA2/serveur_mongodb1.txt

echo "show dbs;" |/env/test/osef/mongodb/bin/mongo serveur_mongodb2:20047/admin -uadmin -pPassword | sed 's/GB//g' > ~baumert/SQL/ETNA2/serveur_mongodb2.txt

echo "show dbs;" |/env/test/osef/mongodb/bin/mongo serveur_mongodb3:20047/admin -uadmin -pPassword | sed 's/GB//g' > ~baumert/SQL/ETNA2/serveur_mongodb3.txt

echo "show dbs;" |/env/test/osef/mongodb/bin/mongo serveur_mongodb4:20047/admin -uadmin -pPassword | sed 's/GB//g' > ~baumert/SQL/ETNA2/mongocng.txt

echo "select
srv_nom,
srv_id
from
MDB_SERVEUR_DB
where srv_sgbd_id=1;
" | /env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain | while read srvname srvid; do echo "
select concat('
insert into
MDB_DATABASE (
dat_nom,
dat_serveur_db_id)
VALUES (',
'\"',
SCHEMA_NAME,
'\"',
', \"',
$srvid,
'\");')
from SCHEMATA
WHERE SCHEMA_NAME != 'information_schema';
" | /env/test/osef/mysql/msql -N -uutilisateur -s$srvname information_schema; done > ~baumert/SAUVEGARDE/MDB/MDB.txt

echo "select
srv_nom,
srv_id
from
MDB_SERVEUR_DB
where srv_sgbd_id=2;
" | /env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain | while read srvname srvid; do echo "SET NOCOUNT ON

GO
select \"
insert into MDB_DATABASE (
dat_nom,
dat_serveur_db_id)
VALUES (
'\"||name||\"',
\"||\"$srvid);\"
from sysdatabases
WHERE name NOT IN (
'master',
'model',
'sybsecurity',
'sybsystemdb',
'sybsystemprocs',
'tempdb')
go" |/env/test/osef/sybase/sql -uutilisateur -b -n -S$srvname ; done >> ~baumert/SAUVEGARDE/MDB/MDB.txt

export PGPASSWORD=Password ; echo "
select
srv_nom,
srv_id,
srv_port,
local_serveur,
local_domaine
from MDB_SERVEUR_DB,MDB_LOCALISATION
where local_id=srv_localisation_id AND srv_sgbd_id=3;
" | /env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain | while read srvname srvid port loserv lodom; do echo "
select 'insert into MDB_DATABASE (
dat_nom,
dat_serveur_db_id)
VALUES (
\"' || datname || '\",
' || $srvid || ');'
from pg_database;" |psql -t -uutilisateur -h$loserv.$lodom postgres -p$port ; done >> ~baumert/SAUVEGARDE/MDB/MDB.txt

echo "select
srv_nom,
srv_id
from MDB_SERVEUR_DB
where srv_sgbd_id=4;
" |/env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain |while read nom id ;
do
grep -E -v '^(bye|connecting|MongoDB)' ~baumert/SQL/ETNA2/$nom.txt
|awk -v Quote="'" '{print "insert into MDB_DATABASE (dat_nom, dat_serveur_db_id) values ("Quote $1 Quote", '$id');"}' ;
done >> ~baumert/SAUVEGARDE/MDB/MDB.txt

echo "source ~baumert/SAUVEGARDE/MDB/MDB.txt;"| /env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain 2>> ~baumert/LOG/importations.log

Date de mise à jour des bases

echo "select
srv_nom,
srv_id
from MDB_SERVEUR_DB
where srv_sgbd_id=1;
" | /env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain | while read srvname srvid;
do
echo "select concat('update MDB_DATABASE set dat_date_maj=',
'\"',
max(update_time),
'\"',
' where dat_nom=',
'\"',
table_schema,
'\"',
' AND dat_serveur_db_id=',
'\"$srvid\";')
from tables
where update_time is not null group by table_schema;
" | /env/test/osef/mysql/msql -N -uutilisateur -s$srvname information_schema ;
done > ~baumert/SQL/update.sql
echo "source ~baumert/SQL/update.sql
" | /env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain 2>> ~baumert/LOG/importations.log ;

echo "select
dat_nom,
srv_nom,srv_id
from
MDB_DATABASE,
MDB_SERVEUR_DB
WHERE
dat_serveur_db_id = srv_id
AND srv_sgbd_id=2;"|/env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain |while read datnom srvnom srvid ; do echo "use $datnom
go
select

\"UPDATE MDB_DATABASE SET dat_date_maj='\"||convert(varchar,max(moddate), 23)||\"' WHERE dat_nom='$datnom' AND dat_serveur_db_id='$srvid';\" from sysstatistics
go" |/env/test/osef/sybase/sql -uutilisateur -S$srvnom |grep 2 |sed -e 's/T/ /4'; done |/env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain

Récupération des données REL_USERS_DATABASE

echo "select srv_nom from MDB_SERVEUR_DB where srv_sgbd_id=1;" | /env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain | while read srvname;
do
echo "select distinct concat('insert into REL_USERS_DATABASE (rel_u_users_id, rel_u_dat_id) select u_id, dat_id
from MDB_DATABASE, MDB_USERS
where dat_nom=', '\"', db.Db, '\"', ' and u_log=', '\"',db.user, '\";') from db group by Db, user;
" | /env/test/osef/mysql/msql -f -N -uutilisateur -s$srvname mysql ;
done > ~baumert/SQL/relation.sql

Chargement de la table "REL_USERS_DATABASE"

ssh root@SERVEUR_PHYSIQUE1 ps -efd | grep 5432 |awk '{print $12}'|while read fichier ; do ssh root@SERVEUR_PHYSIQUE1 grep '^host' $fichier/pg_hba.conf | awk -v Quote="'" ' { print "insert into REL_USERS_DATABASE (rel_u_users_id, rel_u_dat_id) select u_id, dat_id from MDB_USERS, MDB_DATABASE where dat_nom=" Quote $2 Quote " AND u_log=" Quote $3 Quote ";" } '; done > ~baumert/SQL/awk.sql

ssh root@SERVEUR_PHYSIQUE2 ps -efd | grep 5432 |awk '{print $12}'|while read fichier ; do ssh root@SERVEUR_PHYSIQUE2 grep '^host' $fichier/pg_hba.conf | awk -v Quote="'" ' { print "insert into REL_USERS_DATABASE (rel_u_users_id, rel_u_dat_id) select u_id, dat_id from MDB_USERS, MDB_DATABASE where dat_nom=" Quote $2 Quote " AND u_log=" Quote $3 Quote ";" } '; done >> ~baumert/SQL/awk.sql

ssh root@SERVEUR_PHYSIQUE2 ps -efd | grep 5433 |awk '{print $12}'|while read fichier ; do ssh root@SERVEUR_PHYSIQUE2 grep '^host' $fichier/pg_hba.conf | awk -v Quote="'" ' { print "insert into REL_USERS_DATABASE (rel_u_users_id, rel_u_dat_id) select u_id, dat_id from MDB_USERS, MDB_DATABASE where dat_nom=" Quote $2 Quote " AND u_log=" Quote $3 Quote ";" } '; done >> ~baumert/SQL/awk.sql

echo "source ~baumert/SQL/relation.sql" | /env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain 2>> ~baumert/LOG/importations.log

echo "source ~baumert/SQL/awk.sql" | /env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain 2>> ~baumert/LOG/importations.log

Espace Libre File System

echo "select distinct
file_nom,
concat(local_serveur,
'.',
local_domaine)
from
MDB_LOCALISATION,
MDB_FILE_SYSTEM,
MDB_SERVEUR_DB,
REL_DATABASE_FILE_SYSTEM
where
srv_localisation_id=local_id
and srv_id=rel_file_database_serveur_db_id
and rel_file_system_id=file_id
group by file_nom;
" | /env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain | while read file local ; do echo "ssh -f root@$local df -Pm $file";
done > ~baumert/SQL/file_espace_occupe.sql

source ~baumert/SQL/file_espace_occupe.sql | grep -v bloc | awk -v Quote="'" ' { print "UPDATE MDB_FILE_SYSTEM SET file_espace_occupe="$3"/1024 where file_nom="Quote $6 Quote";" } ' > ~baumert/SQL/file_espace_libre_exec.sql

source ~baumert/SQL/file_espace_occupe.sql | grep -v bloc | awk -v Quote="'" ' { print "UPDATE MDB_FILE_SYSTEM SET file_taille_giga="$2"/1024 where file_nom="Quote $6 Quote";" } ' >> ~baumert/SQL/file_espace_libre_exec.sql

echo "source ~baumert/SQL/file_espace_libre_exec.sql;" |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Espace des Bases

Espace des Bases MySQL

ssh -f root@SERVEUR_PHYSIQUE2 'cd /env/database/mysql/SERVEUR_DEVELOPPEMENT/data/MONSERVEUR/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=11;"}' > ~baumert/SQL/taille_base.sql

ssh -f root@SERVEUR_PHYSIQUE2 'cd /env/database/mysql/SERVEUR_DEVELOPPEMENT/data/MYSERVEUR_AUTRE/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=12;"}' >> ~baumert/SQL/taille_base.sql

ssh -f root@SERVEUR_PHYSIQUE3 'cd /env/database/mysql/vol2/data/MYCNS/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=7;"}' >> ~baumert/SQL/taille_base.sql

ssh -f root@SERVEUR_PHYSIQUE3 'cd /env/database/mysql/vol1/data/MYSERVEUR_EXTERIEUR/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=9;"}' >> ~baumert/SQL/taille_base.sql

ssh -f root@SERVEUR_PHYSIQUE3 'cd /env/database/mysql/vol3/data/MYGGB/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=10;"}' >> ~baumert/SQL/taille_base.sql

ssh -f root@serveur_mongodb4 'cd /env/database/mysql/data_gaia/MYCNG/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=8;"}' >> ~baumert/SQL/taille_base.sql

ssh -f root@SERVEUR_PHYSIQUE4 'cd /env/database/mysql/data/MYAGC/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=13;"}' >> ~baumert/SQL/taille_base.sql

ssh -f root@SERVEUR_PHYSIQUE5 'cd /env/database/mysql/data/MYAGC2/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=14;"}' >> ~baumert/SQL/taille_base.sql

ssh -f root@SERVEUR_PHYSIQUE3 'cd /env/database/mysql/vol5/data/MYTARA/ ; du -kL --max-depth=1 *' |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $1 Quote" WHERE dat_nom="Quote $2 Quote" and dat_serveur_db_id=15;"}' >> ~baumert/SQL/taille_base.sql

Espace des Bases Sybase

echo "sp_helpdb
go"|/env/test/osef/sybase/sql -uutilisateur -b -SSYBASE_SERVEUR |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $2*1024 Quote" WHERE dat_nom="Quote $1 Quote" and dat_serveur_db_id=1;"}' >> ~baumert/SQL/taille_base.sql

echo "sp_helpdb
go"|/env/test/osef/sybase/sql -uutilisateur -b -SSERVEUR_EXTERIEUR |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $2*1024 Quote" WHERE dat_nom="Quote $1 Quote" and dat_serveur_db_id=2;"}' >> ~baumert/SQL/taille_base.sql

echo "sp_helpdb
go"|/env/test/osef/sybase/sql -uutilisateur -b -SSERVEUR_DEVELOPPEMENT |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $2*1024 Quote" WHERE dat_nom="Quote $1 Quote" and dat_serveur_db_id=3;"}' >> ~baumert/SQL/taille_base.sql

echo "sp_helpdb
go"|/env/test/osef/sybase/sql -uutilisateur -b -SSERVEUR_AUTRE |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $2*1024 Quote" WHERE dat_nom="Quote $1 Quote" and dat_serveur_db_id=4;"}' >> ~baumert/SQL/taille_base.sql

echo "sp_helpdb
go"|/env/test/osef/sybase/sql -uutilisateur -b -SSERVEUR_DU_CNG1 |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $2*1024 Quote" WHERE dat_nom="Quote $1 Quote" and dat_serveur_db_id=5;"}' >> ~baumert/SQL/taille_base.sql

echo "sp_helpdb
go"|/env/test/osef/sybase/sql -uutilisateur -b -SSERVEUR_DU_CNG2 |awk -v Quote='"' '{print "update MDB_DATABASE SET dat_taille="Quote $2*1024 Quote" WHERE dat_nom="Quote $1 Quote" and dat_serveur_db_id=6;"}' >> ~baumert/SQL/taille_base.sql

echo "source ~baumert/SQL/taille_base.sql" |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Espace des Bases MongoDB

echo 'show dbs;'|/env/test/osef/mongodb/bin/mongo SERVEUR_PHYSIQUE1.genoscope.domaine.fr:20047/admin --quiet -uadmin -pPassword |sed s/GB//g |awk '{ print $1 " " $2 " 18"}' > ~baumert/SQL/Mongo__taille.sql

echo 'show dbs;'|/env/test/osef/mongodb/bin/mongo SERVEUR_PHYSIQUE2.genoscope.domaine.fr:20047/admin --quiet -uadmin -pPassword |sed s/GB//g |awk '{ print $1 " " $2 " 20"}' >> ~baumert/SQL/Mongo__taille.sql

echo 'show dbs;'|/env/test/osef/mongodb/bin/mongo SERVEUR_PHYSIQUE2.genoscope.domaine.fr:20048/admin --quiet -uadmin -pPassword |sed s/GB//g |awk '{ print $1 " " $2 " 21"}' >> ~baumert/SQL/Mongo__taille.sql

echo 'show dbs;'|/env/test/osef/mongodb/bin/mongo serveur_mongodb4:20047/admin --quiet -uadmin -pPassword |sed s/GB//g |awk '{ print $1 " " $2 " 21"}' >> ~baumert/SQL/Mongo__taille.sql

awk -v Quote="'" '{ print "UPDATE MDB_DATABASE SET dat_taille="Quote $2 Quote"*1024*1024 WHERE dat_nom="Quote $1 Quote" AND dat_serveur_db_id="$3";"}' ~baumert/SQL/Mongo__taille.sql > ~baumert/SQL/MongoDB_taille.sql

echo "source ~baumert/SQL/MongoDB_taille.sql;" |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Espace des Bases PostgreSQL

export PGPASSWORD=Password ;
echo "select
dat_nom,
concat(local_serveur,'.',local_domaine),
srv_id,
srv_port
from
MDB_DATABASE,
MDB_SERVEUR_DB,
MDB_LOCALISATION
where srv_sgbd_id=3
and srv_id=dat_serveur_db_id
and srv_localisation_id=local_id;" |/env/test/osef/mysql/msql -N -uutilisateur -sMONSERVEUR Vulcain |while read datname srvname srvid srvport ;
do
echo "select
'UPDATE MDB_DATABASE SET dat_taille='||pg_database_size('$datname')||'/1024
where dat_nom=\"$datname\"
and dat_serveur_db_id=$srvid;';"|psql -t -uutilisateur -h$srvname postgres -p$srvport ; done > ~baumert/SQL/postgres_taille.sql

echo "source ~baumert/SQL/postgres_taille.sql;" |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Espace Libre des Bases

Espace des Bases MySQL PostrgreSQL et MongoDB

echo "select
file_taille_giga*1024*1024-sum(dat_taille),
rel_file_system_id
from
MDB_DATABASE,
MDB_FILE_SYSTEM,
REL_DATABASE_FILE_SYSTEM,
MDB_SERVEUR_DB
where
rel_file_database_id=dat_id
and file_id=rel_file_system_id
and dat_serveur_db_id=srv_id
and srv_sgbd_id!=2
and rel_type=\"DATA\"
group by rel_file_system_id;"|/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR -N Vulcain |while read taille id ;
do
echo "update MDB_DATABASE join REL_DATABASE_FILE_SYSTEM on dat_id=rel_file_database_id set dat_espace_libre = $taille
where rel_file_system_id = $id;"; done |/env/test/osef/mysql/msql -f -sMONSERVEUR -uutilisateur Vulcain

Espace des Bases Sybase

echo "select
dat_nom,
srv_id,
srv_nom
from
MDB_DATABASE,
MDB_SERVEUR_DB
where
dat_serveur_db_id=srv_id
AND srv_sgbd_id=2;" |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain |while read datnom srvid srvnom ;
do echo "use $datnom
go
sp_helpsegment \"default\"
go
"|/env/test/osef/sybase/sql -uutilisateur -S$srvnom |tail -n 2 |awk '{print $3}'|grep [0-9] | while read espace ;
do echo "UPDATE MDB_DATABASE SET dat_espace_libre=\"$espace\" *2
where dat_nom=\"$datnom\"
AND dat_serveur_db_id=\"$srvid\";" ; done ; done |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Date Backup SERVEUR_PHYSIQUE6

ssh -f root@SERVEUR_PHYSIQUE6 'cd /env/database/sybase/backup/backtrack/sbackups.physical/SEQ/ ; ls -lrt --full-time' | awk -v Quote='"' '{print "update MDB_DATABASE SET dat_date_backup="Quote $6 " " $7"." Quote" WHERE dat_nom=" Quote $9 Quote " and dat_serveur_db_id=1;"}'|cut -d. -f1,3,4 |sed s/\\.//g |sed -e '1d' |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE6 'cd /env/database/sybase/backup/backtrack/sbackups.physical/SERVEUR_DEVELOPPEMENT/ ; ls -lrt --full-time' | awk -v Quote='"' '{print "update MDB_DATABASE SET dat_date_backup="Quote $6 " " $7"." Quote" WHERE dat_nom=" Quote $9 Quote " and dat_serveur_db_id=3;"}'|cut -d. -f1,3,4 |sed s/\\.//g |sed -e '1d' |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE6 'cd /env/database/sybase/backup/backtrack/sbackups.physical/SERVEUR_EXTERIEUR/ ; ls -lrt --full-time' | awk -v Quote='"' '{print "update MDB_DATABASE SET dat_date_backup="Quote $6 " " $7"." Quote" WHERE dat_nom=" Quote $9 Quote " and dat_serveur_db_id=2;"}'|cut -d. -f1,3,4 |sed s/\\.//g |sed -e '1d' |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE6 'cd /env/database/sybase/dump_db/SERVEUR_DU_CNG1 ; ls -lrt --full-time' | awk -v Quote="'" '{print "update MDB_DATABASE SET dat_date_backup="Quote $6 " " $7"." Quote" WHERE dat_nom=" Quote $9 Quote " and dat_serveur_db_id=5;"}'|cut -d. -f1,3,5,6 |sed s/\\.//g |sed -e '1d'|sed s/CL5//g |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE6 'cd /env/database/sybase/dump_db/SERVEUR_DU_CNG2 ; ls -lrt --full-time' | awk -v Quote="'" '{print "update MDB_DATABASE SET dat_date_backup="Quote $6 " " $7"." Quote" WHERE dat_nom=" Quote $9 Quote " and dat_serveur_db_id=6;"}'|cut -d. -f1,3,5,6 |sed s/\\.//g |sed -e '1d'|sed s/CL5//g |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Date Backup gaia

ssh -f root@serveur_mongodb4 'cd /env/database/postgres/dump ; ls -lrt --full-time *.md5' | awk -v Quote="'" '{print "update MDB_DATABASE SET dat_date_backup="Quote $6 " " $7"." Quote" WHERE dat_nom=" Quote $9 Quote " -and dat_serveur_db_id=23;"}'|cut -d- -f1,2,3,7 |sed -e '1d' |cut -d. -f1,3,5,6 |sed s/\\.//g |sed "s/-and/\' and/g" |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Date Backup MySQL

ssh -f root@CLUSTER11 'cd /env/export/dbdata1/ ; ls -lrta --full-time' |grep .snapshot |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_id AND dat_id=rel_file_database_id AND rel_file_system_id=2;" }' |cut -d. -f1,3 |sed s/\\.//g |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@CLUSTER11 'cd /env/export/svm1/v_volume2 ; ls -lrta --full-time' |grep .snapshot |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_id AND dat_id=rel_file_database_id AND rel_file_system_id=7;" }' |cut -d. -f1,3 |sed s/\\.//g |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@CLUSTER11 'cd /env/export/nfs7/labscope_db ; ls -lrta --full-time' |grep .snapshot |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_id AND dat_id=rel_file_database_id AND rel_file_system_id=8;" }' |cut -d. -f1,3 |sed s/\\.//g |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@CLUSTER11 'cd /env/export/svm1/v_volume1 ; ls -lrta --full-time' |grep .snapshot |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_id AND dat_id=rel_file_database_id AND rel_file_system_id=11;" }' |cut -d. -f1,3 |sed s/\\.//g |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@serveur_mongodb4 'cd /env/database/mysql/dump/backup/MYCNG ; ls -lrta --full-time' |grep "\\.sql"|awk -v Quote="'" '{print "UPDATE MDB_DATABASE SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_serveur_db_id=8 AND dat_nom=" Quote $9 "." Quote";" }' |cut -d. -f1,3,5 |sed s/\\.//g |sed s/\\.sql//g |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

Date Backup SERVEUR_PHYSIQUE1

ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/export/cns-bdd-n03/dbdata4/ ; ls -lrta --full-time' |grep .snapshot |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_id AND dat_id=rel_file_database_id AND rel_file_system_id=12;" }' |cut -d. -f1,3 |sed s/\\.//g |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/postgres/dump ; ls -lrt --full-time' | awk -v Quote="'" '{print "update MDB_DATABASE SET dat_date_backup="Quote $6 " " $7"." Quote" WHERE dat_nom=" Quote $9 Quote " and dat_serveur_db_id=16;"}'|cut -d. -f1,3,5,6 |sed s/\\.//g |sed -e '1d'|sed s/gz//g |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/mongodb/dump/prod ; ls -lrta' |awk '{print $9}'|sed s/\\.//g |while read nom ; do ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/mongodb/dump/prod/$nom ; ls -lrta --full-time' |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_nom=" Quote "'$nom'" Quote " AND dat_serveur_db_id=19;" }' |cut -d. -f1,3 |sed s/\\.//g |sed -e '1d'; done |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/mongodb/dump/SERVEUR_DEVELOPPEMENT ; ls -lrta' |awk '{print $9}'|sed s/\\.//g |while read nom ; do ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/mongodb/dump/SERVEUR_DEVELOPPEMENT/$nom ; ls -lrta --full-time' |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_nom=" Quote "'$nom'" Quote " AND dat_serveur_db_id=20;" }' |cut -d. -f1,3 |sed s/\\.//g |sed -e '1d'; done |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/mongodb/dump/SERVEUR_AUTRE ; ls -lrta' |awk '{print $9}'|sed s/\\.//g |while read nom ; do ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/mongodb/dump/SERVEUR_AUTRE/$nom ; ls -lrta --full-time' |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_nom=" Quote "'$nom'" Quote " AND dat_serveur_db_id=21;" }' |cut -d. -f1,3 |sed s/\\.//g |sed -e '1d'; done |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/mongodb/dump/cng ; ls -lrta' |awk '{print $9}'|sed s/\\.//g |while read nom ; do ssh -f root@SERVEUR_PHYSIQUE1 'cd /env/database/mongodb/dump/cng/$nom ; ls -lrta --full-time' |awk -v Quote="'" '{print "UPDATE MDB_DATABASE,REL_DATABASE_FILE_SYSTEM SET dat_date_backup=" Quote $6 " " $7 "." Quote " WHERE dat_nom=" Quote "'$nom'" Quote " AND dat_serveur_db_id=22;" }' |cut -d. -f1,3 |sed s/\\.//g |sed -e '1d'; done |/env/test/osef/mysql/msql -uutilisateur -sMONSERVEUR Vulcain

Historique

echo "insert into MDB_HISTORIQUE (hist_dat_id,hist_dat_taille,hist_date) select dat_id,dat_taille,curdate() from MDB_DATABASE;" |/env/test/osef/mysql/msql -f -uutilisateur -sMONSERVEUR Vulcain

Vous voulez commenter ? Créez un compte !

Echec lors de la connexion à MySQL : (2002) php_network_getaddresses: getaddrinfo failed: Name or service not known