PlanetMysql.ru — информация о СУБД MySQL

One of the many things that hasn't changed with GlassFish since the acquisition is how we welcome contributions from the community (in fact we've seen an increased number of those recently).

The Oracle Contributor Agreement, or OCA (born as the SCA) is a required document before we can accept such contributions and a fairly common practice in open source projects. One important thing that has changed for the OCA is the email address to use for signed contributor agreements :
            <oracle-ca_us@oracle.com>

One thing that will change is the location of the public list of the OCA signatories. For the time being you can find a consolidated and updated list for GlassFish, OpenJDK, NetBeans, MySQL and more on java.net.

The OCA FAQ document (which is still frequently being updated) lists a good number of answers to questions such as "What does the OCA do?", "Why do you have a Contributor Agreement?", "What if I'm contributing on behalf of my company?", "What can Oracle do with my contribution?" and many more.

PlanetMySQL Voting: Vote UP / Vote DOWN

Despite my best intentions, I haven't posted on this blog for a while, which is a shame! I've become busy writing on so many other places since I moved into my new role in the Oracle Linux product management team in April. I've learned a lot and I am feeling quite at home here! The team is excellent and very nice to work with — I am slowly getting the "Big Picture".

But even though I've been neglecting this blog, there are a lot of things that are publicly visible and document some of my activites:

I've created two podcasts for the Oracle Linux podcasts:

• OCFS2: Features and Benefits
• Latest Btrfs Updates

In addition to working the @ORCL_Linux Twitter account and FaceBook page, I've been blogging on the Oracle Linux blog:

• Linux Filesystem, Storage and Memory Summit
• Follow us on YouTube and Facebook, too!
• Oracle Linux 6.1 has been released
• Oracle Linux 6.1 ISO images now available for download
• First episode of the Oracle Linux Podcast: Sunil Mushran on OCFS2
• New episode of the Oracle Linux Podcast: Chris Mason on Btrfs
• OTN Sys Admin Days - Oracle Solaris and Oracle Linux (Sep. 8th, Sacramento, CA)

From time to time, I'm a guest blogger on the OTN Garage blog:

• Pimp my Ride - Installing Additional Packages on Oracle Linux
• Save disk space on Linux by cloning files on Btrfs and OCFS2

I also created new content and updated pages on the main Oracle web site and the Oracle Technology Network (OTN):

• A new technical white paper about Oracle Linux and the Unbreakable Enterprise Kernel
• An article about How to Extract Files from an Oracle Linux RPM Package Without Installing the Package
• Added a new page about our Oracle Linux support offering
• Updated the OCFS2 product page
• Updated the Oracle Linux technical information page.

I've been traveling a bit as well and attended a few conferences where I spoke about Oracle Linux (and MySQL):

• MySQL High Availability at COLLABORATE 11, Orlando (FL), USA
• An introduction to Oracle Linux at the HEPiX Spring 2011 Workshop, Darmstadt, Germany
• What's new in MySQL 5.5 at LinuxTag 2011, Berlin Germany
• Updates on Oracle Linux and Oracle VM at fisl12, Porto Alegre, Brazil

I probably forgot a few things in my reflection of the past few months, but these were some of the highlights.

Check out my followup blog post on what I'm up to in the coming weeks and months!

PlanetMySQL Voting: Vote UP / Vote DOWN

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:

• BUG#13175: SHA2 function (Patch contributed by Bill Karwin)
• BUG#14104: FLUSH LOGS now takes an optional log_type value so that FLUSH log_type LOGS can be used to flush only a specified log type. (Patch contributed by Eric Bergen)
• BUG#27249: Aliases for wildcards (as in SELECT t.* AS 'alias' FROM t) are no longer accepted and result in an error. Previously, such aliases were ignored silently. (Patch contributed by Martin Friebe)
• BUG#40368: mysqld_safe did not honor underscores in the same way as dashes for server options (Patch contributed by Erik Ljungstrom)
• BUG#45767: Removal of Field::pack_key, Field::unpack_key, Field::pack_cmp storage engine functions (Patch contributed by Zardosht Kasheff)
• BUG#50057: SHOW PROFILE CPU port for Windows (Patch contributed by Alex Budkovski)
• BUG#5724: "mysqladmin password" prompts for a password when none is provided on the command line (Patch contributed by Harrison Fisk)
• BUG#26780: A new mysql client option "--auto-vertical-output", which causes the client to test whether a result table is too wide for the current window (where available) and emit vertical results in that case. (Patch contributed by Eric Bergen)

A big "Thank you" to all the contributors!

PlanetMySQL Voting: Vote UP / Vote DOWN

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:

• What's new in MySQL 5.5? (Slides)
• How to build you own Quadrocopter (Slides)

Afterwards, I also participated in a panel discussion about "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:

• MySQL Replikationstechnologien - eine Übersicht
• Blick in die Werkzeug-Kiste eines MySQL-DBAs

I already received my speaker badge for this conference (see the picture below). Cool idea: you can use the public transport facilities (Buses, Trams) for free, by presenting this card!

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!
PlanetMySQL Voting: Vote UP / Vote DOWN

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:

• What's new in MySQL 5.5? (Slides)
• How to build you own Quadrocopter (Slides)

Afterwards, I also participated in a panel discussion about "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:

• MySQL Replikationstechnologien - eine Übersicht
• Blick in die Werkzeug-Kiste eines MySQL-DBAs

I already received my speaker badge for this conference (see the picture below). Cool idea: you can use the public transport facilities (Buses, Trams) for free, by presenting this card!

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!
PlanetMySQL Voting: Vote UP / Vote DOWN

It's that time of the year again — the nice folks at FOSDEM have granted us a developer room at their upcoming conference (February 5+6 2011 in Brussels, Belgium)!

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!
PlanetMySQL Voting: Vote UP / Vote DOWN

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!

PlanetMySQL Voting: Vote UP / Vote DOWN

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.

PlanetMySQL Voting: Vote UP / Vote DOWN

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.

PlanetMySQL Voting: Vote UP / Vote DOWN

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.

PlanetMySQL Voting: Vote UP / Vote DOWN