Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 221 Next 30 Older Entries

Displaying posts with tag: Non-Tech Articles (reset)

Log Buffer #148: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This is the 148th edition of Log Buffer, the weekly review of database blogs. Welcome.


Since PGCon ‘09 has concluded not long ago (and not far away), let’s start with Postgres stuff, much of which has to do with the convention.

Here are Robert Treat’s reflections on PGCon 2009, on his zillablog: “ . . . PGCon always presents the strongest line up of Postgres information available, and this year was certainly no exception.”

Josh Berkus was there, of course, and he sends two detailed

  [Read more...]
Log Buffer #147: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 147th edition of Log Buffer, the weekly review of database blogs.

Let’s start this week, with blogs from the SQL Server world, where a number of excellent technical posts appear. Alexander Kuznetsov surprises his readers with this assertion: without ORDER BY, there is no default sort order. “Sounds trivial? Right, but different flavors of this myth still persist.  . . .  Because apparently many visitors agreed with this myth, I decided to post a repro script which demonstrates that this is simply not true.”


  [Read more...]
Log Buffer #146: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Hello and welcome to the 146th edition of Log Buffer, the weekly review of database blogs. I have to make this a quick one, but I hope (as always) that the links give you the highlights of this week’s blogs.


Let’s start with Jonathan Lewis’s report from IOUG Day 4: ” Not so much a little gem today as a little surprise and a few consequential thoughts. In a presentation on optimising star transformations the presenter pointed out that bitmap indexes are only available in Oracle Enterprise Edition.”

Here’s Doug Burns with the first of a

  [Read more...]
User Group Sponsorships
+5 Vote Up -0Vote Down

In the wake of Meetup.com changing their sponsorship agreements, Technocation, Inc., an international not-for-profit group, has set up a fund for user group sponsorships. You can use the button below to donate any amount of money in US funds via PayPal:

(all monies sent through that button will be earmarked as a directed donation to the “User Group Fund”. In the interest of not cluttering up this blog post with a Donate button for each currency, you can use PayPal to send funds in *any* currency to “donate@technocation.org”. Just be sure to specify if you want the money to go to specifically to the User Group Fund.*)

Note that meetup.com’s fees are $144 per year ($12 per month).

Four years ago, MySQL and Meetup.com entered into an agreement. I have no idea of

  [Read more...]
The MySQL Bible is Here!
+7 Vote Up -0Vote Down

A year ago, the outline was being written. A lot of work was crammed into the intervening months, and I am happy and proud to announce that the MySQL Administrator’s Bible has been published, and is sitting on the shelf at many major booksellers already. The official publication date is today — Monday, May 11th, 2009 — although some stores have had copies for a week, including Amazon.com.

