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

This week, ten years ago, I was in London for MySQL AB‘s first “train the trainer” course, also meeting (for the first time) my first boss at MySQL Kaj. I’d been hired mid August as employee#25, also doing training but actually primarily as tech-writer for the MySQL documentation (taking over from Jeremy Cole, and essentially I was the documentation team for quite some time . So from this you can deduce that yes, I was hired without meeting either Kaj or anyone in-person! I don’t think we even had a phone call, only email. Oh the days

The training week itself was of course disrupted quite a bit by the events in New York. We had Jeremy who had come on a UA flight from the US, and others from all over the place… it also taught some students a lesson about browsing the net while in a training course, it can end up very distracting.

The oddest event I remember about that particular trip happened upon departure from Heathrow: someone with a clipboard went round the long queues asking whether anybody was carrying eyebrow tweezers. No other items/questions, just that.

I stayed with MySQL for about 6 years, until with a brief break, I started my own company Open Query in 2007 (about half a year before the Sun acquisition). So this September marks the 4-year anniversary of that event already. I spotted an old business card earlier, reminding me that early on we did not just MySQL consulting and training, but also (OSS) business advice – that’s now essentially spun off to Upstarta.

The MySQL side of my business has changed quite significantly as well, going from the usual reactive consulting to proactive subscriptions, in part based on Pythian‘s successful model. A key difference has been that we don’t do emergencies. This disruptive shift happened somewhat by luck, after a talk at Linux Users of Victoria in April 2009. Ben Dechrai made a video recording of this interactive “Relax! A Failure is not an Emergency…” try-out. It also mentioned the BlueHackers initiative/stickers.

While some people including competitors regard our “no emergencies” approach as nuts , it has worked out very well and apart from making customers happy it’s created the sane lifestyle I was looking for (so I could spend more time with my daughter), and enabled contracting others as well. We’re still growing organically, having adapted our internal tools and processes for the proactive service approach along the way – obviously, it’s now more about project management than handling incident tickets.

Like my time at MySQL AB, my journey since then has so far proven interesting, educational, and mostly enjoyable. Later in the year I aim to once again buy a house with a modest garden. And it’s the independence that’ll have made that -and my other explorations- possible. Who knows what lies ahead – most fun when you create your own future!

Isn’t that that time of the year again?

Yes, it is — it’s time for our annual Oracle Bloggers Meetup and of course Oracle is piggybacking OpenWorld with the meetup again! ;)

What: Oracle Bloggers Meetup 2011

When: Wed, 5-Oct-2011, 5:00pm

Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103

View Larger Map.

View Larger Map

See the “Main Dining Room” on the floor plan below (we will actually use half of it – we are too big now to fit into a smaller “Lower Dining Room”) and ask where is the “Oracle Bloggers Meetup” booked under Pythian / Oracle name. These are the keywords to find us easily.

We have selected Wednesday again before the big event at Treasure Island. It seems to be the ideal timing because most of attendees don’t plan anything else on that day while the rest of the evenings are filled with customer meetings, sponsored events and etc. Easy choice now!

Compared to last year, we are shifting it 30 minutes earlier because the Treasure Island event is starting 30 minutes earlier. I don’t think it will be a problem — most of the participants showed up before 5:30pm last year – you will have had enough of OpenWorld by 5pm this time.

Traditionally, Oracle Technology Network joins Pythian sponsoring the venue and drinks.

As usual, vintage t-shirts from previous meetups will make you look cool — feel free to wear them. This year’s activity is still being planned — we have lots of cool ideas and couldn’t decide which one is the coolest but if you have something interesting in mind — let me know privately {last_name} at pythian.com.

For those of you who don’t know the history… The Bloggers Meetups during the Oracle Open World were started by Mark Rittman and continued by Eddie Awad and then I picked up the flag in 2009. The meetups have been great success so let’s keep them this way! To give you an idea, here are the photos from the OOW08 Bloggers Meetup (courtesy of Eddie Awad) and last year’s meetup blog post update from myself.

While the initial meetings was mostly around Oracle database folks, the latest meetups are joined buy guys and gals from lots of Oracle technologies – Oracle database, MySQL, Applications, Sun technologies, Java and more. All bloggers are welcome.

See the results of last year’s meetup here and here follow all the links.

