OurSQL Episode 191: Common Schema, part 1

This week we start talking about common schema by Shlomi Noach. Ear Candy is some caveats about GTIDs and replication, and At the Movies is using jQuery, AJAX and PHP to insert data into MySQL.

News
In the news, the OurSQL podcast will change to a monthly format after episode 200. We love doing the podcast, but it is very time consuming and production is expensive. We will still bring quality episodes, they will just be spaced further apart.

Common Schema
Common Schema Google Code page

Installation section of the common schema documentation.

Tools discussed:

CALL common_schema.get_routine_dependencies( 'common_schema', 'get_routine_dependencies');
+-------------+--------------------+-----------+------+
| schema_name | object_name | object_type | action |
+-------------+--------------------+-----------+------+
| common_schema | get_sql_dependencies | procedure | call |
| mysql | proc | table | select |
+-------------+--------------------+-----------+------+
2 rows in set (0.07 sec)

Common Schema risks

Ear Candy
In this week's ear candy we discuss replication challenges with GTIDs.

At the movies
This week in at the movies, we present a video on how to Insert Data Into MySQL Database using jQuery + AJAX + PHP

Where you can see us
Sheeri will be at the July Boston MySQL User Group on Monday, July 14th, where we'll have David Berube talking about "Improving Your Database Designs with Practical Database Theory"..

Gerry will be at the July Seattle MySQL User Group on Monday, July 14th.

Sheeri will be attending the TDWI Executive Summit in Boston from Sunday July 20th through Wednesday July 23rd.

Gerry will be attending OSCon 2014 from Sunday July 20th through Thursday July 24th.

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