A preliminary schedule is now available for the MySQL Conference & Expo 2010 (in Santa Clara, California, USA). I have two talks and a tutorial, currently scheduled as follows:
Schedule might change a bit, so I suggest keeping an eye on the conference website.
And please remember: we might have changed colors a few times past 2 years, but we are still the nice and friendly people we were back in MySQL AB!
This post explains how to compile oursql and install it on MacOS 10.6. oursql is a Python database interface for MySQL, an alternative to MySQL for Python (i.e. MySQLdb) and MySQL Connector/Python.
First, find out which MySQL you installed. This can be either the 32-bit or the 64-bit version. To make sure, find the mysqld (e.g. in /usr/local/mysql/bin) and do the following in a Terminal window:
shell> file /usr/local/mysql/bin/mysqld
.../mysqld: Mach-O 64-bit executable x86_64
If you see x86_64, you got 64-bit, otherwise 32-bit. If you see both, then you have a universal build. This is important for specifying the ARGSFLAG when building.
Download oursql from Launchpad and unpack it into some directory. Using the information from above, you’ll have to do following for 64-bit platform (or universal build) in a Terminal window:
shell> ARCHFLAGS="-arch x86_64" python setup.py build
shell> sudo python setup.py install
For 32-bit, you’ll have to do:
shell> ARCHFLAGS="-arch i386" python setup.py build
shell> sudo python setup.py install
Following error will be reported when you don’t specify the correct ARCHFLAGS:
ld: warning: in .../lib/libmysqlclient.dylib,
file is not of required architecture
- When building failed, it is good to remove oursql, unpack it and try again.
- If you don’t want to compile anything, or run into more troubles, give MySQL Connector/Python a try (alpha releases). It’s a pure Python implementation of the MySQL Client/Server protocol and doesn’t need compiling or a MySQL installation.
- You can download MySQL from either www.mysql.com or dev.mysql.com.
Today we made a change in the schedule of talks held in the MySQL Developer Room at FOSDEM 2010, swapping two talks. Change is:
The printed booklets found at the conference will not reflect the change, but the printable schedule has already been updated.
FOSDEM 2010, Sunday 7 February, the MySQL Developer Room packed with 12 talks! And this year we serve Python just before the lunch break.
In 20 minutes I’ll try to give an overview of the drivers currently available for connecting your Python applications with MySQL. Incase you wonder, this will not evolve around MySQL Connector/Python alone!
We’ll also go over some frameworks and tools like SQLAlchemy.
20 minutes, it’s not much, but should be enough. I hope to get a similar talk accepted for the MySQL Conference&Expo 2010.
I must admit that I’m a bit lost when people are starting to discuss during the Q&A of presentations, here at AMOOCON, Rostock (Germany). The PBX or ‘business communication’ world is a bit unknown to me, but hearing that the Open Source solutions are market leader in North America came as a surprise. 88% of this share is Asterisk. This fact was for me the most remarkable thing to remember from Mark Spencer‘s keynote.
Jim Van Meggelen talked about high availability in setups using PBX. It’s more an ongoing exercise using Linux Heartbeat, patching cables and other stuff. The database part is tricky, he mentioned, but I’ve commented that moving this out and using MySQL Cluster could solve this. Replication would however be a better because it is easier. Talking to Tim Panton I agreed that MySQL Cluster would add more complexity.
Lenz Grimmer gave an excellent overview on how to achieve (near) high availability using MySQL. Pity his talk collided with the lunch being served in the corridors. At 16:15 I’m giving my MySQL Cluster talk in 30 minutes. Trying to make people warm using it more!
Last week the first edition of the Open Source Data Center conference (or OSDC) took place in Nuremberg, Germany. It was organized by Netways, who are also doing the Nagios conference. They indeed know how to organize! I was quite sick that day, and had to leave the second day for home.
Talks were mixed. I learned about Puppet, and I wish I had it during the years I was a sys-admin. Kristian gave a nice overview on how they do things at Booking.com, and bashed a bit on our MySQL Enterprise Monitor, but he’s allowed!
My talk about MySQL Cluster was apparently well received. I asked who liked beer, and all responsed. At least all were awake at the start!
I hope more folks will show up next year, if Netways is doing it again.
I’m happy to announce (bit unofficially) the first (alpha) source code release of MySQL Connector/Python. It’s hosted on Launchpad and can be downloaded using the Bazaar client. It’s more a preview as I’m still working on it during free time. Please post comments, bug reports, ideas, critics, etc..
MySQL Connector/Python is a rewrite of the MySQL Protocol in Python. It does not require the C library libmysqlclient, thus no compiling. However, I’m currently working on making a version which will be linked with the MySQL libraries, for performance.
Small, silly example:
db = mysql.connector.Connect(host='localhost')
cursor = db.cursor()
stmt = "SELECT VERSION()"
row = cursor.fetchone()
I’ve not been doing system administration for years, so I missed out on Puppet. It looks pretty cool to administer machines and services. Looking through the recipies I found some example for MySQL setting the root password. Interesting stuff.
I’ve downloaded and installed it on my Mac. It’s written in Ruby. I’ll check it further making maybe something around MySQL Cluster then. If possible, maybe even before my talk at the Open Source Data Center conference in Nuremberg, Germany.
Today I gave an introduction talk of MySQL Cluster at FOSDEM 2009 in Brussels. The room was full and I didn’t see anyone dozing!
A good feedback later on was to show more usecases. This a good point and I think on working on a talk showing less how it works, but how it can be used. Doing both technical details and use-cases is hard to do in 50 mintes.
I feedback is appriciated!
BTW, slide will eventually come online somewhere..
OK, I cheated and read my ‘work’ email! Today my talk proposal got accepted and I’m off to the MySQL Conference & Expo, held in Santa Clara (CA, USA), end April 2009. My talk will be about the MySQL Support Team: how it started, the transformation it went through and how it scales today (and much more!).
This is my first talk overseas! I’m quite excited!