Blog Profile / The Data Charmer
| URL : | http://datacharmer.blogspot.com | |
|---|---|---|
| Filed Under: | Programming / Database Development | |
| Posts on Regator: | 304 | |
| Posts / Week: | 1.2 | |
| Archived Since: | June 30, 2008 | |
Blog Post Archive
Multi dimensional cubes in MySQL through Gearman
I gave two presentations about Gearman at the Linux.conf.au. As part of the preparation for these talks, I created several sample applications. One of them, about remote replication administration, I will cover in a separate post. The...Show More Summary
MySQL user group meeting in Sydney, January 15th
On January 15th I will be in Sydney, Au, on my way to Wellington, New Zealand.I will be at the MySQL User Group, hosted at the Sydney Mechanics’ School of Arts at 5.30pm.I will talk about testing complex database systems with MySQL Sandbox.The meeting is open to all. If you want to attend, please register at the Sydney MySQL User Group meetup page.
MySQL user group meeting in Dubai, January 13th
On January 13th I will be in Dubai, UAE, on my way to Wellington, New Zealand.I will be at the MySQL User Group, hosted at Sun Microsystems offices at 6pm.I will talk about boosting performance with MySQL 5.1 partitions, covering the recent 5.5. additions.The meeting is open to all. If you want to attend, please register at the meetup page.
Speaking, speaking, speaking: Dubai-Sydney-Wellington
()From January 12th to 27th I will be traveling to the Southern Hemisphere and speaking at two user groups and two conferences. The schedule (see below) is almost scary. I will be talking about Partitioning (Dubai and Wellington), MySQL...Show More Summary
Filtering mysqldump output
Several people have suggested a more flexible approach at mysqldump output in matter of user privileges.When you dump the data structure for views, triggers, and stored routines, you also dump the permissions related to such objects,...Show More Summary
Holiday gift - A deep look at MySQL 5.5 partitioning enhancements
Half a day into my vacation, I managed to finish an article on a topic that has been intriguing me for a while. Since several colleagues were baffled by the semantics of the new enhancements of MySQL 5.5 partitions, after talking atShow More Summary
MySQL Conference 2010 - The call for participation is open
The MySQL Conference 2010, co-sponsored by Sun and O'Reilly, has opened its Call for participation.There is already an impressive lineup of tutorials, and I don't say that only because I am on that list. You will find the usual suspects...Show More Summary
Getting started with MySQL 5.5
Some time go, we announced a new release model for MySQL. As all new things, it had some initial hiccups (with MySQL 5.4 we were still getting acquainted with the new model), but now it seems to be in full swing. By the time you read these lines, MySQL 5.5 will be available. Show More Summary
MySQL user groups in Dubai and Sydney, on my way to NZ
In January 2010 I will attend Linux.Conf.Au, which this year is held in Wellington, New Zealand.It's a long way from Europe to New Zealand, and so I will take a few stops.On January 13 I will be in Dubai, UAE. If you are around, I would love to organize a MySQL meeting. Show More Summary
Gearman: distributed computing and Codebits pictures
The first Codebits> day lasted until long past midnight. So the attendees were a bit sleepy today, but they were brave and got up early enough for my session. The presentation covered the basics of Gearman, some advanced magic to install...Show More Summary
MySQL schema maintenance
At CodeBits I had my first session about MySQL schema maintenance. I covered the basic command line possibilities before coming to the recommended tool, MySQL Workbench.The slides are available at slideshare.Interesting questions:Are...Show More Summary
Poor man's schema comparison
Comparing database schemas is one of those DBA tasks that occurs all the time.If you can afford the luxury of having a GUI, then MySQL Workbench is the tool for you. It will help you compare structures and eventually synchronizing the...Show More Summary
Codebits 2009, coders conference and competition in Lisbon
Codebits is approaching. Form December 3rd to 5th, this gathering of 600 developers for a conference, which is also and foremost a competition, will occupy the mind of the best coders in Europe.I will be a speaker, with two sessions:Schema...Show More Summary
Gearman for MySQL
If you haven't yet heard about Gearman, it's time to have a look at it. Its distributed client server architecture are a perfect match for today's cloud oriented applications.When talking about Gearman, much stress is often given on its scalability features, such as map/reduce and distributed loads. Show More Summary
Spider and vertical partition engines with new goodies
The Spider storage engine should be already known to the community. Its version 2.5 has recently been released, with new features, the most important of which is that you can execute remote SQL statements in the backend servers. The method is quite simple. Show More Summary
Introduction to Gearman at the Italian Research Council
I was invited to contribute some technological views at the Italian National Research Center, during the Internet Governance Forum.My contribution was ahigh level introduction to Gearman, which sparked a debate about the impact of the cloud on the future of open source. Show More Summary
Jeremy's article on MySQL Sandbox in Linux Magazine
Jeremy Zawodny of Craiglist has written a kind article about MySQL Sandbox.The article, MySQL Sandbox: Treat MySQL Instances like Virtual Machines, is a practical test of MySQL Sandbox with usage examples and warm appreciation.Thanks, Jeremy!The article was published in July but I noticed it only today. I guess I should pay more attention to my favorite topics when I travel.
Partitioning with non integer values using triggers
Looking at Bug#47310, which is a feature request that I hear frequently when I talk about partitions, I wrote a comment, suggesting triggers to work around the limitation.The reason for the limitation is that allowing arbitrary functions...Show More Summary
Snow Leopard blues
On Friday afternoon, I went to give a presentation about MySQL advanced features at the Sardegna Ricerche technology park. The presentation included a quick introduction to MySQL Sandbox, something that I have been doing for years, and I thought I could do blindfold, if required. Show More Summary
The Open Source Events Calendar
Kudos to Lenz, who has put together a comprehensive calendar of open source events. Most of them are somehow related to the MySQL ecosystem, but there is no limitation to what the calendar contains. Here is the announcement, with the instructions to use and contribute to the calendar. Show More Summary