The views or opinions expressed on this blog are my own and do not necessarily reflect the views or opinions of my current employer. The views or opinions expressed by visitors on this blog are theirs solely and may not reflect mine.
Thursday, January 6. 2011
If you want to give Drupal 7 a try without having to install anything, I've now updated my Drupal 7 appliances on SuSE Studio to the latest release. The appliance is based on openSUSE Linux 11.3 and is available in two variants:
The appliance is available in various formats:
So congratulations to the Drupal developer community for reaching this goal and thanks to SuSE/Novell/Attachmate for providing the infrastructure for creating such appliances. I also would like to especially thank Richard Bos for the testing and many suggestions for improvement of these appliances!
Tuesday, January 4. 2011
I will be in the Bay Area at the end of this month, to attend a summit of the IOUC (International Oracle Users Group Community), to talk about MySQL and to meet with the organizers of Oracle User Groups worldwide. MySQL is a big topic for many members of their groups, I am looking forward to learn more about their activities and how we can better collaborate in the future. My recent experiences at the DOAG Conference in Nuremberg and the UKOUG Conference in Birmingham were quite positive — I was very pleased by the number of attendees at the MySQL sessions.
Since I'm so close to San Francisco, I gladly accepted the invitation to speak at the San Francisco MySQL Meetup Group on Wednesday, 26th of January. The topic of my talk will be "MySQL High Availability Solutions" where I will try to give a broad overview about the technologies and concepts involved.
Last time I checked, they already had 74 confirmations, the venue can host a maximum of 150 people. So if you'd like to attend and meet, hurry up and sign up soon!
Wednesday, December 15. 2010
MySQL 5.5: CMake replaces autoconf/automake on all platforms, support for autotools has now been removed
There has been a lot of buzz about the MySQL 5.5 GA release and its new features and other user-visible improvements. In this blog post, I'd like to touch on a less noticeable, but still important change.
CMake has already been used to build the MySQL Server on Windows for a long time, while the GNU autotools were used on all other platforms. Since MySQL 5.5, all builds on all platforms are now performed using the same tool chain. With the latest release of MySQL 5.5, we've made an important step to clean up and simplify the MySQL build system: the support for autoconf/automake has now been removed completely. We've been performing the release builds of MySQL 5.5 using CMake exclusively for quite some time already. It became obvious that maintaining two separate build systems simply had become too much of a burden for our engineers, especially since the autotools-based builds were no longer exhaustively tested. This change was outlined in WorkLog#5665 - Removal of the autotools-based build system. We've made this step in close cooperation with our community of packagers (e.g. the maintainers of MySQL packages on the various Linux distributions).
By moving to CMake, we are giving our developers one common build mechanism for all platforms and there is a lot of new useful functionality such as out-of-source builds or a GUI for configuring the build options. And they can now build MySQL in the very same way that we do it for our own binaries! I've covered the advantages in my previous blog post about Building MySQL Server with CMake on Linux/Unix already. We've also created a general article about CMake and MySQL as well as an Autotools to CMake Transition Guide on the MySQL Forge Wiki. The description of the source build process in the reference manual has also been updated to reflect this change.
A big “thank you” should to go to Vladislav Vaintroub and Davi Arnaut for implementing and pushing the transition to CMake forward, and to Paul DuBois for creating and improving the documentation! Wearing my former build and release engineer hat, I am very happy about this change.
Other CMake-related articles that are worth reading:
Thursday, December 9. 2010
Just as a friendly reminder about what I wrote a month ago: we've already received a number of great talk submissions for the MySQL & Friends Developer Room at FOSDEM 2011, thanks to everyone who contributed so far! However, we still are looking for some more!
You can submit your proposal via this form. The deadline for turning in your talk is Sunday, 26th of December, 2010.
Just to recapitulate, the DevRoom (H.2213) will be available to us on Saturday 5th 2011, from 13:00 till 19:00. Each session will last 20 minutes plus 5 minutes of Q&A. See this year's schedule for inspiration — I think we had a great lineup of talks that addressed a good mixture of MySQL-related topics. I am looking forward to your ideas and suggestions! Thanks in advance for your support.
Friday, December 3. 2010
As part of the upcoming Oracle OpenWorld/Java One in São Paulo, Brazil next week (which will also include MySQL-related sessions), there will be a free MySQL Community event, which will take place on December 8th, from 13:00-18:00.
Here's the (translated and abbreviated) description from the events page:
Sounds like a fun event to be at — if you're a MySQL user/enthusiast and you happen to be in the area, don't miss this! You can register for the event via phone or email to the contact information given on the page cited above.
Monday, November 29. 2010
I've been going through our bugs database to compile a list of some noteworthy patch contributions that have been included in the MySQL 5.5 release. Of course any contribution is appreciated, no matter how small! And the list is probably not complete — please let me know if I'm missing any. I omitted a number of smaller patches that fixed compile issues and I only considered contributions that were tracked in our bug database and were tagged as "Contribution".
Note that these are new patches that have not been part of any other MySQL release — of course, all contributions from previous releases are included in 5.5 as well. We also received a few patches for InnoDB (particularly by Mark Callaghan and his team mates at Google/Facebook), which were incorporated in the InnoDB plugin in MySQL 5.1 (and hence got included in the InnoDB version of MySQL 5.5, too).
Here they are, in no particular order:
Hello from Birmingham, UK! I'm here to attend and speak at the UKOUG Technology & E-Business Suite 2010 conference (what a name!) We actually have two packed tracks of MySQL Sessions this Wednesday, including a keynote by Richard Mason (Vice President of MySQL Sales and Consulting at Oracle) about Oracle's strategy and plans for MySQL as well as highly technical sessions about MySQL High Availability, Scalability and Performance tuning from experts in the field. Ronald Bradford, Oracle Ace Director and long-time MySQL community advocate will also be there, speaking about Common MySQL Scalability Mistakes and MySQL idiosyncrasies that BITE. The latter talk is actually going against my own talk about "Making MySQL Administration a Breeze - A Look Into a MySQL DBA's Toolchest". This is going to be interesting!
If you happen to be nearby, don't hesitate to come over! Admission to the MySQL session stream and the exhibition area is free! The online registration has been closed in the meanwhile, but I just learned that you can just turn up on site and the conference team will accommodate you. See you on wednesday!
Tuesday, November 16. 2010
It's finally official — please join me in welcoming my new/old colleague Dave Stokes, who just joined the MySQL Community Relations Team at Oracle as the new MySQL community manager for North America. Some of you may remember him from a previous stint at MySQL, where he was in charge of the MySQL certification program. Back then, he was already running the North Texas MySQL Users Group and a regular blogger on Planet MySQL. I am sure we will be seeing much more of these kind of activities from now on. So welcome aboard, Dave! I look forward to working with you.
Monday, November 15. 2010
Yesterday afternoon I returned from the SAPO CodeBits 2010 conference, which took place in Lisbon, Portugal. Just like the previous year, CodeBits has been a great conference to be at and I am grateful for having been selected for participation. Thursday, the first conference day was quite a busy one for me — I gave two presentations in a row:To SQL or not to SQL", together with representatives from other open source databases (@fdmanana from CouchDB, @antirez from Redis and @bpedro for PostgreSQL). It was an interesting but somewhat slow discussion and the overall conclusion is still the same: there's more than one tool for a given job, choose carefully what your requirements are and don't just blindly believe the hype.
On Friday, I had some more time to attend other people's presentations. In the evening I took part in another panel discussion about Physical Computing. I also had the "opportunity" to try one of the Nuclear Tacos (Video) they served — I have never had something that hot before. Ouch! Fortunately my tastebuds recovered in time for the speaker's dinner, which took place later that evening. We went to a Rodizio restaurant nearby, the food was plenty and delicious!
Saturday was a pretty low activity day for me. I spent some time in the DIY corner, doing some Arduino hacking. Later that day I attended the project presentations and the closing keynote. Unfortunately a majority of the content was in Portuguese, so I only got parts of the content. But it was still fun! I've published my pictures of CodeBits on Flickr, I hope you enjoy them
Later today, I will be travelling to the DOAG Conference 2010 in Nuremberg, Germany. I'll be giving two talks (in German) there on Wednesday, 17th:
There will also be a MySQL Community Meetup on Tuesday, 19:00 at the Press Center of the Congress Center East. If you're around, you're more than welcome to join us there!
Next up in the conference schedule for this year is the UKOUG Conference in Birmingham, UK (Nov. 29th - Dec. 1st). We helped them with setting up a MySQL session stream, and they've created an interesting lineup of talks. I'll be speaking about Making MySQL Administration a Breeze - A Look Into a MySQL DBA's Toolchest. See you there!
Monday, November 8. 2010
I've been informed about two upcoming events/conferences that are organized by the independent Oracle user groups of the respective countries. If you're nearby, how about submitting a talk about a MySQL-related topic?
On March 29, 2011 the the Oracle Benelux User Group will have their yearly OBUG Benelux Connect 2011 conference, which will take place in Brussels, Belgium. You can submit your proposal until December 3rd, 2010 via this link.
On May 19th and 20th, 2011, the Oracle User Group Finland together with the Oracle User Groups of Estonia, Latvia and Russia will organize the EMEA Harmony 2011 Spring conference, which will take place in Helsinki, Finland. The Call for Papers has been opened — you can submit your speaking proposals until February 1st, 2011 via this submission form.
And while we're at it: the MySQL Developer room at FOSDEM 2011 in Brussels is still seeking for more talk proposals, too! Please consider submitting your suggested talk until Sunday, 26th of December, 2010
Monday, November 1. 2010
As usual there were more applications than they were able to accommodate, so we are very grateful for this opportunity for collaboration. Titled "MySQL and Friends", our room next year will be H.2213 with a capacity of 100 seats. It will be at our disposal on Saturday 5th, from 13:00 till 19:00. Like last year, we would like to set up a schedule of talks related to the MySQL server and the various projects that surround it. Each talk will last 20 minutes, plus 5 minutes of Q&A and a 5 minute break for switching speakers, giving us 12 slots in total to fill with excellent tech talks. Take a look at this year's schedule for some examples! I hope we can assemble an even more exciting and interesting schedule for next year.
Quoting from my last year's call for papers:
We are looking for covering a wide range of topics that attract both MySQL DBAs as well as application developers that work with MySQL as their database of choice. Are you developing a new storage engine or other plugin? Do you want to share your experiences and best practices in administering or deploying MySQL servers? Did you develop a new method to scale a MySQL setup? Let us and the audience know about it! You can submit your talk proposal via this submission form.
The deadline for turning in your proposal is Sunday, 26th of December, 2010, after which there will be a voting and rating period to identify the most interesting and attractive topics.
Please check the FOSDEM 2011 information page on the MySQL Forge Wiki for more details and don't hesitate to contact me directly, if you have any questions or suggestions. I look forward to your proposals!
Thursday, October 28. 2010
The UK Oracle User Group (UKOUG) is an independent non-profit organisation of users of Oracle products in the UK, which organizes over 80 events per year all across the UK and Ireland. They have more that 15.000 members and were established over 25 years ago. Currently, they are in the final stretch of the preparations for their annual Technology & E-Business Conference, which will take place from November, 29th - December, 1st in Birmingham (UK).
For the first time, the conference will host a dedicated stream of presentations related to MySQL, which is scheduled for Wednesday (Dec. 1st). Targeted at database administrators, developers as well as users new to MySQL, there will be presentations from well-known speakers and participants of the MySQL community as well as members of the MySQL Team at Oracle.
Attendees will learn about best practices and gain valuable insight into the MySQL Server and related applications and tools.
Highlights include a keynote about the Oracle strategy and plans for MySQL by Richard Mason, Vice President of MySQL Sales and Consulting at Oracle, talks about High Availability with MySQL and MySQL Cluster as well as InnoDB Performance Tuning best practices. Other sessions will cover related products and projects from the MySQL ecosystem, that help to make the most of MySQL. See the full agenda on the conference web site for details and speaker information.
Registration for the event is still open. Get your tickets now!
Monday, October 25. 2010
Over the weekend I updated my Drupal 7 test appliance in SUSE Studio to the Drupal 7.0-beta2 release, which was released on Oct. 23rd. I also added phpMyAdmin upon a user request, to provide a web-based method to work with the MySQL instance, if needed.
In addition to the lightweight "headless" appliance (which can only be accessed and configured via a remote network connection), I've now also created a GUI-based version. This appliance starts a minimal GNOME desktop and a Mozilla Firefox browser, which in turn opens the Drupal installation page by default. I hope you will find this useful if you want to toy around and test Drupal 7 without having to go through the entire OS and LAMP stack configuration yourself. In fact, you can even test this appliance via the recently added test drive option from right out of your web browser!
The appliance is now also available in OVF format. SuSE Studio now also builds Amazon EC2 images, which don't seem to be available for download from the SUSE Gallery yet. I assume this is a recent addition to the continuously improving SUSE Studio functionality, hopefully these images will be made available soon.
Saturday, September 18. 2010
The Drupal community just recently released another alpha test release of their upcoming Drupal 7 version, to shake out the remaining bugs and to encourage more users to test it.
If you would like to give it a try, but you don't have a free server handy, how about using a virtual machine instead? Using the fabolous SuSE Studio, I've created an appliance based on openSUSE 11.3, Drupal 7.0-alpha7 and MySQL 5.1 with the InnoDB plugin and strict mode enabled (both for the SQL mode and InnoDB mode. Using this configuration helps to ensure that Drupal works well with the current version of MySQL/InnoDB and does not use any "questionable" SQL statements. This might be especially interesting for additional modules - Drupal core did not reveal any problems using strict mode so far.
You can download disk images for VMware/Virtualbox/KVM or XEN from the SUSE Gallery (free login required). Just boot the appliance in your virtualization application of choice, choose your keyboard layout and step through the network configuration and Time Zone selection. Once the appliance has booted up and the login: prompt appeared, point your web browser to the appliance's IP address to start the Drupal installation/configuration. MySQL has been pre-configured, there is an empty database named "drupal" and a user "drupal" with the same password to access it. You just need to enter this information in the Drupal Database configuration dialogue during the installation. Anything else can be configured to your liking.
After you have finished the installation, you can toy around with a fresh Drupal 7 installation! Install additional modules, change the themes, add content. And make sure to report all bugs that you run into while doing so! Have fun.
Thursday, August 26. 2010
With OpenSQL Camp and FrOSCon being over for almost a week now, it's time to come up with a short summary. I traveled home on Monday morning and then took Tuesday off, so I had some catching up to do...
As for the past years, FrOSCon rocked again! According to the closing keynote, they had around 1.500 (unique) visitors and I had a great time there. I really enjoyed meeting all the old and new faces of the various Open Source communities. The lineup of speakers was excellent, Jon "maddog" Hall's keynote about "Free and Open Source Software in the Developing World" was quite insightful and inspiring.
Most of the time I was busy with speaking at and running the OpenSQL Camp session track in room "HS6", but I managed to sneak out and listen to a few other talks as well. Additionally, I gave a presentation about ZFS on Linux, which had a good crowd and some interesting discussions.
This year, all of the sessions in the main lecture halls were streamed live, so people not able to attend could at least get a glimpse on what was going on these two days. Many times it was a really tough decision to make – there were way too many good sessions going in parallel. So being able to see the recording afterwards somewhat relieved that pain. The FrOSCon team has already begun to publish the video files – they are separated by day and lecture room and can be obtained from http://froscon.tv/.
And we were really lucky with the weather, too - the weekend was warm and sunny, a perfect setting for the social event, which is one of the highlights of FrOSCon. Impressive: this year, the attendees consumed one cubic meter (1000 liters) of Beer!
Finally, I'd like to express my special gratitude to all the speakers of OpenSQL Camp – thank you very much for your support and for devoting your time to participate in our subconference! It was appreciated.
Show tagged entries
Original content in this work is licensed under a Creative Commons License