Archive for the ‘Linux’ Category

« Older Entries

Some ZFS News

Friday, August 27th, 2010

Phoronix has a really well-written article on ZFS, including news on a company planning to release a CDDL-licensed linux kernel module.

ZFS is the holy grail of filesystems. Many Database Administrators have switched from Linux to Solaris because ZFS has much better snapshot support than LLVM, as well as good SSD support.

phoronix.com: Native ZFS Is Coming To Linux Next Month (Aug. 27, 2010)
phoronix.com: Btrfs, EXT4 & ZFS On A Solid-State Drive (Aug. 9, 2010)
phoronix.com: Benchmarking ZFS On FreeBSD vs. EXT4 & Btrfs On Linux (July 27, 2010)
phoronix.com: Running ZFS With CAM-based ATA On FreeBSD 8.1 (July 26, 2010)
github: Native ZFS for Linux
FreeBSD Wiki: ZFS

Posted in BSD, Business, Linux, OSCON, Open Source, Oracle, Storage, Tech, Toys | No Comments »

SVLUG meeting: Next-generation Samba with John Terpstra

Wednesday, August 4th, 2010

At the Silicon Valley Linux Users’ Group (SVLUG), John Terpstra lectured on the development history and status of Samba, a high-performance storage project he worked on, and ClearOS.

John is a technology manager and co-author of The Official Samba-3 HOWTO and Reference Guide (Bruce Perens’ Open Source Series).

He has previously worked as a VP at TurboLinux and Caldera on Linux clustering products. (I vaguely remember those products from way back around 2000.)

Some of the Samba tips he gave were:

  • trim your samba configuration file down to essential settings
  • Samba’s ActiveDirectory capabilities enable large networks to scale beyond Microsoft’s implementation
  • network bandwidth consumption can be reduced by proper configuration of WINS and broadcast vs. anycast

John also mentioned that Microsoft is contributing to Samba through their effort to make various protocols available to all POSIX operating systems and also interop testing meetings.

He gave an interesting overview of a document discovery project that required an elaborate storage system. He was able to setup a working test environment with RHEL, LVM, GFS2 and DRBD and various filesystems before switching to Glusterfs on top of Solaris ZFS for more efficient handling of directory metadata with deep directory paths containing 800,000 files per directory. (There were approx. 3 volumes containing 14 TB each.)

Thanks to Symantec for hosting the meeeting once again.

Axceleon acquires Turbolinux’s EnFuzion Clustering Solution (2002)

Posted in Linux, Open Source, Storage, Tech, Toys, User Groups | No Comments »

O’Reilly Open Source Conference 2010, Portland

Friday, July 23rd, 2010

Once again, the O’Reilly Open Source Conference (OSCON) was held in Portland, Oregon.

It was a good conference, and we had beautiful weather all week long.

Executive Summary

The themes promoted by the conference organizers were Cloud Computing, NoSQL, Emerging Languages (Scala, Erlang, Parrot, Go) and Android phone development.

The @oscon twitter channel was heavily used to coordinate amongst organizers and attendees. I used the TwiXtreme twitter client program on my BlackBerry.

Plug Computers were very popular in the Expo area. They are 5 watt ARM-based computers running Debian Linux that fit into a power brick-sized case and cost $99 to $129 depending on features. The Marvell booth had a few models on display, from GlobalScale (GuruPlug) and Ionics. High-end models have dual gigabit NICs, multiple USB ports, a WiFi access point and other expansion ports.

There was also continuing buzz regarding Facebook’s Flashcache SSD module (GPL v2) for linux, and also ZFS snapshots.

Tutorials

I went to the Gearman Cookbook tutorial, the first half of the Chef tutorial and some of the Cloud Summit talks.

The Gearman Cookbook tutorial was excellent. After a detailed overview of the Gearman architecture and implementations in Perl and C, a number of use cases were explored in detail, including before and after code samples. The talk was both easy to listen to as an overall survey, as well as providing immediately useful info for those wanting to deploy it.

The Chef tutorial was very detailed – too much so perhaps. I went to the first half only, since I am not planning to implement Chef soon (I use PXE and anaconda/kickstart with CentOS), and did not need that level of detail at this time. cfengine, puppet and chef are ops tools for configuring servers. Chef uses Ruby data structures for its configuration files, and has include files and other useful syntax. Basically, users can “code” server configuration, as if they were traditional apps.

