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 中文
Showing entries 1 to 30 of 221 Next 30 Older Entries

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

Amazon RDS – prime time? Time will tell
+0 Vote Up -0Vote Down
A client of ours is just getting started with Amazon Relational Database Service (RDS) and I wonder as time marches on how popular this cloud solution is going to play out for them and Amazon as a valid/useable service offering. Many times in the past we have encountered off-the-shelf solutions from vendor A based on [...]
Tips for Leveraging Oracle OpenWorld 2012 From Pythian Marketing
+0 Vote Up -0Vote Down
With Oracle OpenWorld just around the corner & MySQL Connect already underway I can’t believe yet another year has passed.  This is my third OOW and I must have a following as folks are already reaching out to me on twitter @pythiansimmons (log buffer lady seems to be a handle I can’t seem to shake). [...]
Some Nostalgic Reminiscences in Honor of Pythian’s 15th
+0 Vote Up -0Vote Down

In honor of our fifteenth anniversary, I have assembled a few nostalgic items from our earliest years in business.

On September 7, 1997 I went to the Ottawa U public library to come up with some names for the company Steve Pickard and I wanted to found the next morning. The goal was to choose the company name, register the dot-com, and then go incorporate it. I really felt that I lucked out when I discovered the word Pythian, which means “about the Pythia“. The Pythia was the Oracle of Delphi in ancient Greece. (Remember that we launched as an Oracle ecosystem services company, and our other practices came afterwards with MySQL launching in 2002 and SQL Server launching in 2005).

I was also delighted that the Pythian Games were also

  [Read more...]
Oracle OpenWorld 2012 – Bloggers Meetup
+0 Vote Up -0Vote Down

Oracle OpenWorld 2012 is just over a month away, and yes, we are organizing the Annual Oracle Bloggers Meetup — one of your top favorite events of OpenWorld.

What: Oracle Bloggers Meetup 2012

When: Wed, 3-Oct-2012, 5:30pm

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

  [Read more...]
First MySQL/NoSQL/Cloud Latin America conference
+0 Vote Up -0Vote Down
This last week was the first time we have this kind event here in Argentina, of course this is a great initiative and a good starting point for next events. My impressions: being the first time that these kind of conferences were done in Argentina I have to say it was great, small but great. [...]
PgEast 2011 Day The Second
+1 Vote Up -0Vote Down

Well day two here at PgEast has drawn to a close and it was another
very informative day.

Today I concentrated on the more common tasks of a Pg DBA so I attended three
talks (four if you count mine) that where rather heavy on the technical side of being a Pg DBA

Keven Kempter drew me back again with his excellent talk on Backup and recovery methods
this time giving some very good advice on how to use and abuse of pg_Dump_all and
PG_restore. He also touched on three different recipes PITR on ProstgreSQL and gave some handy
advice on when and why to use it.

I also caught another Mongo talk this time by Steve Francia it was on the application of Mongo
in a real world web retail store. He presented a very convincing argument for the NoSQL side of things in
the retail realm namely that RDBMS works great when you have but a few similar






  [Read more...]
Pythian at UKOUG Technology and E-Business Suite Conference 2010
+1 Vote Up -0Vote Down

Hello Birmingham!

It’s past Sunday midnight and I’m stuck in my room in the last couple hours finishing my slides for my masterclass tomorrow. Turns out that I’m presenting the very first session of the conference at 9am. I wish there is a keynote instead so that I could grab one more hour of sleep (it’s going to be deep into the night back home in Canada). Strange that the keynote was moved to Wednesday — I hope UKOUG has really good reason for that!

My two hours masterclass will start at the same time as Tom Kyte’s a-la keynote session — what a competition. On the other hand, there is no other sessions in server technology so I expect that folks without interest of database development will automatically end up in my session. I’m in Hall 5 – quite large room. Is it the second

  [Read more...]
A Pythian Fork
+4 Vote Up -2Vote Down

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

  [Read more...]
