Jeeze people. You’re all noisy. I’m sure it was all done for posterity’s sake.

23M     irclogs/MagNET/#perl.log
29M     irclogs/freenode/#mysql.log
36M     irclogs/freenode/#debian.log
37M     irclogs/foonetic/#xkcd.log
39M     irclogs/OFTC/#debian.log
43M     irclogs/freenode/#jquery.log
44M     irclogs/freenode/#perl.log

$ for file in irclogs/MagNET/#perl.log irclogs/freenode/#mysql.log irclogs/freenode/#debian.log irclogs/foonetic/#xkcd.log irclogs/OFTC/#debian.log irclogs/freenode/#jquery.log irclogs/freenode/#perl.log; do echo -n "$file: " ; head -1 $file ; done
irclogs/MagNET/#perl.log: --- Log opened Thu May 26 08:31:32 2011
irclogs/freenode/#mysql.log: --- Log opened Wed Dec 28 09:03:49 2011
irclogs/freenode/#debian.log: --- Log opened Tue Mar 12 12:52:40 2013
irclogs/foonetic/#xkcd.log: --- Log opened Wed Dec 28 19:33:43 2011
irclogs/OFTC/#debian.log: --- Log opened Tue Jul 12 19:25:48 2011
irclogs/freenode/#jquery.log: --- Log opened Tue Jan 31 …

We get a lot of questions about what our Adaptive Fault Detection algorithm really is and how it works. Although I can't tell you exact details, I want to explain a few things about what our algorithm is and what kind of results it can deliver. I get a lot of questions about it that assume it's just anomaly detection, so I'll cover that. I will also show a couple of representative faults our system has detected.

What Is A Fault?

In simplest terms, a fault is a momentary stall, where requests for work (queries, IO operations) continue to arrive but are not being serviced.

Our fault detection algorithm is based on queueing theory, and observes work requests arriving, in progress, and completing. When work continues to arrive, queues up, and does not complete, the system is stalled.

Faults are typically caused by system overload or poor performance. Either something is demanding more than it should from the …

We're Hiring!

VividCortex has several open positions, both technical and non-technical. All of these positions are fulltime, based in Charlottesville, VA or Montevideo, Uruguay. Our benefits include:

• Fulltime salaried positions
• Working with some of the coolest customers in the world
• Flexible work environment, unlimited vacation and remote working opportunities
• Competitive salaries
• Option grants
• Change to work on challenge startup challenges
• Use technologies like Go, Angular, D3, MySQL, Kafka and more bleeding edge stuff
• Full healthcare and dental coverage for US employees
• Lunches, cellphone and a macbook

Charlottesville Office Manager & Startup Ninja

Ideally, the candidate is incredibly organized, knows how to get stuff done, a strong communicator, and wants to be part of a fast-growing startup. The …

We're Hiring!

VividCortex has several open positions, both technical and non-technical. All of these positions are fulltime, based in Charlottesville, VA or Montevideo, Uruguay. Our benefits include:

• Fulltime salaried positions
• Working with some of the coolest customers in the world
• Flexible work environment, unlimited vacation and remote working opportunities
• Competitive salaries
• Option grants
• Change to work on challenge startup challenges
• Use technologies like Go, Angular, D3, MySQL, Kafka and more bleeding edge stuff
• Full healthcare and dental coverage for US employees
• Lunches, cellphone and a macbook

Charlottesville Office Manager & Startup Ninja

Ideally, the candidate is incredibly organized, knows how to get stuff done, a strong communicator, and wants to be part of a fast-growing startup. The …

No news in telling Galera is the synchronous multi master solution for MySQL.
But Galera is just a provider.

What do you mean by provider?

Remember configuring “Galera”?
There are two options
wsrep_provider and wsrep_provider_options
These define the provider (Galera) and the options for the provider.
The rest of the wsrep_ options are for wsrep.

https://launchpad.net/wsrep

wsrep API defines a set of application callbacks and replication library calls necessary to implement synchronous writeset replication of transactional databases and similar applications. It aims to abstract and isolate replication implementation from application details. Although the main target of this interface is a certification-based multi-master replication, it is equally suitable for both asynchronous and synchronous master/slave replication.

So yes, …

Help fill up the MySQL track at the Southeast Linux Fest. RFP for #self2014 has been extended to Mon April 28th at 9 PM ET. Last chance! Get those talk submissions in!

MariaDB 5.5.37 was recently released (it is the latest MariaDB 5.5), and is available for download here:

https://downloads.mariadb.org/mariadb/5.5.37/

This is a maintenance release, and so there are not too many big changes of note, just a number of normal bug fixes. However, there are a few items worth mentioning:

• Includes all bugfixes and updates from MySQL 5.5.37

read more

I received a panic call from a newbie MySQL DBA. Or should I say the ‘Linux Admin’/’MySQl DBA’/’CSS guru’/’PHP Programmer’/’Network Admin’/’Backup Operator’/’CIO’ of a small business. He had reset his password was was now locked out. Luckily, he had only changed his password and still had root access.

What he did:
mysql>use mysql;
SET PASSWORD for 'mrdoesall'@'10.%' to 'bigsecret';
mysql>


Long time MySQL DBAs should be groaning at this with a wince remembering when it happened to them. For those of you who did not catch the problem, what happened is that he value in the user.password table is set to the string ‘bigsecret’. When our friend tries to login, the password is encrypted and compared to the value in user.Password. The comparison of the encrypted value does not equate to the unencrypted value and the login fails.

The presentations submitted for MySQL Connect are amazing. This year again I am very fortunate and slightly cursed to be on the selection committee again. Fortunate that I get a glimpse of some truly amazing work being done with MySQL. And cursed in that there are a lot of great talks that will not make it that I still want to see.

We had over 190 submissions for 50 some odd speaking slots. In the past there has been some over lap with two members of the same engineering team proposing slight variations on a topic that can be combined. Sometimes there are blatantly obvious marketing sessions that will not only speed you queries, brighten you teeth, but also walk your dog. Usually it is easy to pick out a few obviously poor proposals. But not this year. They are all pretty much technical raw meat, dripping with staggering loads of vital information. …

I started using MySQL 11 years ago.  That’s not too long compared to other people in the industry, but nonetheless here’s my perspective on the state of the MySQL industry after attending Percona Live MySQL Conference & Expo 2104.

In short, the attitude around MySQL has changed from “Does it work?” to “Is it fast and reliable?” to “How do we manage it?” To further generalize, these periods correspond roughly to the original MySQL AB team, Percona and Oracle, and the last period is the current period so key players are emerging, like WebScaleSQL.

Does it work?

Peter Zaitsev said in one of his keynote talks that MySQL used to be considered a toy.  Today that …