Nuffing.com

MySQL Installation Process Checklist
All DBAs, regardless of experience level, should follow a written process when setting up a new server.  There are just too many steps to neglect doing so and many of the steps you are likely to forget have little to do with MySQL.
Naturally, every company has a different process.  The process we outline below is one we have used in the past and focuses on working through the Change Management process, setting up backups and monitoring, and focusing on good communication with team members and clients as well as ensuring documentation of your work.  Hopefully this article will give you some ideas on implementing your own process document.
Below are the steps we have documented in the past when creating a new installation of MySQL:
Initial Change Management Processes
Edit the ticket and set to Waiting on Customer
Send an email to the requestor with the new database questionnaire document
Once completed questionnaire is received and you are ready to start, set ticket status to “Work in Progress” and save ticket
Perform the MySQL installation as documented in your standards documents
Verify MySQL configuration is accurate and caches, logging, enabled as dictated by SOP
Install database schema as supplied by customer
Create user account(s) for app and any other users with minimal required privileges as requested by customer. Ensure that all passwords comply with your company’s Password Policy
Perform any requested loading of the database utilizing data or process outlined by customer
Test that database is accessible over the network with the created user account(s)
Setup Monitoring
Open the original request in your Change Management system. If this is Production, add a comment to the ticket stating that you are setting up monitoring user account.
Create a monitoring account with minimal privileges such as USAGE and a password conforming to your Password Standards.
Ensure that database monitoring thresholds are properly set in monitoring program
Setup Backups
Add a comment to the ticket stating that you are setting up backups
Once backup disk is mounted, install backup software (if needed), configure it, and perform a test backup to the new backup directory and test email functionality
Verify that the backup appears to be valid
Verify that backups are running as expected daily
PerformanceTesting
Use whatever tool you have at your disposal to test performance of the new server(s).  Tools such as sysbeench, mysqlslap, and more are easily available and configurable
Closing Activities for Change Management
Update Change Management ticket with a summary of what’s been done
Notify the requestor via email that the server is available for testing
Ask customer if it is acceptable to close the ticket
Documentation
Add the information about the server to your team’s documentation
If customer is okay with doing so, change status of ticket to “Closed” and save the ticket
via Planet MySQL
MySQL Installation Process Checklist

Encrypting your sensitive data is important, but not all encryption tools are the same. Last week we asked you for your favorites, and then we looked at the top five file encryption tools and put them head to head. Now it’s time to crown the community favorite.

VeraCrypt, the spiritual (and in many ways, including its code, actual) descendant of TrueCrypt, took the top spot by a wide margin, bringing home close to 41% of the overall vote. It’s free, (mostly) open source, cross-platform, offers strong encryption, and offers all of the great features TrueCrypt did before its developers abandoned it.

Second place with 20% of the overall vote was 7-Zip, a file compression tool that also has the ability to create encrypted archives. It’s also free and cross-platform, and easy to use. Third place with close to 16% of the vote went to GNU Privacy Guard—more a platform than a product, but one with tons of individual tools that support its preferred encryption method, PGP. In fourth place with over 15% of the votes cast was Microsoft’s BitLocker, built in to and already available in Windows Vista and Windows 7 (Ultimate and Enterprise), and into Windows 8 (Pro and Enterprise), as well as Windows Server (2008 and later). Bringing up the rear with just over 7% of the overall vote was AxCrypt.

For more on each of these and the honorable mentions not listed here, make sure to head back to our full Hive Five feature to read more.

The Hive Five is based on reader nominations. As with most Hive Five posts, if your favorite was left out, it didn’t get the nominations required in the call for contenders post to make the top five. We understand it’s a bit of a popularity contest. Have a suggestion for the Hive Five? Send us an email at tips+hivefive@lifehacker.com!

via Lifehacker
Most Popular File Encryption Tool: VeraCrypt

Jerky is the on-the-go snack that has fueled Native Americans, pioneers, and astronauts alike. And it’s easy to make at home. This method, popularized by Alton Brown, uses an ordinary box fan and air filters to dry the meat.

Read more on MAKE

via Make:
New Project: Simple Box-Fan Food Dehydrator, a’la Alton Brown

To make a spark that can light a fire, all you need is flint, tinder, and some good old fashioned friction. It’s a fire-making method that’s been around for thousands of years. But sparks are tiny, delicate things, so if you want to turn one into a roaring flame, you have to be deliberate about […]

via The Art of Manliness
The Ultimate Firestarter: How to Make Char Cloth

If you like knives, blade steel is important to you.  Blade steel is the heart of a knife, and good blade steel is very important.  But steels change and new steels are released on an almost yearly basis.  Most steels start out in cutting tools for industrial applications.  A small handful, S30V, S35VN, and Sandvik’s 14C28N,[…..]
via AllOutdoor.com
Six Upgrade-worthy Blade Steels

