Dear MySQL users,
MySQL Connector/Python v1.0.11 is a new version of the 1.0
production release of the pure Python database driver for
MySQL.
MySQL Connector/Python version 1.0 is compatible with MySQL
Server versions 5.5 and greater, but should work with earlier
versions (greater than v4.1). Python v2.6 and greater as well as
Python v3.1 and greater are supported. Python v2.4 and v2.5 are
known to work, but are not officially supported.
MySQL Connector/Python v1.0.11 is available for download
from
http://dev.mysql.com/downloads/connector/python/#downloads
A brief summary of changes in MySQL Connector/Python v1.0 is
listed below. Please check the change log file inside the
distribution for a more complete list of changes or online at:
…
MySQL for Visual Studio is a new product including all of the Visual Studio integration previously available as part of Connector/Net. The product is now released as GA and is appropriate for use in production environments. It is compatible with MySQL Server versions 5.0-5.7 and Visual Studio versions 2008-2012.
If you missed the recent MySQL Cluster 7.3 GA webinar then the replay is now available here.
In the webinar replay you can learn how MySQL Cluster 7.3 has delivered key features enabling the latest generation of web and mobile services to take advantage of high scalability on commodity hardware, SQL and NoSQL interfaces and 99.999% availability; these include:
- Support for Foreign Key constraints – implemented to be as compatibile with InnoDB as possible
- NoSQL JavaScript connector allowing native access from node.js applications to MySQL Cluster, bypassing the SQL layer
- Browser-based Auto-Installer for fast configuration of production-grade clusters
- Connection Thread Scalability …
Join 7500 others and follow Sean Hull on twitter @hullsean.
There’s a lot of talk on the web about scalability. Making web applications scale is not easy. The modern web architecture has so many moving parts. How can we grapple with the underlying problem?
Also: Why Are MySQL DBAs So Hard to Find?
The LAMP stack scales well
The truth that is half right. True there are a lot of moving parts, and a lot to setup. The internet stack made up of Linux, Apache, MySQL & PHP. LAMP as it’s called, was built to be resilient, dynamic, and scalable. It’s essentially why Amazon works. Why what they’re doing is possible. Windows & .NET …
[Read more]Memcache access for MySQL Cluster (or NDBCluster) provides faster access to the data because it avoids the SQL parsing overhead for simple lookups – which is a great feature. But what happens if I try to get multiple records via memcache API (multi-GET) and via SQL (SELECT with IN())? I’ve encountered this a few times now, so I decided to blog about it. I did a very simple benchmark with the following script:
#!/bin/bash
mysql_server="192.168.56.75"
mc_server="192.168.56.75"
mysql_cmd="mysql -h${mysql_server} --silent --silent"
mysql_schema="percona"
mysql_table="memcache_t"
mc_port=11211
mc_prefix="mt:"
function populate_data () {
nrec=$1
$mysql_cmd -e "delete from ${mysql_table};" $mysql_schema > /dev/null 2>&1
for rec in `seq 1 $nrec`
do
$mysql_cmd -e "insert into ${mysql_table} values ($rec, repeat('a',10), 0, 0);" $mysql_schema > /dev/null 2>&1
done
}
function mget_via_sql() {
nrec=$1
in_list=''
for rec in …[Read more]
I made a new tutorial for how to use MySQL to develop Big Data
Applications. This is a 'Udacity'/explaining-on-paper style of
video which I hope you will enjoy and find helpful.
Please 'like' or retweet if you feel it is informative.
As I mentioned in a previous post that I’d mention how I resolved some additional missing include files when building MySQL on Windows.
In this post I cover 4 missing header files, as they are all related and have to do with polling, and headers (and functions) from libevent, and in the folder /sys. I’m not sure if one should even use these functions from libevent on Windows, as these are not needed for Windows, and may not be beneficial either (that last part I’ve just read briefly about, so I’d need to that a bit more myself to be 100%), but including the headers won’t hurt, as it doesn’t hurt if they don’t exist.
At any rate, here were the 4 related missing header file warnings:
-- Looking for include file sys/devpoll.h -- Looking for include file sys/devpoll.h - not found -- Looking for include file sys/devpoll.h -- Looking for include file …[Read more]
Percona Server version 5.5.32-31.0
Percona is glad to announce the release of Percona Server 5.5.32-31.0 on July 2nd, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.32, including all the bug fixes in it, Percona Server 5.5.32-31.0 is now the current stable release in the 5.5 series. All of Percona‘s software is …
[Read more]This week we continue talking about the Openark Kit. Ear candy is the Percona Configuration Wizard, and At the Movies is a keynote from the SkySQL and MariaDB Solutions Day about the SkySQL and MariaDB merger and the MariaDB Foundation.
Openark Kit series:
Part 1
Part 3
Events
DB Hangops -
every other Wednesay at noon Pacific time
Training
SkySQL Trainings
By default the included Lua within MySQL proxy (0.8.3) does not include socket, necessary for getting microsecond granularity. To setup you have to install Lua and socket on the OS first:
For CentO5
$ sudo yum install lua lua-socket
For Ubuntu
$ sudo apt-get install lua5.1 liblua5.1-socket2
The following enables use within MySQL Proxy.
cp /usr/share/lua/5.1/socket.lua /path/to/mysqlproxy/lib/mysql-proxy/lua cp -r /usr/lib64/lua/5.1/socket /path/to/mysqlproxy/lib/mysql-proxy/lua cp -r /usr/lib64/lua/5.1/mime /path/to/mysqlproxy/lib/mysql-proxy/lua
My lua script can now use syntax similar to:
require 'socket'
function read_query( packet )
...
now=socket.gettime()
print( string.format("# %s.%3dn%s;n",os.date("%X",now),select(2,math.modf(now))*1000 , query))