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.
Oracle announced that it is providing yum repositories for MySQL, including MySQL packages, MySQL workbench and MySQL connectors.
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
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.
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.