Skip navigation links
MySQL 5.7 DMR4

Developer Articles RSS Feed for DevZone articles

Making Use of Boost Geometry in MySQL GIS

By David Zhao | April 22, 2014

This post talks about how we make use of Boost.Geometry in MySQL to implement reliable and efficient GIS functionality, as well as changes to the GIS features in the lab release. Now that InnoDB is the default storage engine for MySQL, our user base is rapidly transitioning to InnoDB. One capability that they have been demanding is a performant and scalable GIS implementation. Along with adding R-tree index support to InnoDB, we also decided to replace the original GIS algorithms with a more powerful, reliable, effective and efficient geometric engine.

MySQL 5.7 and GIS, an Example

By Matt Lord | April 22, 2014

This post will offer a very simple demonstration of how you can use MySQL 5.7 for Spatial features within your applications. In order to demonstrate this, I’ll walk through how we can determine the 10 closest Thai restaurants to a particular location.

MySQL Fabric RC - Adding High Availability and/or Scaling to MySQL

By Andrew Morgan | March 31, 2014

MySQL Fabric provides a simple way to manage a collection of MySQL Servers and ensure that transactions and queries are routed to the correct server. We're pleased to announce that the Release Candidate load is now available! This article explains what MySQL Fabric is and how to set it up. It also gives an example of how it can be used to introduce High Availability (including automated failure detection and transparent failover) and/or scale-out (using data partitioning/sharding).

MySQL Cluster 7.3 GA: Increasing Developer Flexibility and Simplicity

By Andrew Morgan | June 18, 2013

The MySQL team at Oracle are excited to announce the immediate availability of the MySQL Cluster 7.3 Development Milestone Release GA release. Some might call MySQL Cluster 7.3 "the foreign keys release" - and sure enough it is a major engineering achievement to build a distributed database that enforces referential integrity across a shared-nothing cluster, while maintaining ACID compliance and cross-shard JOINs. But MySQL Cluster 7.3 is so much more as well. The design focus has been on enabling developer agility - making it simpler and faster than ever to enhance new services with a highly scalable, fault tolerant, real-time database - with minimum development or operational effort.

MySQL 5.6: Improvements in Thread Pool

By Mikael Ronström | May 15, 2013

MySQL Thread Pool has now been updated for the MySQL 5.6 version. Obviously, with the much higher concurrency of the MySQL Server in 5.6 it's important that the thread pool doesn't add any new concurrency problem when scaling up to 60 CPU threads. The good news is that the thread pool works even better in MySQL 5.6 than in MySQL 5.5. MySQL 5.6 has fixed even more issues when it comes to execution of many concurrent queries and this means that the thread pool provides even more stable throughput almost independent of the number of queries sent to it in parallel.

More Developer Articles »

MySQL Quickpoll RSS Feed for Quickpolls

Which Operating Systems do you deploy your PRODUCTION MySQL applications on?

Microsoft Windows
Oracle/RedHat Enterprise Linux
CentOS Linux
Fedora Linux
SuSE Enterprise Linux
OpenSuSE Linux
Debian Linux
Ubuntu Linux
Gentoo Linux
Other Linux
Solaris
MacOS X
FreeBSD
OpenBSD
AIX
HP-UX
Other

View results »

More Quickpolls »