MySQL Query for Nearest Location Based Service based on Haversine Formula

  • Posted on: 2 November 2014
  • By: oon
Location Based Service with MySQL

MySQL support geospatial since version 5.0.6 with spatial extensions [3], but since MySQL 5.6, it has several new geo functions [2].

But what if we only want to find nearest location that the coordicate (latitude and longitude) stored at MySQL?

Backup MySQL or MariaDB or Percona Data with Percona XtraBackup

  • Posted on: 26 September 2014
  • By: oon
Percona XtraBackup for MySQL/MariaDB/Percoba

So you are maintaining valuable data on MySQL? (or MariaDB or Percona)

Then what's your backup strategy? is it make a master-slave (multi server) MySQL [5], or master-master MySQL servers, or cluster MySQL servers, or at minimum doing data backup?

If you plan to backup MySQL data regularly, you should not use mysqldump, better you use XtraBackup from Percona [1] to backup innodb or xtradb.

From my case, I create a specific user to handle data backup, for example with minimum privileges required [2].