Hello Charlottesville and Montevideo, we are looking for talented software engineers to join our team.

Background

Our company builds database management tools for the world’s leading technology companies. Our users are recognizable, leading websites that you use everyday. We run agents on highly critical production systems, collect a large amount of data, and our clients use our webapp to run their systems better and faster, automatically identify problems, and look at systems in a new way.

We are backed by some very smart investors (#2 on the Netflix Challenge, founder of IPOed tech company, founder of leading AdWords consulting firm), Battery Ventures, and a lot of other cool folks.

Our …

Originally published in the article MySQL Forks: Which one is right for me?, published in the June edition of php[architect]. Oracle’s MySQL is the granddaddy of MySQL servers.  Originally created by Monty Widenius in 1994, it was named after his first daughter, My.  Monty co-founded MySQL AB in order to release MySQL as a free [...]

Using MySQL 5.6.13 under CentOS 6.4, I had a replication failure on one master/slave topology because the master binary log had the following entry that was intentionally written by the MySQL server.

$ mysqlbinlog --start-position=244670849 mysql-bin.000029
...
# at 244670849
#131028 19:31:38 server id 39  end_log_pos 244670906 CRC32 0xc5d084ec
# Incident: LOST_EVENTS
RELOAD DATABASE; # Shall generate syntax error
# at 244670906
...

The question is why? I do not know the answer. Searching online indicates this can occur in a MySQL Cluster environment, and can occur around the use of GRANT statements. Neither of these situations are applicable here. This site runs 4 different master/slave topologies all running the same version, and this has been the only occurrence.

The message, if taken literally could indicate that the master server failed to write all events to the master binary log, but instead of reporting any …

Every day is a new journey but the path remains the same. Bloggers are advancing on this path to reach new milestones. They sometimes pace high, sometime low, but whatever, they never miss to share what they learn along the way, and present that through Log Buffer.

Oracle:

This post is about installing a Virtualized Oracle 12cR1 RAC Cluster using Oracle Linux 6.4 Virtual Machines on VMware ESXi 5.

Frits Hoogland is compressing sqlplus output using a pipe.

One of the greatest advancements in EM12c from previous Enterprise Manager versions is the auto-deployment.

…

I was playing around with MySQL Workbench earlier in the week, and ran across the “clean up SQL” feature, which I thought was neat. Here’s a picture-based demonstration – you can click on the pictures to make them bigger, so … Continue reading

In this post I wanted to highlight

percona.com/bugs/<tool>

 , for example: percona.com/bugs/pt-stalk.  This only works for Percona Toolkit.  We often advise people to check a tool’s current bugs, but we don’t always say how.

The official link for Percona Toolkit bugs on Launchpad is https://bugs.launchpad.net/percona-toolkit/+bugs, but then you still have search from there.  So this quick link is a lot easier if, for example, pt-stalk fails to parse df with NFS …

In the MySQL team, we’ve observed that having a large number of possible SQL modes creates confusion amongst users. For example, if you follow my advice on ‘recommended defaults for new applications’, it is:

sql-mode="STRICT_TRANS_TABLES,
  ERROR_FOR_DIVISION_BY_ZERO,
  NO_AUTO_CREATE_USER,
  NO_AUTO_VALUE_ON_ZERO,
  NO_ENGINE_SUBSTITUTION,
  NO_ZERO_DATE,
  NO_ZERO_IN_DATE,
  ONLY_FULL_GROUP_BY"

This is quite specific, and may be too much to expect of a novice user to set in configuration.

One proposal we are putting forward to address this is to simply reduce the number of options that are available. Namely:

• Remove the options ERROR_FOR_DIVISION_BY_ZERO, NO_ZERO_DATE and NO_ZERO_IN_DATE.
• Have these behaviours be enabled when turning on the …

Percona Live London 2013 is almost here: November 11-12 2013. Team MariaDB & SkySQL will be present, and here’s an agenda if you’re interested in all things MariaDB:

1. Monday, 11.11.2013 – 2-5pm – What’s New in MariaDB 10 and MariaDB Tools – a tutorial from Ivan Zoratti. This is a hands-on lab, complete with virtual machines provided by Ivan. You’ll also get to see MariaDB Manager from the abstract.
2. Tuesday 12.11.2013 – 9.45-10.00am – What’s New in MariaDB 5.5 and what will happen with MariaDB 10.0 – a keynote from Michael “Monty” Widenius of the …

PalominoDB CEO Laine Campbell presented this class at the O'Reilly Velocity Conference, NYC Oct 2013. The class is broken into two videos and is a total of 85 minutes.

Click here for Part 1 - Click here for Part 2

Laine will explain the options for running MySQL at high volumes at Amazon Web Services, exploring options around database as a service, hosted instances/storages and all appropriate availability, performance and provisioning considerations using real-world examples from Call of Duty, Obama for America and many more.

Laine will show how to build highly available, manageable and performant MySQL environments that scale in AWS—how to maintain then, grow them and deal with failure. Some of the specific topics covered are:

…

ScienceLogic has a pretty fantastic network monitoring appliance.  So good in fact that InfoWorld gave it their "2013 Best Network Monitoring System on the Planet" award.  Inside their "ultraflexible, ultrascalable, carrier-grade" enterprise appliance, ScienceLogic relies on MySQL and has since their start in 2003.  Check out some of the things they've been able to do with MySQL and their reasons for continuing to use MySQL in these highlights from our new MySQL ScienceLogic case study.

• Science Logic's larger customers use their appliance to monitor and manage  20,000+ devices, each of which generates a steady stream of data and a workload that is 85% write. On …