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 中文
Showing entries 1 to 30 of 183 Next 30 Older Entries

Displaying posts with tag: Podcasts (reset)

OurSQL Episode 182: Optimizing MariaDB
+0 Vote Up -0Vote Down

This week we discuss new optimizer improvements in MariaDB 10. Ear Candy is about the MariaDB threadpool, and At the Movies is Oracle's Tomas Ulin talking about raising the bar with 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 181: MariaDB Goodies
+0 Vote Up -0Vote Down

This week we discuss more features of MariaDB 10. Ear Candy is how to avoid downtime when switching to GTIDs and At the Movies is Managing Hundreds of MySQL Servers Efficiently.

News
MySQL Community Awards 2014: the Winners

MariaDB 10
MariaDB 10.0.1 features
Other MariaDB podcasts:
OurSQL Episode 89, where we talk about an overview of MariaDB

read more

OurSQL Episode 180: Sharing the Load
+0 Vote Up -0Vote Down

This week we talk to Justin Swanhart about Shard-Query, a massively parallel processing query engine for MySQL. Ear candy is about mydumper, and At the Movies is "Common Deadly MySQL Development Mistakes."

Events
Percona Live
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 179: MySQL's Materialized Views
+0 Vote Up -0Vote Down

This week, we interviewed longtime community member and Percona principal support engineer Justin Swanhart about Flexviews, a tool for Materialized Views in MySQL. Ear Candy is about the EXPLAIN analyzer, and At the Movies is about "Advanced MySQL Replication Architectures and Latest Developments".

Flexviews
Justin Swanhart's open source tools
ABOUT Flexviews - "Flexviews is a unique toolkit for the creation and upkeep of MATERIALIZED VIEWS for MySQL."

read more

OurSQL Episode 178: License to Use
+0 Vote Up -0Vote Down

This week we discuss more software licenses, concluding our 3-part series on licenses. Ear Candy is what happens when ALTER TABLE crashes, and At the Movies is Jon Day of SkySQL presenting MaxScale.

Events
Percona Live

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 177: Artistic License
+0 Vote Up -0Vote Down

This week, we sat down with Luis Villa about non-software licenses. Ear Candy is and At the Movies is Sheeri talking about Percona Replication Manager at the Boston MySQL User Group a few years ago.

Non-software Licenses
Luis Villa's Wikipedia page.

Back in episode 146, we talked about the GPL open source license, and its versions and derivatives.

Database directive at Wikipedia. In the EU, you can license a database.

read more

OurSQL Episode 176: Replication Everywhere
+0 Vote Up -0Vote Down

This week we talk about replication features in MariaDB 10. Ear Candy is a gotcha about PIVOT tables in MariaDB, and At the Movies is about the viability of transactions.

Percona Live
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 174: CONNECT the world
+1 Vote Up -0Vote Down

This week we discuss MariaDB's CONNECT storage engine. Ear Candy is inconsistent behavior with dates, NULLs and collations. At the Movies is a talk about the history and future of MySQL and its variants.

Sheeri:
The 2014 MySQL Community Awards are open for nominations until Sunday, 23 February 2014

Events
DB Hangops - every other Wednesay at noon Pacific time. Upcoming dates are Wednesday February 19th, March 5th and March 19th.

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

read more

OurSQL Episode 173: Time for Percona Live
+1 Vote Up -0Vote Down

This week, we talk about the new and innovative talks appearing at Percona Live. Ear Candy is about warming up the innodb buffer pool cache, and At the Movies talks about zero-cost joins.

Pecona Live
Percona Live 2014 is Tuesady April 1st through Friday April 5th at the Santa Clara Convention Center in Santa Clara, California.

Percona Live 2014 conference site

Register for Percona Live - save $100 if you register on or before March 2nd!

read more

OurSQL Episode 172: A New Proxy
+0 Vote Up -0Vote Down

This week, we talk with Ivan Zoratti of SkySQL about MaxScale, a new MySQL proxy. Ear Candy is about accidentally removing a dependent package, and At the Movies is a DB Hangops recording of MaxScale, replication saturation and monitoring.

