June Meetup – Building An AWS-like Platform With Auto-Scaling Databases & Web servers

Share on Tumblr

I’ll be out of town for work, but #okcmysql member Josh Walcher (http://www.bigboardroom.com/) will be driving a discussion about scaling applications using various automation, APIs, and other techniques.

The goal is to hopefully introduce folks to some new ideas while having an interactive discussion to see what others are doing to manage similar issues.

Pizza will be provided as usual and if it works out, I’ll hopefully be able to join remotely for some of the talk as well.  And please RSVP here so we can get a good head count for food:  http://www.meetup.com/Oklahoma-City-MySQL-Meetup/events/222840388/

Hope to see you there and thanks Josh for offering to drive the discussion while I’m out of town!

Installing MySQL for Testing – Part 2

Pin It
Share on Tumblr

As a continuation of Part 1 in this tutorial, we’ll work through some basic interaction with our test database using MySQL Workbench.  Some things we’ll cover include:

  • Setting our current database
  • Creating a new table
  • Inserting rows into a table
  • Selecting rows from a table
  • Basic UI review of Workbench

Without further adieu, lets get started using MySQL!

Continue reading

Installing MySQL for Testing – Part 1

Pin It
Share on Tumblr

At long last…  the first real post of the intro series on getting started with MySQL!  (Better late than never, right?)

There are a few ways you can go about setting up a test instance that are generally shared across Operating Systems:

  • Install locally on your machine (Windows, OSX, Linux)
  • Set up a local Virtual Machine, then install MySQL on the VM
    • This is my preference as it also allows me to get familiar with the OS (preferably Linux)
  • Set up a quick Amazon EC2 Instance
    • This is easiest if you are comfortable with EC2, but can also be costly if you forget to turn off an instance or want to spend lots of time testing and experimenting

For the sake of folks getting their feet wet, I’ve setup a Virtual Appliance that you can import and start using right away:

https://s3.amazonaws.com/okcmysql/MySQL-Testbed.ova

The rest of this post and Part 2 will be a step-by-step guide on getting starting with the above appliance.  So lets get started!

Continue reading

Operating System Survey

Share on Tumblr

As I start to work through some various tutorials and other instructional guides, I want to get a feel for what people are using.  Please let me know what OS you are currently using and which OS(s) you feel comfortable with.

Ideally, I’m planning to provide a VirtualBox appliance built out with CentOS (linux) that you can run on any machine.  Depending on your comfort level, you can interact with MySQL using:

  • MySQL UI Tools (workbench)
  • VM command line (ssh into VM, then work locally)
  • Local command line client

What Operating System do you use on your own computer/laptop?

View Results

Loading ... Loading ...

What Operating System(s) are you comfortable with?

View Results

Loading ... Loading ...

Check back for a post discussing Virtual Box as it should prove to be a great tool for experimenting with and learning MySQL, regardless of the OS you are used to using.  It will also allow you to experiment, make changes, etc and not worry about impacting your actual system.

February Meetup – MySQL & GIS

Share on Tumblr

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!