Orphaned Disks in OVM and What to Do with Them

Some time ago I was doing a maintenance on an OVM and noticed that it had significant number of disks without mapping to any virtual machine (I need to mention that the OVM cluster was a home for more than…

Read More >

Log Buffer #511: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server, MySQL.

Read More >

Datascape Podcast Episode 9 – What’s Up with Oracle These Days?

With the hype around cloud and cloud first initiatives, automation, DevOps, and very specialized cloud-based databases, I wondered what was going on with one of the datascape’s old faithful technologies, Oracle Database.

Read More >

Insights on the Sysbench 1.0 Release

If you’ve ever had to evaluate server performance, you likely know of sysbench, a performance benchmark project started by Peter Zaitsev with continued development by Alexey Kopitov. The last official release was the version 0.4, which is found in almost…

Read More >

Multi Tb migration Using mydumper

In this post I will explain how to transfer a multi terabyte size database between two MySQL instances using mydumper, which is a logical backup and restore tool that works in parallel. I will also cover the case where you need…

Read More >

Ansible and AWS Automation

Overview The goal was to create and manage a MySQL RDS instance and learn how to control AWS resources by using Ansible. With Ansible interacting with AWS it’s best to determine how hard or easy it is to build and…

Read More >

Understanding MySQL Isolation Levels: Repeatable-read

Isolation levels are a rare subject in MySQL literature. The documentation provides a terse description and focuses mainly on locking issues, but does not discuss the semantics of each isolation level. This is not only a problem that affects MySQL…

Read More >

Change of Database Passwords Through OEM

Once in a while passwords for system database accounts should be changed due to different requirements; it is a boring routine task, but it still needs to be completed. However, with the help of OEM it can be automated and…

Read More >

Datascape Podcast Episode 8 – SQL Server 2017 & Microsoft Data Amp

In this episode, Warner joins us again, this time to discuss the Microsoft Data Amp 2017 event and dive into detail about all of the new and exciting announcements that were made. We dive into data migration services, the managed instance concept, today’s expectations of DBA’s, and much more!

Read More >

Log Buffer #510: A Carnival of the Vanities for DBAs

This Log Buffer Edition covers Oracle, SQL Server and MySQL.

Read More >
Page 1 of 29212345...10...Last Page »