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,
…
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
The call for papers for OSCon 2014 is open until Thursday, January 30th
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
The call for papers for OSCon 2014 is open until Thursday, January 30th
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]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
Training
SkySQL Trainings
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
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
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.
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
MySQL Tech Tour Tokyo Nov 27th 2013
MySQL and Linux tech event in Atlanta Dec 5,
2013
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 - community vs.
standard vs. enterprise
MySQL Workbench 6.0 interface changes with pictures.