[…] Announcing new Yum repositories for MySQL. This is a big deal, for anyone running MySQL or a related product. It was MariaDB‘s yum repositories which made it easy for me to migrate to v5.5 from 5.1 in CentOS. […]

There’s a lot to love about the MySQL product documentation – a lot of hard work from a number of very talented Oracle staff goes into it (not to mention the helpful suggestions and feedback from the community).  There is, however, one page I find myself coming back to again and again, despite the fact that it’s somewhat hard to find.  This is the MySQL Server options/variable reference page.  It’s a helpful table that lists every MySQL Server option or variable, what version it was introduced or deprecated in, whether it’s dynamic or not, whether variables have session/global/both scope, and links to the version-specific documentation for that variable (useful to know when default values changed, for example).

It always takes me a while to find this page again when I’m looking for it, as it’s …

We are pleased to announce that MySQL Enterprise Monitor 3.0.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available via the Oracle Software Delivery Cloud with the November update in about 1 week. This is a maintenance release that fixes a number of bugs. You can find more information on the contents of this release in the change log.

You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then use the "Product or Family (Advanced Search)" feature.

You will also find the binaries on the Oracle Software Delivery Cloud in approximately 1 week. Choose "MySQL Database" as the Product Pack and you will find the Enterprise Monitor along …

This week we discuss the basics of MySQL Workbench. Ear Candy is using performance schema to find unused accounts, and At the Movies presents XtraDB Cluster.

News
Oracle announced that it is providing yum repositories for MySQL, including MySQL packages, MySQL workbench and MySQL connectors.

MySQL Workbench
features of MySQL Workbench - community vs. standard vs. enterprise

MySQL Workbench 6.0 interface changes with pictures.

read more

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 …