February Meetup – MySQL & GIS

Share Button

When: Wednesday, February 25th @7pm

Where: The404 (details)

At this month’s meetup, I gave a talk about the current (and soon to be GA) geospatial capabilities of MySQL.  The talk covered such things as:

  • High level geospatial overview
  • Early methods of doing geocoding (lat/lon/radius)
  • Intro to GIS functions (geometry type, st_* functions)
  • The impact of adding SPATIAL indexes to InnoDB (coming in 5.7)

My biggest takeaway from prepping for this talk was how excited I am to see SPATIAL indexes for InnoDB in 5.7 (http://dev.mysql.com/downloads/mysql/5.7.html).  We ran some sample queries with and without indexes and it showed how InnoDB goes from essentially unusable for GIS programming to a very viable solution.

I can’t wait for 5.7 to be GA!!

As promised, here is a link to the slides: http://www.slideshare.net/mbenshoof/mysql-gis

It was great to see everyone and I’m looking forward to next month!


January Meetup – Big Data

Share Button

Its almost that time again…

When: Wednesday, January 28th @7pm

Where: The404 (details)

This month, in a slight change of gears, we are talking about everyone’s favorite topic – Big Data.

Our own Kristin Ferrier will be giving a talk about HiveQL (see, I told you we’d talk about complementary technologies) which should serve as a great introduction to Hadoop/Hive.

Along with that, I’ll give a talk (hopefully just drive a larger discussion) about how MySQL fits into the big data ecosystem.  Some topics will include:

  • MySQL strategies for storing big data
  • Leveraging multiple technologies based on use case
  • Developing a hybrid approach to the problem

I hope to see you there and as always, please RSVP at the meetup site here:  http://meetu.ps/2FfXQn

Hope to see you there!

December Meetup

Share Button

Thanks to those that braved a cold rain the week before Christmas for our last meetup of 2014!

Per your requests, I’ve uploaded the slides from the two talks I gave last night – Intro to MySQL Architecture and Basic Query Optimization.  I’ve also attached the initial Intro to MySQL slides as well.

Also, the previously promised intro series is still forthcoming and I’ll likely reference these slides again in various other posts.

I’d like to kick off 2015 strong and one of the suggestions was to work through some typical scenarios that are problematic.  As we move into the new year, I’ll keep you updated as to the January meetup and also get more intro material posted!

Merry Christmas and have a safe and happy New Years!

– Mike

November, 2014 Meetup

Share Button

Due to the Thanksgiving holiday, we’ve rescheduled the November meeting from the normal 4th Wednesday of the month (which falls on the day before Turkey Day) for Tuesday, November 18th at The404.

This month, Alex Ward will give a talk on some introductory .NET programming using MySQL as a data store.  As .NET is a very popular programming language in the area, this seemed like a great topic to show some of the flexibility and compatibility offered by MySQL.

Please RSVP at the meetup page if you plan to attend so we can get a good count (for food, etc).

Thanks and hope to see you there!

Intro Post Series

Share Button

To complement the theme of “Getting Started with MySQL”, we’ll also be starting a series of blog posts with similar topics:

  • Installing MySQL
  • Some basic SQL
  • Operating System differences
  • and more

Check back soon to see the first post in hopefully a helpful series for those wanting to get started with MySQL!

October Meetup – Intro to MySQL

Share Button

In a step back from previous meetings, we’ll shift the focus to introductory topics about MySQL. Much of the feedback that I’ve gotten is that while some of the more advanced discussion is good, there is a desire for more basic information.

With that in mind, the October Meetup will be just that – an Intro to MySQL.  Some of the topics will include:

  • General database concepts
  • What is MySQL?
  • How is it used?
  • How can I get started with it?

I’ll also include a demo showing a MySQL installation on Windows for those that may not be comfortable diving right into Linux.

As usual, food will be provided and we’ll be raffling off a copy of High Performance MySQL (courtesy of Percona) as well!  Please RSVP as well so we can get an accurate count for food.

Hope to see you there!

Announcing the August Meeting!

Share Button

Building on the enthusiasm and topic from the first meetup, I’m pleased to announce the August meeting on August 27th at 7pm at The 404.  This months meeting will build on July’s topic of indexing strategy by showing some real-world application.

Dave Stokes, Community Manager from Oracle and former MySQL Certification Manager for MySQL AB and SUN will discuss how to use EXPLAIN to optimize queries that are shown to be sub-optimal.  This is a very common task for MySQL DBAs and also a good practice for developers (DBAs love it when their developers think about query execution prior to code being deployed).

I’ll also give a brief talk on how you can collect traffic from a production system and isolate problem queries.  More often than not, bad queries are the source of server problems so identifying and optimizing them is key to keeping your database running optimally.

Like last time, we’ll be providing pizza, drinks, and snacks – hope to see you there!

– Mike

First Meeting – Peter Zaitsev as Guest Speaker

Share Button

I’m pleased to announce that the first meet-up of the OKC MySQL User Group will take place on July 23rd at 7pm in the Oklahoma City Film District at the Paramount OKC.  For the initial meeting, I wanted to bring in a guest speaker to help generate some extra excitement.  I think our first guest should do just that…

Peter Zaitsev, co-author of High Performance MySQL and CEO of Percona was kind enough to offer his time to give a presentation covering “MySQL – Indexing Best Practices”, followed by a question and answer session.  This is a great opportunity for anyone interested in MySQL to hear from one of the household names in the community!

We’ll be providing pizza and drinks (courtesy of Percona) and will also be raffling off some additional items, including a pass to the 2015 Percona Live MySQL Conference and Expo in Santa Clara.

Please spread the word to anyone and everyone in the industry and I look forward to seeing you at our first event!

– Mike


Inaugural Meetup

Share Button

I’m currently planning the first meetup for the OKC MySQL users group.  The general timeframe is currently late July with specifics (time/location) yet to be determined.

I’m working on bringing in an exciting outside speaker and will post more details as the time approaches.  If you have any ideas for topics that you would like to discuss, please add them as comments to this thread.

You can also join our group on meetup.com and here is the link for this event (you should sign up and I’ll broadcast more information as it becomes available).

Thanks and I look forward to seeing you there!

OKC MySQL User Group Launched!

Share Button

In response to some discussion with other attendees at the recent Spring Beta 2014 conference in Oklahoma City, I’ve decided it is time to create a local MySQL User Group.

The goal of this site is to bring local users of MySQL together through meet-ups and this online forum to discuss the current database environment of the metro.  What are the trends?  What are you seeing in the industry?  What can we do to improve the ecosystem?

Topics on this site will be geared towards MySQL, but it can also serve as a forum to discuss database technologies in general.

Be sure to check back often as we plan to get our first meet-ups on the calendar over the summer!

– Mike