Paweł Domański
57 lines
1.6 KiB
Markdown
57 lines
1.6 KiB
Markdown
---
|
|
type: "DailyNote"
|
|
title: Daily Note - 2026-05-12
|
|
date: 2026-05-12 08:06:11
|
|
tags: []
|
|
Status: Active
|
|
---
|
|
|
|
CREATE USER 'dnb_eu_dba'@'%' IDENTIFIED BY 'CommonDBA890!@#';
|
|
GRANT ALL PRIVILEGES ON * . * TO 'dnb_eu_dba'@'%' WITH GRANT OPTION;
|
|
ALTER USER 'dnb_eu_dba'@'%' PASSWORD EXPIRE NEVER;
|
|
FLUSH PRIVILEGES;
|
|
|
|
|
|
log-error=/var/log/mysql/error.log
|
|
slow_query_log = 1
|
|
slow_query_log_file = /var/log/mysql/slow-query.log
|
|
long_query_time = 5
|
|
innodb_file_per_table = 1
|
|
#bind-address=10.198.1.136
|
|
bind-address=0.0.0.0
|
|
port=3306
|
|
|
|
|
|
|
|
CREATE USER 'dnb_eu_dba'@'%' IDENTIFIED BY 'CommonDBA890!@#';
|
|
GRANT ALL PRIVILEGES ON * . * TO 'dnb_eu_dba'@'%' WITH GRANT OPTION;
|
|
ALTER USER 'dnb_eu_dba'@'%' PASSWORD EXPIRE NEVER;
|
|
FLUSH PRIVILEGES;
|
|
|
|
|
|
|
|
|
|
CREATE USER 'splunk'@'localhost' IDENTIFIED BY 'xPOfVfLbKpv4kHu!@#78';
|
|
|
|
GRANT SELECT ON performance_schema.* TO 'splunk'@'localhost';
|
|
|
|
GRANT RELOAD, PROCESS, REPLICATION SLAVE, REPLICATION CLIENT ON *.* TO 'splunk'@'localhost';
|
|
|
|
ALTER USER 'splunk'@'localhost' PASSWORD EXPIRE NEVER;
|
|
|
|
FLUSH PRIVILEGES;
|
|
|
|
chmybccdb0npl01 root
|
|
Cc-2ch019.$qsRa
|
|
|
|
GRANT SLAVE MONITOR
|
|
ON *.*
|
|
TO 'splunk'@'127.0.0.1';
|
|
|
|
FLUSH PRIVILEGES;
|
|
|
|
|
|
|
|
INC0805514 -> (Splunk Observability) Disk > 80% [G:] CHDBASQDB0NPW01.bisnodech.local - backup and truncate logs
|
|
INC0805145 -> (Splunk Observability) Disk > 80% [/var/log] chmybccdb0npl01.blue.bisnode.net - Monitoring issue, repair splunk otel
|
|
SCTASK0737627 -> General Database Request - BART DRN 3422 - preparation to migration - Full backup and restore ~1:10 + incremental backup ~20 min If is posibility to run backup and restore in one day |