The MySQL Enterprise Monitor Advisors version 2.3.4.2076 is now available.

Welcome to the MySQL Enterprise Tools team's blog. 

Our team focuses on creating tools for monitoring and managing your MySQL environments. 

Here we will discuss various things relating to the MySQL Enterprise Monitor, MySQL Proxy, MySQL Connector Plugins, and any other things that generally interest us within the team. 

We will also give new release announcements here, and aggregate these within the MySQL Enterprise Monitor "What's New" feed.

Welcome to the MySQL Enterprise Tools team's blog. 

Our team focuses on creating tools for monitoring and managing your MySQL environments. 

Here we will discuss various things relating to the MySQL Enterprise Monitor, MySQL Proxy, MySQL Connector Plugins, and any other things that generally interest us within the team. 

We will also give new release announcements here, and aggregate these within the MySQL Enterprise Monitor "What's New" feed.

It’s the scorching summer season in this part of the world, Pakistan. There are many summer woes as the temperature reaches to 45 centigrade and beyond, but that also brings in the most savored fruit of the world, the king of fruits, Mango. Pakistan is one of the largest producer and exporter of this fruit from paradise. There are many variates of mangoes and its hard to pick from them as they all are so sweet and eye catching. Same is the case with the database related blogs, when it comes to selection for the edition of Log Buffer. So once again here you are, about to savor the sweet blogs in Log Buffer #224.

Oracle:

Automatic Diagnostic Repository (ADR) has changed the way we think about logs and traces in Oracle. …

After the success of Percona Live in New York, we have published in our website the presentation slides of talks from the leading experts in MySQL. Check it out.

Percona is glad to announce the release of Percona Server 5.5.12-20.3 on June 9, 2011 (Downloads are available here and from the Percona Software Repositories).

Based on MySQL 5.5.12, Percona Server 5.5.12-20.3 is now the current stable release in the 5.5 series.

Other Changes

• The list of authors of the plugins used have been corrected. Bug Fixes:#723050 (Y. Kinoshita)

For more information, please see the following links:

• Downloads: Binary distribution,  …

Open Ocean's new Fund celebrated with pitching competition - I'll give the winner Black vodka as much as he/she can carry (inside and outside)!

I am delighted that we now have been able to launch our new Open Ocean Fund. With 40 M euro (60M USD) in first closing, the race is now on to identify new disruptive start ups, that we with Community and Open Source strategy and proper funding, can help drive for similar success as achieved with MySQL.

In my mind a vital part of entrepreneurship is to be able to combine work with fun!

For this reason we decided to launch a pitching competition, where we bring the winning team to Finland, both for good worktime with our team, but also for some social time and nice …

Tungsten Replicator is a powerful replication tool, designed to replace and enhance MySQL native replication. In addition to moving data between MySQL servers, Tungsten Replicator also provides more powerful features, such as centralized replication administration tools, global transaction IDs, multiple masters, parallel replication. With such power comes also greater complexity. But fear

NDB cluster is a very interesting solution in term of high availability since there are no single point of failure. In an environment like EC2, where a node can disappear almost without notice, one would think that it is a good fit.

It is indeed a good fit but reality is a bit trickier. The main issue we faced is that IPs are dynamic in EC2 so when an instance restarts, it gets a new IP. What the problem with a new IP? Just change the IP in the cluster config and perform an rolling restart! no? In fact this will not work, since the cluster is already in degraded mode, restarting the surviving node of the degraded node group (NoOfReplicas=2) will cause the NDB cluster to shutdown.

This can be solved by using host names instead of IPs in the config.ini file. What needs to be done is to define, in /etc/hosts, on entry per cluster member. The API nodes are not required. Here is an example:

$ more /etc/hosts
127.0.0.1 …

I don’t need to emphasize how productive you can be if you find what you are looking for in a quick and easy way. Google has shown it to us. Wouldn’t it be fun to have the same ease and speed while searching for data in your databases? Well, that’s what Data Search is all about. Find the data you want without writing any queries or worrying about the underlying schema. Type in the search string and you’ll have a table of all search results waiting to be clicked and be taken to the exact cell of the table. It also supports search operators like AND, OR and “”. Note that the results of this search is not the same as WHERE clause query results. Its rather a natural way of search. Lets say its like googling your database. For better precision you can search with regular expressions too.

…