Can I delete Amazon snapshots that were created by CreateImage?
Only if the snapshot is not used by an AMI.
When you create an image of an instance, AWS will automatically create a snapshot of it first. This snapshot is needed by the AMI, so you cannot delete it. Fortunately Amazon will warn you when the snapshot is needed by an image, so when in doubt, just try to delete it in the webinterface. You will then get an error message that the snapshot is currently in use.
When I tried to install the Debian Skype package from their website I received an error message “Wrong architecture ‘i386′”. It is way easier to install Skype directly from the command line, just enter these commands on a 64-bit system:
dpkg --add-architecture i386
wget -O skype-install.deb http://www.skype.com/go/getskype-linux-deb
dpkg -i skype-install.deb
apt-get -f install
This will install Skype and all needed 32-bit libraries on a Debian 64-bit installation. Great also for automated installs of Skype. See https://wiki.debian.org/skype for more information.
To install ec2-consistent-snapshot on Fedora install the required libraries
yum install perl-Net-Amazon-EC2 perl-DateTime-Locale perl-DateTime-TimeZone
Then download the software from GitHub
git clone https://github.com/alestic/ec2-consistent-snapshot.git
To start the software just execute the perl script.
DragonDisk is a great frontend for Amazon S3 and is available for Linux, Mac OS X and Windows. Development is currently on hold however, so if you are looking for a nice cross-platform S3 GUI take a look at CrossFTP. The free version works just great. Amazon Glacier and Google Storage are also supported.
The Pingdom website had problems yesterday already and is down again, does anyone know more? Currently there appears a message from CloudFlare, Error 522, Connection timed out. Are they under attack and tried to block it with CloudFlare or did they use it before already? On Twitter it just says “We are experiencing some issues right now”.
Update: A few days later they are still using CloudFlare, probably their standard setup. Seems to work rather well, the site is loading fast but there is some package loss. No information on the source of their problems.
Searching and replacing a word or text in a MySQL table is easy. If you want to replace the word wang with wand in the text
A magic wang… this was what Harry had been really looking forward to.
use the command
update table set field = replace(field, 'wang', 'wand') where instr(field, 'wang') > 0;
where field needs to be the name of the database field that you want to search. Wang will be changed to wand then while the rest of the content will remain the same.