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 …

So I came across an odd situation today.

I have a system that creates memory tables using the PHP  $_COOKIE['PHPSESSID'] value.

Once some work is done it then drops the table.

Two sample tables are below for my example .


@@VERSION: 5.6.19-log
CREATE TABLE `f7a7a8d3a7ba75b5eb1712864c9b27eb` (
    ->   `id` int(11) NOT NULL AUTO_INCREMENT,
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=MEMORY;

CREATE TABLE `8865e52c7e1bea515e7156f240729275` (
    ->   `id` int(11) NOT NULL AUTO_INCREMENT,
    ->   PRIMARY KEY (`id`)
    -> ) ENGINE=MEMORY;


Now some simple processing occurs on the real tables I used then like I said I dropped them.
…

Monitoring MySQL and MariaDB databases without a powerful tool like MONyog can be challenging. However, if you already use MONyog you might not be using it to it’s full potential. In this webinar, we will introduce you to the entire feature set of MONyog followed by a Q&A session.

You’ll also be delighted to know that one lucky winner gets MONyog Ultimate worth $399 for free. So, make sure you book your spot.

Date: Tuesday, July 8, 2014
Time: 10:00 am PT
Presenter: Rohit Nadhani (CEO, Webyog)
Register your spot for free

Update: Congratulations to Vandana Sharma on …

Metadata locking has been an exciting adventure for the last couple years in MySQL and MariaDB. Users and applications using only MyISAM tables are learning the joys of locking conflicts between transactions/connections.

read more