Posts Categorized: Technical Blog
Our flagship tool, Support Track, is steadily migrating over to use DBIx::Class to read and manipulate our databases. This is a very useful tool, for many reasons that can be better explained by others. One of these reasons is that, thanks to the magic of SQLite, it lets us write unit test scripts, and other quick prototyping codes, without needing to set up a heavy database server to run against. However, Support Track is powered by Oracle, not SQLite, and while DBIx::Class abstracts most of the differences out of our code, it can’t completely eliminate them. How do we overcome the syntactic differences?
I spent last week at Collaborate 2012 in Las Vegas, and it was a really great experience in many ways. I am a MySQL DBA and have been working with MySQL for most of my career, so Collaborate didn’t seem like an obvious choice. It turned out that I had so much to learn from Oracle professionals and the Oracle community that could be applied in the MySQL world. For me, an indication of a good conference is when you come back inspired and full of ideas.
Pythian’s Oracle Apps DBA team recently upgraded a client’s E-Business Suite system to version 12.1.3, bringing them into compliance with Oracle’s baseline support requirements for Release 12.1 nearly one year ahead of deadline. We’d like to tell you a bit about this project — not to toot our own horn (though that’s nice too, we are kinda proud), but because it provides an ideal illustration of the power of the Pythian service delivery model, particularly as it applies to large enterprise-class projects.
This is a quick blog post from Collaborate 2012 in Vegas. I’m only doing one session this year, but it’s a very long session — I’ve just done a deep dive on deploying Oracle Database 11gR2 for High Availability. It’s a broad topic, and my plan was to focus a lot on basic concepts and how they work.
COLLABORATE is all about quality and content, presenters elaborating based on their specific areas(s) or expertise. The show may be elaborate, but “show” is secondary to education. A handful of tier 1 shows throughout the calendar year do just that. The primary focus is on the user community, the people who live the software from day-to-day.
I made the epic journey with my Pythian (and former Nokia) colleague Andrew Moore, and once at the conference we met up with more members of our Pythian MySQL team: Marco Tusa, Raj Thukral, and Singer Wang. We all ran into former colleagues at the conference, caught up with old friends, and made some new friends. The conference this year was buzzing with enthusiasm, learning, and creativity. I’m delighted to say it delivered everything I anticipated and more.
The Keynote talks included some words from Peter and Baron of Percona, Martin Mickos now of Eucalyptus Systems, and Brian Aker of HP. I was impressed by the new HP cloud product powered by OpenStack and now with an Aker-driven DaaS backed by a tuned Percona Server. It was interesting to watch the demo video on creating new instances as well as the snapshots of existing instances to create cloned instances. I would like to review this for myself and now will since the HP guys were offering to send beta access to the attendees.
Here are my notes on the third session I attended today, entitled “MySQL Cluster Performance Tuning”.
Here are my notes from the first session I attended today,entitled “Using and Benchmarking Galera in Different Architectures”.
Here are my thoughts on the “Boost Your Replication Throughput with Parallel Apply, Prefetch, and Batching” presentation I attended today.