Three Editions of MySQL are Available
+1 Vote Up -2Vote Down

Yes, you read the title correctly — there are three editions of MySQL available, according to http://www.mysql.com/products/enterprise/server.html (http://www.mysql.com/products/enterprise/server.html). Well, that page names two, and then of course there is the community edition….

From the manual page:

MySQL Enterprise Server is available in the following editions:

* MySQL Enterprise Server – Pro is the world’s most popular open source database that enables you to rapidly deliver high performance and scalable Online Transaction Processing (OLTP) applications.
* MySQL Enterprise Server – Advanced is the most comprehensive edition of MySQL. It provides all the benefits of MySQL Enterprise Server Pro and adds horizontal table and index partitioning for improving the performance and management of VLDBs

  [Read more...]
ODTUG Kaleidoscope 2010: Best Practices
+1 Vote Up -0Vote Down

Updated: 29-Jun-2010, 30-Jun-2010.

For me, ODTUG Kaleidoscope 2010 started on Friday with the ACE Directors briefing. Best practices topic was touched there slightly and I twitted about it. I decided that the feedback deserves a blog post so I’m simply quoting the conversation here. If you have anything to add, you know where to find the comment box.

alexgorbachev:
best practices should be forbidden or rather renamed to blue-prints #
  [Read more...]
ODTUG Kaleidoscope 2010 — Ready… Set… Go-o-o!
+1 Vote Up -0Vote Down