If you are planning to attend, please comment here with the phrase “COUNT ME IN”. This will help us make sure we have the attendance numbers right. Make sure you provide your blog URL with your comment — it’s a Bloggers Meetup in the end! Make sure you comment here if you are attending so that we have enough room, food and (most important) drinks. Last year we barely fit. Again, we are reserving a bigger room but we want to make sure we can fit everyone!

Of course, do not under any circumstances forget to blog and tweet about this year’s bloggers meetup.

Last, but not least, you should know that the real organizer of the event and the one doing all the heavy-lifting here is Vanessa Simmons – give her a pat on the back when you see her.










Looking forward to seeing even more of you again this year!

Welcome to Log Buffer, the weekly round up of news and happenings in the database world.

We’re planning our publishing calendar for 2011. Happy to announce that we’ll have a few guest hosts in the New Year. Don’t forget if you’d like to host or edit a future edition of Log Buffer on your own blog, send a note to the Log Buffer coordinator.

We’ve had several contributions of favorite reads from the team this week. Enjoy this issue, Log Buffer #208.

Gwen Shapira’s picks:

Iggy Fernandez uses GraphViz to visualize his explain plans – he thinks it makes them easier to read, but Gwen’s not sure she agrees. In the comments, Tim Hall and Charles Hooper give a lot of information on how to read explain plans correctly and are worth reading.

Jonathan Lewis, on Oracle Scratchpad, blogs about optimizer issues with collection types and suggests a work-around.

Asif Momen updates that Oracle released a nifty little tool for looking up DBA views and background processes.

Jared Stills ran into interesting date format issues while working on his latest book.

Pythian’s Alex, Christo and Dan were blogging live from UKOUG 2010. It looked like they were having so much fun, I’m not sure why they call it work! Welcome home, Paul and team – you made it, despite the snow.

Vadim Tkachenko blogs about a very scary InnoDB bug that can corrupt your data and crash your database. It can even allow your users to do it to you! Read and take steps to protect yourself.

In DB2 news, Fahd Mirza suggests:

Henrik Loeser expounding as how to build a full text index on PDF documents in DB2.

Raul F. Chong gives the chance to experience the next version of DB2 today!

Willie Favero appreciates the security offered by the DB2 10.

Edwin Sarmiento writes his second post in a series on HADR, further building on his point that a good HADR strategy is more than just the underlying technology.

Guiseppe Maxia, the Data Charmer, starts a lively discussion on MySQL forks, and points out 5 arguments in favor of them.

Hard to believe it’s December already.

Everyone loves the colorful and easy lighting fire logs you can buy in the store for between $3-5, and from our feedback we are savoring the fact that everyone also adores the vibrant and flamboyant log buffer.

Winter has started and the holiday season is approaching fast. With the chillness of winter and festive mode induced by the holidays, bloggers across the planet are coming up with more and more exciting ideas. Let’s start with sizzling log buffer #207.

Oracle Jewels:

Discussing the common errors by the DBAs, Hemant K Chitale from Oracle Singapore advises against blindly killing sessions.

Cellcli, an Exadata utility which is used to manage Exadata storage, is another hot topic of the week. Kerry Osborne sheds light on it here, and Pythian Blog here.

A very lucid, reproducible example about Index Joins has been put on display by Jonathan Lewis. It’s a compact introduction about Index Joins, which are also known as Index Hash Joins.

How much disk do I need for my new Oracle database? This is the question,one of my favorite blogger Martin Wildake asked and answered in his blog post. He is also an Oakie now, and even secretly doesn’t think that he deserved it. Congrats Martin, you really deserved it.

A Crisp and cool overview of Execute Queues and Work Managers in Oracle Weblogic servers has been provided this week by the Weblogic Wonders blog.

SQL Server Pearls:

Melissa Coates, the SQL Chick, throws light on the usage of variables, expressions and the custom code in his recent blog post and how they work in harmony in the SQL Server Reporting Services.

There is still not much information available in documentation or elsewhere on Reporting Services administration via scripts, but David Levy, so graciously provides a very useful script to change SSRS Report credentials with Powershell.

Pinal Dave on his weblog shows how to do concatenation in SQL Server. Its different than in Oracle and MySQL, and those small differences are always a challenge for beginners even when the solution is very simple.

Venkatesan discusses the composite primary key in SQL Server on his blog with screen shots.

