English
| Showing entries 1 to 30 of 140 | Next 30 Older Entries |
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 (http://www.mysql.com/news-and-events/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 (http://www.mysql.com/news-and-events/events/)
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=foo
Exporting:
./my sqldump instancename
Remote mysql sandbox deploy:
deploy remote sandboxes -m MySQLVer -l list,of,servers
We 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 (http://www.mysql.com/news-and-events/events/)
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.
Upcoming MySQL tech tours (http://www.mysql.com/news-and-events/events/)
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
Upcoming MySQL tech tours (http://www.mysql.com/news-and-events/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 (http://www.mysql.com/news-and-events/events/)
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 (http://www.mysql.com/news-and-events/events/)
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 (http://www.mysql.com/news-and-events/web-seminars/mysql-security-enhancements-and-important-security-tips-for-isvs-oems/) on Thursday, February 21st.
MySQL Performance and Scalability in Spanish (http://www.mysql.com/news-and-events/web-seminars/mysql-5-6-performance-scalability-afina-tu-bd-en-este-webinar-gratuito/) Thursday, February 28th.
This week we begin to discuss replication features in MySQL 5.6. Ear Candy is a LOAD DATA INFILE bug and using CSV to get beyond it; At the Movies is Suzan Bond talking about "The Art of Self-Sourcing".
Events
Oracle's doing more MySQL tech tours. These seminars will be in the mornings, and are free. They will be on:
Tuesday, February 19th in Petach Tikva, Israel
Thursday, February 21st in Oslo and Brussels
This week we present part 2 of optimizer enhancements in MySQL 5.6, including subquery optimizations and the new optimizer trace feature. Ear Candy talks about what "hole punching" is with regards to file systems. In At the Movies we present "How to Deal with Difficult People".
Events
Galera, SkySQL and MariaDB are doing a Road Show in Stockholm on February 7th.
Oracle's doing more MySQL tech tours. These seminars will be in the mornings, and are free. They will be on:
Friday, February 15th near Milan
This week we discuss part 1 of the new optimizer enhancements in MySQL 5.6. Ear Candy is a gotcha about persistent replication configuration, and At the Movies is MVCC in PostgreSQL.
Events
Galera, SkySQL and MariaDB are doing a Road Show in Hamburg on February 1st and Stockholm on February 7th.
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd.
OSCON 2013 will take place in Portland, OR from Monday July 22nd through Friday July 26th. The call for speakers closes at midnight Pacific Time on Monday, February 4th.
This week, we talk about Linux I/O schedulers. Ear Candy is iotop, and At the Movies is learning how to use EXPLAIN.
News
OurSQL is taking the EBU's recommendation for volume for mobile devices. You can find a link to a white paper titled: "On the way to loudness nirvana".
Events
Oracle is doing a small MySQL tech tour, on January 22nd to Pleasanton, CA and on January 23rd to Belmont, CA.
This podcast would not achieve its goal if there were no listeners to learn about MySQL. This week we play a bunch of bloopers as our year-end gift to you. We hope these make you laugh!
This week we discuss manipulating text data and the CSV storage engine. Ear Candy is Venn Diagrams visually showing joins, and At the Movies is about how to retain your individuality while being on a team.
Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.
Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify
[Read more...]This week we discuss triggers in MySQL. Ear Candy is SQL in the Shell, and At the Movies is Project Triage and Recovery, by Keith Casey of Twilio, at the 2012 CodeConnexx conference.
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.
Northeast LinuxFest is happening at Harvard University, Cambridge MA Saturday March 16th and Sunday March 17th, 2013. Open Database Camp will be held there. Sponsors are needed, make sure to specify you are helping
[Read more...]This week we talk more about stored routines, including the several different DECLARE statements. Ear Candy is about ssh hacks to make logging into multiple servers easy, and At the Movies is "Everything You Ever Wanted to Know About Deployment But Were Afraid to Ask".
Events
FOSDEM 2013 is taking place in Brussels, Belgium Sat Feb 2 - Sun Feb 3rd. Call for papers for the MySQL & Friends room closes December 21st.
This week we go over stored routine basics. Ear Candy is linux.die.net, online man pages for Linux, and At the Movies is key things that DBA need to know.
News
Open Source DBA's Holiday Gifts for MySQL DBAs - check out the CafePress link, many are positively funny.
Events
Oracle is having free Tech Tours for MySQL in Dublin, San Diego,
This week, we continue our series going through the Operations Report Card as it applies to database administrators. This week in Ear Candy, we talk about a hidden client value for max_allowed_packet (separate from the session variable). In At the Movies, we present Karen Tegan Padir of Enterprise DB presenting The More Things Change, the More They Stay the Same.
Events
Oracle's "Scale with MySQL" seminars:
Madrid, Tuesday 27 November
This week we continue part 3 of the Operations Report Card and how it relates to database administration. This week we talk about the section on "Operational Practices", and it covers how operations are run. In Ear Candy we present different tools for finding a machine's external IP address, and in At the Movies we present a video about MySQL Security from when Sheeri was touring Latin America in July.
Feedback
Webyog's blog noted that the OurSQL blog/podcast was among the Top MySQL Blogs You Should Be
While we were at MySQL Connect last month, we interviewed long-time MySQL developer JD Duncan about integrating NoSQL and JavaScript with MySQL. His team developed the Node.js API for MySQL. This week, we present the interview we did. In Ear Candy, we discuss what makes a senior DBA, and in At the Movies we present a ScaleBase webinar.
Events
Oracle's "Scale with MySQL" seminars:
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November
This week, we go through the "Modern Team Practices" part of the Operations Report Card, and how it applies to DBAs.
Events
Oracle's "Scale with MySQL" seminars:
Scale with MySQL Seminar, London, Tuesday 30 October
Bucharest Romania, Tuesday 13 November
Madrid, Tuesday 27 November
This week we present the MySQL Connect Keynote: Community Perspective—Why Upgrade to MySQL 5.6. This is the entire keynote panel, featuring Sarah Novotny of Meteor Entertainment as the moderator, and panelists Giuseppe Maxia of Continuent, Domas Mituzas of Facebook, Sheeri Cabral of Mozilla and Mark Leith of Oracle. We discussed the main features we thought would be useful to us as well as the community.
This week we talk about startup scripts and their gotchas. Ear candy is a startup cache gotcha and at the movies presents an introduction to VoltDB.
Events
Percona Live Santa Clara, 2013 call for papers closes Friday October 12th.
Oracle's "Scale with MySQL" seminars:
near Paris, Tuesday 16 October
Scale with MySQL Seminar, London, Tuesday 30 October
This week we present the Sphinx Storage Engine. Ear Candy is a gotcha about setting variables in the configuration file, and At the Movies is a video about MariaDB.
Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.
This week we present what Multi-Version Concurrency Control (MVCC) means, as well as how InnoDB implements it to achieve transactionality and ACID compliance. Ear candy is a GROUP BY performance gotcha, and At the Movies is a FULLTEXT webinar from Percona.
Events
MySQL Connect will be held in San Francisco on Saturday September 29th and Sunday September 30th. The schedule is now online.
| Showing entries 1 to 30 of 140 | Next 30 Older Entries |
