|
||||||
|
Using the script you can get the alert message from the replication server if replication is down or not working. ——————————————————————————————– #!/bin/bash PATH=/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin #script checking the replication is running or not. #If replication is down then sent the alert mail. slave_server_hostname=192.168.10.1 ###check if already notified### cd /root if [ -f slave_problem.txt ]; then rm -rf […] Database Replication In MySQL
Configure the MySQL Master Server Step 1 : edit /etc/mysql/my.cnf file. #skip-networking #bind-address = 127.0.0.1 (add below line in /etc/mysql/my.cnf file) server-id = 1 log_bin = /var/log/mysql/mysql-bin.log binlog_do_db = replicationdb step 2 : Restart Mysql server #/etc/init.d/mysql restart Step 3 : create a user with replication privileges: #mysql -u […] * For SH/BASH/TCSH Below script will implement a 5 minute idle time-out for the default /bin/bash shell. Step 1: Create file autologut.sh # vi /etc/profile.d/autologout.sh Add New Append the following code: TMOUT=300 readonly TMOUT export TMOUT Step 2: Save and close the file. Set permissions: # chmod +x /etc/profile.d/autologout.sh
*For tcsh version follow the […] If you have two IDE drives that are of identical size, and provided that you are sure they contain no bad sectors and provided neither are mounted, you can run dd if=/dev/hda of=/dev/hdb To copy the entire disk and avoid having to install an operating system from scratch. It doesn’t matter what is on the […] Full Name : Message-Digest algorithm 5 Usage : Using an MD5 checksum you can verify the integrity of data Algorithm : cryptographic hash function with a 128-bit value MD5 sum first identify the the data which is backup and then create a MD5 checksum which is combination of unique string of letters and numbers put […] sed ‘/./!d’ filename.txt > temp1.txt sed ‘/^$/d’ filename.txt > temp1.txt grep -v ‘^$’ filename.txt > temp1.txt Suppose we want to take a backup of user’s account. So for that first of all we have to block the user to login into their account to maintain data integrity of user’s backup files. So using below technique we can do that very easily.enjoy !!! Edit the pam file located in /etc/pam.d/ directory for […] f you want to restrict/allow access to certain service on timely basis using iptables. Use : iptables patch-o-matic extension (pom or p-o-m) That allows us to match a packet based on its arrival or departure timestamp. Syntax : iptables RULE -m time –timestart TIME –timestop TIME –days DAYS -j ACTION –timestart TIME: Time start value […] Split on a 300mb example.zip file: #split -b 100mb example.zip It will generate 3 files with the following file sizes: 100MB xaa 100MB xab 100MB xac After split use: cat to combine a file #cat xa* > example-new.zip ssue: Check your /var/log/auth.log file. In this file you can able to see that some unauthorized user is constantly trying to access your system using brute force attacks. He/she trying to get the access of your system by some scripts which is trying to login with different password. We can block this using simple iptables […] |
||||||
|
Copyright © 2024 - All Rights Reserved Powered by WordPress & Atahualpa |
||||||
Recent Comments