The MySQL Utilities Team is pleased to announce the latest release candidate (RC) release of MySQL Utilities. This release includes a number of improvements for useabilty, stability, and a few enhancements. A complete list of all improvements can be found in our release_notes.

New Utilities!
We have also included two new utilities.

• The mysqlrplsync utility was added, which checks data consistency between servers in a replicated setup. 
• The mysqlrplms utility was added, which provides round-robin multi-source replication (a slave server continually cycles through multiple masters in order to store a consolidated data set).

How Can I Download MySQL Utilities?
You can download MySQL Utilities 1.4.2 from the following link using one of the pre-built …

To install and run MySQL Fabric, we need:

• Python 2.6 or 2.7
• Connector Python (MySQL Fabric-aware Version 1.2.1 or later)
• One or more MySQL servers installed and running (5.6.10 or later):
  • Backing Store
  • Managed Servers
• MySQL Utilities 1.4.2 or later

Python 2.6 or 2.7

We can use the following command to check whether python is installed in our machine or not:

$ python --version

If you don't have the appropriate version installed, please, read through the following web page and find out how to download and install python 2.6 or 2.7:

• https://wiki.python.org/moin/BeginnersGuide/Download

Monday 31 March 2014 proved to be a big day for MySQL with 5 announcements of products getting new releases: the next milestone release MySQL Server 5.7.4, MySQL Workbench 6.1 going GA and Connector/J 5.1.30 and MySQL Utilities 1.4.2 RC which include MySQL Fabric. That’s 4, the fifth being Connector/Python.

Connector/Python v1.2.1 has been released as Release Candidate. Check out the  …

As you saw in the press release, MySQL Fabric 1.4.2 is now released! If you're interested in learning more about MySQL Fabric, there is a session April 3, 2014 11:10–12pm titled Sharding and Scale-out using MySQL Fabric in Ballroom G.

MySQL Fabric is a relatively new project in the MySQL ecosystem and it focuses on building a framework for working with large deployments of MySQL Servers. The architecture of MySQL Fabric is such that it allows extensions to be added and the first two extensions that we added were support for high-availability using High-Availability groups (HA groups) and sharding to manage very large databases. The first version of sharding have hash and range sharding implemented as well as …

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 …

Often I would need to work on customer servers where MySQL Utilities would be a really good fit for the tools I need. However, I would not want to mess around with the customer servers just to have it running so I would have the tools built and sandboxed on its own directory where I can cleanup later. Here’s how:

cd ~
wget http://mysql.mirrors.hoobly.com/Downloads/MySQLGUITools/mysql-utilities-1.4.1.tar.gz
tar xzf mysql-utilities-1.4.1.tar.gz
cd mysql-utilities-1.4.1
python setup.py build
python setup.py install --root=/home/revin/mysql-utilities-1.4.1
export PYTHONPATH=.:/home/revin/mysql-utilities-1.4.1/usr/lib/python2.6/site-packages
/home/revin/mysql-utilities-1.4.1/usr/bin/mysqlfrm --help

Your source of the package and install directory may vary – enjoy!

This week we released MySQL Connector/Python v1.1.6 has been released with a fix for the Django backend. If you  wonder (or not?) where Connector/Python v1.1.5, it got released a few weeks ago. Yes, PyPi has been updated! Don’t forget to use –allow-external using newest pip.

Some useful links:

• Documentation: http://dev.mysql.com/doc/connector-python/en/index.html
• Release Notes:  …

MySQL Connectors provide connectivity to the MySQL server for client programs. APIs provide low-level access to the MySQL protocol and MySQL resources. Both Connectors and the APIs enable you to connect and execute MySQL statements from another language or environment. Oracle provides a number of these, enabling developers to build database applications in the language of their choice. Among those developed by Oracle are drivers for JDBC and ODBC. Any system that works with JDBC or ODBC can use MySQL. And you can find many more, including drivers for PHP, Perl, Python, Ruby, Tcl and even Eiffel!

To get a head start on developing with MySQL, take the MySQL for Developers training course. This …

The Stackforge Libra project as with most Openstack based projects is written in Python.  As anyone who has used Python before probably knows, Python has something called a GIL (Global Interpreter Lock).  The GIL basically causes Python to only execute one thread at a time, context switching between the threads.  This means you can't really use threads for performance reasons in Python.

One solution to get a little more performance is to use Eventlet.  Eventlet is a library which uses what is called "Green Threads" and hacks on top of the networking libraries to give a mutli-threaded like feel to an application.  As part of this blogging series for HP's Advanced Technology Group I'll write about some of the things I found out the hard way about Eventlet so hopefully you don't hit …

ConFoo, the conference for web developers, is hosting its fifth edition. It will take place in Montreal at the Hilton Bonaventure on February 26th – 28th. These five days are packed with great technical talks and semi-private trainings on your favorite technologies.

It’s definitely a conference for IT professionals, wether you are a developer, integrator or project manager. With its 150 talks, you are sure to find a presentation that will help you grow your core skills. Among them you can find :

• Mobile development
• Cloud computing
• Project management
• Databases and big data
• Development with PHP, Ruby, Java, DotNet, Python and Javascript
• Web security
• …

Meet the experts who crafted your programming language or framework, and who push the technology to a new level. Exchange …