In case you missed Norvald’s post, the official yum repos now support the 5.7 development releases!
The MySQL manual documents how you can enable 5.7, but I wanted to also provide a quick demonstration since using yum sub-repositories is a new concept to me.
Installing the repo
All versions of MySQL are downloaded via a single repo file, which can be downloaded from: http://dev.mysql.com/downloads/repo/.
You can copy the URL from the download page directly into a yum localinstall command. For example on Enterprise Linux 6, the command is:
sudo yum localinstall http://dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
Activating MySQL 5.7
The default version of MySQL enabled with the repo will be MySQL 5.6 GA. The documented way to change this to 5.7 is:
shell> sudo yum-config-manager –disable mysql56-community
shell> sudo yum-config-manager –enable mysql57-community-dmr
You also have the option to manually edit the sources.list file, which if you run the above commands will now contain:
[root@mysqlrpm ~]# cat /etc/yum.repos.d/mysql-community.repo
[mysql-connectors-community]
name=MySQL Connectors Community
baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
[mysql-tools-community]
name=MySQL Tools Community
baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# Enable to use MySQL 5.5
[mysql55-community]
name=MySQL 5.5 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# Enable to use MySQL 5.6
[mysql56-community]
name=MySQL 5.6 Community Server
baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/6/$basearch/
enabled=0
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
# Note: MySQL 5.7 is currently in development. For use at your own risk.
# Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/
[mysql57-community-dmr]
name=MySQL 5.7 Community Server Development Milestone Release
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=1
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
From there, a yum install will show MySQL 5.7 as the intended version to be installed:
[root@mysqlrpm ~]# yum install mysql-community-server
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: ftp.osuosl.org
* extras: ftp.osuosl.org
* updates: ftp.osuosl.org
Setting up Install Process
Resolving Dependencies
–> Running transaction check
—> Package mysql-community-server.x86_64 0:5.7.3-0.1.m13.el6 will be installed
–> Finished Dependency Resolution
Dependencies Resolved
====================================================================================================================================================================
Package Arch Version Repository Size
====================================================================================================================================================================
Installing:
mysql-community-server x86_64 5.7.3-0.1.m13.el6 mysql57-community-dmr 62 M
Transaction Summary
====================================================================================================================================================================
Install 1 Package(s)
Total download size: 62 M
Installed size: 281 M
Is this ok [y/N]:
via Planet MySQL
Installing MySQL 5.7 DMR3 with the official yum repos
3 Questions to Ask at Dinner to Make Your Family Stronger
More and more research studies are concluding that regular dinners are the key to a happy, healthy family. Dinnertime is a great time to discuss how well your family is working. The Week highlights an agile approach to this (something we’ve seen similarly applied to parenting in general).
Taking excerpts from the book The Secrets of Happy Families, The Week quotes Scrum software developer Jeff Sutherland‘s approach:
The centerpiece of the program is a weekly review session built on the principle of "inspect and adapt."
Three questions get asked:
1. What things went well in our family this week?
2. What things could we improve in our family?
3. What things will you commit to working on this week?
You don’t have to actually fire off those questions directly like that, but those three things are good ones to discuss with your family on a regular basis. Just having regular dinners and meaningful conversations during them could improve just about everything parents worry about. If the agile approach isn’t for you, try the 10-50-1 formula also taken from the book:
10. Aim for ten minutes of quality talk per meal. .. 50. Let your kids speak at least half the time. … 1. Teach your kids one new word every meal.
Hit up the link below for lots more family bonding advice.
The secrets of happy families | The Week
Photo by Lars Plougmann.
via Lifehacker
3 Questions to Ask at Dinner to Make Your Family Stronger
Biking Across a Pool of Cornstarch Beats Walking on Water Any Day
The minds behind the Hard Science YouTube channel have given us a crash course in the exciting world of non-Newtonian fluids in the most awesome way possible—by biking across a pool of cornstarch that is, at once, both solid and liquid.
via Gizmodo
Biking Across a Pool of Cornstarch Beats Walking on Water Any Day
The best photos of 2013
Fix Your Computer Hunch and Other Posture Problems in 30 Seconds
This one exercise can greatly improve your mobility and flexibility—and cure the many ills that come from sitting hunched in front of a screen all day. It takes just 30 seconds and you don’t need any equipment.
Max Shank teaches us how to do this move, called the Thoracic Bridge. It basically opens up your body and can help with pain and tightness in your shoulders, back, and hips. It looks a little weird to do, but when you get the hang of it, you should automatically feel the difference in your body’s alignment and posture. (Also, you don’t have to be as crazy acrobatic as Max in switching sides.)
There are lots of easy stretches you can do to correct your hunching and get all the benefits of better posture, but if you’re only going to do one thing, the Thoracic Bridge move is arguably the best one since it corrects so many issues in half a minute.
Thoracic Bridge Instructional Video: Improve your flexibility in 30 seconds | YouTube via James Clear
via Lifehacker
Fix Your Computer Hunch and Other Posture Problems in 30 Seconds
I want to dip everything in this magic hydrocoating water paint
Everything I own, everything I will buy, every fiber of my body, everything in this world should be dipped into water paint. The hydrocoating process is popular in weapons and helmets but really deserves to be shmeared all over the world. We might have to come up with better designs but I never want to use a paint brush to paint again.
via Gizmodo
I want to dip everything in this magic hydrocoating water paint
Photographing an African safari
Boston Globe Staff photographer Essdras M Suarez experienced a two week safari in Kenya and Tanzania this year. Here is a selection of what he captured and thoughts upon his return:
As a photojournalist, youre always looking to capture moments that define life. In the wild, youre witnessing life or death situations, and its a truly humbling experience. Were used to living in a world where we humans are top predators and life is extremely safe. When you find yourself in an environment where youre no longer the top predator, it puts things in perspective to see how and where we fall within the food chain. I never thought Id be excited photographing nature, but I found myself completely entranced by the whole experience and I cant wait to do it again. ( 27 photos total)
As a photojournalist, youre always looking to capture moments that define life. In the wild, youre witnessing life or death situations, and its a truly humbling experience. Were used to living in a world where we humans are top predators and life is extremely safe. When you find yourself in an environment where youre no longer the top predator, it puts things in perspective to see how and where we fall within the food chain. I never thought Id be excited photographing nature, but I found myself completely entranced by the whole experience and I cant wait to do it again. ( 27 photos total)
As the day comes to an end at a Serengeti National Park in Kenya, a herd of giraffes line up as they make their way away from the Savannah to the safety of the bush they will need during the night. (Essdras M Suarez/ EMS Photography)
     |
Hello Processing!
Daniel Shiffman’s interactive video tutorial to learn Processing basics in an hour
via Waxy.org Links
Hello Processing!
Dilbert 2013-11-28
A Brief History of Airspace Design
Think Los Angeles at rush hour is bad? Try doing it half-blindfolded with nothing but a radio and a few blinking lights to show you the way. That’s how pilots navigate the invisible highways in the sky, and there’s a beautiful design that makes it all work. It only took about a hundred years to come up with it.