Site NavigationDisclaimerCategoriesSyndicate This Blog |
Saturday, September 20. 2008mylvmbackup 0.10 has been releasedI am happy to announce that mylvmbackup version 0.10 has been released. You can download the updated package from the project home page or via the openSUSE Build Service. This version fixes some bugs and includes new functionality:
First pictures from Software Freedom Day in Riga, LatviaGreetings from the University of Latvia in Riga, where the local activities related to Software Freedom Day 2008 are in full swing! We've just finished the introductionary talk "Software freedom in Latvia" by Evijs Taube (LATA) and Leo Trukšāns (Linux Centre). Currently, Mark Callaghan from Google Inc. is talking about "Running a database when your business depends on it". We've more talks scheduled for the rest of the day and there also is an ongoing workshop about MySQL Performance tuning by Jay Pipes, which takes place in the University's Linux Lab. The full agenda is published on the MySQL Forge Wiki and I just published a first batch of pictures on my gallery. Enjoy!
Posted by Lenz Grimmer
in MySQL, OSS
at
11:21
| Comments (0)
| Trackbacks (0)
Defined tags for this entry: collaborating, community, conference, event, gallery, mysql, pictures, sfd, sun
Tuesday, September 16. 2008PlanetMySQL Update: Goodbye, MagpieRSS, hello SimplePie!
This will provide better support for a wider range of feed types and should also fix a few quirks, e.g. that some postings (for example the one from Kevin Burton) only showed up as an "A" in the Planet's RSS feed. It hopefully also fixes a weirdness with time zones that some people were reporting, but this requires further investigation. The size and complexity of the script was reduced significantly because of this change - SimplePie is a breeze to use in comparison to MagpieRSS and it's very well-documented. The developers provide some more reasons and a comparison on why you should also make this switch! And in case you notice anything broken or weird on PlanetMySQL that might be related to the change, please let me know! This change was an important step for future improvements of the site. Friday, September 12. 2008New UDF for MySQL 5.1 provides GIS functions distance_sphere() and distance_spheroid()In case you are processing and working with geospatial data on MySQL, you may be interested in the following UDF (plugin) for MySQL 5.1: Koji Okumura from Oki Labs Japan has ported two functions from PostGIS into a MySQL UDF:
Since it's an UDF, it can be easily added to an already installed server. These two functions actually complement the improved precise GIS functions nicely (which provide a 2-dimensional DISTANCE() function). You can download the UDF source tarball from here. Compiling it is pretty straightforward and requires a local copy of the MySQL 5.1 sources and the ususal build environment. For my testing, I used the 5.1 source tree that includes the additional precise geospatial functions. Below I just list the commands required to build and create the binary tarball and omit the lengthy output in between some of these commands: $ bzr branch lp:~mysql/mysql-server/mysql-5.1-wl1326 You should now have a binary tarball mysql-5.1.26-rc-linux-i686.tar.gz that you can install or deploy by using the MySQL Sandbox, which I used for my further testing: $ tar zxvf mysql-5.1.26-rc-linux-i686.tar.gz -C ~/opt/mysql Success! Let's see if the new GIS functions work: mysql [localhost] {msandbox} ((none)) > SELECT DISTANCE (GEOMFROMTEXT('POINT(0 0)'),GEOMFROMTEXT('POINT(1000 1000)')) AS distance; Now let's compile and install the UDF that provides the new spherical distance functions. Download the sources and extract the tarball in the same directory in which you branched the MySQL server sources: $ tar zxvf mysql-udf-distance_spheroid-1.0.tar.gz This will build the shared object udf_distance_spheroid.so that you now have to copy into the plugins directory of your server: $ install -D udf_distance_spheroid.so ~/opt/mysql/5.1.26/lib/mysql/plugin Now we have to load the UDF and make the new functions known to the server. Get back into your sandbox or fire up the commandline client again: mysql [localhost] {msandbox} ((none)) > CREATE FUNCTION distance_sphere RETURNS REAL SONAME "udf_distance_spheroid.so"; Now you're ready to experiment with these new functions! For my test case, I calculated the distance between Hamburg, Germany (where I currently live) and Heidelberg, Germany (where I grew up) by providing the Lat/Lon coordinates as points: mysql [localhost] {msandbox} ((none)) > SELECT DISTANCE_SPHERE(GEOMFROMTEXT('POINT(53.583333 9.983333)'),GEOMFROMTEXT('POINT(49.412222 8.71)')) AS 'Distance (m)'; Interestingly, using the virtual ruler on Google Earth gave me a distance of 471881.44 meters for the same coordinates. Not sure where the difference comes from, I assume they are using a slighly different projection system? It would be interesting to see, if these results match what you would get out of PostGIS using the same queries. In any case, these two functions may come in handy, if your application needs to calculate distances between two points on a map. So give it a try! If you have tested this functionality and want to give feedback to Koji, please reply to his post on the MySQL GIS Forum. Celebrating Software Freedom Day in Riga, Latvia
Coincidentally, the a large number of Sun/MySQL Engineers and other Sun folks will be in Riga, Latvia for an internal developer meeting around this day. To make use of this opportunity, we plan to give a number of sessions and presentations (in english) about various topics and to contribute to this global celebration of Open Source Software. We've set up a Team Page on the Software Freedom Day web site for this event - the venue will be the Cafeteria Conference room in the basement of the University of Latvia, Riga, which can accomodate 60-80 people: Raiņa bulvāris 19 There is no entrance fee and you don't have to register - just come by and meet with us! There will be free coffee, refreshments and cake during the breaks. In the evening, Sun will host a social event (incl. free drinks and food) in the SAS Radisson Daugava hotel, starting at 19:30: Radisson SAS Daugava Hotel We've set up a tentative schedule (45 minutes per session plus 15 minutes of Q&A), please check the Wiki for eventual last-minute changes! 11:00-12:00: MySQL/Open Source in Latvia (Evijs Taube, Sun Microsystems) We'd like to thank Leo Trukšāns, Michael Dexter and Georg Richter for their help and support in getting this event arranged and organized! I look forward to being there and help to spread the word about the stuff that keeps me occupied for more than 13 years now
Posted by Lenz Grimmer
in Linux, MySQL, OSS
at
12:02
| Comments (2)
| Trackbacks (0)
Defined tags for this entry: collaborating, community, contributing, event, meeting, mysql, oss, presentation, sfd
Thursday, September 11. 2008Project Kenai: looking at the technology behind it
If you are a maintainer of an Open Source project, you currently have plenty of choice when it comes to getting your project hosted for free. One criterion could be your software configuration management system (SCM) of choice. Some of the hosting services that I am currently aware of and the choice of SCM they offer include:
As disclosed by Tim Bray some days ago, there now is another option - Kenai is open for project hosting (currently by invitation only)! In his blog post, he interviews Nick Sieger, one of the developers behind this project about their motivation and intentions: We need to demonstrate credibility in building on top of more traditional LAMP/SAMP web stacks (not just Java EE); and we need to show viability of Sun technologies and hardware for next-generation web applications. In a nutshell, Kenai is a platform for:
Some of the features that are currently available include:
Reading the interview with Nick and looking at some presentations slides for RailsConf from Fernando Castano (a jRuby and Database performance engineer at Sun and another member of the project team), I was able to gather a list of the tools and technologies they used to build Kenai:
I found it interesting that they decided to deploy and run the Rails application as a war file within the Glassfish application server (using Warbler). By the way, the fabolous OpenSUSE Build Service is a Rails application, too! So far, the entire site is powered by a single MySQL instance with query cache enabled. The project is hosted on the following infrastructure:
You should check out Fernando's presentation for more technical details, tuning info and how they benchmarked the setup - it contains a number of useful tuning hints and performance graphs. Last time I checked, 27 Projects have joined so far (e.g. jRuby, xVM Server). Kenai itself is developed on Kenai. It's going to be interesting what other projects will find their home there. Nick also talked a bit about their future near term plans: to improve the usability and feature set, incrementally improve the site navigation and layout and adding support for hosting files/release downloads. They also consider offering Jira as an option to Bugzilla for bug tracking and Git as another SCM option. There is an IRC channel #projectkenai on freenode.net, to get in touch with the developers directly. The mailing list for the Project Kenai site itself, is users@help.kenai.com - you can subscribe to this list here.
Posted by Lenz Grimmer
in Linux, MySQL, OSS
at
17:21
| Comments (0)
| Trackbacks (0)
Defined tags for this entry: bzr, collaborating, community, development, hardware, hosting, java, mercurial, mysql, opensolaris, oss, scm, solaris, subversion, sun
Wednesday, September 10. 2008MySQL University Session tomorrow: OpenSolaris Web Stack
For the first time, the presentation will not be performed by (former) MySQL employees/developers, but by two of our "Sun Classic" colleagues: Jyri Virkki (OpenSolaris Web Stack community lead) and Murthy Chintalapati (Sr Engineering Manager, Web Stack development) will talk about the OpenSolaris Web Stack: OpenSolaris Web Stack is an OpenSolaris project and community building an integrated stack of popular open source web tier infrastructure technologies such as Apache HTTP server, MySQL, memcached, PHP and Ruby On Rails optimized for Solaris platform. This session introduces OpenSolaris Web Stack, its status and future development including addition of newer technologies such as lighttpd, Varnish etc., as well as the ease of use features for developers and deployers. We will also be discussing an experimental web stack IPS package repository and it could be leveraged to build and make available popular end user applications such as Drupal. MySQL University sessions are free to attend - all you need is an IRC client (to post your questions and comments) and an audio player capable of playing back an OGG audio stream, so you can listen to what is being said. See the Instructions for Attendees on the MySQL University pages for more information on how to log in and attend. The audio stream will be recorded and published on the MySQL University pages for later consumption, in case you can't make it or want to listen to a previous session.
Posted by Lenz Grimmer
in Linux, MySQL, OSS
at
12:08
| Comments (0)
| Trackbacks (0)
Defined tags for this entry: collaborating, community, distribution, drupal, mysql, opensolaris, oss, perl, php, presentation, programming, university, web
Thursday, September 4. 2008New database layer in Drupal 7 to support replication, PDO and SQLiteOne of the sessions at DrupalCon I attended was Larry Garfield's talk about "Drupal Databases: The Next Generation", which gave me a good insight into the current state of the Drupal database layer and how they plan to overhaul it for Drupal 7. The key points that I took away:
The slides and a video of the presentation are available, if you want to check it out. There is a task list on the Drupal.org web site that keeps track of the ongoing activities.
Posted by Lenz Grimmer
in MySQL, OSS
at
15:00
| Comment (1)
| Trackbacks (0)
Defined tags for this entry: community, databases, development, drivers, drupal, php, presentation, programming
MySQL 5.1 Use Case Competition: Adding support for MySQL 5.1 Events to phpMinAdmin
Thank you very much for your submission and the support, Jakub! We appreciate it. If you're reading this and are using MySQL 5.1 and any of it's new features: have you considered telling your story yet? You may even win something when doing so! Wednesday, September 3. 2008Interview at DrupalCon: how to grow your local Drupal User GroupI had a nice chat with Kieran from Acquia at DrupalCon last week - we discussed how people running local Drupal user groups could expand their outreach into other communities, in particular into the MySQL User Groups. Scott Mattoon captured our conversation on video, which is now available on blip.tv: The gist of what we talked about: if you are organizing a local Drupal User Group Meetup, check out http://mysql.meetup.com to find out if there is a local MySQL user group nearby. Chances are high that there is! And if not, you may find at least people in the area that would be interested in meeting about this subject. We also maintain list of user groups on the MySQL Forge Wiki. Consider extending your invitation for your next meetup to these folks as well! It's very likely that someone would be interested to learn more about Drupal. The same applies to other user groups, e.g. from the PHP community.
I personally run a MySQL User Group here in Hamburg, and I usually extend my invitations to a number of channels and mailinglists, including the local PHP, Perl and Linux User Groups. Every once in a while, a new member from these communities shows up. So this thing works the other way around, too: if you are the organizer of a MySQL Meetup, have you thought about looking at http://groups.drupal.org/ yet? Maybe you will find a Drupal User Group in your very own town that you could invite to learn more about MySQL and exchange contacts? If you are looking for more tips on how to run and expand your User Group, I've created a page with useful hints about this topic on the MySQL Forge Wiki. Your feedback and additions are very welcome! Monday, September 1. 2008More slides and pictures from DrupalCon and FrOSConI'm back home from DrupalCon 2008 now - it has been a great event! I met a lot of nice people from the Drupal Community and learned a lot about this CMS. I've been very busy in uploading the remaining pictures from the event to my gallery - so here's for your viewing pleasure:
I also gave two talks and held a BoF there - the slides have now been attached to the session nodes, one of them (the HA session) even includes a video recording:
I've also uploaded some pictures from FrOSCon to my Gallery now, hope you enjoy them! The slides of my FrOSCon talks are now uploaded to the conference system as well:
(Page 1 of 1, totaling 11 entries)
|
QuicksearchCalendarShow tagged entriesCreative Commons |