“Good Leadership Is Always Human”

"Good Leadership Is Always Human"

“Good leadership is always human. It takes time and energy. It is hard work. Which is why good leadership is so special when we find it.” – Simon Sinek

While it seems straightforward—and maybe even a little obvious—you can become preoccupied with the wrong things when taking the lead. It’s easy to get lost thinking about results, output, performance, and the sorts of quantifiable metrics that can look a lot like success. Ultimately, however, you don’t get to those points without successful human interaction. If you want to lead well, you can’t forget the human component.

Good Leadership | @simonsinek via Swissmiss

Photo by Jirsak (Shutterstock).


via Lifehacker
“Good Leadership Is Always Human”

MySQL 5.6 DBA Beta Exam IS TOUGH!

I have just finished the MySQL 5.6 DBA Certification Exam Beta and my best advice is to study, study, study. The exam is in beta which means three things. The first is the exam is three hours long and it took me all that time to finish. Normally I am very fast test taker which has helped me earn three college degrees and enough computer related certifications to wallpaper a decent sized house. So if you are a slow reader, suck down a gallon of high octane coffee before your test appointment.
Secondly consider that some of the question will need to be cut out or reworked as the exam becomes production to fit the normal two hour test window Pearson View prefers. But in the beta period you over test and cut out the questions that prove less than satisfactory. So if you see a questions that triggers the ‘where the heck did they find that?’ reflex, you can hope that it gets determined to be a question to be relegated.
Thirdly and lastly is that while in beta you will not get your grade for several weeks. There is not immediate pass/go, pass/fail, or thumbs-up/thumbs-down. You will walk out wondering just exactly how you did. And you will also have some mental notes that you will want to go to the manual to crosscheck.
I have heard some say that because of a lack of a Certification Guide, that the only way to pass will be to take the DBA Class and that is bull cookies. I had access to the course materials (one perk of working for Oracle is the access to mountains of docs) and there are numerous items on the exam not covered in them or the class exercises. You had better go through the exam objectives with a fine tooth comb and spend a good deal of time on the new features of replication, performance schema, user administration, and everything else new in 5.6 or you will be wasting your time. I estimate that a complete certification guide for 5.6 would at least twice the size of the 5.0 version and kill off too many trees.
I do have a big hint. The PV testing software will let you right click on any item on the list of answers and strike it out to help you eliminate multiple choice options that are obviously wrong. So pick off the obviously wrong answers and mark the question for review if you get stuck.
So how does it compare to the ol’ 5.0 DBA exam? Well, the questions are much more rigorous in testing your knowledge but less picky on wording. Or to be more precise, the hard part is the material and not the way the questions are asked. In the past a candidate had to memorize a lot of minutiae and a little of that is still there. But the overwhelming majority of the questions cover items that a DBA will have to handle as part of the job.
And how does it compare to the ‘hands-on’ 5.1 DBA exam? Both measure practical DBA material and my preference will be on the hands-on approach. But you can not cover the breath of material as in the 5.6 exam with a hands-on exam.
via Planet MySQL
MySQL 5.6 DBA Beta Exam IS TOUGH!

​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

Not too long ago, Amazon introduced Glacier, an online storage/archiving solution that starts at just a penny per GB per month. Depending on your storage needs, Amazon Glacier could be the most cost-efficient way to back up your data for a lifetime. Here’s what you need to know about it and how to set it up.

How Amazon Glacier Works

​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

Amazon Glacier is a low-cost, online storage service where you pay every month only for what you use (online storage space plus data transfers). It’s like Amazon’s other inexpensive storage service, S3—only about 10 times cheaper. Why does it cost so little? Amazon’s designed Glacier to be optimized for data you don’t access often—think long-term storage of photos and videos, archived project files, etc. You’re not supposed to use it to regularly retrieve files or constantly delete them off the servers, and if you do it’ll cost you.

The most important thing to know about Amazon Glacier is that if you want to retrieve files, it takes 3 to 5 hours to complete. So this isn’t for backing up and quickly retrieving a file you accidentally deleted and need right away.

Your files and folders are stored in Amazon Glacier containers called "vaults." Amazon calls all the stuff in your Glacier vaults "archives." These can be a single file or you can zip multiple files and folders into a single archive, which can be as large as 40TB. If you ever need to retrieve your data, you request it by archive. (They don’t want you downloading an entire vault at once; you’ll pay dearly if you want to.)