Keeping your personal data safe doesn’t have to be difficult—as long as you keep the sensitive stuff encrypted and under your control. That’s why this week we’re looking at the five best file encryption tools you can use to encrypt your data locally so only you have the key.

Earlier in the week we asked you for your favorite file encryption tools, and you gave us tons of great nominations, but as always, we only have room for the top five.

For the purposes of our roundup, we’re focusing on desktop file encryption tools – the ones you use on your own computer to encrypt your own private data, not cloud services that promise to encrypt your data, or business services that say they offer encryption. The goal here is to find the best tools you can use to lock down your sensitive files—whether they’re photos, financial documents, personal backups, or anything else—and keep them locked down so only you have the key. For those unfamiliar with the topic, we have a great guide on how encryption works, and how you can use it to keep your own data safe.

With that out of the way, here are your top five, in no particular order:

VeraCrypt (Windows/OS X/Linux)

VeraCrypt is a fork of and a successor to TrueCrypt, which ceased development last year (more on them later.) The development team claims they’ve addressed some of the issues that were raised during TrueCrypt’s initial security audit, and like the original, it’s free, with versions available for Windows, OS X, and Linux. If you’re looking for a file encryption tool that works like and reminds you of TrueCrypt but isn’t exactly TrueCrypt, this is it. VeraCrypt supports AES (the most commonly used), TwoFish, and Serpent encryption ciphers, supports the creation of hidden, encrypted volumes within other volumes. Its code is available to review, although it’s not strictly open source (because so much of its codebase came from TrueCrypt.) The tool is also under constant development, with regular security updates and an independent audit in the planning stages (according to the developers.)

Those of you who nominated VeraCrypt praised it for being an on-the-fly encryption tool, as in your files are only decrypted when they’re needed and they’re encrypted at rest at all other times, and most notably for being the spiritual (if not almost literal) successor to TrueCrypt. Many of you praised them for being a strong tool that’s simple to use and to the point, even if it’s lacking a good-looking interface or tons of bells and whistles. You also noted that VeraCrypt may not support TrueCrypt files and containers, but can convert them to its own format, which makes moving to it easy. You can read more in its nomination thread here.

---

AxCrypt (Windows)

AxCrypt is a free, open source, GNU GPL-licensed encryption tool for Windows that prides itself on being simple, efficient, and easy to use. It integrates nicely with the Windows shell, so you can right-click a file to encrypt it, or even configure "timed," executable encryptions, so the file is locked down for a specific period of time and will self-decrypt later, or when its intended recipient gets it. Files with AxCrypt can be decrypted on demand or kept decrypted while they’re in use, and then automatically re-encrypted when they’re modified or closed. It’s fast, too, and allows you to select an entire folder or just a large group of files and encrypt them all with a single click. It’s entirely a file encryption tool however, meaning creating encrypted volumes or drives is out of its capabilities. It supports 128-bit AES encryption only, offers protection against brute force cracking attempts, and is exceptionally lightweight (less than 1MB.)

Those of you who nominated AxCrypt noted that it’s really easy to use and easy to integrate into your workflow, thanks to its shell support. If you’re eager for more options, it also has a ton of command line options, so you can fire up the command prompt in Windows and perform more complex actions—or multiple actions at once. It may not support the strongest or most varied encryption methods available, but if you’re looking to keep your data safe from most threats, it’s a simple tool that can lend a little security that your data—like files stored in the cloud on Dropbox or iCloud, for example—are secure and convenient to access at the same time. You can read more in this nomination thread here and here.

---

BitLocker (Windows)

BitLocker is a full-disk encryption tool built in to Windows Vista and Windows 7 (Ultimate and Enterprise), and into Windows 8 (Pro and Enterprise), as well as Windows Server (2008 and later). It supports AES (128 and 256-bit) encryption, and while it’s primarily used for whole-disk encryption, it also supports encrypting other volumes or a virtual drive that can be opened and accessed like any other drive on your computer. It supports multiple authentication mechanisms, including traditional password and PINs, a USB "key," and the more controversial Trusted Platform Module (TPM) technology (that uses hardware to integrate keys into devices) that makes encryption and decryption transparent to the user but also comes with a host of its own issues. Either way, BitLocker’s integration with Windows (specifically Windows 8 Pro) makes it accessible to many people, and a viable disk encryption tool for individuals looking to protect their data if their laptop or hard drives are lost or stolen, in case their computers are compromised, or a business looking to secure data in the field.

