dufault.info

Ramblings of a phone weenie, Linux sysadmin, and other things geeky

Android for the Vogue package updates to newest SDK

Martin (or dzo) has released another update for the Vogue, updating his release to the newest SDK available from Google, which was made available from last monday.
This release has broken a few custom applications made by some, as the phone keyboard now needs to be written, and the previous method used an on screen keyboard [...]

Transit directions now available via Google Maps on Windows Mobile

Apparently this was released without much fanfare, but Google Maps Mobile v2.2.0.16 for your Windows Mobile smartphone / pocketpc has been released, which means it now provides transit directions on the go.
This makes me extremely happy, but annoyed as well, as it was released quietly — I’m even subscribed to the Google Latlong blog.
Give it [...]

Updated Android SDK released

A new, updated Android SDK was released today.
Get it here:
http://android-developers.blogspot.com/2008/08/announcing-beta-release-of-android-sdk.html

Billix

I  wanted to mention that I’ve been looking for something like for this a bit — a USB key that comes with a way to install multiple Linux distributions.  While at work, we primarily use Gentoo, we still have a Ubuntu server or CentOS install to do occasionally, and it would be nice to have [...]

A Script to Optimize Fragmented Tables in MySQL

I wrote a BASH script that will run “optimize table” on any table fragmented. it’s pretty tidy, and you can supply usernames and passwords, and even run it against remote MySQL databases.
Here’s an example of it’s output:
root@lit [~]# mysqlFragFinder
MySQL fragmentation finder (and fixer) v0.7.2, written by Phil Dufault ( http://www.dufault.info/ )
Found 59 databases
Checking someforum_forum … [...]

MySQL Tuner

I’ve been using this for the past two weeks:
MySQL Tuner
I’ve used on servers running on MySQL 4.0, or 5.1 lately to tweak their preformances.  Itt’s an awesome script, and I recommend using it on any MySQL server you can find.

Making SSH connections to your frequent remote hosts faster with ControlMaster

I recently learned of a newish OpenSSH feature, a feature that let’s you reuse existing SSH connections.
If you want to enable this functionality on a per-host basis, then you can setup your ~/.ssh/config file like this:
Host *
ControlMaster no
ControlPath ~/.ssh/master-%l-%h-%p-%r.sock
Host someserver
Compression yes
ControlMaster yes
To enable it:
ssh -f -N someserver
After that, just ssh in like you would normally:
ssh [...]

Hotswap a SCSI, SAS, or SATA drive in Linux

There seems to be not a lot of information on Google about this, thus, I post.
At my work, the majority of our servers have hot-swappable drive bays — however, Linux doesn’t usually automatically notice the drive is gone. Worse, sometimes it doesn’t even notice new drives hooked up.
Now, SCSI and SAS both support hot-plugging [...]