It is time… Time for one more very special conference for me. Why special?

  • I have never been to ODTUG Kaleidoscope before. I always like new conferences — new experience.
  • Unlike Sheeri, I do not speak! This is one of those rare conferences where I come to slack off, meet old friends and make new ones, go to lots of sessions and actually learn stuff.
  • Coming from the DBA background, it’s not often that I come to development oriented conferences and I think I should do more of that.
  • It’s in Washington, DC. I lived there for some time and have number of good friends there. I’m really excited to see them again!
  • So what am I going to do there? I just arrived and right in time for the Oracle ACE Directors’

      [Read more...]
    OpenSQLCamp Boston Pages are online
    +5 Vote Up -1Vote Down

    OpenSQLCamp is less than 4 months away, and I have finally gotten around to updating the site. Special thanks go to Bradley Kuzsmaul and the folks at Tokutek for getting the ball rolling and making the reservation at MIT. Using MIT means that we will have *free* reliable wireless guest access and projects.

    OpenSQL Camp is a free unconference for people interested in open source databases (MySQL, SQLite, Postgres, Drizzle), including non-relational databases, database alternatives like NoSQL stores, and database tools such as Gearman. We are not focusing on any one project, and hope to see representatives from a variety of open source database projects attend. As usual I am one of the main organizers of Open SQL Camp (in previous years, Baron Schwartz, Selena Deckelmann and Eric Day have been main organizers too; this year Bradley

      [Read more...]
    Next Week’s MySQL Sessions at ODTUG Kaleidoscope
    +3 Vote Up -1Vote Down

    By now you know that there is a MySQL Track during next week’s ODTUG Kaleidoscope in Washington, DC. Ronald Bradford and I organized the schedule at the last minute (Ronald did a lot of the work!). It was difficult to fill a schedule with 19 sessions that are either 1 hour or 1.5 hours long, and to do it I ended up with three presentations.

    At each presentation I will be giving away a copy of The MySQL Administrator’s Bible, so be sure to show up! All MySQL track sessions are in Maryland C, and all times are Eastern.

    On Monday, June 28th from 4 pm – 5:30 pm I will be presenting

      [Read more...]
    Keeping Up
    +2 Vote Up -0Vote Down

    I found I never published this post as it was sitting in my drafts few months now — it was written in 13th February, 2010. I’m publishing it without any changes.

    I learn therefore I am!

    I’ve just wrote few bits about learning a new technology and after skimming through my Google Reader, I noticed a great post by Chen Shapira — Deliberate Practice. That’s reminded me about another aspect of learning that I didn’t mention — learning is a continuous process.

    There are two aspects…

    • No matter how good I am and how much I know, my knowledge and expertize become outdated relatively quickly these days unless I keep up with the
      [Read more...]
    The MySQL Track at Kaleidoscope is set!
    +5 Vote Up -1Vote Down

    The MySQL track at Kaleidoscope in Washington, DC during June 28-July 1st is set! Here is the schedule, Lincoln VI is the MySQL track room.

    Ronald has done a super job and spent a ton of hours in the past several weeks coordinating this effort. Work has kept me much busier than normal, but I have lent some time to the coordination as well. It is a credit mostly to Ronald that we have been able to plan an entire 19-session conference track, complete with confirming speakers, in less than a month. (You may notice the schedule does not have all 19 sessions full, we are just waiting for some more speakers to confirm details.)

    Whether or

      [Read more...]
    A Useful Tool to Centrally Manage Many MySQL Instances
    +7 Vote Up -2Vote Down

    I have been talking with a group of folks who have been making a product that has lots of free functionality, including the ability to centrally manage many MySQL instances. The administration functions include starting and stopping MySQL, seeing status and system variables, seeing and managing the MySQL config file (/etc/my.cnf), seeing and managing accounts, a small dashboard of overall health graphs, and more.

    With this free tool you can look at and manage local and remote databases. It supports ssh tunneling, including ssh using password-protected ssh keys. It’s pretty neat, and I have been working with the product manager to add features. I think this took will become the de facto standard for centralized GUI administration of MySQL.

    The tool is
    MySQL workbench….Surprise! One of the best new features for the

      [Read more...]
    An SSH tool to make your life easier
    +6 Vote Up -2Vote Down

    A MySQL user group member saw that I use Poderosa as my ssh-on-Windows tool, and asked why I did not use PuTTY. My response was that I like having tabbed windows and hate having to keep opening another PuTTY program every time I want to open another connection. With Poderosa I can open a new connection with Alt-N, and I can even connect directly to Cygwin with an icon.

    But Poderosa is not the tool I wanted to mention….Another user group member mentioned PuTTY Connection Manager. It wraps around PuTTY and gets the existing saved connections, makes a nicely tabbed browsing window where you can open sessions by double-clicking the connections, which are now listed on the right-hand side.

    See screenshot below:

      [Read more...]
    The Doom of XtraDB and Percona Server?
    +7 Vote Up -5Vote Down

    In The Doom of Multiple Storage Engines, Peter talks about how the storage engine concept of MySQL is usually spoken of in positive terms, but there are many negatives.

    I have a hard time trying to figure out the deeper meaning behind Peter’s post, given that Percona writes a storage engine for MySQL, XtraDB. Does this mean that Percona will stop developing XtraDB? Does this mean that the Percona Server will diverge farther and farther away from MySQL so that they’re not compatible any more and migrating from MySQL to Percona Server is very difficult?

    Or maybe it’s just that Peter is saying one thing and doing the opposite; which just seems wrong because that would be blatant hypocrisy on Percona’s part.

    (This idea was a comment on

      [Read more...]
    Liveblogging: Senior Skills: Sysadmin Patterns
    +1 Vote Up -4Vote Down

    The Beacon Pattern:
    - This is a “Get out of the business” pattern
    - Identify an oft-occurring and annoying task
    - Automate and document it to the point of being able to hand it off to someone far less technical

    Example:
    - System admins were being put in charge of scheduling rooms in the building
    - They wrote a PHP web application to help them automate the task
    - They refined the app, documented how to use it, and handed it off to a secretary
    - They have to maintain the app, but it’s far less work.

    The Community Pattern:

    - Prior to launch of a new service, create user documentation for it.
    - Point a few early adopters at the documentation and see if they can use the service with minimal support
    - Use feedback to improve documentation, and the service
    - Upon launch, create a mailing list, forum,











      [Read more...]
    Liveblogging: Seeking Senior and Beyond
    +2 Vote Up -1Vote Down

    I am attending the Professional IT Community Conference – it is put on by the League of Professional System Administrators (LOPSA), and is a 2-day community conference. There are technical and “soft” topics — the audience is system administrators. While technical topics such as Essential IPv6 for Linux Administrators are not essential for my job, many of the “soft” topics are directly applicable and relevant to DBAs too. (I am speaking on How to Stop Hating MySQL tomorrow.)

    So I am in Seeking Senior and Beyond: The Tech Skills That Get You Promoted. The first part talks about the

      [Read more...]
    MySQL Track at Kaleidoscope
    +11 Vote Up -2Vote Down

    On Monday, Ronald Bradford posted that the independent Oracle Developer Tools User Group had opened up their Kaleidoscope Conference, well-known throughout the Oracle community for in-depth technical sessions for developers, to the MySQL community. Giuseppe Maxia posted his thoughts on Tuesday.

    We have confirmed that there will be an entire MySQL track at Kaleidoscope! Because Kaleidoscope is less than 8 weeks away, we could not go through a standard call for papers. Ronald and I have been working to come up with appropriate topics and speakers for an audience that uses MySQL but is probably more familiar with Oracle. We contacted

      [Read more...]
    Videos of Pythian Sessions from the 2010 O’Reilly MySQL Conference and Expo
    +2 Vote Up -0Vote Down

    Here’s a sneak peek at a video matrix — this is all the videos that include Pythian Group employees at the MySQL conference. I hope to have all the rest of the videos processed and uploaded within 24 hours, with a matrix similar to the one below (but of course with many more sessions).

    TitlePresenterSlidesVideo link
    (hr:min:sec)Details (Conf. site link)

    Main Stage
    Keynote: Under New Management: Next Steps for the CommunitySheeri K. Cabral (Pythian)N/A18:16
    session 14808Ignite talk: MySQLtuner 2.0Sheeri K. Cabral (Pythian)PDF5:31N/A
    Interview
    Thoughts on Drizzle and

      [Read more...]
    MySQL Conference Notes
    +1 Vote Up -3Vote Down

    This is not my notes about the MySQL conference that just occurred. These are my thoughts about MySQL conferences in general. Baron wrote in The History of OpenSQL Camp:

    After O’Reilly/MySQL co-hosted MySQL Conference and Expo (a large commercial event) that year, there was a bit of dissatisfaction amongst a few people about the increasingly commercial and marketing-oriented nature of that conference. Some people refused to call the conference by its new name (Conference and Expo) and wanted to put pressure on MySQL to keep it a MySQL User’s Conference.

    During this year’s conference, I heard a lot of concern about whether or not O’Reilly would have a MySQL conference, and whether or not Oracle would decide to sponsor. I heard all of the following (in no particular

      [Read more...]
    Liveblogging: Edward Screven State of the Dolphin Keynote
    +4 Vote Up -0Vote Down

    Chief Corporate Architect at Oracle, been at Oracle since 1986, technology and architecture decisions, responsible for all open source at Oracle. Company-wide initiatives on standards management and security — http://en.oreilly.com/mysql2010/public/schedule/detail/12440.

    Where MySQL fits within Oracle’s structure.

    Oracle’s Strategy: Complete. Open. Integrated. (compare with MySQL’s strategy: Fast, Reliable, Easy to Use).

    Most of the $$ spent by companies is not on software, but on integration. So Oracle makes software based on open standards that integrates well.

    Most of the components talk to each other through open standards, so that customers can use other products, and standardize on the technology, which makes it

      [Read more...]
    My thoughts on Ada Lovelace Day, A candid conversation with Sheeri Cabral
    +3 Vote Up -2Vote Down

    I had an interesting conversation with Sheeri yesterday. She had pointed out that today was Ada Lovelace Day, a day devoted to highlight and thank the many women in the Information Technology industry for their contributions. She suggested that if I wanted to blog about it she would find that appropriate, given what we’ve achieved here at Pythian.

    First, I consider that a huge compliment. And then, a distant second, I told Sheeri – no I don’t think I’ll blog about it, that’s not my thing.

    This is the IM conversation that came out of that email exchange when Sheeri and I connected about an hour later. You may or may not find it interesting, but ultimately I thought it was interesting enough to share.

    tl;dr: Happy Ada Lovelace Day.

    expanded version:

    Paul


      [Read more...]
    International Women’s Day
    +2 Vote Up -1Vote Down

    If you do not know what International Women’s Day is: http://www.internationalwomensday.com/

    Start planning your blog posts for Ada Lovelace day now (March 24th, http://findingada.com/ Ada Lovelace Day is an international day of blogging (videologging, podcasting, comic drawing etc.!) to draw attention to the achievements of women in technology and science.)

    To that end, I would like to point out all the women currently in science and tech fields that I admire and think are doing great things. I think it would be great if everyone, male or female, made a list like this:

    The women that have taught me science/tech along the way:

    High School:
    Mary Lou Ciavarra (Physics)
    Maria Petretti (Pre-Algebra, and Academic Decathlon)
    Reneé Fishman




      [Read more...]
    Announcing: Monday night community dinner at Pedro’s during the O’Reilly MySQL Conference & Expo
    +4 Vote Up -0Vote Down

    Just the facts:
    What: MySQL user community dinner
    Who: me, you, and many MySQL community members
    When: Monday, April 12th – Meet at 6:30 at the Hyatt Santa Clara or at 7 pm at the restaurant
    Where: Pedro’s Restaurant and Cantina – 3935 Freedom Circle, Santa Clara, CA 95054
    How: Comment on this blog post to add your name to the list of probable attendees

    I was sad that last year there was no community dinner, and I missed the one the year before when Jonathan Schwartz and Rich Green made an appearance. This year I am determined not to miss it, and so I am calling for a community (pay-your-own-way) dinner on Monday, April 12th, at Pedro’s – a Mexican






      [Read more...]
    Free 10-day trial of Safari Books Online
    +2 Vote Up -0Vote Down

    That’s right — get your free 10-day trial! All the information I know is here:

    http://bit.ly/37E9ld

    But the basics are: No access to Rough Cuts or Downloads, for new subscribers only. It’s one of those “sign up and if you do not cancel after 10 days, we bill you” — and at $42.99 a month, that’s not a mistake you want to make. Must sign up by Nov. 24th.

    To sign up now: https://ssl.safaribooksonline.com/tryitfree

    I was asked to send this information along, so I am…Now’s your chance to skim High Performance MySQL, among other high quality books!

    Gerry Narvaja: the Winds Of Change
    +2 Vote Up -0Vote Down

    For very personal reasons that don’t belong in this article, I decided a few weeks ago that it’s time for me to move on. The year and a half that I worked for Pythian have been a wonderful experience, and this is article is my tribute to this great company.

    The MySQL Team

    Being able to work side by side with two MySQL experts like Sheeri Cabral and Augusto Bott has been a great experience. I have learned a lot, not only about MySQL, but also about what a great DBA should be like. Both of them are recognized MySQL Community members and regular speakers at the MySQL Users Conference and other events. Sheeri has been named MySQL Community Member of the Year twice in a row. Both are a guarantee of excellent service.

    My Predictions  [Read more...]

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

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

    Since all that OOW news forced Gerry to give them short shrift last week, let’s begin with blogs on . . . 

    SQL Server

    Jeremiah Peschka gets our week going with his refresher introduction to SQL Server system databases.

    Likewise, Pinal Dave reviews the difference between candidate keys and primary key.

      [Read more...]
    Showing entries 1 to 30 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.