Of course, it goes without saying that BitLocker was a contentious nomination. More than a few of you touted BitLocker’s accessibility and ease of use, and many of you even praised its encryption for being strong and difficult to crack. Many of you noted that you switched to BitLocker after the developers of TrueCrypt suggested it. Others, however, brought up the assertion made from privacy advocates that BitLocker is compromised and has backdoors in place for government security agencies (from multiple countries) to decrypt your data. While Microsoft has officially said this isn’t true and maintains there’s no backdoor in BitLocker (while simultaneously maintaining the code as closed source—but available to review by its partners, which include those agencies), the assertion is enough to make more than a few of you shy away. You can read more about the criticism and controversy at the Wikipedia link above, or in the nomination thread here.

---

GNU Privacy Guard (Windows/OS X/Linux)

GNU Privacy Guard (GnuPG) is actually an open-source implementation of Pretty Good Privacy (PGP). While you can install the command line version on some operating systems, most people choose from the dozens of frontends and graphical interfaces for it, including the official releases that can encrypt everything from email to ordinary files to entire volumes. All GnuPG tools support multiple encryption types and ciphers, and generally are capable of encrypting individual files one at a time, disk images and volumes, or external drives and connected media. A few of you nominated specific GnuPG front-ends in various threads, like the Windows Gpg4Win, which uses Kleopatra as a certificate manager.

Those of you who nominated GnuPG praised it for being open-source and accessible through dozens of different clients and tools, all of which can offer file encryption as well as other forms of encryption, like robust email encryption for example. The key, however, is finding a front-end or a client that does what you need it to do and works well with your workflow. The screenshot above was taken using GPGTools, an all-in-one GnuPG solution that offers keychain management as well as file, email, and disk encryption for OS X. You can read more in its nomination thread here.

---

7-Zip (Windows/OS X/Linux)

7-Zip is actually a lightweight file archiver—and our favorite archive utility for Windows. Even though it’s amazing at compressing and organizing files for easy storage or sending over the internet, it’s also a strong file encryption tool, and is capable of turning individual files or entire volumes into encrypted volumes that only your have the keys to. It’s completely free, even for commercial use, supports 256-bit AES encryption, and while the official download is Windows only, there are unofficial builds for Linux and OS X systems as well. Most of 7-Zip’s code is GNU LGPL licensed and open to review. Compressed and encrypted .7z (or .zip, if you prefer) archives are easily portable and secure, and can be encrypted with passwords and turned into executables that will self-decrypt when they get to their intended recipient. 7-Zip also integrates with the shell of the operating system you’re using, making it usually a click away from use. It’s also a powerful command line utility.

Those of you who nominated it noted that it may not have the most robust user interface, but it gets the job done, and many of you have it installed anyway specifically for its robust file compression and decompression capabilities. You noted it’s fast, flexible, free, and easy to use, and while it may not be the fastest file encryption tool (and it’s not capable of whole volume or disk encryption), it gets the job done—especially for encrypting files you need to send to someone else and actually have them be able to access without jumping through too many hoops. Some of you noted that 7-Zip’s encrypted volumes are flexible—perhaps too flexible, since new files added to an encrypted archive aren’t encrypted (you’d have to extract them all and make a new archive for that), but it’s otherwise a minor ding. You can read more in its nomination thread here.

---

Now that you’ve seen the top five, it’s time to put them to an all-out vote to determine the community favorite.

---

Honorable Mentions

We have two honorable mentions this week. First and foremost is Disk Utility (OS X), which is bundled with OS X as a disk repair and management tool. Disk Utility can also encrypt drives and volumes, and since OS X can create a compressed volume just by right-clicking a file, series of files, or a folder and selecting "Compress," Disk Utility makes encrypting anything you want extremely easy. Plus, it’s built in to OS X, so you don’t need to install anything else. You can read more about it in its nomination thread here.

Second, we should tip our hats to the venerable old TrueCrypt, our old champion, which actually earned a number of nominations in the call for contenders thread. We covered the meltdown of TrueCrypt when it happened, with the developers abruptly abandoning the project claiming that it’s no longer secure, in the middle of their independent security audit. The developers suggested switching to BitLocker, and pushed out a new version that’s widely considered compromised. However, the older version, 7.1a, is still widely regarded as safe, even though development on it has been abandoned, and the tool has been left without security updates since then. Even so, security analysts split on whether you should trust TrueCrypt or move on to another encryption utility. Many people stand by it even though it’s a dead project, others have built their own projects on top of it (see VeraCrypt, mentioned earlier), and others keep using the last safe version. We can’t recommend TrueCrypt anymore ourselves, but you can read more in its nomination thread here, and over at Steve Gibson’s page dedicated to TrueCrypt here.

