[ORACLE] Preupgrade fixups

fixup_b4_mig.pdf

[Cassandra] Changer mot de passe, changer nom de cluster

Changer mot de passe : 

 

modifier paramètres dans yaml : 

keystore_password
truststore_password 

 

Changer de nom de cluster :

1 -UPDATE system.local SET cluster_name = '<cluster_name>' where key='local';

2- nodetool flush system (recommended)

3. cluster_name update cassandra.yaml the name for the new cluster

4. Restart cassandra cluster

[MSSQL]Kill session

kill_session_mssql.pdf

MAJ Sequence

sqlplus -s user_admin/<mdp>@BDDREC << EOF > upd_seq.sql
SELECT 'SELECT setval('''||sequence_name||''','||last_number||', true);'
FROM user_sequences;
exit;
EOF
psql --single-transaction  -h $2 -U postgres -d $1 -f ./upd_seq.sql

Commenter fichier unix

sudo sed -i -e '/LATIN1/ s/^#/--/' /pgdata/migration/*dev*/*.sql

[MSSQL] Disable/Enable FK

disable FK

DECLARE @sql NVARCHAR(MAX) = N'';

;WITH x AS 
(
  SELECT DISTINCT obj = 
      QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id)) + '.' 
    + QUOTENAME(OBJECT_NAME(parent_object_id)) 
  FROM sys.foreign_keys
)
SELECT @sql += N'ALTER TABLE ' + obj + ' NOCHECK CONSTRAINT ALL;
' FROM x;

EXEC sp_executesql @sql;

enable FK 

DECLARE @sql NVARCHAR(MAX) = N'';

;WITH x AS 
(
  SELECT DISTINCT obj = 
      QUOTENAME(OBJECT_SCHEMA_NAME(parent_object_id)) + '.' 
    + QUOTENAME(OBJECT_NAME(parent_object_id)) 
  FROM sys.foreign_keys
)
SELECT @sql += N'ALTER TABLE ' + obj + ' WITH CHECK CHECK CONSTRAINT ALL;
' FROM x;

EXEC sp_executesql @sql;

Calcul stats PostgreSQL

for tablename in $(psql -U postgres -h $2 -d $1 -t -c "select table_name as _table from information_schema.tables t where t.table_schema='sche_admin' order by _table asc"); do

  echo $tablename

  psql -U postgres -h $2 -d $1 -c "analyze ${tablename};"

  psql -U postgres -h $2 -d $1 -c "select count(*) ${tablename} from ${tablename};" >> compte_pgsql.log

done

 

En // :

vacuumdb --port=$PORT --username=$PG_USER --analyze-only --verbose --jobs=4  $PG_DATABASE

Installation et configuration de Cassandra

en-HTCC-8.5.2-Dep-InitializingCassandra.pdf

en-GMS-8.5.2-Deployment-ConfiguringanExternalCassandra.pdf

 

Qqs prérequis :

Faut désactiver le swap

             Il y des warning lors de démarrage de cassandra : 

            WARN  [main] 2021-04-29 16:18:32,338 SigarLibrary.java:174 - Cassandra server running in degraded mode. Is swap disabled? : false,  Address space adequate? : true,  nofile limit adequate? : true, nproc limit adequate? : true

 

1. Mettre le paramètre system vm.max_map_count a 1048575 ( dans /etc/sysctl.d/ 99-sysctl.conf)

             WARN  [main] 2021-04-29 16:18:32,338 StartupChecks.java:311 - Maximum number of memory map areas per process (vm.max_map_count) 65530 is too low, recommended value: 1048575, you can change it with sysctl.

 

Il est recommander de mettre les commitlogs dans un FS dédié séparer des data.

• Monter le /var/lib/cassandra/commitlog sur sd (lvm) dédié ( 20GB de taille )

 

Changer le home de user cassandra en /home/cassandra au lieu de /var/lib/cassandra

 

Ajouter les lignes suivantes dans fichier .bash_profile

 

PATH=$PATH:$HOME/.local/bin:$HOME/bin

#

export CASSANDRA_HOME=/usr/share/cassandra

export CASSANDRA_INCLUDE=$CASSANDRA_HOME/cassandra.in.sh

export CASSANDRA_CONF=/etc/cassandra/conf

export CASSANDRA_OWNR=cassandra

export CASSANDRA_BIN=/usr/sbin/cassandra

export JAVA_HOME=/usr/lib/jvm/java-1.8.0-openjdk-1.8.0.292.b10-1.el7_9.x86_64

#

PATH=$PATH:$CASSANDRA_BIN:$JAVA_HOME/jre/bin

export PATH

export PS1='[$LOGNAME@$HOSTNAME:W]$'

 

Faut installer le package jemalloc.x86_64