versuch.net

When you make backup using mysqldump, you will get one big file in your backup folder. If you want to move the backup file to another server or just want to save it in your local computer, it will take time because of the size of the file. Indeed, you can split it per table. This script can help you to backup your mysql database, and splits the backup file every 10 tables.

Sometimes, your application was stalled and stay in memory and never exit. For this, you can create a simple bash script to define whether the application is worth to be killed. This example will kill wkhtmltopdf-amd application that has state Sl and have been running for more than 1 hour. You can then call this script via cron, to call it periodically. #!/bin/bash get_proc=`ps -C wkhtmltopdf-amd -o pid=,stat=,etime= | awk '{if ($2 == "Sl" && !(substr($3,0,2)+0 < 1) ) print $1; }'` for i in $get_proc do kill -9 $i done

Environment To setup a failover system with Pacemaker, Corosync and DRBD, we need 2 servers, 3 IP address in the same subnet and one partition with same size in both server. In this setup, mysql and apache are already configured Software requirement: DRBD & drbdlinks Pacemaker & Corosync psmisc package (needed by pacemaker) It is highly recommended to use separate network adapters for synchronization but it is also work with 1 network adapter. In this example, we use below configuration: Node 1, hostname: fo2, ip: 10.0.0.2, synchronization partition: /dev/sdb1 Node 2, hostname: fo3, ip: 10.0.0.3, synchronization partition: /dev/sdb1 IP Cluster: 10.0.0.1 Domain: test.ok Synchronization folder: /sync