What is GTID? 

4c2ad77f-697e-11e3-b2c3-c80aa9f17dc4

• This is the server’s 128 bit identification number (SERVER_UUID). It identifies where the transaction was originated. Every server has its own SERVER_UUID.

What problems GTID solves?

• It is possible to identify a transaction uniquely across the replication servers. Make the automation of failover process much easier. There is no need to do calculations, inspect the binary log and so on. Just MASTER_AUTO_POSITION=1.
• At application level, it is easier to do WRITE/READ split. After a write on the MASTER, you have a GTID so just check if that GTID has been executed on the SLAVE that you use for reads.
• Development of new automation tools isn’t a pain now.

How can I implement it?

Three variables are needed in ALL servers of the …

The North Texas MySQL Uxer Group will meet July 14th in the Oracle office in Irving at 6PM. Part of the topic will be MySQL query & server tuning with MySQL Workbench and part will be a surprise from Oracle ACE, Oracle MySQL ACE, and IOUG big shot George Trujillo who was recently relocated to the Dallas / Fort Worth Area.

And yes, pizza will be served ’cause pizza makes user groups run.

6031 Connection Drive
Suite 900
Irving, TX 75039

In this blog post regarding MySQL for Excel features included since version 1.2.0, we are going to talk about a new option that is used along with Edit MySQLData operations; very useful when editing data in a multi-user environment. If you are not familiar with editing MySQL data it is very advisable that you visit our thorough blog post about that topic: How To - Guide to editing MySQL data within Excel.

Remember you can install the latest GA or maintenance version using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer Zone. …

Here are a few videos those of you who are just getting started with Sphinx may find useful. The first video demonstrates a very simple implementation with Ubuntu, PHP, and MySQL. The second video is also about installing on Ubuntu. And, the last video discusses fulltext query syntax. Check ‘em out. Quick Start with Ubuntu [...]

My previous post was an introduction to the TokuDB storage engine and aimed at explaining the basics of its design and how it differentiates from InnoDB/XtraDB. This post is all about motivating you to give it a try and have a look for yourself. Percona Server is not officially supporting TokuDB as of today, though the guys in the development team are working hard on this and the first GA release of Percona Server with TokuDB is looming on the horizon. However, there’s a beta version available now. For the installation tests in this post I’ve used the latest version of …

Acquisition positions Pythian for industry shift with additional DevOps, big data, enterprise infrastructure, MySQL, and NoSQL services and expertise

OTTAWA, Ontario and SAN FRANCISCO — June 26, 2014 — Pythian, the global leader in data management consulting and services, today announced that it acquired Blackbird.io, a DevOps and data services provider. The acquisition is part of Pythian’s strategy to leverage the rapid increase in demand for agile development, operations, and technology delivered “as a service.” With the addition of Blackbird.io’s team, Pythian will now become the largest open-sourced database managed services company in the world.

Blackbird.io, formerly PalominoDB and DriveDev, is dedicated to helping its customers achieve optimal development velocity and operational excellence. The company supports applications …

MySQL User Camp Bangalore organized on 20th June, 2014 started as per plan. It was a good gathering. We got many users from different companies like Flipkart, CTS, CGI, Yahoo, Onze Technologies, Webyog and few other startups. Apart from this we also got 2 Mysql customers this time from UID Aadhar project managed by HCL.

Event started on its scheduled time with a welcome speech by Srinivasarao Ravuri, (Senior Manager, Software Development at MySQL India) . He thanked all the attendees for coming followed by a brief agenda and handed over the mic to the speakers for presentation.

It was followed by a talk on ” MySQL 5.7 New Features and NoSQL support in MySQL” by Sudipto Sahoo (Senior Engineer at MySQL India). He gave a good summary on the new features …

Kära vännar! Det börjar det dra ihop sig för nästa SMUG-träff, och vi har äntligen spikat tid, plats och agenda.

Denna gången kommer vi att ha en eftermiddag med Ronald Bradford - http://ronaldbradford.com/ - som kommer att vara på plats i sverige. Vi kommer att finnas i B3IT’s lokaler i stockholm den 21 augusti, och vi kommer starta tidigt, 14:00.

På programmet står följande:

• Effective MySQL Architecture and Design Practices
• Effective Web Site Operations
• Upcoming MySQL features for modern applications

Vi kommer att ta en paus eller två på lämpligt ställe och avsluta med Q&A med Ronald Bradford.
Efteråt tänkte vi förflytta oss till ett lämpligt ställe och äta och dricka. Vi vill gärna att ni meddelar oss om ni vill följa med efteråt så att vi vet hur många vi bör boka åt. Kostnad för mat och dryck på …

On 19th June 2014, Mats Kindahl and I presented a free webinar on why and how you should be using MySQL Fabric to add Sharding (scaling out reads & writes) and High Availability to MySQL. The webinar replay is available here. This blog post includes a transcript of the questions raised during the live webinar together with the responses given – if you’re questions aren’t answered already then please feel free to post them as comments here.

Abstract

MySQL Fabric is built around an extensible and open source framework for managing farms of MySQL Servers. Currently two features have been implemented – High Availability (built on top of MySQL Replication) and …

I have spent a few days now playing with CoreOS and helping other members of HP's Advanced Technology Group get it running on their setups.
Today I thought I would write about the good and the bad about CoreOS so far.  Many components are in an alpha or beta state so things may change over the coming months.  Also as a disclaimer, views in this post are my own and not necessarily those of HP.
Installation
As stated in my blog post yesterday, I have been using CoreOS on my Macbook Pro using Vagrant and VirtualBox.  This made it extremely easy to setup the CoreOS cluster on my Mac.  I made a minor mistake to start with, and that is to not configure the unique URL required for Etcd correctly.  A mistake a colleague of mine also made on his first try so it likely to be a common one to make.
I initially …