Today on the show, I am joined by my colleagues, John Schulz and Valerie Parham-Thompson. Both John and Valerie just returned from the MariaDB Conference in New York City. As MariaDB is a native, relative and viable option to MySQL, I thought that it would be a good time to delve into the platform in detail and share what we have discovered with you here today. In this episode, we find out more about the MariaDB Conference – why it was founded, what the attendance was like and who the Conference is beneficial for. We then take a closer look at MariaDB and investigate the key differences between MariaDB and MySQL – highlighting MariaDB’s newest and most user-friendly features. We also learn more about other software platforms, such as Percona and Oracle, and how they compare to MariaDB. Our insightful guests continue to offer some helpful tips and resources for anyone getting started in MariaDB. So, if you are currently using MySQL or MariaDB, …
[Read more]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.
This week we discuss advanced pt-table-sync, including bidirectional sync. Ear Candy is starting MySQL on low-memory virtual machines, and At the Movies is "What's New With MySQL and MariaDB?"
pt-table-sync
Episode 188,
where we talked about pt-table-sync basics
pt-table-sync documentation
Options discussed:
--bidirectional
--chunk-column
--conflict-column
--conflict-comparison - greatest, least, newest, oldest, equals,
matches
--conflict-value
--conflict-error
This week we discuss pt-table-sync basics. Ear Candy is about how MyISAM can seem transaction-aware, and At the Movies is MySQL and NoSQL at Craigslist.
Events
DB Hangops -
every other Wednesay at noon Pacific time
Upcoming SkySQL events
Upcoming MySQL events
OSCon 2014 will be held at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.
This week, we discuss DB Hangops with special guest, Geoffrey Anderson. Ear Candy is that GTIDs in MariaDB and MySQL are different, and At the Movies is Jonathan Levin talking about deduplicating your data with MySQL.
DB Hangops
DB Hangops -
blog and videos of previous hangouts
YouTube DB Hangops channel
DB Hangops
twitter account
Anemometer, a tool for reporting on and graphing slow queries, developed by Box.
This week we talk with former co-host Sarah Novotny about Data at OSCon. Ear Candy is about SQL Courses, and At the Movies is a two and a half hour tutorial about MySQL Scaling Strategies for Developers.
Events
DB Hangops -
every other Wednesay at noon Pacific time
OSCon 2014 will be held at the Oregon Convention Center in Portland, Oregon from Sunday July 20th through Thursday July 24th.
This week we discuss pt-table-checksum for keeping data in sync. Ear Candy is a rational look at why one company chose MySQL; At the Movies is using MySQL in a practical way for Big Data.
pt-table-checksum
pt-table-checksum
pt-table-sync
Episode 151,
where we talked about Oracle toolsmysqldbcompare and
mysqldiff
Options discussed:
--replicate, --no-create-replicate-table
This week we discuss MySQL and Geographical Information Systems (GIS). Ear candy is how MVCC in InnoDB relates to undo logging and how you can write better queries based on this information. At the Movies is a demo of GIS.
MySQL and MariaDB geographic information
Geographic features in MariaDB
Spatial Extensions in MySQL
The SQL part of the OpenGIS Implementation Standard
for geographic information, from the Open Geospatial
Consortium's website.
This week we discuss new optimizer improvements in MariaDB 10. Ear Candy is about the MariaDB threadpool, and At the Movies is Oracle's Tomas Ulin talking about raising the bar with MySQL.
Events
DB Hangops -
every other Wednesay at noon Pacific time
Training
SkySQL Trainings
This week we discuss more features of MariaDB 10. Ear Candy is how to avoid downtime when switching to GTIDs and At the Movies is Managing Hundreds of MySQL Servers Efficiently.
News
MySQL Community Awards 2014: the Winners
MariaDB 10
MariaDB 10.0.1 features
Other MariaDB podcasts:
OurSQL Episode
89, where we talk about an overview of MariaDB