OurSQL Episode 191: Common Schema, part 1_MySQL
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 SchemaGoogle Code page Installation sectionof the common schema documentation.
Example of get_routine_dependencies(): 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 discussreplication challenges with GTIDs. At the movies This week in at the movies, we present a video on how toInsert Data Into MySQL Database using jQuery + AJAX + PHP Where you can see us Sheeri will be at theJuly Boston MySQL User Groupon Monday, July 14th, where we'll have David Berube talking about "Improving Your Database Designs with Practical Database Theory".. Gerry will be at theJuly Seattle MySQL User Groupon Monday, July 14th. Sheeri will be attending theTDWI Executive Summitin Boston from Sunday July 20th through Wednesday July 23rd. Gerry will be attendingOSCon 2014from 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 orTweet about @oursqlcast Trackback URL for this post:http://technocation.org/trackback/1323 |