Geekblogger presents some new and very useful SQL Server functions for DBAs and the programmers here.

MySQL Gems:

Shlomi Noach shed a positive light on mysqldump in response to Morgan’s blog post. Even though he agrees with some of Morgan’s arguments.

There is a good review of MySQL High Availability book by Simon Mudds on his blog.

Anders Karlsson releases a MySQL Plugin for MySQL 5.5 that allows to monitor the most recently executed, and the most frequently executed statements using 2 INFORMATION_SCHEMA tables.

Mark Callaghan elaborates on salient points about an interesting question as how are Index-Only scans implemented in InnoDB.

If you want to know or refresh the basics about moving from MyISAM to Innodb or to XtraDB, then this blog post is a good piece to look at.

NoSQL Ornaments:

Alex Popescu discuss about the options of running NoSQL and SQL in the cloud in a very easy manner.

Dan Pritchett says it all from the Engineering Mantra: NoSQL, SQL, Is that the Question?

CAP Theorem is another getting-hotter-by-day among many bloggers and Michael Stonebraker dishes out his take.

Jonathan Ellis expounds on the business requirements for the drive to find alternate data management solution to tackle the challenge of rapidly increasing data volumes in his post.

DB2 Flowers:

Adam Gartenberg blogs about as how companies are finding value in the Analytics. He presents some interesting statistics from the surveys.

Dan Krook wrote a brief overview of an article series that Mark Nusekabel, Yan Li Mu and he wrote about their experience migrating a large PHP and MySQL.

Dave Beulke appreciates that DB2 10 Security improves Java Performance in this blog post.. Its a good discussion about ROLES-based security model.

Well, That’s all for this week. Thanks for stopping by.

Welcome to Log Buffer, the weekly news blog about blogs in the datasphere… As we kick off Log Buffer #206, our own Gwen Shapira shares a few of her weekly favorites:

Oracle:

Arup Nanda posted an excellent script on how to summarize backup information from the rman catalog. He also posted a tool for automatically purging time-based partitions.

Pythian’s resident Exadata expert, Marc Fielding posted links to the latest recording of his Exadata webinars.

Gary Mayers, on Sydney Oracle Lab explains Oracle user security model.

Riyaj Shamsudeen shows what really happens when you update a query with the same values it already had.

Jonathan Lewis explains how he tests list partitions, a post which gives an excellent review on how one should go about testing new features in general.

MySQL:

At MySQL Performance Blog, Aurimas posts a war story about a very unusual data recovery. Test your backups, or you may have to go through the same ordeal.

In same blog, Morgan Tucker gives another reason why you shouldn’t use mysqldump to take backups.

SQL Server:
MVP Edwin Sarmiento is blogging live from SQL PASS 2010 in Seattle.

Aaron Bertrand introduces a feature in SQL Server 2011, called SEQUENCE that most Oracle DBAs would recognize too.

And lastly a few general posts. One from Michael Lopp, who, on the “Rands in Repose” blog, explains how people follow conversations, with some amusing examples.

And the second from Singer Wang who reports that RedHat 6 is finally out after 4 years.

A big shout out to this week’s contributors wraps up this issue. Don’t forget, if you’re interested in hosting your own issue of Log Buffer – send an email to the Log Buffer Coordinator.

A very warm welcome to the Log Buffer, the premier medley of fresh information culled from the blogs related to the technology which stores the world, yes, the databases.

In this edition, the Log Buffer #205, we have yet again found the pulse of the industry.

Oracle:

On the Oracle front, leading Oracle technologist Andrey Goryunov carries on his hands-on experiments of newest version of the Oracle database. This time he slices away chopt.

It’s always very informative and exciting to know about internals of RAC Stuff like what actually is maintained in the Voting Disk . Riyaj has it here.

Jonathan Lewis does a little thought experiment with list partitioning.

HugesPages almost always provide value to the Oracle databases on the Linux Systems, and many people wonder why they are not the default. Kevin Closson touches some points regarding HugesPages, and he also notes down some finer points like the dislike of AMM and Hugespage for each other.

Hardly anyone would refuse a gift consisting of chocolate, ice cream, flower and designer watch. Yes, now you can have Tanel Poder, Cary Millsap, Jonathan Lewis, and Kerry Osborne at one Virtual Oracle Conference.

Tim Hall, like many other people is perturbed over the plagiarism of his articles.

