|
This week we discuss MySQL Views. Ear Candy is GRANTs and replication and At the Movies is a presentation by Giuseppe Maxia talking about "Creating Multi-Master clusters with Tungsten Replicator".
Events
DB Hangops - every other Wednesay at noon Pacific time
Training
SkySQL Trainings
This week we talk about server and status variables relating to the performance schema and the ps_helper tool. Ear Candy is an sql_mode bug, and At the Movies is a performance_schema and ps_helper webinar.
Performance Schema Variables
MySQL 5.5 performance schema variables
MySQL 5.6 performance schema variables - many options are auto-sized
SHOW GLOBAL VARIABLES LIKE 'performance_schema%';
This week we explain performance_schema a bit deeper. In Ear Candy, we talk about max_binlog_cache_size and At the Movies presents Max Mether of SkySQL talking about "High Availability Solutions for MySQL".
Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming MySQL events
This week we discuss the basics of using the performance schema in MySQL 5.5 and 5.6. Ear Candy is about a temporal gotcha when using dates and times that do not exist, and At the Movies is David Stokes giving some useful for System Administrators who also are in a DBA role.
News
Continuent's Tungsten Replicator is now completely open source
TokuDB is now open source
This week we discuss Tungsten and MySQL 5.6 replication with friend of the show, Giuseppe Maxia (aka the Data Charmer). Ear Candy is MariaDB's Cassandra storage engine, and At the Movies is Giuseppe's "MySQL 5.6 Replication – features and usability" video from Open Database Camp.
Events
DB Hangops in May will be Wed May 8th and 22nd.
Upcoming MySQL tech tours
This week we talk to Giuseppe Maxia about MySQL Sandbox. Ear Candy is about table_open_cache, Open_tables and Opened_tables, and At the Movies features MariaDB.
MySQL Sandbox
MySQL Sandbox
Examples:
MariaDB slave of a master:
make sandbox mysql-tarball --master
make sandbox mariadb-tarball --slaveof master-port=fooExporting:
./my sqldump instancenameRemote mysql sandbox deploy:
deploy remote sandboxes -m MySQLVer -l list,of,serversWe discuss INFORMATION_SCHEMA with plenty of examples on useful queries. In this week's Ear Candy, we talk about resident versus virtual memory on Linux, and in At the Movies has a video about MongoDB.
Events
DB Hangops in May will be Wed May 8th and 22nd noon pacific time.
Upcoming MySQL tech tours
This week, we explain the InnoDB and Memcached integration in MySQL 5.6. Ear Candy is about the nonexistent 2-step deadlock detection in MariaDB and At the Movies is Colin Charles talking about the features of MariaDB 10.
InnoDB and memcached in MySQL 5.6
memcached official page
InnoDB integration with memcached MySQL manual page
History of the term NoSQL
setting up the InnoDB memcached plugin in MySQL 5.6
This week, we take a lighter topic and talk about the many uses and meanings of "binary". Ear candy is a but about SET GLOBAL SQL_BIN_LOG, and At the Movies is Ariel Weisberg of VoltDB explaining sharding and elastic clustering.
Events
DBA Hangops - an every-other-week hangout for dba's (right now it's mostly MySQL) - The DB hangops sessions for April and May are April 10th, April 24th, May 8th and May 22nd.
Call for Papers for MySQL Connect is open! The call closes Friday, April 12th.
This week, we talk about variables with changed default values in MySQL 5.6. Ear Candy is the pt-config-diff tool and At the Movies is Tim Callaghan of Tokutek talking about Fractal Trees.
Changed Defaults in MySQL 5.6
Percona's article about default variable differences in MySQL 5.5 and MySQL 5.6
MySQL 5.6 manual page about changes to server defaults in MySQL 5.6.
This week we discuss new variables in MySQL 5.6. Ear Candy talks about a problem with XFS performance on a Linux kernel, and At the Movies discusses columnar databases.
@eRadical points out a correction to episode 130 - multiple InnoDB buffer pools were new in MySQL 5.5, not MySQL 5.6.
Events
Call for Papers for MySQL Connect is open! The call closes Friday, April 12th.
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
This week we discuss deprecated, removed and ignored variables in MySQL 5.6. Ear Candy is about innodb_file_per_table enabled by default, and At the Movies is "Different MySQL Forks for Different MySQL Folks".
Events
Upcoming MySQL tech tours
Open Database Camp will be part of the Northeast LinuxFest at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. You can register and submit presentations on the opensqlcamp.org website.
This week we interview Shlomi Noach about the upcoming Percona Live: MySQL Conference and Expo in Santa Clara April 22-25th, 2013. There are 2 organizations with new trainings, too! Ear Candy is a resource with data models, and At the Movies is how to setup and operate Tungsten replication.
Events
Upcoming MySQL tech tours
LinuxFest Northwest will take place in Bellingham, Washington on Sat Apr 27th and Sun Apr 28th.
This week, we discuss GTIDs in MySQL 5.6 and how they work with replication. In Ear Candy, we link to an extremely useful resource for complicated MySQL query patterns. In At the Movies, we present The Finer Art of Being a 'Senior' Employee.
Events
Oracle's upcoming webinars:
MySQL Security Enhancements and Important Security Tips for ISVs and OEMs on Thursday, February 21st.
MySQL Performance and Scalability in Spanish Thursday, February 28th.