Jul 092018
 

If you have worked with mysql/mariadb/galera …. sooner or later you are going to have to do a restore.  Or if you are setting up a new master – slave, the size of the database can greatly affect how long it takes.  mysdqldump at one time was all that was available and for it for to be accurate, you need to lock tables which can affect production environments, do the dump in another shell, record the master log and position, transfer the files to another server, import the database, change master too ….. very very very time consuming.  So here is a way I have found that doesn’t lock the tables, doesn’t need to record the master log file or position, and does the dump and import in parallel greatly speeding things up.

Continue reading »

May 052018
 

We have all lost a hard drive at one time or another on a laptop or desktop computer and it always seems like it happens right after several weeks of not performing backups.  Last year, I lost about 15 years of research on an external drive that failed.  I had this system that has worked as long as I can remember where I simply swapped an external drive every two years with a new one after copying the data.  What failed on me though was I became over-confident in this system and wiped out the older drives in order to make room for something else, meanwhile the current drive decided to barf after only about 6 months of usage … literally within a couple weeks of me wiping the previous drives clean.  I was pretty pissed to say the least.  So, lesson learned, I decided to implement a better backup plan.  I wanted a way that would work and be simple.  Instead of a file server and transferring data over a wire, I wanted an external drive I could plug-in and leave plugged in while working or at home or in some motel.  I wanted full backups and I wanted it to be incremental to save space.  This was how I accomplished these tasks …

Continue reading »

May 012017
 

This is another way to quickly analyze nginx logs.  It will spit out the top 25 ip’s, domains, requests and some other data.  You may need to change the array value to match the format of your nginx logs.

It uses perl so it is very fast and takes just seconds to analyze hundreds of thousands of lines in a log file.  It can also be used for apache too or other column whitespaced logs.

Continue reading »

May 012017
 

I’ve wrote about this before in Using Sed to search between dates and offered a ad-hoc solution but the other day I came up with a much better solution using a little known option of ‘date’ command.  Using this new method, you just pass the time in minutes prior to current time.  I.e. if you want the last hour, you would simply type ‘./sed_time.sh 60’ and it will spit out the correctly formatted sed command like this:

$ ./sed_time.sh 60
sed -n '/01\/May\/2017\:07\:16\:15/,/01\/May\/2017\:08\:16\:15/ p'

Continue reading »

Sep 132016
 

I have shared this recipe at many different hiking forums, facebook groups, and with friends and family for years.  Several people have asked me to do a video and I just never seemed to get around to it.  Well, I finally got it done while video’ing my sheltowee trace trail thru-hike series.  In this video I show you how to make one of the ultimate breakfasts for hikers.  It is loaded with lots of calories, carbs, healthy fats, fiber, and protein that are needed for energy, maintain your weight, and to keep muscles from being sore.  I go into details about why I chose each ingredient and several variations of the recipe (I seldom make it the same way twice but the basic recipe remains unchanged).  The variations I go into are chocolate, vanilla, strawberry, peanut butter, and even a peanut-butter-chocolate aka receeses flavored.  Have a look at the video to learn how to make this awesome breakfast.  Share any tips or experiences you have with the recipe.

 

Sep 132016
 

This video goes in-depth into what I am taking on my sheltowee trace trail thru-hike.  You should also watch the first video regarding food too.

 

Sep 132016
 

First just let me say that there is nothing disgusting about this video, no limbs were lost, there was no blood, and the video has no gore.  However, if you ever go fishing, eventually some day this is going to happen and let me just tell you to remain calm, the fish hook will come out, it takes a whole lot more force than you think, it doesn’t hurt, and skin is very stretchy.  With that being said …. have a look at the arm I caught!

Sep 132016
 

Another video in the sheltowee trace series, but this time I talk about my food choices and how I buy them in bulk and repackage them to improve nutrition, save money, save weight.  I specifically am using mountain house meals in this video.

Continue reading »

Sep 132016
 

Last year I was going to hike the sheltowee trace trail as a thru-hike.  Due to the timing of buying a new house, I had to delay it.  This year I am going to complete it in the fall.  The sheltowee trace trail is currently 323 miles and runs from Burnt Mill Bridge in Big South Fork State Park, Oneida, TN to north of Moorehead, KY.  It runs primarily though the Daniel Boone National Forest.  It is known as “Kentuckys Longest Trail”, Trail 100, and is blazed with turtles because Daniel Boone who traveled the trail was named “Big Turtle” by the Sheltowee Indians.  You can find out more information at these locations:

The Forest Service USDA has a pdf file with info and trail

SheltoweeTrace.com has information

SheltoweeTrace.org has trail notes, information, reroute information, and a store where you can buy maps and ST Gear.

I have also done a few videos that I will link to on my website.  The first is my gear planning.  I am still a few weeks out from the hike and this could change, so I provided a link to my gear list that I am using for this hike at geargrams.com in the video.  I intend to do the hike at not more than 21 days, roughly 14 miles per day with approx 12 hours of daylight available in the fall.

Continue reading »

Aug 062016
 
view from eagles nest / eagle point buttress

This is the video from my recent hike at red river gorge on numerous unofficial and official trails to form a loop. It takes about 4.5 hours to complete, including stopping for lunch, and requires advanced back country navigation skills. I would recommend you use a gps for this hike (if you want the gpx file for this hike, just let me know via a comment on youtube).