Xaprb

Stay curious!

Making MySQL comfortable for Oracle DBAs

with 6 comments

I’m at Hotsos Symposium this week, and it suddenly occurred to me that a lot of Oracle DBAs who are beginning to manage MySQL servers might have some things to share with others in a similar role shift:

  • Familiar, comfortable tools and techniques, or capabilities of the Oracle Database, that you miss in MySQL
  • Equivalents or replacements for the aforementioned

Do you have anything to share with your fellow DBAs going through ODT (Oracle Delerium Tremens)? Do you have any wishes that you haven’t satisfied yet? Post in the comments and let’s see if we can create a sort of forum for sharing and/or a wishlist in case someone gets an urge to fill in a missing piece!

Written by Xaprb

March 7th, 2012 at 11:50 am

Posted in Oracle,SQL,Tools

«
»

6 Responses to 'Making MySQL comfortable for Oracle DBAs'

Subscribe to comments with RSS

  1. MySQL can now backup data to the big STB backup systems and works with the Database Firewall.

    Dave Stokes

    7 Mar 12 at 2:43 pm

  2. Thanks Dave. I was also thinking about things like AWR, included utility programs, etc.

    Xaprb

    7 Mar 12 at 3:22 pm

  3. I am an Oracle DBA who had to look after MySQL, with no training, and found I really liked it. I created a presentation (which I have given at UKOUG, OUG Harmony, Kscope and NZOUG), “MySQL: the least an Oracle DBA needs to know”, in which I show my fellow Oracle DBAs, through live demos, how good it is.

    I have created the following introductory guide to MySQL for Oracle DBAs:
    http://patrickhurley.wordpress.com/mysql-for-oracle-dba/

    Patrick Hurley

    8 Mar 12 at 9:38 am

  4. Patrick, are there features like AWR that you wish were available in MySQL? Put another way, if I create a pt-awr tool for Percona Toolkit, do you care?

    Xaprb

    8 Mar 12 at 1:32 pm

  5. AWR and ASH are incredibly useful; just today, by digging in the dba_hist_… views to see what sessions were doing 3 days ago, I managed to determine the cause of a concurrency problem.
    So if I were having to undertake MySQL troubleshooting I am sure I would find them very useful.
    However we only use MySQL for small drupal and wordpress sites, for which I have never needed to perform any tuning or troubleshooting.
    The most complicated thing I have done in MySQL is set up replication, and I did find that a lot easier than setting up Oracle Data Guard.

    Patrick Hurley

    8 Mar 12 at 2:06 pm

  6. I can say in truth, having spent 20+ years working with Oracle db, and suddenly having to install, configure etc mysql, that I miss simple things like AWR, the ability to see what users are doing with one query, but on the other hand, replication was easeir to set up than RAC etc, export (mysqldump) takes me back to the good old days of Ingres, ADABAS etc

    I am still working out how to tune, and understanding what the different engines do, but hey I’ve been doing this for 2 months!

    Angus

    3 Jul 12 at 12:17 am

Leave a Reply