Ken Jacobs has been a fantastic advocate of the Oracle and MySQL user communites. I met Ken on the board of the Independent Oracle Users Group (IOUG). While Ken was the board liasson on the IOUG board, he was always supporting the Oracle user groups and made very important contributions throughout his time on the board and afterwards. After serving time on the board, Ken was still always
Both Oracle and MySQL provide a number of sample schemas so users can build different schema environments and load them with data. So I thought I'd get one of the Oracle sample schemas and go through the exercise of converting it to a MySQL schema. I could have gone in either direction, since this is more of a MySQL blog I made MySQL the destination. Before I start let me introduce some of
My customers tell me Oracle is winning the war with the Oracle Enterprise Manager (OEM) as the tool of choice for managing the Oracle Infrastructure across multiple tiers. With Oracle 11g, Oracle will be adding more RAC integration/functionality into the middle-tier with OEM. Part of the power of OEM is that it manages Oracle Database Servers, Application Servers, Services, Applications and
Just about every week I am asked by customers what storage engine they should be using. As well as, what storage engine should we be paying attention to in the future (i.e. Falcon, Maria, InnoDB, etc.).It's finally time to start looking very seriously at the InnoDB plug-in. It's in the final beta releases while Maria and Falcon are still in alpha stage. The really nice thing about the InnoDB
GUI Interfaces to use with MySQLWhen meeting with MySQL customers I always get asked about GUI interfaces.I am always asked, what GUI to you recommend with MySQL? Two of the most popular are SQLYog and Navicat for MySQL customers.Looking at Oracle SQL DeveloperI think it is time to see how well SQL Developer works with MySQL. Oracle's SQL Developer has matured into a very nice tool and its
Today's Competitive Global Economy Environment for DBAsWith today's competitive environments, the more marketable you are the better. Being flexible and being able to support different solutions is very important. Environments surrounding databases are getting more complex, so increasing your expertise in different areas is important. There are a lot of options with application servers,