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 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 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 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 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.
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
The 3rd season of MySQL Marinate begins October 1st! Join the meetup group and RSVP at season 3 to join! You can do the work on MySQL, or if you prefer, MariaDB or Percona.
If you do not have the book yet, you can still do the first week by using the online material from Browse Contents on the OReilly book page for Learning MySQL. There is homework for week 1, see the master list for all the information.
If you would like to learn MySQL from the ground up, consider joining us. This is for beginners If you have no experience with MySQL, or if you are a developer that wants to learn …
[Read more]