This year Bob’s job as a DBA has some challenging issues. His company is considering moving to the cloud, which has Bob worried about job security. The developers are interested in adopting Devops, to streamline their applications. Additionally, his boss wants more database security and decided that the system needs 24 x 7 maintenance. As if that’s not enough, there seems to be never ending demands for growth in services, solutions, data and the need for speed.
The IT landscape constantly transforms, a hill of data here, a new road through instances there, and over it all: cloudy weather. To keep up with the changes, DBAs like Bob must continually track the changes and evolve with the landscape. Currently there are some megatrends underway that fundamentally affect how we develop and manage our IT systems.
Most DBAs face challenges similar to Bob’s. They need solutions and tools to keep up with IT’s constant changes. We at dbWatch track these changes and develop tools to help DBAs. Here are some solutions for the challenges we most often see DBAs struggling with, solutions that we actively build to meet the constant changes, solutions to help people like you and Bob.
Bob asked us, “Who came up with this word anyway?” *) Well Bob, it would be nice if Devops were as simple as combining two words.
At Bob’s company, Devops is relatively new. They jumped on the Devops bandwagon recently, a year ago. Unfortunately, they are still working through some of the typical problems employees experience when their silos are whisked away and replaced by new diverse teams.
It’s been a rocky road, the developers still usually insist on “proof” before believing that there’s an error in their system. The DBAs continue to use custom scripts and specialty tools that they have built themselves. “Overall,” Bob says, “It feels like half the team members only speak Ewokses and the other half only know Droidspeak. We need to find a Galactic Basic, which everyone can use to understand each other.”
While we may have a drone Millennium Falcon, we don’t claim that dbWatch can solve galactic communication problems. However, we can help developers and DBAs find a lingua franca.
*) By the way, Devops, (devops or DevOps) is attributed to Patrick Devois, who coined it as a hashtag in 2009. Devois spells it Devops, we’ll leave the fight over the capital letters to the code writers.
We’ve recommend that Bob’s company have a trial of dbWatch. Our other clients have found that the user access controls saved them time and energy. “You’re able to define a role for the DBA by which accesses are allowed,” explained Marek Jablonski, CTO at dbWatch. “For example, a part-time DBA would only have access to a few functions, others might have limited roles or even simply read-only access.” In addition, the DBA can track what is happening within the system. “You can define access by time of day, calendar dates, activities, placement, almost anything,” Marek said.
Bob looks forward to the insight and overview this will give him, allowing him to control the system and free up time to work on things that need his attention.
Cloud strategy – or lack thereof – can make or break a company, having serious financial and business impact. On one side, the cloud offers agile scalability, allowing businesses to grow and meet peak demand quickly. On the other side, if everything is moved to the cloud without critical planning, it could have a significant economic impact. When something looks too good to be true, of course it isn’t true – a move to the cloud does not solve all your problems.
We know that on the cloud control will be even more critical than before. Bob might not need to worry about backups anymore, but he’ll need to monitor performance (and cost!) closer than ever. The cloud is on the meter, and that meter can run fast.
Our solution for cloud-control: being able monitor all database resources in a single view, regardless of where they are located. One dbWatch view shows all instances: on-premise, Azure and any other cloud. This gives all DBAs the insight and control needed to manage performance and make qualified decisions between what to run locally and what should migrate to the cloud. Having some databases thoughtfully selected for the cloud will free Bob up to have more time for other projects. However, all clouds are not created equal. There are somethings he needs to watch out for, especially when it comes to Azure.
Most cloud databases function like normal databases. Azure databases are a bit different. It manages the database for you. “It’s not so clear what’s happening when you’ve moved things off-premise,” says Marek. “You just have to trust them.”
24 x 7 operations
While Bob is no stranger to 24/7 operations, it is new to have all aspects of the company working around the clock, with colleagues and customers working at all timezones. His current biggest challenges are: intensified monitoring needs and good automated distribution of alerts and warnings, depending on time of day and week. Last year he missed out on detecting an incident and just managed to catch it before a major disruption; naturally he wants to avoid this happening again.
Here dbWatch offers Bob a practical fast solution. He understands from problems with his semi-automated monitoring that he needs a fully automated system. We can offer him one step further in solutions, distributing the information gathered in the system in a fast and efficient way to the correct person at the correct time via the best channel. Also, when Bob’s in office when an alert comes in, he can simply change to dbWatch management mode to fix the problem
Because Bob is the senior DBA in his company, he usually ends up on-call. He can configure dbWatch monitoring to catch the serious issues when he’s out of office and send the alert to the frontline monitoring, telling them to call him if a specific alert comes in.
Growth and scalability
Growth in complexity and numbers does not automatically mean more DBAs. DBAs are expected to evolve and become more and more efficient all the time. Full-time DBAs today are expected to manage much more than a handful of servers/instances.
Since Bob started working for his current employer five years ago, there has been between 10% to 25% growth each year. Earlier, Bob’s job was like managing a small taxi company, now he’s expected to coordinate a city-wide public transportation network. It goes without saying, Bob has to run the public transportation network using the same staff he had in the small taxi company.
This large-scale operation requires better tools than what’s currently in his tool box. dbWatch’s tools give overview and insight to name, group, sort, organize and report in addition to managing instances. “What works for a handful becomes too labor intensive and repetitive when faced with several hundred instances. It’s like going from managing a single race car to being responsible for a city-wide public transport network,” Andreas, CMO at dbWatch, says, “We often see DBAs handling hundreds of instances each, and sometimes multiple platforms as well.”
Scalability is becoming a real issue in many enterprises and is and issue we pay a lot of attention to. We discuss this further in “Why scalable database monitoring is a must for growing businesses” and “Understanding database scalability – a 101 guide“.
By the way, we could reassure Bob that his job isn’t in danger. First, Bob has something that will ensure his continued employability: the ability to embrace change. DBAs who can change with IT, seeing it as a challenge rather than a barrier, are resilient and likely to remain employed. In addition, Bob works on complex DBA jobs, so his job is unlikely to be threatened by the latest level of developments.
So, is this all? Of course not! If you have questions about dbWatch solutions or have suggestions for other areas where we could make a difference for DBAs please let us know. We would love to hear your opinion. Drop us an email at firstname.lastname@example.org
Who is this Bob person?
Bob is a mix of several of the clients we work with, including some of the DBAs on our team. While he is a fictional character, we and our clients have all experienced similar problems.
This blog post was contributed by Rebecca Harrison.
Rebecca Harrisson writes and helps people communicate clearly by day and is a folk harpist and storyteller by night. She writes for IT companies and harp magazines. You’ll find her on LinkedIn.