Month: December 2013

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

via Gizmodo
Biking Across a Pool of Cornstarch Beats Walking on Water Any Day

via kottke.org
The best photos of 2013

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

via Gizmodo
I want to dip everything in this magic hydrocoating water paint