It is our pleasure to announce MySQL presence at the OpenSource Developer Conference in Taipei, Taiwan next week. MySQL has secured 2 talks and the booth where you can meet our MySQL experts. Please mark your calendars for April 11-12, 2014, especially for following MySQL talks:

• Sharding and Scale-out Using MySQL Fabric by Ryusuke Kajiyama, the OSS specialist with over 10 years of experience in system design utilizing MySQL and Open Source solutions. His talk is scheduled for Apr 11 @ 10:20-10:50.
• MySQL Utilities by Ivan Tu, the MySQL Sales Consultant in Taipei. Ivan has Java programming background and is experienced in both, MySQL and Oracle database. His talk is scheduled for Apr 11 @ 11:50-12:20.

We are looking forward to talking to you at the OSDC next week!

I was browsing around the Internet (don’t remember what for) and I accidentally found one cool aspect of MariaDB. There is a feedback plugin and this short post is meant to encourage you to use it!

Ok, so what it does and why should you opt-in to be spied on It takes some information about your MariaDB server including it’s usage and it will send it to the MariaDB folks. It doesn’t send private data from your database. It sends stuff like what OS are you running, what version of various plugins, how did you tweaked the default settings and also how big and how busy is your server. Now a short list of why I turned this on:

• Why not? Doesn’t cost me anything, nothing from the data I send is secret.
• When I develop an …

This weekend we are going to be part of the LOADays Conference (Linux Open Administration Day) a free open source event hold in Antwerp, Belgium, followed by the tutorial on Monday, April 7th.

Do not miss to attend this small but friendly event hold in Antwerp, the second biggest city in Belgium and the capital of the Antwerp province. So, you can join the sightseeing with attending LOADays and getting in touch not only with a Linux people but also with MySQL!!

MySQL is represented by our colleague Carsten Thalheimer who is going to have a talk about "Why MySQL in a Business critical environment". His talk is planned for Sunday, April 6, 2014 @ 13:30.

For the whole conference plan you can check the Schedule section of the LOADays website.

See you …

Are you already a MySQL User Group Leader?

or

Are you thinking about taking this role in the near future?

If yes, please let me invite you to the Annual User Group Leaders' Summit organized by Oracle User Group team. The purpose of this 2 days meeting is sharing the expertise, knowledge and share experience with leading the UG as well as learning of the new ways how to handle groups by using new technologies & tools (i.e. Cloud..).

It is great opportunity to talk to other User Group leaders and share the experience and knowledge with them. There will be Java User Group, Oracle User Group and of course MySQL User Group Leaders!

Find details about this event below and if you are interested and/or want to know more, please do not hesitate to contact myself or make a registration at the link below. You will be contacted by us with a …

On Thursday MySQL technology saw a huge boost. It’s hard for anyone now to argue that MySQL isn’t in the game of extreme scalability and performance, which some NoSQL vendors have been using as a tagline for the last years. To see four of the largest MySQL and MariaDB users come together to bootstrap a branch of MySQL for extreme scaling needs is simply fantastic. The improvements done inside these companies will now be available to the rest of the community. In all fairness Facebook and Twitter, in particular, have been making their improvements publicly available also before. Google has also made some improvements available publicly over the years and have lately been active in the MariaDB project with code reviews, bug fixes and other patches. But broadening the public contributions further and combining it all, is new.

Engineering of MySQL technology happens in many places. Aside from Oracle and the companies behind WebScaleSQL, …

MariaDB is participating in the Google Summer of Code 2014. Students are encouraged to propose a project before the deadline (this Friday!).

This is our second year participating, and as always we have an ideas page available. We also have a list of things we think are achievable in JIRA – check out our gsoc14 tag.

In 2013, we had three projects, of which two are in MariaDB 10.0: PCRE regular expressions and Roles. The other will be targeted towards MariaDB 10.1. There’s nothing like having GSoC students participate and …

Problem

Using MySQL Connector/Python, you are calling a stored procedure which is also selecting data and you would like to fetch the rows of the result.

Solution

For this example we create a stored procedure which is executing SHOW SLAVE STATUS.

cnx = mysql.connector.connect(user='scott', password='tiger',
                              database='mining')
cur = cnx.cursor()
cur.execute("DROP PROCEDURE IF EXISTS slave_status")
proc = "CREATE PROCEDURE slave_status () BEGIN SHOW SLAVE STATUS; END"
cur.execute()
cur.call("slave_status")

for result_cursor in cur.stored_results():
 for row in result_cursor:
   print(row[0])

The result from the above would be:

shell> python foo.py
Waiting for master to send event

Discussion

The stored_results() method of …

Have you ever noticed the vast number of command line programs that ship with MySQL? Here is an ls from MySQL 5.6.16's bin directory:

morgo@Rbook:~/Documents/mysql-installs/5.6.16/bin$ ls
innochecksum
msql2mysql
my_print_defaults
myisam_ftdump
myisamchk
myisamlog
myisampack
mysql
mysql_client_test
mysql_client_test_embedded
mysql_config
mysql_config_editor
mysql_convert_table_format
mysql_embedded
mysql_find_rows
mysql_fix_extensions
mysql_plugin
mysql_secure_installation
mysql_setpermission
mysql_tzinfo_to_sql
mysql_upgrade
mysql_waitpid
mysql_zap
mysqlaccess
mysqlaccess.conf
mysqladmin
mysqlbinlog
mysqlbug
mysqlcheck
mysqld
mysqld-debug
mysqld_multi
mysqld_safe
mysqldump
mysqldumpslow
mysqlhotcopy
mysqlimport
mysqlshow
mysqlslap
mysqltest
mysqltest_embedded
perror
replace
resolve_stack_dump
resolveip

For MySQL 5.7 we are planning to cleanup and remove programs that appear to have no current use-case. This helps us to improve …

In November, I wrote about the command SHOW ENGINE INNODB MUTEX and sought feedback as to how it continues to be used post introduction of performance_schema.

The outcome from this feedback is that the MySQL team has decided to remove this command from MySQL 5.7.

These decisions are not light ones for the team to make. I wanted to thank everyone for their feedback, and also share why this decision was an important one for the future of MySQL:

1. By design, data collection for SHOW ENGINE INNODB MUTEX was always enabled, with no switch to disable it. We believe that for some workloads being able to disable the collection is useful, and in the case of performance_schema this is possible.
2. performance_schema overlaps with this …

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 …