Another post on Ansible over on the codecentric blog: Jinja2 for better Ansible playbooks and templates linked here for your convenience :)
8 Older Entries »
On the company blog I published a post about our experience with Ansible today.
It is no shoot out between different automation tools, but rather a collection of Ansible basics and our experience with it so far. Soon another post will follow about dynamically generated inventories for OpenStack virtual environments.
You can find it here: codecentric blog: Ansible: Simple, yet powerful automation.
This is the second part of two series of blog posts to setup a
SSH connection on Windows from scratch. The first part can be
This article describes in step by step fashion a guide on how to create and configure a SSH Tunnel with port forwarding to a remote MySQL server running FreeSSHd on Windows using Putty locally.
This article describes in step by step fashion a guide on how to install and configure a SSH server in a MySQL server running on Windows using FreeSSHd.
SSH tunnels provide a very effective means to access remote services and applications. Not only does it provide encryption of data between hosts, but it allows you to route connections between a sequence of servers, thus chaining connections. A common use of this method is to provide encrypted connections to MySQL servers so that user accounts can be limited to only “localhost” privileges, yet accessed from remote workstations without having to run MySQL+SSL.
The concept is simple, for example let’s say you have three servers: localhost (your workstation in America), a server in Europe, and a server in Japan. You want to access Apache running on port 80 on the Japan server but because of firewall restrictions you cannot access port 80 remotely, and to make things more difficult the Japan server only allows SSH connections from the Europe server’s IP. We can solve this by creating a SSH tunnel that forwards localhost port 8080 …[Read more]
A special extended edition of Tech Messages for 2011-09-21 through 2012-05-11:
- Understanding Linux CPU Load - when should you be worried?
Performance Testing - Load Balancer SSL Stress
This is a great simple test. Thanks, Corey!
- Mosh: the mobile shell
- Twitter open sources its MySQL secret sauce
This guy is serious about his lab!
I’ve been playing around with some quick system automation scripts that are handy to use when you don’t want / need to setup a chef or puppet action. I like to keep all of my hostnames and login details in a MySQL database (a cmdb actually) but for this example we’ll just use a couple of nested lists. This script executes commands in parallel across the hosts you choose in the menu system via the “pdsh” command, so make sure you have that installed before running. Alternately you can change the command call to use ssh instead of pdsh for a serialized execution, but that’s not as fun or fast. With some customizations here and there you can expand this to operate parallelized jobs for simplifying daily work in database administration, usage reporting, log file parsing, or other system automation as you see fit. Here’s the code. Comments welcome as always!
#!/usr/bin/env python ## NAME: menu_parallel_execution.py ## DATE: …[Read more]
Here’s a simple answer to a simple question. “How do I run a backup of MySQL to another machine without writing to the local server’s filesystem?” – this is especially useful if you are running out of space on the local server and cannot write a temporary file to the filesystem during backups.
Method one – this writes a remote file.
mysqldump [options] [db_name|--all-databases]| gzip -c |
ssh email@example.com "cat > /path/to/new/file.sql.gz"
Method two – this writes directly into a remote mysql
mysqldump [options] [db_name|--all-databases]| mysql
--host=[remote host] –user=root –password=[pass] [db_name]
This part will be about more software used in the process of writing the book. The last episode covered writing tools, file/version management and backups. What's up now is graphics programs, virtualization and PDF handling.
For outlining and structuring thoughts I like mind-maps. I know they are not for everyone, but if you like them and do not want to spend a lot of money on …[Read more]
8 Older Entries »