OurSQL Episode 83: The NewSQL World

This week, we talk with Ori Herrnstadt, CTO of Akiban.

MariaDB announced their 5.3 GA and 5.5 alpha releases.

Oracle will be at DrupalCon in Denver, CO from Monday, March 19th through Friday, March 23rd.

Percona's XtraDB cluster announcement
XtraDB Cluster at the San Francisco MySQL Meetup on Wednesday, March 21st
XtraDB Webinar on Wednesday April 4th

High Performance MySQL, 3rd edition

The upcoming free Oracle Tech Tours are:
Reston, VA on Tuesday, March 20th.
Chicago, Illinois, on Thursday, March 22nd

SkySQL trainings
Paris Mar 27, 2012 – Mar 30, 2012
Boston Apr 02, 2012 – Apr 05, 2012
Paris May 15, 2012 – May 18, 2012
Paris Jun 18, 2012 – Jun 21, 2012

There are more details on the Performance Tuning Class and the full SkySQL Training Schedule includes classes on:
- Administering a MySQL database
- Administering a MySQL cluster
- Developing Applications with the MySQL database
- High Availability for the MySQL database

The Percona Live: MySQL Conference and Expo is from Tuesday, April 10th through Thursday, April 12th. The conference is at the Santa Clara, California Convention Center. Use code PL-pod and save 10% off registration!.
Check out the tutorial and session schedule.

On Friday, April 13th in Santa Clara, CA is the SkySQL and MariaDB Solutions Day, A free one-day seminar on mysql topics.

Also on Friday, April 13th in Santa Clara, CA is Drizzle Day - a one-day workshop on all things drizzle. The event is free, but donations are welcome. Technocation is actually a sponsor of this conference.

Last but not least, also on Friday 13th in Santa Clara, CA Sphinx will have their Sphinx Search Day actually the 3 events are coordinated and are run at the same location as the Percona MySQL UC.

Collaborate, the technology and applications forum for the Oracle Community, has 18 MySQL sessions. Collaborate runs from Sunday, April 22nd through Thursday, April 26th, 2012 at the Mandalay Bay Hotel and Casino in Las Vegas Nevada.

On Wednesday, April 25th in London, Oracle is offering a free seminar, including breakfast, on scaling MySQL.

LinuxFest Northwest will be happening on Saturday April 28th and Sunday April 29th. The MySQL eco-system is usually well represented. If you will be in the Pacific NW, you should consider attending. It's a lively event less than 2 hours North of Seattle and 1hs S of Vancouver.

SELF call for Papers - call for papers is open until Tuesday April 3rd.

The 1st Latin American Conference about Mysql,, NoSQL and Cloud technologies will be held in Buenos Aires Wednesday, June 27th through Friday, June 29th at the Puerto Madero Hilton Hotel.

Interview with Ori Herrnstadt, CTO of Akiban
Akiban is a full-stack software solution that acts as a MySQL slave to execute your worst read queries. It optimizes queries with multiple table joins to be fewer (and in many cases, no) joins, using their table-grouping concept.

Akiban web site

Akiban use cases

If your MySQL queries are running slowly (taking several seconds or even minutes) or if you could benefit from simplifying complex joins transparently, apply for Akiban's design partner program

Backups are recommended via snapshot, there are no special tools to backup Akiban.

Monitoring is the same as using MySQL, just use the regular MySQL templates you use with Cacti/Nagios/whatever.

Wikipedia's definition of normalization

Ear Candy
This week's ear candy is cssh. There's also csshX for Mac

There is also osh and the fabric python library.

At the Movies
This week in at the movies we present Managing Databases in a DevOps Environment by Robert Treat of Omni TI at Postgres Open, in September 2011.
There's a lot of talk in the devops world about bringing developer concepts to system administration, and discussion the other way about bringing the awareness of operations to developers, but a lot of the conversation leaves out what is often the most critical part of your technology stack: the database. Robert talks about how you need a plan that both developers and operations people can understand and embrace, that includes monitoring and visibility, managing schema changes and production pushes, optimization, configuration and backups, specifically as applied to databases.

Videos from PG Open 2011

Where you can see us
Gerry will be at the April Seattle MySQL User Group on Monday April 2nd from 7 - 9 pm. No topic has been set yet.

Sheeri will be delivering a tutorial on White-hat Google Hacking and MySQL Security at Percona Live: MySQL Conference and Expo from April 10-12th, 2012 in Santa Clara, CA. Gerry will be at this conference too.

Sheeri will also be speaking at the SkySQL and MariaDB Solutions Day on Friday, April 13th, 2012 in Santa Clara, CA, giving a session on creating a data warehouse.

Sheeri will be speaking about MySQL Security at the Professional IT Community Conference, Friday May 11 - Saturday May 12 in New Brunswick, NJ

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