A new major version of Connector/Python is available: v2.0.0 alpha has been been released and is available for download! As with any alpha-software, it’s probably not good to throw it in production just yet. Our manual has the full change log but here’s an overview of most important changes for this relase. Some incompatibilities The world evolves, at least the software does, and Python is not different. I’m not as bold as the guys at Django who dropped support of Python v2.

A few weeks ago MySQL Fabric got GA and shipped together with MySQL Utilities 1.4. Today, 2 weeks late, a tooth less and having fixed my website(s), I can blog about MySQL Connector/Python v1.2 going GA. My previous post about the release candidate already summed up the important changes, and nothing changed since then except few bug fixes. Here are again the important new features/bugs fixed for Connector/Python v1.2: Added support for MySQL Fabric.

Finally fixed my website and switched to Nginx (from Lighttpd, sorry Jan!). Was a pain setting up Nginx, but afterwards, the configuration looks clean. Actually, the major headache was setting up Wordpress with SSL admin on different server.

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 Change History if you want to keep up with what is being added and changed.

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.