EmergencyEMERGENCY? Get 24/7 Help Now!

MySQL and geospatial programming: An introduction to GIS

 | March 13, 2015 |  Posted In: Insight for Developers, MySQL

Geographic information systems (GIS) are used by application developers to incorporate geographic information into their datasets to create apps with cool features such finding the address to the best steakhouse in town or the locations of local points of historical interest (the list is endless). In a nutshell, GIS captures, store, checks and displays data […]

Read More

Integrating pt-online-schema-change with a Scripted Deployment

 | November 21, 2013 |  Posted In: Insight for DBAs, MySQL, Percona Server, Percona Software

Recently, I helped a client that was having issues with deployments causing locking in their production databases.  At a high level, the two key components used in the environment were: Capistrano (scripted deployments) [website] Liquibase (database version control) [website] At a high level, they currently used a CLI call to Liquibase as a sub-task within […]

Read More

pt-online-schema-change and binlog_format

 | June 24, 2013 |  Posted In: Insight for DBAs, MySQL

Statement-based or row-based, or mixed?  We’ve all seen this discussed at length so I’m not trying to rehash tired arguments.  At a high level, the difference is simple: Statement based replication (SBR) replicates the SQL statements to the slave to be replayed Row based replication (RBR) replicates the actual rows changed to the slave to […]

Read More

MySQL 5.6 – InnoDB Memcached Plugin as a caching layer

 | March 29, 2013 |  Posted In: MySQL

A common practice to offload traffic from MySQL 5.6 is to use a caching layer to store expensive result sets or objects.  Some typical use cases include: Complicated query result set (search results, recent users, recent posts, etc) Full page output (relatively static pages) Full objects (user or cart object built from several queries) Infrequently […]

Read More