Posts by Alex Gorbachev
Arjen Lentz is in town doing his Sydney training program 7-Sep to 9-Sep and kindly agreed to drop by and talk about something interesting in the MySQL world – be it a technical topic or the state of the MySQL community eco-system.
What we are looking at during this videocast is how to troubleshoot the connectivity issues that can be caused by VIP’s in Oracle RAC environment and how to diagnose cryptic Oracle error messages using SQL*Net tracing facility on the client side.
I’ll be in Canberra next week presenting at the ACT Oracle User Group Developer and DBA Seminar Day on Thursday, 23 July 2009. If you are in Australian capital city, I’d be very much looking forward to see you there! The topic I will be presenting is 11g New Features Out of the Box. I presented it few times already but originally, it’s based on Christo Kutrovsky’s presentation from Oracle Open World 2007. Unlike many presentations on 11g new features, this session will be focused on the enhancements that often go unnoticed and not marketed widely but boost DBA productivity and are available out of the box without much implementations efforts.
The topic for this meetup is quite exciting – Oracle Exadata and everything about it. David Centellas, Senior Database Consultant from Oracle will do technical presentation on Exadata and, after the break, we will have a open forum discussion where two Oracle’s Enterprise Architects, Tim Rubin and Chris Jones, will answer our questions and share thir real-world experience.
This blog post was inspired by a recent report of a Database Analyst at American Express stealing Credit Card data. It’s amazing how many companies still follow a mainly “perimeter security” approach when it comes to controlling access to sensitive information—their focus is on network security using firewalls, advanced authentication options, and so on. Even with such measures, it’s very common to setup strong barriers to the outside world but very little by way of internal limits; most internal people have some level of access to servers that store and process sensitive data.
OpenSQL Camp will take place Saturday 22nd and Sunday 23rd of August, in St. Augustin, Germany, so it could do for a nice August getaway to Germany. It’s not really the biggest of cities, but then again, that is part of the charm, going to some small city and learning more about databases.
In case you do happen to be curious, feel free to check out the list of proposed sessions, although it is not complete, it does give a overview of what to expect.
Presentation: Migrating 1 Terabyte Database to MySQL — Case Study by Alex Gorbachev. This presentation is based on the real project migrating from RDB on OpenVMS to MySQL on Linux. We will review the migration of the data itself and what infrastructure has been setup — high availability cluster with Heartbeat, DR site replication, organizing backup for 1 TB database. The system has been successfully put in production few months ago.
We will start with an overview of the AQ technology in Oracle database – what it is and what it let you do. Then we will see how it’s used in Oracle E-Business Suite and how to manage it. Our speakers for the evening are your fellow SOM members – Jurijs Velikanovs and Warwick Sands. TBC.
No doubt you want to cast you first vote for my abstract — Developing Plug-ins for Oracle Enterprise Manager by example :) This presentation starts with an introduction of Enterprise Manager’s Extensibility features and walks the audience through the basics of creating a new plug-in. This session will also demonstrate some proven plug-in development steps based on the experience gained from developing MySQL management plug-in. Session includes a demo of the plug-in development scenarios. After this presentation, attendees will be able to design and develop management plug-ins for their own applications. Login to Oracle Mix and vote now. At the time of writing, my session is on the very top — help to keep it there! ;-)
The first videocast was quite popular — it has more than 300 views in couple weeks and considering no Hollywood stars were starring in that video and there were no nude scenes, I think it’s fair to say that this format was very much welcomed by the audience. Today, I’m posting the follow up session on VIP’s (Virtual IP’s) with Oracle RAC. What I demonstrate today is a typical configuration mistake for a RAC databases created with Database Configuration Assistant (DBCA) and what’s the result of such omission.