Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 183 Next 30 Older Entries

Displaying posts with tag: Podcasts (reset)

OurSQL Episode 153: Tooling Around, Part 3
+3 Vote Up -0Vote Down

This week we continue our series on MySQL Utilities, talking about replication and failover tools. Ear Candy is a gotcha with poor GRANT syntax that MySQL does not give warnings about, and At the Movies is an open forum from the SkySQL Solutions Day a few months ago.

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

MySQL Utilities part 3
mysqlfailover

read more

OurSQL Episode 152: Tooling Around, Part 2
+1 Vote Up -0Vote Down

This week we continue our series on the MySQL Utilities. In this week's Ear Candy, we talk about a path problem installing MySQL Utilities on Ubuntu, and At the Movies is a preview of the SkySQL data suite.

Part 1 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

Events
DB Hangops - every other Wednesay at noon Pacific time

Percona University is coming to Washington, DC on Thursday, September 12th.

read more

OurSQL Episode 151: Tooling Around, Part 1
+1 Vote Up -0Vote Down

This week we start talking about the Python MySQL Utilities. Ear Candy is a pitfall when importing a mysqldump export and At the Movies is "Deploying MySQL in AWS and OpenStack" by Mark Riddoch of SkySQL.

Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

MySQL Utilities
MySQL Utilities documentation

read more

OurSQL Episode 150: MySQL Connect
+3 Vote Up -0Vote Down

This week we talk about MySQL Connect sessions. Ear Candy is the mysqladmin "relative" command, and At the Movies is Manipulating JSON with MariaDB and MySQL. Listen to hear how to win a free pass!

Events
DB Hangops - every other Wednesay at noon Pacific time

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

read more

OurSQL Episode 149: Trolling
+0 Vote Up -0Vote Down

This week we continue our interview with Noam Kritzer of Bakos & Kritzer, talking about patent case law and patent trolls. Ear Candy is temporary table ghost files, and At the Movies is Manipulating JSON with MariaDB and MySQL.

defensive vs. offensive patents

Patent trolls

Trademarks and domain names

Copyright.gov, a resource written for lay people.

read more

OurSQL Episode 148: Intellectual Property
+0 Vote Up -0Vote Down

This week we interview Noam Kritzer from the law firm of Bakos & Kritzer about copyright, patents and trademarks. Ear Candy is about SUBSTRING_INDEX and At the Movies is Colin Charles presenting a panel on MariaDB.

Events
DB Hangops - every other Wednesay at noon Pacific time

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

read more

OurSQL Episode 147: It's Web Scale
+0 Vote Up -0Vote Down

This week we talk with Tim Callaghan of Tokutek about TokuMX, a take on MongoDB. Ear Candy is perror on Windows and At the Movies is a presentation from the SkySQL and MariaDB Solutions Day 2013 about Tokutek.

TokuMX

Replication between MySQL and MongoDB using Tungsten a couple of years ago at Open DB Camp in Sardinia (2011).

Previous interviews with Tokutek folks in:
Episode 39

read more

OurSQL Episode 146: License to run
+1 Vote Up -0Vote Down

This week we discuss copyleft, GPL and related licenses. In Ear Candy we discuss INFORMATION_SCHEMA and permissions, and At the Movies is about a columnar database.

Events
DB Hangops - every other Wednesay at noon Pacific time

Oracle is having a MySQL OTN Virtual Developer Day August 31st.

FrOSCon - Aug 24-25th, 2013 in St. Augustin, Germany.

Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

read more

OurSQL Episode 145: Biblical Tools, part 3
+3 Vote Up -0Vote Down

This week we finish up talking about the Openark Kit for MySQL. Ear Candy is using both --master-data and --tab with mysqldump, and At the Movies features Robert Hodges of Continuent presenting Scalable MySQL Operation in the Cloud with Continuent Tungsten.

Openark Kit series:
Part 1
Part 2

Openark Kit
oak-purge-master-logs
PURGE BINARY LOGS at the MySQL manual page.

read more

OurSQL Episode 144: Biblical Tools, part 2
+2 Vote Up -0Vote Down

This week we continue talking about the Openark Kit. Ear candy is the Percona Configuration Wizard, and At the Movies is a keynote from the SkySQL and MariaDB Solutions Day about the SkySQL and MariaDB merger and the MariaDB Foundation.

Openark Kit series:
Part 1
Part 3

Events
DB Hangops - every other Wednesay at noon Pacific time

Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings

read more

OurSQL Episode 143: Biblical Tools
+3 Vote Up -0Vote Down

This week we start to discuss the Openark Toolkit. Ear Candy talks about how to estimate the size of MySQL's working set, and At the Movies is a backup presentation from Open Database Camp.

Openark Kit series:
Part 2
Part 3

Openark Kit
Openark Kit

Episode 80, discussing the Percona Toolkit

read more

OurSQL Episode 142: Great Views
+1 Vote Up -0Vote Down

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

Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings

Tungsten University trainings

read more

OurSQL Episode 141: Performance Enhancements
+3 Vote Up -0Vote Down

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%';

read more

OurSQL Episode 140: More Performance
+1 Vote Up -0Vote Down

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/)

Training
SkySQL Trainings
Tungsten University trainings

read more

OurSQL Episode 139: Starting to Perform
+1 Vote Up -0Vote Down

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

read more

OurSQL Episode 138: The Relevance of Tungsten
+2 Vote Up -0Vote Down

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/)

Training
SkySQL Trainings
Tungsten University trainings

read more

OurSQL Episode 137: Playing in the Sandbox
+2 Vote Up -0Vote Down

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

Get MySQL Sandbox on Launchpad

read more

OurSQL Episode 136: Digging for Information
+1 Vote Up -0Vote Down

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/)

Training
SkySQL Trainings
Tungsten University trainings

read more

OurSQL Episode 135: Another Kind of Buffer
+1 Vote Up -0Vote Down

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

read more

OurSQL Episode 134: When Binary's Not Binary
+1 Vote Up -0Vote Down

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.

read more

OurSQL Episode 133: MySQL on Auto-Tune
+2 Vote Up -0Vote Down

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.

back_log

read more

OurSQL Episode 132: New and Shiny!
+2 Vote Up -0Vote Down

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.

read more

OurSQL Episode 131: Fresh Variables
+1 Vote Up -0Vote Down

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

read more

OurSQL Episode 130: Retired Variables
+1 Vote Up -0Vote Down

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.

read more

OurSQL Episode 129: New and Extended
+1 Vote Up -0Vote Down

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.

read more

OurSQL Episode 128: Your Global ID Please
+1 Vote Up -0Vote Down

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.

read more

OurSQL Episode 127: No Sweat Slaves
+2 Vote Up -0Vote Down

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

read more

OurSQL Episode 126: Subqueries and Tracking
+3 Vote Up -0Vote Down

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

read more

OurSQL Episode 125: New and Improved...And Faster!
+2 Vote Up -0Vote Down

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.

read more

OurSQL Episode 124: When Do You Want It?
+1 Vote Up -0Vote Down

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.

read more

Previous 30 Newer Entries Showing entries 31 to 60 of 183 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.