Fulltext results:
- mySQL @linux:databases
- tables are crashed): mysqlcheck --repair --all-databases -u root --password=PASSWD If the server cr... nnection to MySQL server during query creating database xxx .: ERROR 2002 (HY000): Can't connect to... ects.com/resources/programming/t-how-to-fix-mysql-database-myisam-innodb-1634.html If you get annoyed, ... e passwd and retry ---- == mysqldump == dump a database to a .sql file. there are many parameters. ch
- Replication @linux:databases:mysql
- ====== Replication ====== High Availibility Database Replication Setup ===== Replication Setups ===== ... tion: If we know that only one node is performing data modifications we can avoid many possible problems... "slave" could be easily promoted to a new master. Data modifications are automatically replicated to fai... tator' can be setup, which does not run an actual database * ... ===== Master <-> Master Setup =====
- Crypto @linux:filesystems
- # write random data on the partition cryptsetup -c aes-xts-plain64 ... un **badblocks** check or **dd** to overwrite all data with random bit patterns badblocks -c 10240 -s... ever could happen to your storage and see if your data is still there." ---- \\ **References:** * ht... ead of a partition: create a file full of random data, setup loop device, luksFormat & format
- Bootloader @linux:filesystems
- em, you can mount the partitions and transfer the data anyway you like (as root user): 1. **rsync** needs params and data must be excluded, (but works f&f in a running sys... WARNING: Device /dev/ram0 not initialized in udev database even after waiting 10000000 microseconds. .
- btrfs @linux:filesystems
- imize ===== COW is not good for small files like database files: disable it for a directory: chattr... ib/ balance reorders metadata - use after a lot data has changed or disc was full: fast: btrfs fi b... he allocated space, not the space. Used shows the data-usage space. you need to add metadata usage. b
- PHP @linux:webserver
- owned by the same user as the sftp user - not www-data. **Pool per domain config:** cd /etc/php5/fpm... adduser --disabled-login USERNAME adduser www-data USERNAME mkdir /var/www/USERNAME chown -R USE
- Streaming -Server und Cam -Software
- l gabekangas/owncast:latest docker run -v `pwd`/data:/app/data -p 8080:8080 -p 1935:1935 -it gabekangas/owncast:latest \\ ===== cvlc Webcam to Stream
- Nginx @linux:webserver
- :** mkdir /var/cache/ngx_pagespeed/ chown www-data:www-data /var/cache/ngx_pagespeed/ **edit /etc/nginx/sites-available/default:** server { #....
- Shell Commands & Oneliner
- tar cvpzf /mnt/somewhere/backup.tgz --exclude=/data --exclude=/proc --exclude=/lost+found --exclude=/... dump of complete filesystems ===== **backup raw data of a disc (as root): ** dd if=/dev/sdX | gzip
- dirvish @linux:backup
- 100GB of small mail files. Usually we mirror the data from a remote server and backup via dirvish from ... re other copies of the files. This can even cause database servers to hang, because they don't get a loc
- vsFTPd @linux:network
- ssl_enable=YES allow_anon_ssl=NO force_local_data_ssl=NO force_local_logins_ssl=NO ssl_tlsv1=YE... pasv_min_port=55000 pasv_max_port=60000 ftp_data_port=20 listen_port=21 ===== Client testing =
- Crash Recovery
- nt -t sysfs none /mnt/sys Now you can take your data back already. To repair what is broken, you prob
- LXC @linux:virtualization
- er -a amd64 ==== Clone container ==== Copy all data: lxc-clone --backingstore btrfs --orig vs1 --ne
- Debian Server Install
- from somewhere (at least new packages) * rsync data * munin * monit * fail2ban * **install ne
- Databases
- ====== Databases ====== mySQL-Server TriX...