Events
DB Hangops - every other Wednesay at noon Pacific time
Upcoming MySQL events, including Tech Tours (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings
Tungsten University trainings

read more

OurSQL Episode 171: Another Round of Toolkit
+1 Vote Up -0Vote Down

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127,

  [Read more...]
OurSQL Episode 171: Another Round of Toolkit
+1 Vote Up -0Vote Down

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127,

  [Read more...]
OurSQL Episode 171: Another Round of Toolkit
+0 Vote Up -0Vote Down

This week we discuss more tools in the Percona Toolkit - pt-align, pt-fifo-split, pt-diskstats, pt-ioprofile, pt-fk-error-logger, pt-mext and pt-mysql-summary. Ear Candy is why you should load the timezone tables in MySQL and At the Movies is using GTID replication for high availability.

Obscure Percona Tools
We have talked about Percona tools in many episodes:
Episode 76, Episode 77, Episode 79, Episode 80, Episode 81, Episode 85, Episode 90, Episode 116, Episode 127,

  [Read more...]
OurSQL Episode 170: Auto-failover, part 2
+1 Vote Up -0Vote Down

This week we discuss administering Percona Replication Manager. Ear Candy is about repository packages from MariaDB and Oracle, and At the Movies presents a Riak engineer talking about "convergent replicated data types" - data structures that tolerate eventual consistency.

Events
DB Hangops - every other Wednesay at noon Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

The call for papers for OSCon 2014 is open until Thursday, January 30th

read more

OurSQL Episode 168: Autofailover, part 1
+1 Vote Up -0Vote Down

This week we discuss setting up Percona Replication Manager. Ear Candy is playing with Unicode to make seasonal pictures and At the Movies is about systems performance with lots of MySQL examples.

Events
DB Hangops - every other Wednesay at noon Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

The call for papers for OSCon 2014 is open until Thursday, January 30th

read more

OurSQL Episode 167: Data, Data Everywhere
+2 Vote Up -0Vote Down

This week we discuss test data sets. Ear Candy is errata from Episode 165 on Galera Cluster, and At the Movies is "Runaway Complexity in Big Data"

Test Data Sets
Episode 81, where we talked about different benchmark tools
Sysbench - general version
Percona's sysbench tests

Factors: # tables, concurrency, data set size

Episode 143, where we did an ear candy featuring Morgan Tocker's article on estimating MySQL's working set with INFORMATION_SCHEMA

read more

OurSQL Episode 166: Top Hat Options
+1 Vote Up -0Vote Down

This week we discuss fine-tuning Galera Cluster. In this week's ear candy we talk about recent changes to mysqldump and locking; At the Movies presents "Using Amazon Web Services for MySQL at Scale".

Events
DB Hangops - every other Wednesay at noon Pacific time
FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events (http://www.mysql.com/news-and-events/events/)

Training
SkySQL Trainings

read more

OurSQL Episode 165: Top Hat Cluster
+0 Vote Up -0Vote Down

This week we talk about how to install and set up Galera Cluster. Ear Candy talks about the new MySQL repos from Oracle and what to know about using them; At the Movies is Michael Stonebreaker talking about how to process today's big data transactional processing needs.

Galera Cluster
Codership documentation of Galera Cluster
Installing Percona XtraDB Cluster on Ubuntu documentation
MariaDB's Galera Cluster documentation

read more

OurSQL Episode 164: Who's Doing What?
+0 Vote Up -0Vote Down

This week we talk about how to install and use the MariaDB Audit plugin, and what the audit log looks like. Ear Candy presents a gotcha with MySQL and temporary directories, and At the Movies is about using Dynamo for more than just a data store.

Events
DB Hangops - every other Wednesday 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 163: Moving Along
+0 Vote Up -0Vote Down

This week we discuss MySQL's Migration Toolkit. Ear Candy is about the replication format as it propagates through multi-tier master and slaves; At the Movies is Distributed Data Analysis with Hadoop and R.

MySQL Migration Toolkit
Episode 161 where we talked about how MySQL Workbench is a replacement for the older MySQL GUI Tools, including the MySQL Migration Toolkit.

New Migration Toolkit in MySQL Workbench.
Installing ODBC Drivers for use with the Migration Toolkit.

read more

OurSQL Episode 162: Exploring Workbench Further
+0 Vote Up -0Vote Down

This week we explore MySQL Workbench further. Ear Candy is Stewart Smith's 'libeatmydata' and At the Movies is a video to help folks familiar with SQL learn how to use Riak's MapReduce.

Events
DB Hangops - every other Wednesay at noon Pacific time

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

MySQL Tech Tour Tokyo Nov 27th 2013
MySQL and Linux tech event in Atlanta Dec 5, 2013

read more

OurSQL Episode 161: The sharpest tool on the bench
+0 Vote Up -0Vote Down

This week we discuss the basics of MySQL Workbench. Ear Candy is using performance schema to find unused accounts, and At the Movies presents XtraDB Cluster.

News
Oracle announced that it is providing yum repositories for MySQL, including MySQL packages, MySQL workbench and MySQL connectors.

MySQL Workbench
features of MySQL Workbench (http://www.mysql.com/products/workbench/features.html) - community vs. standard vs. enterprise

MySQL Workbench 6.0 interface changes with pictures.

read more

OurSQL Episode 160: More Free Hot Backup
+0 Vote Up -0Vote Down

This week we finish our 2-part series on xtrabackup. Ear Candy is changing the sorting behavior of GROUP BY and At the Movies is a talk on performance schema.

Events
DB Hangops - every other Wednesay at noon Pacific time

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

Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center, with a community dinner on the 11th.

read more

OurSQL Episode 159: Free Hot Backup
+0 Vote Up -0Vote Down

This week, we talk about Percona's Xtrabackup. Ear Candy talks about .frm files and how many fields an InnoDB table can have, and At the Movies is a talk about indexes.

Xtrabackup
Episode 38 where we previously talked about Xtrabackup

Installing Percona's Xtrabackup

Operating system permissions and database privileges needed to use xtrabackup

read more

OurSQL Episode 158: Know Your Forks
+1 Vote Up -0Vote Down

This week we discuss features of Percona Server 5.6 compared to MySQL 5.6. Ear Candy is about pt-upgrade, and At the Movies is a set of lightning talks.

Events
DB Hangops - every other Wednesay at noon Pacific time

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

Percona Live London 2013 is happening Monday November 11th and Tuesday November 12th, 2013 at the Millenium Gloucester Conference Center

Training
SkySQL Trainings

read more

OurSQL Episode 157: More Than One Master
+0 Vote Up -0Vote Down

This week we interview Luis Soares about multi-source replication. Ear Candy is about memory allocation with FEDERATED and FEDERATEDX storage engines, and At the Movies is about increasing performance by archiving data.

Download the multi-source replication MySQL server snapshot at labs.
Enabling MySQL multi-source replication on Luis' blog,
A quick introduction to multi-source replication, with an example

read more

OurSQL Episode 155: Weaving with Fabric
+2 Vote Up -0Vote Down

Actually, this is episode 156, sorry about the error in the title!

This week we interview Mats Kindahl, a MySQL Senior Principal Software Engineer, about the open source Fabric framework for transaction-safe, semi-automatic sharding and high availability. Because we recorded this during the MySQL Connect conference there is no Ear Candy, nor At the Movies.

Events
DB Hangops - every other Wednesay at noon Pacific time

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

MySQL Tech Day in Paris Thursday Oct 10th

read more

Interesting Resources for Technical Operations Engineers
+0 Vote Up -0Vote Down

As you may have already heard, I am looking for good techops engineers to join my team at Swiftype. This process involves a lot of interviews with candidates and during those interviews along with many challenging practical questions I really love to ask questions like “What are the most important resources you think an Operations Engineer should follow?” or “What books in your opinion are must-read for a techops?” or “Who are your personal heroes in IT community?”. Those questions often give me a lot of information about candidates, their experience, who they are looking up to in the community, what they are interested in, and if they are actively working on improving their professional level.

Recently, one of the

  [Read more...]
OurSQL Episode 155: Tooling Around, Part 5
+0 Vote Up -0Vote Down

In this episode, we finish our series about the MySQL Utilities. Ear Candy is pt-stalk, and At the Movies is a fast parallel query engine.

MySQL Utilities part 5

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities

mysqlrplcheck

[bugzilla2]$ mysqlrplcheck --master=root:PASS@bugzilla1 --slave=root:PASS@localhost:/var/lib/mysql/mysql.sock

read more

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

This week we continue our series exploring the MySQL Utilities. Ear Candy is using the performance schema to find out which accounts fail to properly close connections, and At the Movies has a video about databases and determinism.

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 5 of MySQL Utilities

Events
DB Hangops - every other Wednesay at noon Pacific time

read more

Showing entries 1 to 30 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.