If you have paid attention to my other blog entries you have already figured that I am a fan of Literate Database Work as well as a user of Vertica. sql-mode and sql-interactive-mode are quite powerful. I combined them with yasnippet. The product is vertica-snippets - a package you can install via MELPA. If you are like me you probably
For the last 6 years I used Perl and the Catalyst MVC framework for my homepage. It provides a lot of nice features. The only issue: I haven’t used a lot of them. Being a heavy Emacs user and to follow the KISS principle I wanted to switch to Orgmode and org-publish. Thanks to Howard Abrams this turned out quite easy. I copied some of his elisp code to give my own Emacs the capabilities. As I liked his Webdesign I analyzed and transformed it into my own - of course asking for permission down the road. Finally I managed to update my collection of links and invested the extra time to redirect URLs from my previous website.
With a much easier way to publish I can just hope I am going to spend more time in the future writing about more topics.
disclaimer: use at your own risk
If you pay close attentation to the HP Vertica documentation you will see this requirement for doing a restore:
The cluster to which you are restoring the backup has the same number of hosts as the one used to create the backup. The node names and the IP addresses must also be identical.
Using the same node names is not complicated. Even if you run your Vertica Cluster on Amazon AWS. IP addresses are difficult though.
Having 500 git commits on an editors configuration files is quite a number. I think it’s a good reason for another recap.
A machinist builds his own tools. The same rule should apply to somebody working in Development or Systems Administration.
It makes your live easier and in the end it will speed you up.
Orgmode tables and literate devops.
As a sysadmin you probably know the rule: No production changes on Friday! If you use git to manage your automation and happen to not using git tags to finally send your code life this little code snippet might be for you:
Recently I found an old print of a Emacs keyboard map. As it is quite useful I searched the internet to find the source for this print. I figured the old saying upload something to the internet and it’s saved forever isn’t true. Searching my ancient notebooks I was lucky and found the pdf file. I couldn’t reach the original Author Sami BEN GRINE but found the original announcement post at https://groups.google.com/forum/m/#!topic/gnu.emacs.help/t2XkXn-0UJ4:
Even as on advocate of automation I see the need of taking notes of your systems. Legacy systems and stuff that cannot be automated for whatever reason. Using a logbook in plain text is a good choice.
If you call this file
LOGBOOK.org and use Emacs you can save a lot
of hassle. Besides beeing a good editor Emacs is capable of running
shells. org-mode gives you a markup language and the capability of
executing code blocks in that shell.
Literate Database Work by Howard Abrams was eye opening.
My only problem: I am currently in the Oracle world and orgmode ob-sql doesn’t support sqlplus. With SQLi-Mode it’s at least possible to use Emacs to connect to a database. In this case Oracle. But ob-sql supports Perl dbi-shell. For Perl there is DBD::Oracle which brings us full circle.
In the last 20 years I used a lot of programs but Emacs is still around. The one thing I regret: I should have started earlier diving into it. It’s 18 month since I started using git for my Emacs configuration. 180 commits - time for a resume.
Ever wondered what’s the right amount of tip?
How to share bookmarks within your department or company?
Maybe you even didn’t thought about this solution. Often wikis are used for this task. You have to visit an extra website to get to your final destination. Quite cumbersome if you ask me.
I’ve been using EMACS for the better part of my sysadmin live. Back in the days I’ve learned the basics of editing. Every now and then I learned another shortcut or command.
Things changed with my current position of a Senior Sysadmin: Now I spend most of the day in Emacs. Writing hundreds of lines of code and configfiles I figured it was time to dig deeper into Emacs to save time and make my life easier.
A couple of month ago we had a discussion about partitioning on the USENIX/Sage mailing list. Laziness tends to configure only 3 partitions today: /boot, swap and /. With LVM you can easily resize partitions and there are quite some advantages:
Just a couple of days ago it happened again: A DVD sitting on my desk and a computer ready for installation without a DVD drive. The only difference this time: I had no USB DVD drive.
Lets assume you are using LinuxVirtualServer in direct routing mode.
Now you are in the situation that your cluster nodes have to talk to the outside world to fetch rss feeds or talk to authentication systems. These systems are not under your control and might change the ip address and you wouldn’t get informed.
Operating a globally accessed webservice for the last couple of years traffic costs, web performance and user experience are familiar topics for me.
All these topics come down to web optimization and caching.
The first and probably easiest task is activating gzip compression. There are some known issues with eg some version of Internet Explorer. In my setup i made good experience with this line for Apache:
I am using IPMI and other out-of-band management interfaces since 2006.
Sometimes they are referred to as BMC, ILOM or Remote Supervisor Adapter (RSA). There are quite some differences:
Cheapest models supply only features like power on/off, reset and serial-over-lan. They work quite well and fit most needs. If you spend more money you get features like upload of floppy images, mounting remote CD/DVD or even KVM capabilities. Nowadays you have often a web interface. Sometimes you get a dedicated LAN port for it. Quite often its shared with LAN0. Both versions work well and it depends more on your grade of paranoia which type you prefer. If you buy server hardware you get the basic module for free. In a Linux environment you can stay with that type. For Windows I recommend using the KVM version. Even though Windows Server can do serial-over-lan since version 2003.
Even though i have to admit that git has a high learning curve it’s worth the time.
I started with the ProGIT book and use it today for a wide range:
- source code
- to manage the images of my camera
- in conjunction with etckeeper