MySQL Fabric 1.5.2 is out. In this release, you will find fixes for some bugs and, specially, new exciting features:
New interface using the MySQL Protocol
Now MySQL Fabric mimics to some extent a MySQL Server. This will foster the MySQL Fabric adoption by other connectors as they will not have to use a XML-RPC protocol.
import mysql.connector cnx = mysql.connector.connect(host='localhost', port=32275, user='admin', password='adminpasswd') cur = cnx.cursor() cur.execute("CALL dump.servers(patterns=%)", multi=True) print cur.column_names for row in cur.fetchall(): print "Row", row
Provisioning command group
We have started to make MySQL Fabric Cloud Aware and exploit the easiness to spawn new machines in a cloud environment. There is a long road ahead and this is just the beginning.
We have relocated the MySQL Connector/Python repository on GitHub to the following location:
The old location will redirect to the above URL.
No, we have not updated the README.txt or made something special for GitHub. I personally don’t mind what is currently showing on GitHub: it is readable, and it is correct. I still hope GitHub will make it easier to show something else, like asking which document to display and as what format.
The MaxScale team have been working hard fixing bugs and improving performance. On Friday we released a update of MaxScale, the pluggable proxy for MySQL and MariaDB, I wanted to write a little about a few of those changes. I will not mention every change, there are release notes that give the list of bugs fixed in this version, but rather highlight a couple of performance related changes and describe the rationale behind them. However before I start on the two items I wanted to discuss just a quick note to say that this version introduces cmake as the means to build MaxScale. The previous Makefiles are still available in this version, but will be withdrawn in future versions as we transition to cmake for build, installation and packaging.
In one of the test scenarios that I was running I[Read more...]
MySQL is the database of choice for most OpenStack components (Ceilometer is a notable exception). If you start with a small deployment, it will probably run like a charm. But as soon as the dataset grows, you will suddenly face several challenges. We will write a series of blog posts explaining the issues you may hit and how to overcome them.
Have a look at the logical diagram of OpenStack below (click the image for a larger view).
The diagram is a bit[Read more...]
Did you know common_schema supports a complete breakdown of all accounts on your database server? It can provide you with the GRANT statements required to set up an account, the REVOKE statements to undo the former, and this can be broken down on a per-object & per-object-type basis. Consider the sql_grants view:
Find who has privileges on a table called t:
[Read more...]select * from common_schema.sql_grants where priv_level_name='table' and object_name='t'\G GRANTEE: 'power1'@'localhost' user: power1 host: localhost
MySQL Connector/Python v2.0 goes GA with version 2.0.1 GA. It is available for download from the MySQL Developer Zone! The previous post about 2.0 described what changed and what was added, here’s an overview: