Operations | Monitoring | ITSM | DevOps | Cloud

Databases

The latest News and Information on Databases and related technologies.

What is Differential Backup (SQL Server)

Even though SQL (Structured Query Language) has been around since the 1970s, it’s still a relevant and widely-used tool in today’s IT world. Many organizations around the globe still rely on SQL server databases to store their confidential data. In order to protect this valuable information, IT professionals often use differential backup to protect data in SQL servers. As you know, there are multiple types of backup available, so why use differential for SQL servers?

7 ways businesses can improve the quality and speed of database releases

The quality of database releases relies on thorough initial testing in development with teams needing access to fast, reliable data. While database testing is one of the most challenging aspects of development, processes which utilize database clones can overcome these issues. A database clone is a complete and fully functioning copy of a database that is identical to the original in terms of the metadata and the data.

Enhancing Database Capabilities with Multi-Database and User Management

In the past few months, our team has worked hard to enhance our database features. We've made significant updates to our database management capabilities, giving our customers the ability to manage multiple logical databases on the same server (or cluster) and to create custom database users.

Distributed Database Architecture: What Is It?

Databases power all modern applications. They’re behind your Angry Birds mobile game as much as they’re behind the space shuttle. In the beginning, databases were hosted on a single physical machine. Basically, it was a computer running only one program: the database. Then we moved to running databases on virtual machines, where resources are shared among multiple operating systems and applications.

Battling database performance

Earlier this year, we experienced intermittent timeouts in our application while interacting with our database over a period of two weeks. Despite our best efforts, we couldn’t immediately identify a clear cause; there were no code changes that significantly altered our database usage, no sudden changes in traffic, and nothing alarming in our logs, traces, or dashboards. During that two-week period, we deployed 24 different performance and observability-focused changes to address the problem.

Q1 Roadmap Review & Q2 2023 Look Ahead

In our recent virtual meetup the VictoriaMetrics Founders team discussed some of our Q1 2023 highlights, including features highlights, the 2023 roadmap for VictoriaMetrics as well as first introduction to the upcoming VictoriaLogs. In this blog post, we’d like to share a summary of these highlights and a heads up on where to find our team in the coming weeks and months - starting with our participation at KubeCon Europe 2023.

Releasing Graphite Query Language in Open Source VictoriaMetrics

As many of our users and the wider monitoring community will know, Graphite Query Language is a query language for Graphite monitoring tools, which helps analyze data stored in it. Graphite is a well-known and respected pioneer in the monitoring space, which has seen a number of next generation monitoring solutions enter the scene … such as ourselves. It’s been used by a wide range of companies, which started using monitoring tools more than a decade ago.

How to monitor MySQL performance metrics in minutes

MySQL, a leading open source database for the past few decades, underpins potentially millions of applications, from tiny prototypes to internet-scale e-commerce solutions. The beauty of MySQL is not only its powerful relational database capabilities but also that it can be scaled up as the application grows. Why should you care about MySQL performance? Because MySQL is the backbone of many applications, your application performance will be inherently tied to your MySQL database performance.