Have something to say about one of the contenders? Want to make the case for your personal favorite, even if it wasn’t included in the list? Remember, the top five are based on your most popular nominations from the call for contenders thread from earlier in the week. Don’t just complain about the top five, let us know what your preferred alternative is—and make your case for it—in the discussions below.

The Hive Five is based on reader nominations. As with most Hive Five posts, if your favorite was left out, it didn’t get the nominations required in the call for contenders post to make the top five. We understand it’s a bit of a popularity contest. Have a suggestion for the Hive Five? Send us an email at tips+hivefive@lifehacker.com!

Title photo by andrey_l (Shutterstock).

via Lifehacker
Five Best File Encryption Tools

Built and designed in the 1960s after the A-12 Oxcart, the SR-71 Blackbird is still the fastest, most vanguardist air-breathing airplane in the history of aviation. These once classified photos reveal how Lockheed built both birds in secret, in California. They look taken at the Rebel base in Hoth.

"Everything had to be invented"

The A-12 and the SR-71 were a completely different design from anything else before it—and everything after, as time has demonstrated. At the time, many of the technologies needed to make these airplanes were considered "impossible." And yet, thanks to Kelly Johnson and the amazing team at engineers and scientists at Lockheed’s Skunk Works, they were invented from scratch—in twenty months.

According to Lockheed Martin’s official account, Kelly Johnson—the engineer who made the A-12 Oxcart and the SR-71 Blackbird—"everything had to be invented. Everything." From the The Pratt & Whitney J58 engines—a technological feat still unsurpassed by today’s mass manufactured airplanes—to its titanium skin—capable of surviving temperatures from 315C (600F) to more than 482C (900F)—and composite materials. Its landing gear, for example, is "the largest piece of titanium ever forged in the world." Ironically, the United States did not have enough titanium to build these airplanes, so they have to buy it from the Soviet Union. Imagine that: Buying the only material in the world that could make an spy plane from the country you wanted to spy.

Major Brian Shul, one of the SR-71 pilots and author of Sled Driver, tells more about the manufacturing process:

Lockheed engineers used a titanium alloy to construct more than 90 percent of the SR-71, creating special tools and manufacturing procedures to hand-build each of the 40 planes. Special heat-resistant fuel, oil, and hydraulic fluids that would function at 85,000 feet and higher also had to be developed.

Thanks to these technologies and his skills, Shul survived many surface-to-air missile attacks (check out this amazing story about how the Blackbird saved his neck over the skies of Libya.) No Blackbird was ever shot down.

These photos are a testimony to this amazing engineering and manufacturing feat:

Cutaway illustrations of the twin cockpit variant of the SR-71. Notice the inlet funnels that increased the air speed in front of the J58 engines.

Lockheed’s Skunk Works’s manufacturing plant in Burbank, California. Later, both the Oxcart and the Blackbird would be coated with an special black paint that reduced the temperature by 23C (75F) and had radar absorbing capabilities.

Notice the titanium panels forming the skin of these birds.

Only 50 Blackbird airframes were built. "The dies or molds were destroyed as directed by then Secretary of Defense McNamara to prevent any other nation from building the aircraft."

Final A-12 Oxcart ever produced: Article 133

Close up of one of the SR-71s in manufacturing

Another angle, from the other side

Production schedule for the SR-71

The J-58 engines

This is the exhaust of the J-58 engine. It could reach temperatures of 1760C (3200F).

The Blackbirds kept flying long after their retirement from the USAF. One of them stayed at NASA: Here’s a photo from the Armstrong Flight Research Center (then Dryden) of an SR-71 being retrofitted for test of the Linear Aerospike SR Experiment (LASRE).

The finished Blackbirds

And now more Blackbird porn because I know you love it

The analog cockpit was the only thing that, compared to the rest of futuristic technologies used in the Oxcart and Blackbird, seems completely out of place:

You can see it in ultra-high definition here. And get the explanation of how it works from a SR-71 pilot here.

One last factoid:

478 total people have flown the Blackbirds. More people have climbed to the top of Mount Everest than has flown this aircraft. Although a few Lockheed crewmembers were killed during the testing stages of the Blackbird, the U.S. Air Force never lost a man in the entire 25 years of active service. The SR-71 flew for 17 straight years (1972-1989) without a loss of plane or crew. Considering the environment the Blackbirds flew in, that is an enviable safety record.

According to Kelly Johnson, no SR-71 was ever touched by any of the more than 1,000 missiles launched at these birds since its first mission to 1981.

---

SPLOID is delicious brain candy. Follow us on Facebook or Twitter.

via Gizmodo
Fascinating photos reveal how they built the SR-71 Blackbird