At first we need to instal this packages if they are not presented: yum -y install corosync pacemaker pcs Before your cluster could be configured, you need to start the pcs daemon and boot up at each node, so type Continue reading High Availability Cluster on Centos 7 using Corosync & Pacemaker & pcs
First of all we need to enable xp_cmdshell option on our SQL server. This option enables system administrators to control whether the xp_cmdshell extended stored procedure can be executed on a system. By default, the xp_cmdshell option is disabled on Continue reading How to backup SQL Server databases to a mapped drive using Username and Password
If you try to remove a logical volume you’ll get error like this: Logical volume VolGroup00/LogVol01 contains a filesystem in use. The solutions is to check is there open files, most likely no: lsof | grep LogVol01 And after that Continue reading LVM problem – Logical volume contains a filesystem in use.
To be absolutely clear this plugin is alternative to the MySQL Enterprise Audit Plugin made by Percona. This plugin is a part of Percona 5.6 version, so you can download the latest 5.6 version from http://www.percona.com ind extract .so file Continue reading Installing Percona Audit Plugin on MySQL 5.6.21 community server
For your convenience, a short phrase book, starting with explanation of process states where MySQL is mostly working to look up data from tables: “Sending data” – reading data from tables (or looking it up) “Copying to tmp table” – Continue reading MySQL processlist phrases
A really short instruction for haw to test your CPU, File IO and MySQL on CentOS 6.5 1. Install sysbench It’s easy and there is a RPM package in repositories yum install sysbench 2. CPU benchmark sysbench –test=cpu –cpu-max-prime=10000 run Continue reading How to benchmark your system with sysbench
Download the antivirus components: yum install clamav-daemon clamav-freshclam clamsmtp Add the following to the end of your “/etc/postfix/main.cf” file: content_filter = scan:[127.0.0.1]:10025 Make your “/etc/clamsmtpd.conf” file look like this: OutAddress: localhost:10026 ClamAddress: /var/run/clamav/clamd.ctl User: clamav Make your “/etc/clamav/clamd.conf” file look Continue reading Postfix Email antivirus scanning with ClamAV on Linux
Templates Templates are a key feature of rsyslog. They allow to specify any format a user might want. They are also used for dynamic file name generation. Every output in rsyslog uses templates – this holds true for files, user Continue reading Custom templates for rsyslog
Using Spamassassin with Postfix Install Spamassasin using the following: yum install spamassassin spamc Configuring Postfix to use Spamassasin. In “/etc/postfix/master.cf”, change this: smtp inet n – – – – smtpd To be this: smtp inet n – – – – Continue reading Postfix Email Spam check with Spamassasin on Linux
This tutorial demonstrates how to find and deal with programs opening network ports on your Linux system. In our example below, the TCP port 6667 is open. This port is usually used for IRC servers. If you see this port Continue reading Find programs listening on network ports and removing them