How To Upgrade MySQL from 5.5 to 5.7 on CentOS/AWS Linux

Author: , December 7th, 2017

START: Server version: 5.5.54-log MySQL Community Server (GPL) FINISH: Server version: 5.7.20-log MySQL Community Server (GPL) 1 2 3 4 5 6 mysql –execute="SET GLOBAL innodb_fast_shutdown=0;" service mysqld stop yum remove mysql mysql-* yum install mysql57-devel mysql57-server mysql57-test service mysqld start mysql_upgrade mysql –execute=”SET GLOBAL innodb_fast_shutdown=0;” service mysqld stop yum remove mysql mysql-* yum install […]

How To Fix Apache VirtualHost Overlap on Port 443 on AWS Linux

Author: , July 4th, 2016

If you get this error when starting Apache or via `apachectl configtest`: [warn] _default_ VirtualHost overlap on port 443, the first has precedence then you must add: NameVirtualHost *:443 to /etc/httpd/conf/httpd.conf, then restart Apache

How To Auto-Restart Apache If the Load Gets Too High

Author: , September 15th, 2015

The script to check and restart apache…works on CentOS – YMMV! 1 2 3 4 5 6 7 8 9 10 11 #!/bin/bash MAXLOAD=6 check=$(uptime | awk -F’average: ‘ ‘{print $2}’ | awk ‘{print $1}’ | tr -d ‘,’) if [[ $check > $MAXLOAD ]]; then     /sbin/service httpd stop     HOST=`hostname`   […]

How To Fix “Could Not Bind to Address: Permission Denied” Errors on CentOS/Amazon Linux

Author: , October 16th, 2014

Permission denied: could not bind to address To disable on the fly: # getenforce Enforcing # setenforce 0 # getenforce Permissive # sestatus To survive a reboot: # vi /etc/sysconfig/selinux Change: SELINUX=enforcing to SELINUX=disabled ~or~ SELINUX=permissive

How To Resize an ext3 Filesystem

Author: , August 31st, 2014

I had to replace an ailing root volume on AWS, so I decided to double the size when I created the new volume from snapshot. After booting, I realized that df still showed the old filesystem size of 10GB, not the new size of 20GB Here is the solution: resize2fs /dev/xvda1 1 2 3 4 […]

How to Install Apache mod_evasive on AWS Linux/CentOS

Author: , July 26th, 2014

I was getting tired of using iptables to block the various hackers and bots constantly slamming my servers (the Chinese are the worst offenders by far – curse them!). I found the Apache module mod_evasive and installed it. Here are links to various articles about mod_evasive: http://www.zdziarski.com/blog/?page_id=442 https://coderwall.com/p/eouy3g http://www.crucialp.com/resources/tutorials/server-administration/flood-protection-dos-ddos-protection-apache-1.3-2.0-mod_dosevasive-avoiding-denial-of-service-attacks.php Add the Module to Apache I […]

How To Install Continuent Tungsten Replicator Using Puppet on AWS

Author: , April 15th, 2014

https://github.com/continuent/continuent-puppet-tungsten As user root: vi /root/install.pp 1 2 3 4 5 6 7 8 9 10 11 12 13 14 $clusterData = {     "myServiceNameHere" => {         "topology" => "master-slave",         "master" => "myDBHostName1",         "slaves" => "myDBHostName2",     }, } class { […]

How To Install SysBench on AWS Linux/Centos

Author: , November 17th, 2013

1 2 3 4 5 6 7 8 9 yum install libtool mysql-devel wget http://sourceforge.net/projects/sysbench/files/latest/download tar xvzf sysbench-0.4.12.tar.gz cd sysbench-0.4.12 libtoolize –force –copy ./autogen.sh ./configure make make install yum install libtool mysql-devel wget http://sourceforge.net/projects/sysbench/files/latest/download tar xvzf sysbench-0.4.12.tar.gz cd sysbench-0.4.12 libtoolize –force –copy ./autogen.sh ./configure make make install

How To Install Ruby on Rails with Passenger on Apache using RVM

Author: , July 31st, 2013

These are the steps I took to get this installed on a t1.micro AWS instance. OPTIONAL: Increase virtual memory for compiling Passenger as per warnings from passenger-install-apache2-module dd if=/dev/zero of=/swap bs=1M count=1024 mkswap /swap swapon /swap BASIC INSTALLATION yum install -y gcc-c++ patch readline readline-devel zlib zlib-devel openssl-devel libxml2-devel libxslt-devel libcurl-devel make bzip2 autoconf automake […]

How to Block wp-login.php Attacks on WordPress Sites

Author: , May 17th, 2013

Introduction WordPress installs globally have been taking quite a hit recently, as nefarious persons continue to attempt brute-force attacks against the WordPress login page. Based on research and experimentation, I have chosen the following approach to provide security with the lowest performance hit: require a web-server-level password for all requests to the wp-login.php file. This […]