MySQL 5.6 introduced major advances to monitoring made via PERFORMANCE_SCHEMA, but also made a change in how it binds to the network by default.  In MySQL 5.5, the –bind-address configuration option defaulted to “0.0.0.0″, meaning only IPv4.  This changed to “*” in MySQL 5.6, accepting connections on both IPv6 and IPv4 interfaces.  Somehow (I’ve not looked into it yet), my (unsupported) WindowsXP installation now refuses to bind to IPv4, which caused surprising problems for certain tools that seem to internally map “localhost” …

What is Amazon Redshift and how does it compare to Shard-Query?

Amazon Redshift is the petabyte scale data warehousing system built by Amazon.   It is (currently at the time of this writing)  a beta-quality data warehouse as a service platform hosted in the AWS cloud.   It has has been built from ParAccel technology.  Amazon is an investor in ParAccel.

Amazon Redshift works similarly to Shard-Query.   Both systems allow you to spread data over many machines and treat them as one logical machine.  This architecture  is called “shared nothing” and it has developed the short name “sharding”.

Both systems essentially provide a “virtual database” composed of smaller database.  It is like a RAID array of databases.  You could think of it as a “redundant array of independent databases” in fact.

Sharding

Both Redshift and Shard-Query shard your data …

Some time ago, MySQL Forge went offline.

As part of the Forge dismissal operations, I got a backup of my snippets from the MySQL community team, and I have been lazily looking around for an alternative place where to put them.

I found such a place: Github GIST
Gist is a simple way to share snippets and pastes with others. All gists are git repositories, so they are automatically versioned, forkable and usable as a git repository.

Out of my 25 snippets, these are the ones that still look useful (at least, people have been asking me about those).

• Measuring replication speed
• Poor man's replicator monitor
• …

Join 8000 others and follow Sean Hull on twitter @hullsean. In the past two years we’ve written a ton of material on scalability. Here’s the greatest hits… Why Generalists Are Better at Scaling the Web The internet stack is a complex infrastructure of interlocking components. An scalability engineer must be adept at Linux, plus webservers, […]

The post Scalability Tips & Greatest Hits appeared first on Scalable Startups.

Dolphin and Elephant: an Introduction

This post is intended for MySQL DBAs or Sysadmins who need to start using Apache Hadoop and want to integrate those 2 solutions. In this post I will cover some basic information about the Hadoop, focusing on Hive as well as MySQL and Hadoop/Hive integration.

First of all, if you were dealing with MySQL or any other relational database most of your professional life (like I was), Hadoop may look different. Very different. Apparently, Hadoop is the opposite to any relational database. Unlike the database where we have a set of tables and indexes, Hadoop works with a set of text files. And… there are no indexes at all. And yes, this may be shocking, but all scans are sequential (full “table” scans in MySQL terms).

So, when does Hadoop makes sense?

First, Hadoop is great if you need to …

In MySQL Workbench 6.0, three longstanding issues related to model synchronization were addressed. In this post, we’ll cover how these issues can happen, the underlying cause and how to resolve them.

Model Synchronization

When you synchronize a model to a database, Workbench performs the following steps:

1. Retrieve and reverse engineer the target schema from the database, to an internal representation that can be worked on by Workbench
2. Compare the schema from the model with the corresponding schema from the database, object by object
3. For each difference found, perform the corresponding action needed to change either the source or the target object, so they’re both looking the same. This may mean creating, altering or dropping objects in the database or updating the model to match the database. Because some of these actions can be destructive (such as when a table or column needs to be …

When I started writing this I wrote "Last week Opscode came" obviously now that is "A couple of months ago Opscode came with a bunch of announcements ... one of them being that they are also going to support the Open Source Chef .. rather than only their own platform.

I'd love to see more companies formally do this .. Over the past couple of years I've had numerous situations where organizations where happy to pay for support to an commercial backer of Open Source software... but they were not interested in , software updates, fancy dashboards , unneeded features.

Let alone being limited by some of the features of the Enterprise product (what do you mean there's no vlan support in Xen ? We've been using that for ages (anno 2008)

Even right now I`m talking with a customer that is interested in getting …

People often wonder why DBA's used to hate developers, and with DBA's also the System Engineers,
(note that I just expanded devops by adding dba's to the picture..)

So let me tell you a story ..

A couple of weeks ago one of our customers wanted to start experimenting with a new type of CRM. A gamified CRM.
Zurmo ...

So we set this thing up in a dev environment and started playing with it , while at first it looks nice ..
the application actually felt pretty slow.. however given that is a low resource development environment we looked no further.

Yet the next step is that we run into missing features, such as the fact that every contact you create by default is
set to private .. which really isn't productive for a CRM system where you want to be able to follow up on different
customer and share information.

So we tried figuring out what the database changes to do this in …

As an update to the previous announcement placed on May 15, 2013 I have the pleasure to announce additional events and conferences which MySQL Community Team supports! We are not only an event partner but we also secure the MySQL technical staff, at some events also Java, Oracle VM and Oracle Linux experts as well. Please come to any of the events below and talk to our staff about the latest news Oracle supported technologies! You can find us at:

• PHP UnConference, Hamburg, Germany, September 21-22, 2013
  • There is no schedule set for such events as UnConference. This event is mostly for PHP experts and engineers and the whole schedule is done usually on the place. MySQL is presented!
    
  • Tickets are available for purchasing …

In Part 1 of "SFTP virtual users with ProFTPD and Rails", I introduced ProFTPD's virtual users and presented my annotated proftpd.conf that I used to integrate virtual users with a Rails application. Here in Part 2, I'll show how we generate virtual user credentials, how we display them to the user, as well as our SftpUser ActiveRecord model that does the heavy lifting.

Let's start at the top with the SFTP credentials UI. Our app's main workflow actually has users doing most of their uploads through a sweet Plupload widget. So, by default, the SFTP functionality is hidden behind a simple button sitting to the right of the Plupload widget:

The user can click that button to open the SFTP UI, or the Plupload …