Skip to content

Instantly share code, notes, and snippets.

View bakaut's full-sized avatar

Nikolai Lebedev bakaut

6 followers · 12 following
  • Tempo
  • Montenegro
  • 23:04 (UTC +01:00)
View GitHub Profile
@bakaut
bakaut / docker-compose.yml
Created January 24, 2020 21:24
arangodb docker
version: "2"
services:
agency:
image: arangodb/arangodb
environment:
- ARANGO_NO_AUTH=1
command: arangod
--server.endpoint tcp://0.0.0.0:8529
--agency.my-address tcp://agency:8529
@bakaut
bakaut / permission.txt
Created January 2, 2020 11:25
List of permission minio client
ls mb
15:22:33.773 [200 OK] s3.ListBuckets 10.20.92.77:8016/ 10.126.18.61 2.113ms 🠉 77 B 🠋 607 B
15:22:33.785 [200 OK] s3.ListBuckets 10.20.92.77:8016/ 10.126.18.61 1.433ms 🠉 77 B 🠋 607 B
15:22:50.846 [200 OK] s3.PutBucket 10.20.92.77:8016/test2/ 10.126.18.61 165.785ms 🠉 77 B 🠋 235 B
cp
15:23:10.486 [200 OK] s3.GetBucketLocation 10.20.92.77:8016/test2/?location= 10.126.18.61 14.342ms 🠉 77 B 🠋 378 B
15:23:10.510 [200 OK] s3.HeadBucket 10.20.92.77:8016/test2/ 10.126.18.61 12.06ms 🠉 77 B 🠋 218 B
15:23:10.532 [200 OK] s3.HeadBucket 10.20.92.77:8016/test2/ 10.126.18.61 12.225ms 🠉 77 B 🠋 218 B
@bakaut
bakaut / openresty-http2-pagespeed-install.sh
Created December 21, 2019 12:59 — forked from marklkelly/openresty-http2-pagespeed-install.sh
#!/bin/bash
set -o errexit
clear
# Set versions. Check http://openresty.org for latest version and bundled version of nginx.
OPENRESTY_VERSION=1.9.3.1
NGINX_VERSION=1.9.3
OPENSSL_VERSION=1.0.2d
NPS_VERSION=1.9.32.10
@bakaut
bakaut / readme.md
Last active December 12, 2019 14:20
minio docker testing stend

https://min.io/

Run 16 nodes 14 disk minio distributed mode

To adjust:

1. Change numder of nodes  range(1,17)
2. Change nubber of disks  range(1,15)
3. Change http://minio{1...16}/data{1...14} according 1 and 2
@bakaut
bakaut / 1.events-cleanup.sql
Last active November 7, 2019 19:23
Zabbix 3.4.15 database optimization. Cleanup events table. This store procedure allow decrease cpu usage on 20% and bust up sql select on events table from 30 sec to 3 sec
DELIMITER $$
USE `zabbix`$$
DROP PROCEDURE IF EXISTS `recreate_events`$$
CREATE PROCEDURE `recreate_events`()
BEGIN
DROP TABLE IF EXISTS events_copy_tmp;
CREATE TABLE events_copy_tmp LIKE events;
SELECT clock into @start_time FROM events ORDER BY clock DESC LIMIT 1;
INSERT IGNORE INTO events_copy_tmp (select * from events where source=0);
SELECT count(eventid) INTO @event_from_start from events WHERE source=0 AND clock > @start_time;
@bakaut
bakaut / 00-exim-monitoring.md
Last active December 4, 2023 08:57
Exim 4.92 monitoring and logs parse

Настройка парсинга логов exim

rsyslog сервер, на котором установлена elk stak и настроен rsyslog

На хостах exim добавить в cron

root zabbix_sender -z zabbix-server -s "exim_hostname_in_zabbix" -k exim.queue -o `exim -bpc`

Добавить в rsyslog.conf
@bakaut
bakaut / 01-logstash-config-exim-in
Created October 13, 2019 12:55
Exim 4.92 monitoring and logs parse
input {
syslog {
type => syslog
port => 2514
}
}
@bakaut
bakaut / 3-15-schema.sql
Last active August 1, 2024 06:53
zabbix scheme sql compare
CREATE TABLE `users` (
`userid` bigint unsigned NOT NULL,
`alias` varchar(100) DEFAULT '' NOT NULL,
`name` varchar(100) DEFAULT '' NOT NULL,
`surname` varchar(100) DEFAULT '' NOT NULL,
`passwd` char(32) DEFAULT '' NOT NULL,
`url` varchar(255) DEFAULT '' NOT NULL,
`autologin` integer DEFAULT '0' NOT NULL,
`autologout` varchar(32) DEFAULT '15m' NOT NULL,
`lang` varchar(5) DEFAULT 'en_GB' NOT NULL,
@bakaut
bakaut / perfomance turning.txt
Last active July 14, 2018 13:32
postgesql and zabbix
https://zabbix.org/wiki/Docs/howto/zabbix2_postgresql_autopartitioning
https://github.com/kostya/pg_reindex
https://github.com/cavaliercoder/zabbix-pgsql-partitioning
http://www.umgum.com/zabbix-housekeeper-postgresql-vacuum
https://habr.com/company/postgrespro/blog/301238/
http://it-admin.org/?p=1602
https://blog.2ndquadrant.com/autovacuum-tuning-basics/
https://confluence.atlassian.com/kb/optimize-and-improve-postgresql-performance-with-vacuum-analyze-and-reindex-885239781.html
https://lob.com/blog?p=10
https://www.postgresql.org/docs/9.2/static/routine-vacuuming.html
@bakaut
bakaut / create_host.py
Last active November 7, 2018 07:59
zabbix scripts
import time
import requests
import json
from pyzabbix import ZabbixAPI
post_url = "http://ip/zabbix/api_jsonrpc.php"
'''