Ideas, releases, practical guides, and perspectives from the people building with MySQL.
We finally got the MySQL Connector/Python repositories reorganised on Launchpad. The following changes have been made:
This post is one in a series that I will be doing on MySQL Workbench Utilities – Administer MySQL with Python Scripts.
MySQL Utilities are a part MySQL Workbench. The utilities are written in Python, available under the GPLv2 license, and are extendable using the supplied library. They are designed to work with Python 2.x greater than 2.6. If you don’t have Workbench, you may download the MySQL Utility scripts from launchpad.net. You will also need to …
[Read more]It’s always interesting when somebody asks why they got an error message, and especially sweet when you’re working on something related that lets you answer the question. They were using MySQL Workbench and wanted to know why they couldn’t open a SQL script file by clicking on the Scripting menu option.
As I explained to the individual who asked, you should always click the Edit SQL Script link in the SQL Development section of the MySQL Workbench home page to work on SQL scripts. The Scripting menu option supports Python and Lua plug-ins development and scripts.
They did the following initially, which led down the rabbit warren and left them stumped because they don’t know anything about Python or Lua. This is provided to those who choose to experiment with this advanced feature of MySQL Workbench.
…
[Read more]Yesterday we announced the availability of MySQL Connector/Python v1.0.5 beta. Today I’ve made it available on PyPI so it can be easily installed. Note that I did remove the old development release and when you upgrade or try v1.0.5, you should check the ChangeLog.
shell> pip install mysql-connector-python
For those wondering why the name includes ‘python’: it’s just to align it with other MySQL connectors and to keep the name consistent with other distribution types.
We welcome and appreciate feedback and comments for this first beta release through the forum and the …
[Read more]MySQL Connector/Python v1.0.5 beta is now available for download from the MySQL website. This version is feature complete and we welcome and appreciate feedback and bug reports.
We’re also interested in hearing your feedback for future enhancements. Let us know how you’re using the connector too, especially if you are using it with Django, SQLAlchemy and similar Python technologies.
A few things have changed since the last development releases and we hope the manual shipping with the Connector/Python distribution (and also available online soon) will help you get up to speed.
Here are a few important changes that might be incompatible with current scripts using the now obsolete development releases v0.3.2 and …
[Read more]I’m currently figuring out how to name the MySQL Connector/Python distributions so it works well with PyPi. Source archives would be named like mysql-connector-python-X.Y.Z.tar.gz.
The ‘name’ metadata would be ‘MySQL Connector Python’, thus without any underscores or dashes. This works OK, but if people have objections, please leave a comment.
The brief outage was due to a scheduled move of the servers to a separate rack and subnet dedicated to our work with the Center for Information Assurance & Cybersecurity (ciac) at the University of Washington Bothell (uwb), and a11y.com
I am currently exercising the new (to us) equipment and hope to winnow the less than awesome equipment over the next quarter. I spent the last six months finding the best in breed of the surplussed DL385 and DL380 chassis we (work) were going to have recycled. The team and I were able to find enough equipment to bring up one of each with eight and six gigs of memory, respectively. These will make excellent hypervisors for provisioning embedded instances of Slackware, Fedora, RHEL, CentOS, Debian, FreeBSD, OpenSolaris, OpenIndiana, FreeDOS, etc.
When I initially configured this xen paravirt environment, I failed to plan for integration with libvirt, so I am now re-jiggering the software bridges so …
[Read more]In this blog we discuss invalid dates in MySQL, how to retrieve them using Connector/Python and we raise the question: Should Connector/Python raise an error or just keep returning None on invalid dates?
If you run MySQL without proper SQL Modes, you will be able to update
and
read invalid dates such as ’2012-06-00′. If you’ve payed
attention the past decade, you’ll know that you can prevent this
configuring your MySQL server setting SQL Mode to ‘TRADITIONAL’.
Now, the problem if this is allowed, how do we get invalid dates using MySQL Connector/Python?
Lets look at an example inserting an invalid date and trying to read it again using MySQL Connector/Python:
>>> cur = …[Read more]
A special extended edition of Tech Messages for 2011-09-21 through 2012-05-11:
The new MySQL 5.6 Development Milestone Release (DMR) includes
many new enhancements. One of the most impressive is the use of
Global Transaction Identifiers (GTIDs) for replication. With
GTIDs enabled, administrators no longer need to keep track of
binary log files and positions. In a nutshell, GTIDs simplify the
setup and maintenance of replication.
MySQL Utilities has taken this a step further by providing two
new utilities that automate two of the most complex replication
administration tasks - switchover and failover. Switchover is
changing the role of an active, healthy master to one of its
slaves whereas failover is the act of promoting a candidate slave
to become the new master. Clearly, switchover is an elective
operation and failover is performed when there are issues with
the master.
The GTID utilities are included in release-1.0.5 of MySQL
Utilities. They are included as a plugin for MySQL Workbench or
via …