Oracle recommends that you use JRockit JDK with your Oracle products and the reasons are described by JaySenSharma at his Weblogic Wonder blog.

DB2:

Now, RPM and DEB packages for DB2 Express-C are available for the download. Get it from here.

Troy Coleman, blogs about the ripple-creating news that Last week IBM announced the general availability of DB2 10 for z/OS.

The keynote session for the third day of the IOD conference features the authors of Freakonomics, Steven Levitt and Stephen Dubner, and Craig Mullins highly recommend that.

SQL Server:

If you are curious about the title “Plumbing The Depths of SQL Server / PowerShell Integration, then don’t miss SQL Server Connections conference on Nov 1-4 in Las Vegas and attend the session by Bob Beauchemin.

Though not earth-shattering and sky-ripping, but very valuable nonetheless this post by Jeff about calculating the median.

And following is the ever-green SQL Server Myth buster posts by Euan.

MySQL:

Zack Urlocker rambles on how open source software, cloud and software as a service are helping to bring about the consumerization of IT.

Here is one more effort where the bencmarking of MariaDB is being done.

Have a nice weekend.

Welcome to Log Buffer, the weekly roundup of happenings in the database world.

Lots to cover this week, so let’s get on with Log Buffer #204. Enjoy!

Oracle:

Pythian’s Gwen Shapira dabbles with MySQL and explores MySQL troubleshooting for the Oracle DBA.

Venkat Janakiraman explores how connectivity works for BI EE 11g on Microsoft SQL Server Analysis Services 2008.

Iggy Fernandez explores SQL 101: Which Query is better, in part II to a post he covered in summer of this year.

Chet Justice, on Oraclenerd reviews how to use forgotten function OBIEE: Evaluate

Tanel Poder announces last chance for early-bird rates to sign up for the virtual conference on Systemic Oracle SQL Optimization featuring himself, Cary Millsap, Jonathan Lewis & Kerry Osbourne.

DB2:

Lots going on at the IOD 2010 conference over the past week. Craig Mullins covers the event with news, a video of attendees, and the final keynote.

MySQL:

Sheeri Cabral shares how she determines MySQL fragmentation.

Baron Schwartz posts the third in a series of posts on MySQL limitations – one thread per connection. In case you missed them, part 1 covered single-threaded replication, part 2, the binary log, and part 3, subqueries.

SQL Server:

On In Recovery, Paul S. Randal invites readers to participate in a survey to determine wait times on systems. Chime in with your feedback by commenting on his blog post or sending him an email after reading the instructions. Paul is also calling for participants for T-SQL Tuesday #12 – Why are DBA skills necessary.

And lastly in Postgres news, PG West 2010 is happening next week. There are a number of posts on the need for replication in PostgreSQL 9.0. Joshua Drake stirred the pot, responded and created a Replication poll to find out what you really think. Cast your vote!

Happy Haunting weekend.

It’s that time of the year again — Oracle OpenWorld time — and it’s my pleasure to announce our regular Oracle bloggers meetup again this year. We all know that Oracle community has grown this year so we expect to see folks from all the different technologies including MySQL, Java, Sun hardware folks in addition to the core Oracle database and apps crowd.

So… all of you Oracle bloggers attending Oracle Open World 2010…
… you are invited to attend this Oracle Bloggers Meetup during OOW 2009 — a chance to meet your online buddies face-to-face in relaxed and informal atmosphere.

When: Wed, 22-Sep-2010, 5:30pm

Where: Lower Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA 94103.

View Larger Map

Street view:

View Larger Map

See the “Lower Dining Room” on the floor plan below and ask where is the “Bloggers Meetup” booked under my name — Alex Gorbachev. These are the keywords to find us easily.

The plan is to gather at 5:30pm on Wednesday after three (or for for those of us starting on Sunday) days of intense learning. This year, you won’t need to find where to kill few hours in between of the OOW sessions and customer appreciation event at the Treasure Island — the best place to be this year is our bloggers meetup — the place where all the “cool kids” are.

As usual, thanks to Oracle Technology Network and Pythian for sponsoring the venue and drinks. HP is planning to establish a prize again this year for something fun… yes, we will again do something fun.

