Don't miss these talks at MySQL Users Conference:Tuesday, April 10MySQL Replication 101, 9:30 am -12:30 pm in Room 3Wednesday, April 11What's new in MySQL 5.5 and 5.6 Replication, 11:00 am - 12:00 pm in Room 7Be a Data Management Hero with Good Backups!, 1:00 pm - 2:00 pm in Room 6One to Many: The Story of Sharding at Box, 1:00 pm - 2:00 pm in Room 3Build simple and complex replication

As Keith announced today, there are two more Oracle ACE Directors for MySQL expertise. In case you are wondering how an ACE Director compares to a regular ACE, here is an overview and some FAQ.

MariaDB 5.3 has now three statistics counters for Multi Range Read optimization:

MariaDB [test]> show status like 'Handler_mrr%';
+-------------------------------+-------+
| Variable_name                 | Value |
+-------------------------------+-------+
| Handler_mrr_extra_key_sorts   | 0     |
| Handler_mrr_extra_rowid_sorts | 0     |
| Handler_mrr_init              | 0     |
+-------------------------------+-------+
3 rows in set (0.08 sec)

I’ve just added the first two. The reason for having them is as follows: the point of MRR is to provide speedup over regular execution by doing reads in disk order. In order to make reads in disk order, MRR needs buffer space where it accumulates and sorts read requests. If there are too many read requests to fit into the buffer, MRR will make multiple accumulate-sort-read passes.

Doing multiple …

MySQL is coming to Frankfurt am Main in Germany for a MySQL Developer Day, Febuary 9th.

This developer day has a wide range of sessions and two great resources:  Johannes Schlüter, MySQL Software Developer (great PHP resource as well) and Giuseppe Maxia, Oracle ACE Director for MySQL.

Take advantage of this chance to learn more about MySQL !  More information on the event in Germany can be found here.

Paris France will also host a Developer day in March 21st. More information on this will becoming soon.

Read the original article at What Wouldn’t Google Do?

In his latest book, What Would Google Do? Jeff Jarvis seems to have authored a gushing tribute to the search giant that has pledged to do no evil. He paints a very optimistic picture, and shows us over and over how Google has opened up industries, and how that same openness helps consumers like you and I.

Jarvis, if you don't know him by name, has been a journalist for some time, but gained particular cred and notoriety when he blogged with the headline "Dell lies. Dell Sucks" after his horrible experiences with Dell computers and customer service.

While digging through Googly chapters, on Real Estate, …

I liked Shlomi Noach post on “IS TRUE and IS FALSE“.  This kind of logic create bugs.

What will this return?

select if((1 = true) and ( 1 is TRUE) and (NULL is not TRUE), TRUE, FALSE) as answer;

You should know,

NULL is never TRUE or FALSE but

NULL is always NOT TRUE or NOT FALSE.

NULL is a little like a vacuum.  Ancient Greek philosophers did not like to admit the existence of a vacuum, asking themselves “how can ‘nothing’ be something?”.    Does GOD exist in NULL?

If  select “” is NOT NULL; is TRUE what is “”?

select "" is NOT NULL;
+----------------+
| "" is NOT NULL |
+----------------+
|              1 |
+----------------+

Giuseppe Maxia and Sarah Novotny both have now been awarded Oracle ACE Directors for MySQL !

They both are well respected in the MySQL community and have achieved great things so far. We look forward to seeing what they will do next.

MySQL Cluster usage has certainly continued to spread and recently accelerate well beyond its initial telco vertical roots into Healthcare, Financial Services, SaaS and more. With those additions it certainly becomes desirable for many to provide transparent encryption on the NDB nodes where the data, logs, and checkpoints that write to disk. I’ll not go into all those reasons in this blog, but certainly there are plenty, these white papers provide  more details, especially if you are running within hosted, managed, or cloud environments platforms.

The solution for ndb in a nutshell was straight forward:
1 Set up Gazzang ezNcrypt Flex Platform
2 Stop the ndb process prior to encrypting the ndb_data directory
3 Encrypt the ndb_data directory
ezncrypt -e @ndbdata /home/mysql/my_cluster/ndb_data
4 Add a Flex ACL Rules …

The MySQL Cluster 7.2 Development Milestone Release has been out for a while now and we’d love to hear which are your favourite features – it takes just a few seconds to complete the Quick-Poll. It should literally take seconds to complete and will provide us with valuable feedback on the kind of features are most useful – so that we can build more of them in the future!

You have until Jan. 31 to vote for your favorites tools and services, so, vote now !

Thanks again all folks for your keen interest and your involvement, it was a big surprise to see so many contributors

Follow this link to vote : http://www.mysqlplus.net/2012/01/05/vote-mysqlplus-community-awards-2011/

And come february the 1st for the final results…

Related Posts :

• [RELOADED] Vote for MySQL+ community awards 2011 !
• …