MySQL Enterprise Monitor Advisors version 2.3.9.2137 is now available.

Somebody asked for a simple comparison between a PL/SQL pass-by-value function and pass-by-reference procedure, where the procedure uses only an OUT mode parameter to return the result. This provides examples of both, but please note that a pass-by-value function can be used in SQL or PL/SQL context while a pass-by-reference procedure can only be used in another anonymous of named block PL/SQL program.

The function and procedure let you calculate the value of a number raised to a power of an exponent. The third parameter lets you convert the exponent value to an inverse value, like 2 to 1/2.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

CREATE OR REPLACE FUNCTION find_root_function
( pv_number   BINARY_DOUBLE
, pv_power    BINARY_DOUBLE
, pv_inverse  BINARY_INTEGER DEFAULT 0 ) RETURN BINARY_DOUBLE IS
 
  -- Declare local variable for return value. …

In February of 2012 Iggy Fernandez interviewed me for the NOCOUG Journal. A PDF of the result is here.

Why read stale data from an asynchronous MySQL replica (slave)? Fetch it from a local cache instead! Good for the clusters overall load, good for your applications performance. And, possible with PECL/mysqlnd_ms 1.3, the replication and load balancing plugin for PHP MySQL users.

The idea is simple

Any application using asynchronous MySQL replication must be capable of handling stale results read from a slave (replica) that is lagging behind the master. The quality of service that the application needs from the database cluster is low. If an application explicitly states the minimum service quality it needs, the underlying systems can adopt to it. That’s a cool thing, because the underlying systems don’t need to do more work than necessary. In the case of a PHP MySQL user, the first underlying system is the database driver library, which is mysqlnd.

Tell mysqlnd …

Did you know that approximately 70% of Oracle customers are also using MySQL?  The use cases for each database are often different – and sometime overlap.  But the needs of a database are the same – among them are security, integration with other products, and strong monitoring.  One of the advantages of the MySQL / Oracle relationship is that Oracle is integrating MySQL with many of its other software products such as:

• Goldengate, for real time heterogeneous replication from/to MySQL and other databases.  Goldengate real life use cases include real time replication of selected MySQL data collected online to a data warehouse in Oracle, Teradata, Neteeza, etc; query offloading from a transactional system built on Oracle, DB2 Z series, SQL Server, etc to a MySQL query instance; and real time reporting by real time replication of a subset of data from corporate …

Following the success of our OTN MySQL Developer Day in London last October, we are running additional MySQL Developer Days in Europe!

Join us in:

• Germany: Frankfurt - February 9th - Check out the agenda and register here!
• France: Paris - March 21st - Check out the agenda and register here!

The MySQL Developer Day is a one-stop shop for you to learn all the essential MySQL skills. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You'll also learn the guidelines and best practices in performance tuning and scalability. Space is limited so register now!

Additionally, we …

Following the success of our OTN MySQL Developer Day in London last October, we are running additional MySQL Developer Days in Europe!

Join us in:

• Germany: Frankfurt - February 9th - Check out the agenda and register here!
• France: Paris - March 21st - Check out the agenda and register here!

The MySQL Developer Day is a one-stop shop for you to learn all the essential MySQL skills. In this free, one-day seminar, we will cover everything you need to know to successfully design, develop, and manage your MySQL databases. You'll also learn the guidelines and best practices in performance tuning and scalability. Space is limited so register now!

Additionally, we …

The binary version for MySQL Cluster 7.1.19 has now been made available at http://www.mysql.com/downloads/cluster/ (GPL version) or https://support.oracle.com/ (commercial version)

A description of all of the changes (fixes) that have gone into MySQL Cluster 7.1.19 (compared to 7.1.18) will appear in the 7.1.19 Change log.

This is a cross-post of something I just put up on Google+. My username on G+ is Keith Murphy. If you are interested please search me out on G+ and comment on the post.  Thanks!! km

-------------------------

I have an idea that I wanted to see if there would be interested people who would like to pursue it. One of things I love to do is participate in MySQL Users groups. When I had the chance I was able to go to user groups in various places I have lived or been. However, my home for a long time has been in an area that isn't heavily populated so there is no actual user groups closer than six hours drive away. I did attempt to start a user group in the nearest city several years ago but it didn't get off the ground.

Anyways, I have been using G+ for some months now and I would like to expand my professional usage of it. One of the great new features that Google added recently was "hangouts". If you don't know …

Lately I have been working with a large pool of fairly hetrogeneous MySQL. Similar to a pool of web servers we have almost 100 MySQL servers across two data centers that are the same in terms of platform/schema etc. These aren't our only servers, just the largest group of them.  Previously everything I had done was with smaller numbers of server (30 or less) or larger numbers of servers but across multiple pools/customers. When you work on a single large pool of servers it brings some interesting challenges. While I certainly can apply everything I have learned up to this point, it brings on some new  problems/issues/headaches.

So, I wanted to take things in bit of a different direction and talk about some of problems that you see when managing large groups of servers like this. Over the next few months as time permits I want to discuss the issues that come up and how you can manage many servers like this. Time, unfortunately, has …