Last year, we were collecting signatures on our Bloggers Meetup T-Shirts so feel free to wear them this year to show your seniority at the event. ;-) This year’s activity is a surprise but if you have something cool in mind — let me know privately {last_name} at pythian.com.

For those of you who don’t know the history… The Bloggers Meetups during the Oracle Open World were started by Mark Rittman and continued by Eddie Awad and then I picked up the flag. They have been great success so let’s keep them this way! To give you an idea, here are the photos from the OOW08 Bloggers Meetup (courtesy of Eddie Awad) and last year’s meetup blog post update from myself.

If you are planning to attend, please comment here with the phrase “COUNT ME IN”. This will help us make sure we have the attendance numbers right. I will maintain the list here. Make sure you provide your blog URL with your comment — it’s a Bloggers Meetup in the end! Make sure you comment here if you are attending so that we have enough room, food and (most important) drinks.

Of course, do not under any circumstances forget about to blog and tweet about this year’s bloggers meetup.

Looking forward to seeing all of you again this year!

Log Buffer #197 marks the middle of summer, and the fact that we’re a mere two weeks away from our 200th edition.

To begin this week’s reading, I’d like to highlight two Oracle blogs maintained by Sam J. DeFilippis: Oracle Notes, where he’s recently posted about troubleshooting GoldenGate and positioning a read of Extract/Replicat Trail file or Oracle redo log. Sam volunteered to host a future edition of Log Buffer (thanks, Sam!). You can too, by sending an email to the Log Buffer coordinator, we’re always looking for volunteer publishers.

Brad Hudson a points that PostgreSQL test servers have moved from Oracle to EnterpriseDB.

Marc Fielding posts Part 2 of his series A Grand Tour of Oracle Exadata. He’s also hosting a webinar on how to successfully implement Exadata, Aug. 11th.

Cary Millsap explains why thinking clearly is more important than being correct.

On PL/SQL Challenge, Steven Feuerstein and his readers try to figure out where to find a list of all the tables and debate what is a table these days.

Sheeri Cabral catches up on her blogging this week with posts datawarehousing best practices, comparing Oracle and MySQL. Part 1 covers introduction and power, and Part 2 talks about partitioning. Another, explains Pythian’s method for continuously verifying replication sync, and lastly is a farewell post, as Sheeri forks off…. Pythian wishes Sheeri all the best in her future pursuits.

Iggy Fernandez tries to decide whether to use correlated subquery or join in a query.

Always wanted to learn more about Google’s BigTable database, but find the google papers intimidating?
myNoSQL blog links to a slide-deck that makes it all clear.

Ronald Bradford outlines clear evidence that in the short to medium term Oracle will continue to promote and enhance MySQL, and invites readers to chime in to his discussion on will Oracle kill MySQL?

And, on a side note, Pythian is looking for senior systems administrators who have RedHat Linux administration experience in Australia & other international locations. Visit our candidate system to match your skills with all of our current openings or submit your resume.

For those in Canada – enjoy Civic holiday weekend.

Today marks my last day at Pythian. I have been at Pythian for almost three years. In those three years, Pythian’s already thriving MySQL practice has grown even more. I have worked with big and small clients alike, across many industries, managed a team of up to 4 DBAs, and learned a lot not just about MySQL, but what my goals are in general.

Though I am leaving, everything I said in the blog post I made when I announced I was coming to Pythian still holds true. Pythian is a challenging environment and one I would recommend to anyone who finds their current DBA environment boring that they should come to Pythian and experience what it is like to work here. I had lunch with Paul Vallee yesterday and we even discussed possible future collaborations (hence the title, a joke that I am “forking” off of Pythian).

So if it is so great, why am I leaving? It’s simple, really — Pythian is growing by leaps and bounds. I started when Pythian was about half the size it currently is. There is a lot of change happening within Pythian, and I believe it is very good change. However, I enjoyed the environment Pythian was when I started almost three years ago, and personally I am not ready to go with Pythian on the journey it is taking.

So where am I going next? For starters, I will take the month of August off paid work. I have an idea of where I might go for paid work in September, but you will have to watch Planet MySQL for the announcement. During August I will be doing some conference planning and organizing, for OpenSQLCamp in Boston in October first, and then for conferences in 2011. I will also be moving apartments, which is a big task. And I will be focusing on some personal goals, such as spending more time with my husband and becoming more active.

I am excited about having a month off, even though I have a lot to work on in that month.