OurSQL Episode 161: The sharpest tool on the bench

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.

We talk about connecting, configuring for local management of remote servers, the query editor window, visual EXPLAIN, and running and saving scripts.

clean up SQL feature - blog post with explanations

Getting started with Workbench tutorial

We also talk about data models, reverse engineering from SQL scripts and live databases, and forward engineering to live databases as well as getting CREATE/ALTER scripts. And we go through autolayout and laying out your tables on the grid.

Ear Candy
This week in Ear Candy we will talk about how to use the performance schema to find unused accounts. Federico Razzoli's blog post about how to use performance schema to find unused accounts

At the Movies
In this week at the movies we're presenting a Percona webinar on XtraDB Cluster from last June. XtraDB cluster is based on Galera Cluster and offers an alternative to MySQL replication for high availability. In this webinar Jay Jensen starts with covering configuration and best practices and covers other important issues like monitoring and online schema changes.

Where you can see us

On to where you can see us.
Gerry will be at the November Seattle User Group meeting on Monday, November 11th at 6:30 pm.

Sheeri will be at the November MySQL Boston User Group meeting on Monday, November 11th at 7 pm. The topic will be using the new GTIDs, by Jacob Nikom.

Gerry will be at the December Seattle MySQL Meetup on Monday Dec 9th at 6:30pm at the new Twitter offices in Seattle.

Sheeri will be at the December Boston MySQL User Group meeting on Monday, December 9th at 7 pm.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1267