I went to some of the Cloud Summit talks and BOFs, but found that anybody who has done a simple project using EC2 knew as much or more than the speakers, some I would call blowhards.

Marten Mickos, president of Eucalyptus, is refreshing in that he is always clear about being in it for the money, while also promoting Open Source.

Sessions

Some of the most memorable sessions to me were:

Introduction to MongoDB, Kristina Chodorow (MongoDB)

Kristina is the maintainer of the Perl and PHP drivers for MongoDB. She gave an overview of MongoDB, a NoSQL document store, and its command-line interface, which uses JavaScript.

Some day she will release a sharding tool for MongoDB.

Scaling SourceForge with MongoDB, Nosh Petigara (10gen), Rick Copeland (SourceForge.net / GeekNet)

Nosh and Rick gave an excellent review of incorporating MongoDB into the SourceForge site.

- SF query load is mostly read-only
- ops team benchmarked a few NoSQL candidates, and MongoDB won on performance
- original MySQL servers had 64 GB RAM. After migration to MongoDB, same server machines but only 8 GB RAM
- backup dumps are verified to be bitwise the same as masters
- have to be careful not to dump all documents in your database to the network or it will max out switches
- SF relies on first-class data centers and replication slaves, less worried about MongoDB mmap (not crash-safe)
- I personally looked at their performance numbers and site graphs (on an iPad), and the end result was impressive.

Perl Lightning Talks

As always, the Perl Lightning Talks are a highpoint of the conference.

The “cartoon” of Vincent Pit’s remarkable CPAN module(VPIT) contributions was both informative and hilarious. Vincent is a French Ph.D. candidate in advanced geometry.

Cloud BOF (3 Hours)

The Cloud BOF was disorganized, starting 30 minutes late and for some reason was subdivided into 4 audience groups. Startups and vendors trying to make a cloud sales push led the BOF, including cloud and DNS service providers.

The Health Regulations subgroup came up with a couple ways to make the Cloud palatable to regulators by using encryption on all data due to the multi-tenancy issues with sharing public VMs.

I was in the NoSQL group, which discussed general issues and particular successes. Memcached was the clearest winner, while some people also had success with MongoDB and Redis.

My neighbor was an engineer at Postrank.com. He said that they were happy with HAProxy, but much less happy with the unpredictable IO available when running MySQL on EC2. He also said to carefully look at storage volumes available to your instance, as one is a useful tmpfs. They use AuthSMTP to get around EC2 being generally blacklisted for outbound email.

Database BOFs

MySQL BOF

The MySQL AB engineering staff has left Oracle. Monty Program AB (21 staff) has the core developers, and Percona Inc. (32 staff) has the consultants. Oracle still has some of the InnoDB programmers.

The business plan for Monty Program AB is 60% commercially-sponsored MySQL development, and 40% community-request development. Monty would like commercial users of MySQL to sponsor patches that would benefit them.

Mark mentioned that using Nehalem instructions for CRC were much faster, and that Facebook was using partitions for truncating tables instead of doing multi-record deletes. (See his blog for more details.)

One person mentioned using a commercial backup tool, R1Soft, that inserts a linux kernel module to allow filesystem snapshots. He said to carefully test backup and restore in your environment, especially for filesystems greater than 1 TB which may exceed certain block counter limits. Peter said that some of his clients had used it with varying success.

It worked for him in his environment, and the file browser allows selective file restore (he uses it to restore by priority where a system runs multiple applications.) It starts at $299 for the Standard Edition, and also has MySQL Add-on and Enterprise Editions.

PostgreSQL BOF

The PostgreSQL BOF talked about 30 or so changes that went into version 9.

One of the most exciting new features is a native replication feature, called streaming replication (block-based.) The advantage over Slony-I replication is that Slony-I is trigger-based, so has a variety of issues included inability to replicate DDL commands.

Some of the developers mimed replication events, which was rather amusing to watch. Yes, it was taped.

PostgreSQL is released under the PostgreSQL Licence, which is BSDish.

Peter Zaitsev, co-founder of Percona, organized 3 BOFs, including XtraDB, XtraBackup, Maatkit, Percona Server, Sphinx Search and Running Databases on Flash Storage.

Sphinx Search BOF

