September Meetup – Back to Basics

This month, in honor of the start of the school year, we’ll be going over some of the basics of MySQL:

  • Concepts and Terms
  • Installation
  • Basic usage

I hope to see you at the meetup this Wednesday, Sept 23rd at 7pm at the 404:

September Meetup – Back to Basics

Wednesday, Sep 23, 2015, 7:00 PM

The 404
704 W Sheridan Avenue Oklahoma City, OK

4 Members Attending

As we dive back into a new school year and things ramp back up, I’d like to revisit some of the basics and hopefully introduce MySQL to some people.We’ll go over some high level concepts, basic installation, some tools, and more.If you know anyone that may be interested in learning about MySQL, this would be the meetup to attend!

Check out this Meetup →

If you know anyone that is interested in MySQL, this would be the meetup to attend!

– Mike

August Meetup – Triggers and Stored Procedures

This month, we’ll talk about Triggers and Stored Procedures per some suggestions for last month.  MySQL has support for both and we’ll talk about some of the caveats and real world experiences.

As usual, we’ll provide food and drink.  Hope to see you there!

August Meetup – Triggers and Stored Procedures

Wednesday, Aug 26, 2015, 7:00 PM

The 404
704 W Sheridan Avenue Oklahoma City, OK

1 Members Attending

Per some suggestions last month, we’ll look at various aspects of triggers and stored procedures in MySQL.As usual, the goal is to be interactive and prompt discussion.  Food and drink will be provided – hope to see you there!Mike

Check out this Meetup →

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

I’ll be out of town for work, but #okcmysql member Josh Walcher ( 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:

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 1

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:

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