Finally, pricing is a bit complicated and Amazon doesn’t provide software for uploading and downloading your data, but there are great third-party tools you can use. (See below)

Amazon Glacier vs. CrashPlan and Other Backup Services

So why bother with all these quirks when you can just use CrashPlan, Backblaze, or another popular online backup service? To be honest, if you just want a set-and-forget online backup system, one of those online solutions would be best.

However, if you’re already backing up your data locally to a NAS or external drive, and perhaps also using cloud storage and syncing like Dropbox or Google Drive, Amazon Glacier can be your dirt cheap offsite backup. (Remember the 3-2-1 backup rule?) That way, you have your local backup for retrieving deleted files, restoring your system after a crash, or whatever else. Your Amazon Glacier backup is there just in case your computer and backup drive both get ruined, like in a fire or an earthquake.

All this depends on how much you want to store offsite, though. Let’s compare with our favorite online backup, CrashPlan:

  • CrashPlan’s 10GB backup plan for one computer is $2.99 a month. For that same amount of data on Glacier it’s roughly $0.10 a month. (Using the Glacier server region US East as an example, since it’s one of the lowest priced ones.)
  • CrashPan’s unlimited backup for one computer is $5.99 a month. That’s about the same you’ll pay per month to store 600GB on Glacier.
  • Other examples: 100GB would be $0.88 a month on Glacier; 200GB would be $1.88 a month; 300GB would be $2.88 a month.

(CrashPlan has more attractive pricing if you pay for a year or more in advance rather than monthly, let’s compare apples to apples.) So essentially, if you have less than 600GB to backup offsite, Glacier is the more affordable option. Amazon Glacier is to online storage as pay-as-you-go or prepaid cell phone plans are to wireless plans.

And again, this is assuming that you don’t need to retrieve any of that data regularly (e.g., you use your local or Dropbox backups instead), because, as I mentioned earlier, there are retrieval fees.

To see if it’s worth it for you, use this Glacier Cost Calculator, putting in the size of the data you want backed up. (The early deletion fee is if you delete data uploaded in the last three months; it comes out to about $0.03 per GB—or the amount you’d spend storing it for three months, so you might as well just keep it there.)

How to Back Up to Amazon Glacier

If it sounds good to you, getting started with Glacier is pretty easy.

Step 1: Sign Up for Amazon Web Services

First, sign into your Amazon account or create a new Amazon Web Services account here. You’ll need to enter a credit card, but won’t be charged until you start using Amazon Glacier/AWS. You’ll also have to verify your identity over the phone and then choose a customer support plan (most people will want the free version).

While you’re at it, protect your account with multi-factor authentication (MFA) on the last screen of the setup, a.k.a. two-factor authentication, a second layer of security for your data. If you have Google Authenticator on your mobile device, for example:

  1. Select "virtual MFA" from the types of authentication methods on Amazon
  2. Then, in Google Authenticator, go to the options menu to Add an account > scan QR barcode
  3. With your mobile device, scan the barcode Amazon displays on the screen
  4. Then enter the authentication codes from Google Authenticator into the Amazon security page

Step 2: Create a Security Access Key for Your Amazon Glacier Account

​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

Next, head to the Security Credentials page in Amazon Web Service, expand the "Access Keys" section, and click the "Create New Access Key" button. You’ll download the key file (CVS format) to your computer, which has the numbers required for Amazon Glacier client software to access your files.

Step 3: Create a Vault in Glacier

​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

In the Amazon Glacier console/homescreen, click the Create Vault button. You can also click the region name at the top navigation bar to change to a different data center. (Amazon requires you to choose a data center for your Glacier storage: e.g., US East, US West, Asia, EU. These have different pricing schemes. In general, the US East and US West-Oregon are less expensive, but you’ll want to check the cost calculator mentioned earlier.)

Just name the vault, select if you want notifications on activity for the vault, and you’re done. You can have multiple vaults (e.g., "Photo archive" or "Software backups") in your Glacier account—as many as 1,000 vaults per region—if you want to organize them better. Also, many Glacier clients allow you to create vaults directly in the software.

Step 4: Download and Install an Amazon Glacier Client