Andrew Aksyonoff, the original programmer of Sphinx Search (GPL v2), couldn’t make it to OSCON (the good excuse was that he was busy coding), so Richard Kelm (Sphinx sales/customer support honcho) and Peter filled in (Percona is a business partner with Sphinx, and many of Percona’s clients use it.)

Some of the attendees were existing users, like myself, and some from HP and other companies were looking for a large-scale search solution or alternative to Lucene.

Monty mentioned that the latest MySQL 5.1 should be used, as there have been a number of performance and reliability improvements. Full-text search is supposed to be 10x faster than 5.0, and replication is nearly bug-free by now.

Sphinx Search now has real-time index updates in version 1.1.0 beta. Another very nice feature is SQL+FS indexing.

Here is the full Sphinx 1.1.0 changelog.

Running Databases on Flash Storage BOF

The Running Databases on Flash Storage BOF had a combination of MySQL and Postgres users who have tested or used most of the SSD products: FusionIO, violin, Intel, OCZ, etc. Everybody was happy with SSD IOPS performance, but less so with cost and metadata RAM requirements with the add-in boards (FusionIO may require 4 GB RAM for metadata.)

Peter said that 20% to 30% of his clients are already using SSD – across the spectrum of vendors and models. Some are also trying “massive RAM” solutions, like Cisco servers with 384 GB RAM.

Some users had 1+ TB Postgres databases with very thorny backup and mgmt. issues. One solution was to start a snapshot, but not do the copy operation.

Expo Notes

I had an enjoyable talk with Austin Hook, who has operated the OpenBSD Store for many years. He lives near Calgary, the center of OpenBSD/OpenSSH/PF development. He mentioned that some perennial financial contributors had stopped because of the recession, so here’s the donations link.

I also talked to some reps from a Brazilian outsourcing firm, ActMinds. They currently have 400 employees across Brazil and a sales office in Philadelphia. Brazil is only 2 hours ahead of EST. They said the minimum project size is 2 developers and developer turnover a low 5%/annum. Their pricing is $35 to $45/hour.

And I had fun handling the plug computers on display at the Marvell booth. The Ionics boards are amazingly densely populated.

Discussions

I had the opportunity to talk to a long-time Portland resident who works as a computer consultant. He said that the Portland economy is not doing great, and really hasn’t done well since old-growth logging was stopped after 90% of the forests were cleared. And although hundreds of miles of fiber optic has been laid downtown, it’s not available for residential use. However, the Beaverton area does have ubiquitous FTTH.

I also talked to somebody who attended the Emerging Languages talks. He’s working on his M.Sc. in Computer Science, so found those talks fascinating.

Twitter Humor

There were some humorous tweets:

- “my MongoDB and CouchDB mugs are fighting each other.”
- “I got one MongoDB mug, but need two to safely store coffee.”

Notes

Note to self: skip the nightly parties unless you have a date. The bars are too loud to talk to anybody.

Note to the O’Reilly conference organizers: use meetup.com for the BOFs like ApacheCon does. The average audience was about 10 people, and with meetup it would be 4x that.

OSCON 2010 Slides
Tim Bray: Desperate Perl Hacker
Youtube: OSCON 2010 videos
blip.tv: OSCON2010 videos
wikipedia: Plug Computer
Jeremy Zawodny: MongoDB Early Impressions

Posted in BSD, Business, Conferences, Linux, MySQL, OSCON, Open Source, Oracle, Perl, Storage, Tech, Toys, Travel, User Groups, i18n | 1 Comment »

MySQL Storage Capacity Planning

Sunday, July 11th, 2010

Planning how much storage is needed for MySQL databases is an issue that always comes up when buying new servers.

There’s 2 different general cases, OLTP and logging or Data Warehouse databases.

OLTP Database Storage Capacity Planning

Based on experience, I usually recommend total disk space available to MySQL of around 4x the size of the existing OLTP database to ensure enough working space and to make operations, mgmt. and recovery easier.

Let’s analyze why …

Disk space is needed for:

  • size of database data and index files ( du -sh /var/lib/mysql )
  • size of largest table x 2 if tempfiles or sortfiles are needed, per simultaneous process doing this – hopefully one “rogue” process at a time. (This is one of the main reasons to avoid ad hoc queries on production databases.)
  • size of each backup file, for backups that are stored locally (in a disaster, copying a large database over the network just takes too long for Internet services)
  • size of binlogs if stored outside /var/lib/mysql
  • 5% free for general OS processes
  • 5% to 20% is needed for LVM snapshot space if used

