-
Recent Posts
Recent Comments
Archives
- August 2017
- June 2015
- April 2015
- March 2015
- February 2015
- December 2014
- November 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- February 2009
- January 2008
- October 2007
- August 2007
- July 2007
- May 2007
- April 2007
- March 2007
- February 2007
- January 2007
- December 2006
- November 2006
Categories
Meta
Category Archives: Server Tuning
OurSQL Episode 199: Make It Fast
This week, we discuss common MySQL performance tips.
Continue reading
Posted in Performance, Podcasts, Query Optimization, Server Tuning
Comments Off on OurSQL Episode 199: Make It Fast
OurSQL Episode 203: Scaling by Proxy Part 2
In this episode we finish our series on MaxScale. Ear candy is about using MySQL and Galera for geographic replication, and at the Movies uses MySQL to build big data applications.
Continue reading
Posted in Learning, Performance, Podcasts, Server Tuning
Comments Off on OurSQL Episode 203: Scaling by Proxy Part 2
OurSQL Episode 206: Pieces of Fabric
In this episode we discuss sharding and high availability with MySQL Fabric, including installation and configuration. Ear Candy is rolling out GTIDs with no restarting, and At the Movies is putting MySQL Fabric to use, including a live demo.
Continue reading
Posted in Performance, Podcasts, Server Tuning
Comments Off on OurSQL Episode 206: Pieces of Fabric
OurSQL Episode 180: Sharing the Load
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 W… Continue reading
Posted in Performance, Podcasts, Server Tuning
Comments Off on OurSQL Episode 180: Sharing the Load
OurSQL Episode 172: A New Proxy
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 Ha… Continue reading
Posted in Podcasts, Server Tuning
Comments Off on OurSQL Episode 172: A New Proxy
OurSQL Episode 166: Top Hat Options
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 Pac… Continue reading
Posted in Performance, Podcasts, Server Tuning
Comments Off on OurSQL Episode 166: Top Hat Options
OurSQL Episode 165: Top Hat Cluster
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… Continue reading
Posted in Learning, Performance, Podcasts, Server Tuning
Comments Off on OurSQL Episode 165: Top Hat Cluster
OurSQL Episode 145: Biblical Tools, part 3
This week we finish up talking about the Openark Kit for MySQL. Ear Candy is using both –master-data and –tab with mysqldump, and At the Movies features Robert Hodges of Continuent presenting Scalable MySQL Operation in the Cloud with Continuent Tung… Continue reading
Posted in Performance, Podcasts, Server Tuning
Comments Off on OurSQL Episode 145: Biblical Tools, part 3
OurSQL Episode 139: Starting to Perform
This week we discuss the basics of using the performance schema in MySQL 5.5 and 5.6. Ear Candy is about a temporal gotcha when using dates and times that do not exist, and At the Movies is David Stokes giving some useful for System Administrators who … Continue reading
Posted in Performance, Podcasts, Server Tuning
Comments Off on OurSQL Episode 139: Starting to Perform
OurSQL Episode 138: The Relevance of Tungsten
This week we discuss Tungsten and MySQL 5.6 replication with friend of the show, Giuseppe Maxia (aka the Data Charmer). Ear Candy is MariaDB’s Cassandra storage engine, and At the Movies is Giuseppe’s “MySQL 5.6 Replication – features and usability” video from Open Database Camp.
Events
DB Hangops in May will be Wed May 8th and 22nd.
Upcoming MySQL tech tours
Posted in Performance, Podcasts, Server Tuning
Comments Off on OurSQL Episode 138: The Relevance of Tungsten