Oracle’s assault on the global market goes on with full might and as it adds new products in it’s array, SQL Server also strives hard to get the attention of people through various public appearances, and MySQL is also not behind as its growing array of bloggers marches on. This week’s Log Buffer casts a shadow on some selective blogs from these three technology in its latest edition Log Buffer #218.
Pythian is pleased to announce the new Flash Cache Query Tool for Oracle Exadata, developed by our Senior Consultant, and Oracle ACE, Christo Kutrovsky. This tool will be most valuable for Exadata DBAs and Exadata Architects that are trying to understand if the Oracle Exadata Flash Cache is used as envisioned.
Clouds are dispersing and the sun has started shining through. On the IT horizon, the cloud of Amazon has also dispersed and that is the biggest news of the previous week. Well clouds are elastic and they congregate and become solid after dispersion, and so Amazon will be fine too. And our blogosphere is fine too and here is the latest report about them in this week’s edition Log Buffer #217.
Unfortunately, there is no easy way to monitor what’s in the Smart Flash Cache. Oracle only provided a “list flashcachecontent” command in the cellcli tool, it has no summarization options, and only displays object numbers. So I wrote this handy tool which lets you query the cell flash content on all cells, similarly, you can query the buffer cache (db_cache) contents in v$bh.
My presentation was on an Oracle Exadata implementation that we carried out and that I support on an ongoing basis. The presentation went well and everyone seemed to enjoy it, there were plenty of questions afterwards. We even managed to start a room discussion on columnar compression. The last presentation of the day was from Stewart Bryson on Agile DW with Exadata and OBIEE. All in all, an excellent day which was well run by UKOUG.
This Thursday, I’ll be presenting at the Ottawa Valley SAGE meeting. The topic of the talk will be Perl for Sysadmins, and I’ll try to sell to the audience how Perl can make their lives much, much easier.
Log Buffer has become the mainstream carnival of the Oracle blogosphere. Technological advances in Oracle, MySQL, SQL Server and other database systems, more and more conferences, and increasing numbers of bloggers are making log buffering more and more interesting, and this week’s edition Log Buffer #216 is a clear manifestation of that.
I saw an Interesting question on preventing human error posted on the DBA Managers Forum discussions today. I typed my thoughts and as I was finishing, I thought that it makes sense to post it on the blog too, so here we go…
With Dist::Zilla, so far I was manually setting up the new version number in the dist.ini of my distributions. But, as I’m a lazy, lazy man, automating the process was still at the back of my mind. Well, I finally found the time to work on this. The result is Dist::Zilla::Plugin::Author::YANICK::NextSemanticVersion, which currently lives in the Dist::Zilla::PluginBundle::YANICK distribution (and, of course, in its GitHub repository).
In this blog post, I will cover 3 basic types of MySQL backups for stand-alone database systems. I will not be covering fancy GUI applications, or really complicated processes – just the basic concepts – which is what I think System Administrators (ie – non DBA’s) need to know to have a good/valid backup.