Delete/Purging mysql-bin (binlog) files safely Rumi, January 7, 2021 The file mysql-bin.index keeps a list of all binary logs mysqld has generated and auto-rotated. The mechanisms for cleaning out the binlogs in conjunction with mysql-bin.index are: PURGE BINARY LOGS TO ‘binlogname’; PURGE BINARY LOGS BEFORE ‘datetimestamp’; These will clear all binary logs before the binlog or timestamp you just specified. For example, if you login to mysql run mysql> PURGE BINARY LOGS TO ‘mysql-bin.000223’; this will erase all binary logs before ‘mysql-bin.000223’. If you run mysql> PURGE BINARY LOGS BEFORE DATE(NOW() – INTERVAL 3 DAY) + INTERVAL 0 SECOND; this will erase all binary logs before midnight 3 days ago. If you want to have binlog rotated away automatically and keep 3 days woth, simply set this: mysql> SET GLOBAL expire_logs_days = 3; then add this to /etc/my.cnf [mysqld] expire-logs-days=3 Related Administrations MySQL BinlogMySQL
Reverse Proxy with Caching February 15, 2016 A Sample Nginx Reverse proxy configuration- an alternative to Varnish cache (kind of more simplistic)- user www-data; worker_processes 4; pid /var/run/nginx.pid; events { worker_connections 768; # multi_accept on; } http { proxy_cache_path /cache levels=1:2 keys_zone=STATIC:10m inactive=24h max_size=1g; server { location / { proxy_pass http://127.0.0.1:8080; proxy_set_header Host $host; proxy_cache STATIC; proxy_cache_valid… Read More
List prosody users on Jitsi VB August 6, 2020 For administration thoughts, i wonder if there is a command, prosodyctl or other, which can give a list of user registrered on prosody. Apparently there is a way- just look into your /var/lib/prosody/[domain]/accounts Folder and type in “ls” then count thr .dat files Related Read More
Linux Router- No NAT May 7, 2018 I assume you have one public IP address for your WAN side, and a block for the LAN side, something like this: ISP—–ROUTER ETH0/ROUTER ETH1——SWITCH——PCs You NEED to have a public IP address for the WAN interface, ISP will route the subnet they have given you through this IP address…. Read More