-
-
[Cassandra] Changer mot de passe, changer nom de cluster
Changer mot de passe :
modifier paramètres dans yaml :
keystore_password
truststore_passwordChanger 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 cluster4. Restart cassandra cluster -
[MSSQL]Kill session
-
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
- 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