Remember “In the Trenches”? That’s How I Learned of LOPSA #lfnw

I chatted with a few of the guys at the LOPSA booth and mentioned that I first learned about LOPSA by listening to Kevin Devin’s In the Trenches podcast. This Friends In Tech show was insightful, informative and inspiring in that it presented intelligent and professional discussion about the profession of system administration, not merely righteous badmouthing of L-users. It turned me on to the SOTY contest, for which I was nominated in 2008 2007 and received a T-shirt, even.

Lightfoot Cycles: Smoothie

At LinuxFest Northwest I met an avid bicyclist: Victor Odlivak. He pointed out a northwest recumbent bicycle manufacturer named Lightfoot Cycles. Victor sent me a link to their Smoothie model. I am impressed by the features on this recumbent–it has a BionX power assist and a bench seat. This would appeal to riders that have hills to climb on their commute and might be averse to forward-bent posture on a upright bicycle. Long-arm handlebars are much more intuitive to operate than hip-level steering as well.

Lightfoot Cycles makes a variety of recumbent bikes and trikes.

Lightfoot also produces trikes (with power assist). I have opined here previously that I think recumbent trikes are an ideal HPV solution for mothers with children and groceries, or anyone with limberness challenges where balance or straddling a tall top-tube is not an option. Many of the Lightfoot trikes look like they can haul enough cargo to become an ice-cream cart, taco-stand, or even lug a keg of beer.

I’d lug a keg of beer on a trike, yeah!

Fun Saturday In a Kilt #lfnw #linux

Lots of subdued excitement at LinuxFest Northwest. It was a chilly ride that morning in the rain in a kilt. Bryan Lunduke’s talk was packed! My presentation on MySQL high availability was mellow fun, 45 minutes was not enough time. My son wanted to go home early so I skipped Alpha Geek to take him home. I got into some great conversations about ergonomics and making standing workspaces, and cycle commuting. I met more recumbent riders. Met a Seattle attendee who has been car free for 27 years — and TV free for 31. I wouldna cared about that a few years ago, but it’s certainly inspiring now. The brewing with Linux demonstration was neat. Renews my interest in learning to brew beer.

The after party was mellow and not as loud as last year and I think that was great. Would be great to see OSBridge now that I’ve met so many people who’ve presented there. Small planet–met Hal who knows someone at Bike Friday. Small world!

Looking forward to Sunday. Kilt was requested again–you got it! (You guys know it’s too big on me, right?)

LinuxFest Northwest 2010: MySQL Buffet

MySQL Buffet

This session covers topics in MySQL high availability and performance, centered mostly on your interests and questions.

Your Questions? Your Interests?

Jed Reynolds is not employed by MySQL but has been using it in a HA capacity since 2004

MySQL is a large topic and we can do a thumbnail overview followed by specific topics you’re interested in. I’ve listed the topics below in what I believe are the most important first –if you haven’t mastered backups, you have no business doing InnoDB tuning.

Backups and Recovery

  • mysql dump,
  • replication! do dumps from a pooled out replica
  • LVM snapshots
  • snapshot load issues
  • snapshot recovery: flush w/ read lock, InnoDB recovery
  • InnoDB Hot Backup
  • Maatkit replication checking correction, use cautiously

High Availability

  • replication: snapshot v. restore, LVM, InnoDB
  • load balancing: internal to application or external to application?
  • health criteria for pool-in/out
  • (replication lag, response time, disk free, system load, thread count)
  • ???? Multi-Master v. NDB?
  • Single master, multi mater, and fail over

High Performance

  • High Availability before high performance
  • mysqlperformanceblog
  • monitoring: slow queries, system load, swap, disk io, concurrent connections, replication lag
  • identifying “table pressure” and “update pressure” (large joins, inadequate indexes, bad queries)
  • indexes, multi-column indexes
  • EXPLAIN *show example, geoip data?*
  • query caching and when to not use it (large, infrequent results, frequently updated tables)
  • query caching, memcached, application level, or mysql write-thru
  • table engines suit different purposes

More Detailed Tunings can be found on the mysql performance blog. And softwareprojects.com.

Table Engines Notes

  • MyISAM, Memory, Merge, InnoDB, BDB (tx, fk)
  • Archive (fast inserts, compression, lacks indexes)
  • CSV text files
  • Black Hole
  • Federated, NDB
  • :-( Falcon – transactional, orphaned?
  • ALTER TABLE t ENGINE=foo
  • – 3rd party –
  • NitroEDB – security log management
  • BrightHouse – infobright, warehousing
  • DB2 (IBM)
  • Kickfire: column based db appliance with compression, FPGA processor, CentOS

MariaDB

This is the myontyprogram fork of mysql, and it includes other engines (PBXT) by default,  thread pools and XtraDB instead of InnoDB (same format).

Other Tricky Features

  • triggers
  • views
  • materialized views
  • memcached

Full Text Search

  • RDBMS != Full Text Search
  • Sphinx
  • Lucene, Solar

Security

  • grants
  • ssl
  • think layers: start outside your application and work your way thru it into your backup storage policies.

Don’t Forget to Backup!

Who Am I?

Jed Reynolds has been an IT pro since 1996. He recently completed his first year of car-free commuting–traveling about 2500 miles on his mountain bike, rain or shine. He also loves his Pentax K10D.