Please do not just delete them in the OS. You need to let mysqld do that for you. Here is how mysqld manages it: 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 […]
Red hat linux
MySQL Master-Master Replication Bug – ERROR 1872
Description: When i tried to configurate a crash safe slave with MTS and GTID based replication, but after a OS crash replication failed to be start. error log: ——————————— 2016-10-26 21:00:23 2699 [Warning] Neither –relay-log nor –relay-log-index were used; so replication may break when this MySQL server acts as a slave and has his hostname […]
Create Permanent alias on CentOS/Redhat
The ‘alias’ command in CentOS allows for you to create an alias to a command. For example, if you want to use the vim text editor, but are used to typing vi file-to-edit.txt, you can create an alias to automatically start vim instead of vi when typing the command. Showing current aliases To show the […]
Delete Files Older Than X Days
Command Syntax find /path/to/files* -mtime +5 -exec rm {} \; Note that there are spaces between rm, {}, and \; This is a very simple tutorial how to find and delete files older than X days. I needed this for a project where i collected some images and after a while they took too much […]
MySQL Master-Master Replication
Create MySQL user CREATE USER ‘droaming’@’localhost’ IDENTIFIED BY ‘DroamG.123’; CREATE USER ‘droaming’@’%’ IDENTIFIED BY ‘DroamG.123’; Drop Mysql User DROP USER ‘droaming’@’localhost’; DROP USER ‘droaming’@’%’; Create Mysql Database and grant permission CREATE DATABASE droaming; GRANT ALL ON droaming.* TO ‘droaming’@’localhost’; View MySQL users SELECT User, Host, Password FROM mysql.user; MySQL Master-Master Replication SERVER 01 [mysqld] datadir=/var/lib/mysql […]
Password less command line scripts with MySQL 5.6
I have a number of command line scripts that copy MySQL databases down from staging servers and store them locally. These scripts set the password on the command line using the -p option. With MySQL 5.6, a new warning is displayed every time my scripts run: Warning: Using a password on the command line interface […]
Nagios Notifications using SMTP server with Authentication
We needed to setup Nagios to utilize our internet service providers SMTP Email server for notification emails. The biggest problem was that the ISP’s outgoing email server requires authentication. Nagios setup with SMTP outgoing authentications. These are instructions and examples on how we got this setup working. I hope this helps others in the Nagios […]
Install LAMP on Redhat / Centos 6
LAMP කියන්නේ open-source software කිහිපයක එකතුවක්. ඒ කියන්නේ Linux, Apache HTTP Server, MySQL database, and PHP/Perl/Python). මේ tutorial එකේදි මම ඔයාලට කියලා දෙන්නේ කොහොමද RHEL/CentOS 6.X වල LAMP install කරන්නේ කියලා. මේකෙදි මගේ server එකේ hostname එක test.ideus.lk. server IP එක වෙන්නේ 192.168.1.101/24. මුලින්ම කරන්න පොඩි දෙයක් තියෙනවා.EPEL Repository එක අපේ server එකට configure කරගන්න ඕන. Repository ගැන මම […]
Update PHP 5.1 to 5.5 on Redhat / CentOS 5.5
Add EPEL repo rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-5.noarch.rpm rpm -Uvh http://mirror.webtatic.com/yum/el5/latest.rpm Remove Previous version yum remove php* Install PHP 5.5 yum install php55w-fpm php55w-opcache yum install php55w-xml php55w-gd php55w-process php55w-mysql php55w-mbstring php55w-pear php55w-common php55w-imap php55w php55w-mcrypt php55w-pdo php55w-cli php55w-devel
Installation of KLOXO Hosting Panel with DKIM and SPF
An easy to follow guide to install DKIM on CentOS 5.x Linux mail servers using qmailtoaster and kloxo/lxadmin. help prevent outgoing emails from your email servers winding up in someone’s spam box. KLOXO instalation guide su – root setenforce 0 su – root yum install -y wget wget http://download.lxcenter.org/download/kloxo/production/kloxo-installer.sh #To install as Master (Default Single […]