August, 2013

Run Cronjob every other week (fortnightly)

August 23, 2013 Jordansphere Linux

A customer  has a development server and production server. They wanted all the patches updated on the development server 1 week before being replicated on  the live server – although, of course there might be updates that come out within the 1 week period that may cause issues. My task was to set up the cron jobs […]

More

cron every other week fortnightly,

Random Loss of Connectivity on ESXi5 NICs.

August 20, 2013 Jordansphere VMware

We lost network connectivity to all of the VMs on a particular ESXi 5.0 host. vMotion, Mgmt Network and Storage network were all unaffected. No other host was affected and the NICs were twinned for resilience. When clicking on the NICs via the dVS tab  none of the CDP information was showing for either NIC (Cisco […]

More

Enable SNMP FreeBSD

August 20, 2013 Jordansphere FreeBSD

1) Install Net-SNMP # cd /usr/ports/net-mgmt/net-snmp # make install clean   2) Create SNMP conf file # vi /usr/local/share/snmp/snmpd.conf syscontact blackhole@jordansphere.co.uk rocommunity public 10.0.0.1/24 syscontact Jordansphere syslocation London   3) Start SNMP service # /usr/local/etc/rc.d/snmpd start   4) Input line in rc.conf so it starts on a reboot # vi /etc/rc.conf snmpd_enable="YES"      

More

Configuring MySQL Replication 5.5 in 6 steps

August 16, 2013 Jordansphere FreeBSD

Scenario: You want to create a MySQL replication between an exisiting master and a brand new slave. Both machines running FreeBSD 8.x with MySQL 5.5. The master server currently has a mixture of InnoDB and MyISAM engines. A small amount of downtime is available. Master server:    10.1.1.1 Slave server:     10.1.1.2     (1) ON […]

More

mysql replication master slave,

Install Telnet Client via CLI on Windows 7

August 13, 2013 Jordansphere Windows

To install the Telnet client on a Windows 7 machine Click the Start menu -> Type cmd into the search box. Open the command prompt. Type the following: pkgmgr /iu:”TelnetClient”   Alternatively if you want to install via the GUI; Go to Control Panel -> Programs & Features -> Turn Windows features on or off […]

More

Using Logrotate with MySQL Database Backups

August 1, 2013 Jordansphere FreeBSD

Scenario: I wanted to backup all the databases individually from a MySQL server and keep for x days. I set about achieving this using a custom script combined with logrotate. The server is running FreeBSD 8.x.   1) Firstly, the script (backup-all-dbs.sh): #!/usr/local/bin/bash # backup-all-dbs.sh # backup each mysql db into a different file, rather […]

More

logrotate mysql script daily, mysqldump,

Powered by WordPress. Designed by elogi.