The MySQL Administrator’s Bible, published by Wiley Press (available on Amazon.com at http://www.amazon.com/MySQL-Administrators-Bible-Sheeri-Cabral/dp/0470416912/, fully covers how to administer MySQL 5.1. It is suitable for people new to MySQL, although as an experienced MySQL DBA I can say that I learned a lot while researching and writing this book, and I believe that even veteran

  [Read more...]
Log Buffer #145: a Carnival of the Vanities for DBAs
+2 Vote Up -0Vote Down

Welcome to the 145th edition of Log Buffer, the weekly review of database blogs.


Since MySQL was surely the belle of the bloggers’ ball this week—why, everyone was talking—let’s begin with it.

Baron Schwartz started something with his post examining why MySQL might not benefit from having a mother ship. Dean Ellis of niflheim responded, arguing that everyone needs the MySQL mothership. And that got Sheeri’s Cabral’s attention—she took

  [Read more...]
What If…..
+3 Vote Up -1Vote Down

So, I was pointed to a post by Dean Ellis saying that MySQL needs a mothership which was written in response to another post by Baron Schwartz saying a mothership might not be the best thing for MySQL. Selena Decklemann recently posted about the issue of not having a company behind the software in the Postgres world.

Baron’s first post was spurned by someone saying:
you know, you guys really need Sun/MySQL, because without the mother ship, things will fall apart and your own business will fail.

Dean thinks this may be have been a conversation he had, and states:
What I actually said was: I

  [Read more...]
Meetup.com Confirms Automatic MySQL Sponsorship Ended
+2 Vote Up -0Vote Down

The bad news is that whatever agreement MySQL AB had with Meetup.com has ended. As per the wiki at http://forge.mysql.com/wiki/How_to_create_a_user_group:

MySQL AB has an agreement in place with meetup.com to cover the organizer fees. Simply click at the link at the top of the meetup.com page to request your electronic voucher so you can become an organizer.

Unfortunately, this agreement has ended, so there’s going to have to be a more manual process to get MySQL to sponsor the meetup groups. At its cheapest, a year of meetup.com is $144.

The good news is that Giuseppe and Dups (as well as the local Sun/MySQL folks in Boston who also sponsor the pizza and soda we have) have expressed that they are dedicated to sponsoring these user groups, so

  [Read more...]
Log Buffer #144: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This edition of Log Buffer is my first article on the Pythian Blog. It seems appropriate that, as I start a new chapter of my life in Canada and am looking to the future, a lot of the blogs this week are doing the same.

After the shock of the Oracle takeover the MySQL community is full of hope. Mark Callaghan has written about the new storage engines for MySQL and also suggestions for what the MySQL community could be doing while they wait to hear what Oracle has planned.

Kaj Arno has looked to the future and he thinks he has found some answers.

  [Read more...]
MySQL Documentation Licensing Woes
+1 Vote Up -0Vote Down

By now many folks know that MySQL documentation is not changing its license. This is an issue with many sides, but before I go through them, I want to address a comment made by Masood Mortazavi:

People who are interested in forking the server — and potentially interested in creating what is in effect separate communities of their own — should probably develop their own docs for their own forks.

(There is a cost involved here, I know. However, it should be a cost worth paying if developers of forks really believe in their work. MySQL AB certainly paid that cost in developing the docs while it had already made the code itself freely available under GPL. So, the

  [Read more...]
Log Buffer #143: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This is the 143rd edition of Log Buffer, the weekly review of database blogs.

So . . .  Anything happen while I was away?

Okay, so I heard the big news. And just in case you haven’t, here it is from Sheeri Cabral: Oracle Buys Sun. This is a sea-change in the hi-tech world, and the DB part of it will also get rocked, Sun being the home of MySQL. There’s lots of comment in Sheeri’s post, and indeed, all over the database blogging world. I will try here to cover the best of it.

Oracle + Sun + MySQL

First, Monty Says:

  [Read more...]
Speaking About MySQL
+1 Vote Up -0Vote Down

This year’s Oracle Open World is taking place from October 11-15th, 2009 at the Moscone Center in San Francisco, CA. Paul Vallee noted that Oracle’s acquisition of Sun means that Open World will probably want a MySQL track, and Matt Yonkovit of Big DBA Head mentioned that a blog post on it would spread the word.

The Call for Presentations closes April 26th, which is in just 3 days. You can find out more and submit presentations at http://tinyurl.com/oow09prop. I spoke at Oracle Open World last year on “How to Be an Oracle ACE” and attending the conference was pretty mind-blowing.

If you do submit a talk, feel free to comment here with the title so we can get a broad range of topics submitted, not just 100 speakers submitting “MySQL for the Oracle DBA”.

Keynote: How To Be a Community Superhero
+2 Vote Up -0Vote Down


I am @sheeri on twitter
My blog is at http://pythian.com/blogs/author/sheeri
My e-mail is cabral@pythian.com

Pythian became the first ever Sun Enterprise Remote DBA Partner — read the details at http://tinyurl.com/pythiansun.

Technocation, Inc can provide free web space for slides, videos and audio files. Their website is and you can e-mail them at info@technocation.org Technocation, Inc. is a 501(c) not-for-profit US corporation dedicated to providing educational resources for IT professionals.

  [Read more...]
The Pythian-Sun/MySQL Partnership
+1 Vote Up -0Vote Down
I am very excited to be able to link to this press release announcing that The Pythian Group is the founding partner in MySQL’s brand-new “Remote DBA Provider” partnership program. This is great news for Pythian. It is also good news for Sun/MySQL. (Although admittedly nowhere near as attention-getting as Oracle’s announcement of their purchase [...]
Oracle buys Sun
+2 Vote Up -1Vote Down

It’s true — http://www.nytimes.com/2009/04/21/technology/companies/21sun.html?_r=1&hp.

Ronald Bradford asked, “What does this mean for MySQL?”

Lots of people are going to be proclaiming that it is the death of MySQL, as they did when Oracle bought InnoDB.

But it is not. MySQL and Oracle may both be databases, but they are not competitors. To say they are competitors is like saying that an upscale bar and the corner convenience store are competitors because you can get soft drinks, coffee and tea at both. There are many applications for which Oracle is the appropriate solution, and there’s no reason to even try to see if MySQL can do the same job. Similarly there are many applications for which MySQL is the clearly

  [Read more...]
Pythian Goes to the MySQL Conferences
+0 Vote Up -0Vote Down

I’m very proud to share with you a few things: Sheeri K. Cabral, Nick Westerlund, Paul Vallée, Peter Ling, and I (Augusto Bott) will be in Santa Clara, CA for the MySQL Conference and Expo, MySQL Camp, and the Percona Performance Conference, next week.

Nick and I will be presenting a session called Proactive Operational Measures on the Percona Conference, and another session called 8 Rules for

  [Read more...]
Community Keynote at the MySQL Conference
+1 Vote Up -0Vote Down

I am thrilled to announce that this year’s MySQL Conference will feature a Community Keynote. This is a keynote speech delivered by a community member (not a Sun employee!) about topics relevant to us.

I am delivering this year’s keynote, entitled “How to be a MySQL Superhero” on Wednesday, April 22nd at 9:45 am Pacific. Details are at http://www.mysqlconf.com/mysql2009/public/schedule/detail/9098. This is a great indication that Sun and O’Reilly are taking community very seriously, and want to make sure that our voices are heard — literally.

I hope that this can be an annual featured keynote, like the “State of the Dolphin.” The thriving community is one of the reasons MySQL is the world’s most popular database.

Log Buffer #142: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 142nd edition of Log Buffer, the weekly review of database blogs.

The SQL Server ’sphere was a busy place this week. On In Recovery… Paul S. Randall posted his latest straw poll, this time looking into your practices around transaction log size management.

Linchi Shea observed, “In a multi-process/multi-thread system, locking is central to maintain data consistency and keep things in order.  . . . [We] need to begin with understanding the locking behavior of the basic building blocks offered by SQL Server . . . 

  [Read more...]
Sunday April 19th Games Day
+0 Vote Up -0Vote Down

The Sunday before the MySQL User Conference is always full of trying to meet up with new or old friends, even if your flight lands after dinnertime. With that in mind, the very first event of the week is MySQL Camp’s “Games Day”.

From 12 noon until midnight on the Mezzanine of the Santa Clara Hyatt Hotel (adjoining the Santa Clara Convention Center), there will be an informal games day. The list of games that are definitely appearing are on the MySQL Forge at:


There is still one game I would like to see appear (Set), though there is plenty to keep folks busy — board games, a puzzle, decks of cards, even building toys. I’ll probably be knitting, so if you are the crafty sort and

  [Read more...]
Log Buffer #141: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 141st edition of Log Buffer, the weekly review of database blogs. The Oracle bloggers were especially chatty this week, so let’s start with them.

Rob van Wijk wrote a fine post about choosing between SQL and PL/SQL, defending his choice of straight-up SQL for logic. Naturally, this triggered a lot of discussion, as well as a few responses from other blogs. Chen Shapira framed her response in a question about code life-cycle: would you rather maintain SQL or PL/SQL?

  [Read more...]
New England Database Society Meeting
+0 Vote Up -0Vote Down

I am passing this along — I am not sure if most folks reading this can make it, as it is last-minute and in the Boston area, but I figured I’d let people know that the New England Database Society exists. It’s free, sponsored by Sun (and has been for years, long before Sun bought MySQL), and is hosted by my college database professor, Mitch Cherniack. (To that end, I should probably make sure to promote the Boston User Group here more often! I keep forgetting…)

You can find information on how to be a part of the mailing list at http://www.cs.brown.edu/sites/neds/

The next New England Database Society will be held on Friday, March 27 and the speaker is Christian Jensen of Aalborg University.

  [Read more...]
MySQL Camp Details and Restaurant list!
+0 Vote Up -0Vote Down

As folks are making their plans to go to the MySQL User Conference, I just wanted to remind folks of the schedule of MySQL Camp.

One feature I put together for MySQL Camp but anyone can use is a restaurant list for the hotel area. There’s very little within walking distance, but many people will be local or will rent a car, so finding someone to drive with should not be a problem. The restaurant list is on the MySQL Forge Wiki at http://forge.mysql.com/wiki/SantaClaraRestaurants — updates are welcome!

About MySQL Camp: MySQL Camp is completely free, just walk on in and enjoy the sessions. All sessions are in the Bayshore room off the Mezzanine, and there will be signs directing you to the MySQL Camp room. I describe it as being like “an

  [Read more...]
Log Buffer #140: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This is the 140th edition of Log Buffer, the weekly review of database blogs. Welcome.

Let us begin with Oracle this week. Dan Norris illustrates how to start database services automatically after instance startup. He says, “Services are an essential component for managing workload in a RAC environment. If you’re not defining any non-default services in your RAC database, you’re making a mistake.”

Vivek Sharma published his tale of, Latch: Row Cache Objects causing huge performance

  [Read more...]
How to Have a Good Presentation
+1 Vote Up -0Vote Down

In about 15 minutes, Giuseppe Maxia will begin a webinar in which the main focus is a presentation on “How to have a good presentation”. Talk about meta!

Giuseppe posted how to join the free webinar.

The slides can be found at http://datacharmer.org/downloads/2009_03_Presentation.pdf.

Log Buffer #139: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 139th edition of Log Buffer, the weekly review of database blogs. Let us begin with a look at the best from the Oracle ’sphere.


Many of you might be considering some more training or certification. Coskan Gundogar has already been there, and has returned with the tale to tell, What I learned during Oracle SQL Expert Exam Study Part-1.

In Jared Still’s Ramblings a discussion of the evils of encoding meaning into data.

  [Read more...]
Log Buffer #138: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Welcome to the 138th edition of Log Buffer, the weekly review of database blogs. If you aren’t aware of who I am, my name is Nick and I am a Senior DBA at The Pythian Group. This is my second run at hosting Log Buffer, and I hope you will enjoy it as much as I did creating it.

As we see winter giving way to summer, I thought I would start with Informix.
Over at Informix-technology Fernando talks about FUD for thought where he talks about the future of Informix vs. DB2.

Sticking with IBM, I thought

  [Read more...]
Log Buffer #137
+0 Vote Up -0Vote Down

This is the 137th edition of Log Buffer, the weekly review of database blogs. Dave Edwards is enjoying a week off, and so as part of my plot to take over the world, I am writing this week’s Log Buffer.

First, the fun stuff: Josh Berkus tells us that the American English Translation of the Manga Guide to Databases is available in Japanese Fairies and Third Normal Form.

Then, the basics:
Giri Mandalika points to an article on Using MySQL with Java Technology. This is a basic article on how to connect, and does not go into all the wonders

  [Read more...]
Drizzle Podcast #1
+0 Vote Up -0Vote Down

It has been over a year since the last OurSQL podcast. First, I want to thank everyone who has written in to tell me how much they loved the OurSQL podcast, and how they want it back. Plans are in the works for that, mostly I got busy writing a book on MySQL geared towards folks who are new to MySQL, but not necessarily new to databases. The book is coming out in May and can be pre-ordered at http://tinyurl.com/mysqlbook.

But enough about the past…..In this first Drizzle podcast, Jay Pipes and I talk about what Drizzle is and how Drizzle is different from MySQL both technically and from a community standpoint.

The podcast can be downloaded (5.76 Mb as an mp3 file) or played right through your browser at http://technocation.org/content/drizzle-podcast-%25231. The show notes are also on that page.

Log Buffer #136: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This is the 136th edition of Log Buffer, the weekly review of database blogs. Welcome.

Let’s start with the bad news first. The relational database is doomed. Or is it? That is the line of inquiry taken by the item by Tony Bain on ReadWriteWeb. “Recently, a lot of new non-relational databases have cropped up both inside and outside the cloud. One key message this sends is, ‘if you want vast, on-demand scalability, you need a non-relational database’.  . . .  Is this a sign that relational databases have had their day and will decline over time?”

Whether or not you believe that your

  [Read more...]
Steal This Blog Post
+0 Vote Up -0Vote Down

I have been talking more and more with colleagues about the Open Source community and licenses. Zak Greant recently wrote in Free Culture vs. Fear Culture vs. Fee Culture that, “People with bad intentions will do bad things . . . often regardless of the license on the work.”

And, unfortunately, he is right. If I release an article or presentation video with a Creative Commons license, it is still possible for my work to be plagiarized, and if it is, I will still feel violated.

Many of us who use Creative Commons or MySQL have an Open Source mentality. We often do not see value in pirating software—why would we use Microsoft Word (a legally licensed copy, or pirated) if we can

  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 90 of 221 Next 30 Older Entries

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.