OurSQL Episode 131: Fresh Variables

This week we discuss changed behavior of variables in MySQL 5.6. In ear candy we talk about a cloud-based service to play with SQL on different databases, and At the Movies is Stewart Smith of Percona talking about MySQL in the Cloud as a Service during Linux Conf Australia in Canberra.

Changed behavior of variables in 5.6
boolean variables can be set to ON/OFF 1/0 TRUE/FALSE

Variables with changes:
log_slave_updates
relay_log relative vs. absolute paths
relay_log_basename
relay_log_recovery
report_port
gtid_executed
Episode 128 about GTIDs
bind_address and IPv6 options
default_tmp_storage_engine
lower_case_table_names
max_sort_length
new
old
SHA 256 authentication plugin in MySQL 5.6
secure_auth

Episode 37 about setting defaults and sort_buffer_size
A blog post about sort_buffer_size

sql_log_bin
timestamp now uses a double datatype, and supports partial seconds.

read_only and SET transactions

query_cache_size
query_cache_type

Ear Candy
SQL fiddle, where you can play with SQL on many different databases, including MySQL 5.1, 5.5 and 5.6. This is a cloud-based service.

At the Movies
This week in At the Movies, we present Stewart Smith of Percona talking about MySQL in the Cloud as a Service during Linux Conf Australia in Canberra.

Where you can see us
Gerry will be at the Seattle April MySQL Meetup on April 1st April Seattle MySQL Meetup We are going to have a workshop session where of our members will do a live howto. We're deciding on which tools to use for April and which ones in May.
If you're in the Seattle area, we encourage you to volunteer to talk about how your company uses MySQL or propose a workshop topic that we will talk about during the meetup.

Sheeri will be at the Boston April MySQL Meetup group on Monday April 8th featuring John Zablocki, developer advocate, giving an "Intro to Couchbase: NoSQL Document Database for Interactive Applications".

Gerry will present a tutorial during the Percona Live: MySQL Conference and Expo from Monday, April 22 through Thursday April 25th. The tutorial is on Using TokuDB: A Guided Walk Through TokuDB Implementation. Many of the concepts apply to custom MySQL / MariaDB installations as well.

Gerry will also be attending LinuxFest Northwest in Bellingham, Washington Saturday April 26th and Sunday April 27th.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast