Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 273

Servers Monitoring Availability Programming 273

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Audit Log Plugin One way to track these events is through auditing. The drop events are listed below.

Servers 87

Servers Database Open Source Scalability 87

Dynatrace

NOVEMBER 30, 2023

What was once an onslaught of consumer traffic between Black Friday and Cyber Monday has turned into a weeklong event, with most retailers offering deals well ahead of Black Friday. By focusing on the server, digital performance has become much more consistent, even under the weight of massive amounts of consumer load.

Retail 217

Retail Social Media Performance Benchmarking 217

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. Each row represents an event where one or more attribute values have changed. You can download this sample database here.

Servers 145

Servers C++ Code Database 145

SQL Shack

JUNE 25, 2019

It is essential for the DBA to need to ensure the SQL Server database performance. Overview of Default trace in SQL Server Starting from SQL Server 2005, SQL Server captures a few critical events in the default traces. […].

Database 54

Database Servers Tuning Monitoring 54

Percona

MARCH 21, 2023

We want to improve our ability to replicate your data and limit replication to row-based events securely, wherein we do not have control over the source(s). Another feature, REQUIRE ROW FORMAT, was added in MySQL 8.0.19, limiting replication to row-based replication events. In this blog, I’ll discuss the use case for replication.

Storage 91

Storage Open Source Database Engineering 91

SQL Performance

OCTOBER 17, 2019

My colleague, Erin Stellato, recently asked me a question about where and why event loss could happen with Extended Events. Event Size Matters. While most events generated by Extended Events are relatively lightweight and small in binary format, specific events can generate a much larger payload of data that has to be buffered.

Servers 40

Servers Systems Performance Availability 40

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 108

Servers C++ Storage Systems 108

DZone

FEBRUARY 21, 2023

In this hands-on lab from ScyllaDB University, you will learn how to use the ScyllaDB CDC source connector to push the row-level changes events in the tables of a ScyllaDB cluster to a Kafka server. What Is ScyllaDB CDC?

Open Source 306

Open Source Servers 306

Dynatrace

APRIL 21, 2022

Easily track the health and performance of database servers with AI support. To simplify database monitoring and improve cross-team collaboration, Dynatrace released new extensions to leading databases, including Oracle and Microsoft SQL Server. Break down departmental silos and manage databases holistically.

Database 239

Database DevOps Analytics Servers 239

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 76

Servers Database Testing Open Source 76

Dynatrace

MARCH 29, 2024

This year, Google’s event will take place from April 9 to 11 in Las Vegas. Visit Dynatrace booth #1141 during the event to explore how its real-time insights and optimization capabilities ensure seamless scalability and performance.

Google 258

Google Innovation Cloud Analytics 258

CSS Wizardry

JUNE 30, 2023

Load and DOMContentLoaded are internal browser events—your users have no idea what a Load time even is. TTFB is a good measure of your server response times and general back-end health, and issues here may have knock-on effects later down the line (namely with Largest Contentful Paint). I bet half of your colleagues don’t either.

Metrics 326

Metrics Google Monitoring Analytics 326

Dynatrace

MARCH 14, 2023

Dynatrace provides server metrics monitoring in under five minutes, showing servers’ CPU, memory, and network health metrics all the way through to the process level, with no manual configuration necessary. AL2023 is supported by Dynatrace on day one and has been thoroughly tested by our installations team. How does Dynatrace help?

AWS 278

AWS Lambda Serverless Virtualization 278

SQL Shack

APRIL 7, 2020

This article explains the deadlock definition in SQL Server, and it also mentions how to capture deadlock with extended events. Deadlock is a resource contention issue that occurs between two or more than two processes. To handle this problem, we need to clearly understand how it occurs.

Servers 93

Servers Processing Performance 93

Dynatrace

SEPTEMBER 5, 2023

See all detected databases All databases running on your server instances are autodetected, so you can easily check your database performance statistics and settings. Drill down into further details You can review the availability and performance of high availability replicas and AlwaysOn groups in SQL Server.

Database 197

Database Metrics Monitoring Servers 197

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 New functionality See what you can do with the Audit Log Filter plugin: Configure rule-based auditable events filtering. Block events that match specific criteria. A server restart is not required to add or adjust existing filtering rules. Assign it as default.

Open Source 109

Open Source Database Servers Storage 109

Dynatrace

MAY 27, 2022

At Dynatrace Perform 2022 , David Walker, a Lockheed Martin Fellow, and William Swofford, a full-stack engineer at Lockheed Martin, discuss how to create a self-diagnosing and self-healing IT server environment using this AIOps combination for auto-baselining, auto-remediation, monitoring as code, and more. An example of the self-healing web.

Artificial Intelligence 183

Artificial Intelligence Innovation Servers Database 183

SQL Shack

AUGUST 12, 2019

Performance issues act like an open stage, and you need to look at every aspect such as CPU, RAM, server performance, database performance, indexes, blocking, […]. You should ensure that the database performance is optimal all the time without any impact on the databases.

Servers 44

Servers Monitoring Database Performance 44

Dynatrace

AUGUST 18, 2022

The market offers plenty of monitoring solutions that can link a specific monitored event with a specific scripted action. Because Dynatrace isn’t simply searching for “service is up, service is down” type of events, Dynatrace can actually proactively discover problems in the environment before they happen.

Games 290

Games Monitoring Infrastructure DevOps 290

Dynatrace

NOVEMBER 6, 2023

Kubernetes observability Helps to understand and troubleshoot the health and performance of your MicroShift deployments and optimize resources by providing out-of-the-box alerting and anomaly detection, automated root cause analysis, as well as metrics, events, and topology in context.

Retail 255

Retail Analytics Storage Cloud 255

DZone

JANUARY 31, 2024

SIEM stands for Security Information and Event Management. Key Components in SIEM Log Collection: SEIM systems collect and aggregate log data from Various sources across an organization’s network, including servers, endpoints, firewalls, applications, and other devices.

Storage 136

Storage Data Engineering Network Infrastructure 136

SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Improvements in SQL Server 2016. The subject of this post is the additional changes that are enabled for metadata-only from SQL Server 2016 onward. Extended Events and Trace Flag.

Servers 63

Servers Database Testing Efficiency 63

Dynatrace

NOVEMBER 17, 2023

Infrastructure layer (Kubernetes Cluster, GCP, Standalone server, etc.) As a good practice, we recommend that you incorporate a workflow with a JavaScript task that periodically retrieves job details and ingests them as business events to enhance visibility into the pipeline stages and provide insights into current trends.

Innovation 219

Innovation Architecture Code Processing 219

Percona Community

JUNE 26, 2020

In the week of 14-20 September 2020, MariaDB Foundation will host the MariaDB Server Fest Online Conference. We welcome the Percona Community not just to participate, but also to submit papers for the event. Our target audience are the users of MariaDB Server – current and future ones.

Servers 52

Servers Development 52

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server. Installation and support of SSRS can be confusing.

Tuning 67

Tuning Servers Database Best Practices 67

Dynatrace

APRIL 25, 2023

However, serverless applications have unique characteristics that make observability more difficult than in traditional server-based applications. Serverless applications are composed of event-driven functions that run on demand in response to triggers from various sources, such as HTTP requests, messages, or timers.

Serverless 203

Serverless Lambda Azure AWS 203

The Netflix TechBlog

JUNE 12, 2023

In its typical configuration the Crypt agent enforces FileVault upon login and escrows the resulting recovery key to a corresponding Crypt server. Less than ideal solutions IT and security teams have approached this problem from multiple angles in the past.

Open Source 194

Open Source Database Servers Storage 194

Dynatrace

MARCH 6, 2024

IBM i, formerly known as iSeries, is an operating system developed by IBM for its line of IBM i Power Systems servers. Get a health overview of each system Monitor your system’s performance and detect unexpected events such as IPLs, CPU spikes, and exceeded total job limits. What is IBM i?

Monitoring 231

Monitoring Infrastructure Metrics Analytics 231

Brendan Gregg

MARCH 23, 2024

Some servers have accelerators and you'll want their analysis tools installed as well: e.g., on Intel GPU servers, the intel-gpu-tools package; on NVIDIA, nvidia-smi. On cloud instances, adding Mbytes to the base server image can add seconds, or fractions of a second, to instance deployment time. This list is a minimum.

Servers 145

Servers Traffic Network Systems 145

SQL Server According to Bob

APRIL 1, 2019

You need to make sure to order the events by event_sequence when doing analytics on the XEvent data. Values are generated when the event sequence is submitted to the target. The sequence value associated with causality tracking is incremented when the event is recorded. This is incremented using ++ as each event is produced.

Software Engineering 40

Software Engineering Analytics Servers Engineering 40

Dynatrace

OCTOBER 1, 2020

Applications and services are often slowed down by under-performing DNS communications or misconfigured DNS servers, which can result in frustrated customers uninstalling your application. Identify under-performing DNS servers. Slower response times can be a sign of a stressed DNS server or network communication issues.

Traffic 264

Traffic Network Infrastructure Artificial Intelligence 264

Dynatrace

NOVEMBER 19, 2021

Problems API v2 now includes event evidence data as part of the event details. This eliminates certain timeout issues with Windows Server 2019 at boot. Custom events for alerting using the Build tab and advanced query mode now apply the same metric dimension limits that are applied to Code -tab-based configurations.

Metrics 201

Metrics Monitoring Traffic Servers 201

Scalegrid

AUGUST 22, 2019

Patroni also supports event notification with the help of callbacks, which are scripts triggered by certain actions. Supports event notifications via callbacks scripts triggered by certain actions. Standby Server Tests. Reboot the server. patronictl list did not display this server. Master/Primary Server Tests.

Availability 277

Availability Servers Network Open Source 277

Dynatrace

JANUARY 29, 2024

Closing the loop (or not) : In the event of a successful solution, the platform informs the appropriate teams and closes the loop. It also facilitates workflow optimization by automating responses to specific events that trigger predefined remediation actions. The process repeats it implements until an effective solution.

Best Practices 188

Best Practices DevOps Energy Innovation 188

Dynatrace

DECEMBER 9, 2020

Application servers use connection pools to maintain connections with the databases that they communicate with. You can even integrate Dynatrace into your CI/CD pipeline using the Events API. This allows you to create a deployment event that contains all important details each time a new version is released.

Traffic 137

Traffic Performance Database Metrics 137

Dynatrace

APRIL 7, 2023

The difference is the owner of the Lambda function does not have to worry about provisioning and managing servers. Triggering the Lambda function is event-driven and could include changes in state or an update to a file. To learn more about the AWS Lambda features, visit the Lamba features page.

Lambda 212

Lambda AWS Serverless Latency 212