Last week several people from the MariaDB and SkySQL team headed down to Los Angeles to attend SCALE12x. This is our fourth year at this great event, and this year it seemed even bigger and better than in the previous years (and those were no slouches by any means).

Colin Charles, MariaDB's Chief Evangelist, had two talks this year. The first was about MySQL and MHA, and the second was about MariaDB as a viable alternative to MySQL. Both of these talks were well attended. The database track as a whole was outstanding.

read more

MySQL is very popular and growing on the Windows platform. As a consequence we want to further staff our Windows efforts with a full time Windows performance architect. The Windows performance architect will be an integral part of the MySQL Server development team and also work closely with our Windows Experience team. Work will be centered around profiling and tuning large multi-threaded service applications on the Windows platform, debug and remove limitations and develop new code.

Key qualifications are:

• 5+ years C/C++ software development experience on Windows platform
• Ability to understand large pieces of code fast
• Strong understanding of long running programs (for example Operating System Kernels, Filesystems, high end networking equipment)
• Strong understanding of multi-threaded service applications
• Proven skills in designing and coding complex environments
…

When looking at queries that are candidates for optimization I often recommend that people look at rows_sent and rows_examined values as available in the slow query log (as well as some other places). If rows_examined is by far larger than rows_sent, say 100 larger, then the query is a great candidate for optimization. Optimization could be as simple as adding a few indexes or much more complicated as in generating summary tables so you do not need to rely on large aggregations for your real-time queries.

Just to be clear this is a great rule for your “real time” queries need to be handled very quickly and in high volumes. Batch jobs, reporting queries often will have to scan through millions of rows to get few rows of result set and it is fine.

So it is all clear with rows_sent being smaller than rows_examined but can it be smaller ? Yes it can! Here are couple …

Somebody asked me if there was a cheaper alternative to using the Embarcadero Data Architect (a data modeling tool). I said sure, you can use the MySQL Workbench. My friend laughed and said, it’s to model Oracle databases and they use different data types. I broke the news to him that he can create his own user defined types and use MySQL Workbench to model problems for the Oracle Database 11g.

For example, you can launch the MySQL Workbench, and click on the Model menu option, and in the menu window click on the User Defined Types choice, as shown in the following:

Choosing the User Defined Type option, launches the following form. You can enter customized user defined types in the User Defined Types module:

…

Hadoop is an increasingly popular means of analyzing transaction data from MySQL. Up until now mechanisms for moving data between MySQL and Hadoop have been rather limited. Continuent Tungsten Replicator provides enterprise-quality replication from MySQL to Hadoop under a GPL V2 license.  Continuent Tungsten handles MySQL transaction types including INSERT/UPDATE/DELETE operations and can

Earlier this month I blogged about our new Hadoop applier, I published the docs for that this week (http://docs.continuent.com/tungsten-replicator-3.0/deployment-hadoop.html) as part of the Tungsten Replicator 3.0 documentation (http://docs.continuent.com/tungsten-replicator-3.0/index.html). It contains some additional interesting nuggets that will appear in future blog posts.

The main part of that functionality that performs the actual applier for Hadoop is based around a JavaScript applier engine – there will eventually be docs for that as part of the Batch Applier content ( …

Hi,

Sorry for the delay, I just got back into this problem today, and I basically installed dbForge Studio for MYSQL, I added the user ‘ssluser’@’localhost’, ssluser’@’192.168.0.12′, ‘ssluser’@’web-server.mgc.com’, ‘ssluser’@’127.0.0.1’ with auth_pam, and it says access denied ssluser@web-server.mgc.com, I did it thru ssh tunnel, I also tried directly from putty inside the webserver with mysql -u ssluser -p, and also with no luck it says access denied ssluser@localhost, then I deleted all the users, and recreated them with auth_pam_compat, and also the same problem. I don’t know where to go from here because I managed to get this webserver integrated with activedirectory, but just the mysql part is not successfull.

As a follow up to the previous blog announcement we are pleased to announce following conferences in EMEA & APAC which MySQL Community Team supports. As usual not only MySQL staff is attending, we are sharing our resources with Oracle VM, Linux and Java (where applicable). Please come to meet us at: 

EMEA 

• OpenSUSE Conference - Dubrovnik, Croatia, April 24-28, 2014
  • You can meet the MySQL team at our booth or at any of approved talks. Schedule for this event is not yet approved/published. Please watch the OpenSUSE website for current program schedule. 
• JavaScript UnConference, Hamburg, Germany, Apr 26, 2014 …

We are pleased to announce the SIG MySQL meeting taking place in Berlin, Germany next month! Come to hear news not only from the MySQL world but also on the other topics!

Event details:

Event Name: SIG MySQL

Date: March 27, 2014

Time: 9:30 - 17:30

Place: DOAG e.V. Geschäftsstelle Tempelhofer Weg 64 12347 Berlin  

Event URL & Agenda

We are looking to seeing you there! 

When we launched the official MySQL repos back in October, we wanted to achieve a number of things: First, we closed a gaping hole in our distribution on Linux. Some Linux distros do not ship all the MySQL products, and not everyone is able to or always wants to use the distro packages. And the […]