Sample Calculation

1 database + 2 backups + largest table (50% of db) * 2 = 3x, plus some binlog growth and 5% = 4x original database size.

For most users with basic hardware, all of that will be on 1 filesystem.

Surprisingly, even with separate filesystems for binlogs and backups, the maximum filesystem size doesn’t get reduced much:

  1. one backup needs to be on the main data filesystem, unless you want to spend several minutes copying it to /var/lib/mysql instead of a 1 second move. Possible exceptions are if you have a small database backup on SSD or other really fast device. But copying 50 GB at 400 MB/s would still take 125 seconds, or 2 minutes – just for the copy operation alone.
  2. table copies and sorts will be done in /var/lib/mysql unless $TMPDIR is set and working correctly.

Logging/Data Warehouse Database Storage Capacity Planning

For logging and Data Warehouse databases, capacity planning depends heavily on your initial planning and environment:

  • depending on SLA, a local copy may not be needed for quick recovery – just copy from the backup server over the network
  • some DW databases are effectively backed up by keeping the original load files available
  • canned reports can be EXPLAINed in advance to avoid tempfiles and sortfiles
  • storage engines (table types) consume space differently: Archive < MyISAM < Innodb
  • some storage engines, like Archive and MyISAM (but not Partitions in 5.1), allow filesystem-level read-only permissions, reducing recovery time substantially in case of power loss or fsck

I get alarmed when I see a filesystem with MySQL data on it more than 50% full, but far more so with OLTP usage than logging.

Regardless of planning, a cross-join on two multi-million row tables is guaranteed to consume all space. In that case, see the MySQL manual link below for the expected behavior.

MySQL 5.1 Manual: How MySQL Handles a Full Disk

Posted in Linux, MySQL, Open Source, Storage, Tech | No Comments »

MySQL Privilege System Still a Mess in 2010

Tuesday, July 6th, 2010

It’s already 2010, but the MySQL privilege system has been a mess for over a decade.

Most DBAs are aware that under heavy connection load, the MySQL internal resolver can have problems resulting in login failures, if you don’t use skip-name-resolve.

But I found what appears to be another serious bug …

After issuing a GRANT to create a new user with a wildcard hostname like ‘nagios’@'%.domain.com’ and REPLICATION CLIENT privilege recently to 10x 5.1.30-pro lightly-loaded slaves on CentOS 5.4 without skip-name-resolve, one of the slaves stopped accepting remote connections from any user name. (Local connections still worked fine for all users.)

That’s right … the only change was a GRANT.

Execute the GRANT command …


mysql> GRANT REPLICATION CLIENT on *.* to nagios@'%.domain.com' IDENTIFIED BY 'password';

On a remote server …


$ mysql -u user -ppassword -h hostname
Error 1045: Access denied for user 'user'@'hostname' (using password: YES)

The only thing a little odd about that machine was more than 1 hostname or domain name for that host.

So what can one do to lessen occurrences like this, or at least not get bitten as hard?

  • disable hostname lookups with skip-name-resolve
  • preconfigure grants before going into production
  • expect the unexpected when changing grants in any way
  • know how to quickly and cleanly shutdown the mysql instance and restart it, ideally with startup scripts.

How can one diagnose MySQL privilege bugs?

  • try connections from localhost and remotely
  • write a test script to attempt remote connections to help isolate problems
  • do show full processlist and look for login states or other odd entries
  • mysqladmin flush-hosts to reset the internal DNS host name cache.

MySQL Manual 5.0: 5.4.7. Causes of Access-Denied Errors
MySQL Manual 5.1: 5.4.7. Causes of Access-Denied Errors
MySQL Manual 5.1: 7.5.11. How MySQL Uses DNS
Jeremy Zawodny: Fixing Poor MySQL Default Configuration Values (2001)

Posted in Linux, MySQL, Open Source, Tech | No Comments »

PENLUG Meeting: Linux Open-Source Virtualization Roadmap

Wednesday, May 26th, 2010

Jamie Cameron, the author of Webmin, did a talk on linux virtualization at Peninsula Linux Users Group (PENLUG) in the Bayshore Technology Park in Redwood City tonite.