Third-party software makes uploading, syncing, and automatically backing up your data easy. I’m using Fast Glacier (free, Windows) because it has a lot of features, like bandwidth throttling, drag-and-drop support, a sync tool, and support for smart data retrieval (this saves you money if you have to retrieve files, by staggering the job requests). Other popular clients include CloudBerry Explorer and previously mentioned Arq for Mac. Digital Inspiration has a nice overview of several Glacier clients.

For the rest of these examples, I’m going to use Fast Glacier screenshots, but they should be similar in other programs.

Step 5: Connect Your Amazon Glacier Client to Your Account

​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

Open up the Security Access Key file you downloaded to grab the Access ID and Secret Key codes to put into your client. Once you do so, you’ll see the vaults you created and can upload files and folders to them.

​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

In FastGlacier and CloudBerry Explorer (and probably the other clients), you can simply drag-and-drop folders and files to start the upload. You can do this with mapped network drives—great for backing up a NAS. This is where you would also download or delete files (knowing the limitations mentioned above).

Step 6: Automate Your Backups

​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

FastGlacier has a convenient comparison and syncing tool (under Files > Compare with local folder), where you can see which files are missing from Glacier and choose to synchronize them (with options to upload only changed files, new files, or missing ones). This needs to be manually launched, though.

To automate the backups in FastGlacier, you’ll need to do it with Windows Task Scheduler. In Task Scheduler, create a new task, and point it to the FastGlacier sync script (C:\Program Files\FastGlacier\glacier-sync.exe). In the arguments for the task, put in the name of your Glacier Account, source folder on your computer, region you’ve selected for your vault, Vault name and directory where you want to backup to. See FastGlacier’s command line older sync tool instructions or Get in the Sky for more examples.

As an alternative, CloudBerry Backup ($29.99, Windows) is more of a traditional backup tool for this job or you can even do it for free via FTP backup.

That’s basically it. For a few dollars a year, you add more redundancy to your backup system, with the confidence of having your most precious data saved on redundant servers and an average 99.999999999% durability for your archives.


via Lifehacker
​How to Use Amazon Glacier as a Dirt Cheap Backup Solution

MySQL Workbench 6.0.8 Released

Dear MySQL users,
The MySQL developer tools team at Oracle is excited to announce the availability of MySQL Workbench 6.0.8.
MySQL Workbench 6.0 is the new version the GUI Development and Administration tool for MySQL. This maintenance release contains over 50 bug fixes since version 6.0.7
Improvements in MySQL Workbench 6.0:
a new redesigned Home screen
the SQL Editor and Server Administration UIs were merged into a single connection specific interface, allowing for quick access to administration features while simplifying the location of specific features
improved model Synchronization, lets you compare and update your EER model or database with ALTER scripts and properly handle corner cases involving objects renamed externally or sync schemas with different names
improved support for model printing to PDF files
all new Schema Inspector, gives you a detailed overview of all objects in your schemas, plus access to table maintenance operations such as ANALYZE and OPTIMIZE TABLE
table data search, lets you perform a text search on any number of tables and schemas for rows matching a given pattern
improved Server Status page, gives a quick summary of server status and configuration
cascaded DELETE statement generator, automatically performs the tedious task of generating DELETE statements for deleting a row referenced by foreign keys
new Migration Wizard support for SQL Anywhere and SQLite
several performance improvements
and much more. For a detailed overview of what’s new in MySQL Workbench 6.0, please visit:
http://dev.mysql.com/doc/workbench/en/wb-what-is-new.html
For the full list of bugs fixed in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/changes-6-0.html
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?151
Download MySQL Workbench 6.0 now, for Windows, Mac OS X 10.6+, Oracle Linux 6, Fedora 18, Fedora 19, Ubuntu 12.04 and Ubuntu 13.04 or sources, from:
http://dev.mysql.com/downloads/tools/workbench/
In Windows, you can also use the integrated MySQL Installer to update MySQL Workbench and other MySQL products. For RPM package based Linux distributions, you can get and update Workbench using the new MySQL RPM repository at http://dev.mysql.com/downloads/repo/
Quick links:
– Download: http://dev.mysql.com/downloads/tools/workbench/
– Bugs: http://bugs.mysql.com
– Forums: http://forums.mysql.com/index.php?151
Read more about MySQL Workbench 6.0 and some of its features in
MySQL Workbench 6.0: What’s New
http://mysqlworkbench.org/2013/06/mysql-workbench-6-0-whats-new/

the MySQL Workbench team
via Planet MySQL
MySQL Workbench 6.0.8 Released