He’s working on 2 new products, Virtualmin and Cloudmin, so has had to learn the ins and outs of the current state of linux virtualization with respect to hosting.

His favorite is Xen, but for some reason Redhat is providing more support for KVM (Kernel Virtual Machine), which has several disadvantages including lack of CPU limiting. Redhat acquired KVM resources in 2008.

OpenVZ is popular with budget hosting providers, and Virtuozzo with those that want to pay.

Linux-VServer is the lightest weight alternative, similar to FreeBSD jails, but also the least maintained at this point.

He gave a demo of Cloudmin, including creating a guest and logging into it.

Since Linux has no ABI standard, he prefers developing in scripting languages like Perl for maximum portability.

wikipedia: webmin
Ganeti is a “cluster virtual server management software tool built on top of existing virtualization technologies such as Xen or KVM and other Open Source software.”

Posted in Linux, Open Source, Perl, Tech, Toys | No Comments »

ClusterIt dtop Command Ported to Linux

Tuesday, May 25th, 2010

The light-weight ClusterIt toolkit mostly worked on linux, but dtop (distributed top) still expected BSD-style top syntax.

Here’s a diff I wrote to make dtop work on recent versions of Linux (tested on CentOS 5.5 x86_64):

$ diff dtop.org.c dtop.c

311a312,322
> 	char buf2[30];
>
> 	if (strstr(c, "Swap:") != NULL) {
> 		sscanf(c, "Swap: %30s total, %*s used, %30s free", buf, buf2);
> 		nd->swap = dehumanize_number(buf);
> 		nd->swapfree = dehumanize_number(buf2);
> 		nd->inactmem = nd->wiredmem = nd->execmem = 0;
> 		return;
> 	}
>
>
344a356
> #if ! defined(__linux__)
364a377
> #endif
470a484,486
> #if defined(__linux__)
> 		case 11:
> #else
471a488
> #endif
517a535,539
> #if defined(__linux__)
> 		} else if (strstr(c, "Tasks:") != NULL) {
>                         sscanf(c, "Tasks: %d ",&nodedata[nn].procs);
> #else
519a542
> #endif

The output of dtop on linux looks like this:

HOSTNAME  PROCS  LOAD1  LOAD5 LOAD15 ACTIVE  INACT   FILE   FREE SWPFRE SWUSED
  g00-int     64   0.11   0.04   0.01	   0	  0	 0  7345M  2047M  0.00%
  g01-int     64   0.00   0.01   0.00	   0	  0	 0  7033M  2047M  0.00%
  g02-int     61   0.08   0.02   0.01	   0	  0	 0  6980M  2047M  0.00%
  g03-int     64   0.16   0.06   0.01	   0	  0	 0  7011M  2047M  0.00%
  g04-int     64   0.04   0.04   0.01	   0	  0	 0  6996M  2047M  0.00%
  g05-int     61   0.02   0.01   0.00	   0	  0	 0  7424M  2047M  0.00%

Here is the final, hardened version of dtop.c that uses secure C programming techniques (strn API and double-free safe.)

My long-term preference would be to rewrite dtop in Perl since parsing text input in old-school C is brittle.

Also, dtop should be able to handle top results from heterogeneous systems, and the linux ifdefs contribute to preventing that.

And here are some of the debugging commands I used:

ulimit -S -c unlimited > /dev/null 2>&1
valgrind -v --leak-check=full --show-reachable=yes --track-origins=yes ./dtop
gdb ./dtop core

Dan Saks: Why size_t matters
Karpov: About size_t and ptrdiff_t

Posted in BSD, Linux, Open Source, Tech, Toys | No Comments »

ATA over Ethernet

Thursday, May 13th, 2010

AoE This is a placeholder post for links on AoE, a low-cost LAN-based SAN protocol.

wikipedia: ATA over Ethernet
linux-mag: The ATA over Ethernet (AoE) Protocol (2005)
techrepublic.com: ATA over Ethernet: Worth considering? (2006)
Coraid
Coraid Linux AoE Drivers
Kernel Korner – ATA Over Ethernet: Putting Hard Drives on the LAN
StorageMojo.com: An Open-Source SAN (2006)
ServerFault.com: Cheap but Highly Available Shared Storage?
WinAoE
VMworld 2009: AoE Basics Slides

Tags:
Posted in Linux, Open Source, Storage, Tech, Toys | No Comments »

« Older Entries