Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 90

Open Source Database Hardware Strategy 90

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. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 81

Servers Database Open Source Scalability 81

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. People assume that because the code is public, attackers can have at it and easily wreak havoc.

Open Source 110

Open Source Database Software Software 110

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. If the exit code indicates a failure, the return code from MySQL will tell us the failure reason.

Servers 273

Servers Monitoring Availability Programming 273

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here.

Servers 142

Servers Testing C++ Code 142

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause allows you to shorten your code by avoiding the repetition of identical parts of your window specifications.

Servers 145

Servers C++ Code Database 145

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 74

Database Open Source Servers Code 74

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. You might already use ScaleGrid hosting for Redis hosting to power your performance-sensitive applications.

Metrics 130

Metrics Monitoring Latency Cache 130

DZone

JANUARY 29, 2021

Application Programming Interface acts as the center level between the database and presentation layer in the software development procedure. It is mainly the channel that links the client to the server, drives business procedures, and gives the services which give worth to users.

Testing 214

Testing Programming Performance Database 214

Percona

APRIL 14, 2023

Below, we outline some proactive steps for achieving cost efficiency and maintaining performant database environments amid a turbulent economy: 1. Here are a few ways you can scale down and save: Audit your systems: Auditing your system for unused servers and eliminating those servers can reduce your cloud spend.

Database 81

Database Serverless Tuning Cloud 81

Dynatrace

DECEMBER 9, 2020

Most applications communicate with databases to, for example, pull a catalog entry or submit a new record when an order is placed. To achieve this, there must be a healthy connection between the application and the database. Application servers use connection pools to maintain connections with the databases that they communicate with.

Traffic 136

Traffic Performance Database Metrics 136

VoltDB

MARCH 21, 2024

In the world of databases, data management, and data platforms, this entropy usually takes the form of a simple database or data platform that might be ideal for early use cases evolving (or rather, de volving) into an expensive and unmanageable nightmare due to operational strain from use-case gluttony. How hard can it be?

Cache 52

Cache Database Storage Availability 52

Dynatrace

JUNE 12, 2020

Besides being the most popular web server back end, PHP is also commonly used for developing microservices, shell applications, high-scale back ends, and for scheduling automated tasks. Dynatrace has long provided automatic code-level performance monitoring for PHP applications with OneAgent. Support for request attributes.

Code 132

Code Monitoring Database Metrics 132

Smashing Magazine

SEPTEMBER 28, 2022

Five Data-Loading Patterns To Improve Frontend Performance. Five Data-Loading Patterns To Improve Frontend Performance. When it comes to performance, you shouldn’t be stingy. Every unnecessary bit of JavaScript code you bundle and serve will be more code the client has to load and process. Agustinus Theodorus.

Performance 127

Performance Cache Servers Social Media 127

Dynatrace

JANUARY 23, 2024

In May 2023 the critical vulnerability CVE-2020-36641 in the Java library aXMLRPC was published in the National Vulnerability Database (NVD). XML external entity (XXE) exploit The aXMLRPC library allows its users to connect to a server and perform RPC calls using the XML-RPC protocol over HTTP.

Java 196

Java Servers Code Software 196

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 83

Scalability Database Open Source Traffic 83

SQL Shack

SEPTEMBER 6, 2021

In this article, we will explore in detail the factors that cause SQL Server stored procedures to be recompiled. Introduction SQL Server Stored procedures are the make-ready T-SQL codes that can be executed again and again by the database users to perform data manipulation commands and data definition commands.

Servers 90

Servers Database Code Performance 90

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. When undertaking any sort of performance optimisation work, one of the very first things we learn is that before you can improve performance you must first measure it. Browsers now even have performance audits built right in.

Servers 88

Servers Performance Metrics Database 88

Scalegrid

MARCH 28, 2024

In this comparison of Redis vs Memcached, we strip away the complexity, focusing on each in-memory data store’s performance, scalability, and unique features. Redis and Memcached both provide high performance with sub-millisecond response times. Choosing between Redis and Memcached hinges on specific application requirements.

Cache 130

Cache Storage Scalability Architecture 130

Dynatrace

JANUARY 20, 2020

If you work with SAP ABAP, you may have noticed that finding information about SAP application and transaction performance involves scaling a high barrier to entry. While powerful, SAP performance management tools like the SAP Solution Manager are also complex. Assess problem impact and focus on the pressing issues first.

Monitoring 151

Monitoring Performance Infrastructure Network 151

Scalegrid

DECEMBER 14, 2023

How the MongoDB timeout is set up can significantly affect your application’s performance, no matter if you are an experienced MongoDB user or just starting with NoSQL databases. Typical applications are interacting with different database servers based on the business logic.

Java 130

Java Network Servers Database 130

Dynatrace

NOVEMBER 3, 2023

already address SNMP, WMI, SQL databases, and Prometheus technologies, serving the monitoring needs of hundreds of Dynatrace customers. focused on technology coverage, building on the flexibility of JMX for Java and Python-based coded extensions for everything else. This includes Python-coded extensions, which are also sandboxed.

Technology 236

Technology Technology Scalability Availability 236

Dynatrace

JULY 1, 2020

Over the years, I ’ve heard many different kinds of questions related to SAPGUI performance. The questions always seem to be the same when it comes to performance and user experience : . Wh ich users and locations are having performance problem s ? . What happens to user performance during close cycles? .

Database 239

Database Servers Monitoring Code 239

Percona

MARCH 13, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona Server for MySQL 5.7.41-44 44 On March 2, 2023, Percona Server for MySQL 5.7.41-44 Percona Server for MongoDB 4.2.24-24

Servers 79

Servers Open Source Database Software 79

Dynatrace

JUNE 1, 2020

Application Performance Monitoring (APM) in its simplest terms is what practitioners use to ensure consistent availability, performance, and response times to applications. APM can also be referred to as: Application performance management. Performance monitoring. Dynatrace news. Application monitoring.

Monitoring 131

Monitoring Performance Social Media Artificial Intelligence 131

Scalegrid

APRIL 5, 2024

Grasping the concept of Redis sharding is essential for expanding your Redis database. This method involves splitting data over various nodes to improve the database’s efficiency. The purpose is scaling out distributed systems effectively and offering improved management and performance while processing numerous keys.

Scalability 130

Scalability Efficiency Java Database 130

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Dynatrace

MAY 17, 2023

Making applications observable—relying on metrics, logs, and traces to understand what software is doing and how it’s performing—has become increasingly important as workloads are shifting to multicloud environments. However, this method limited us to instrumenting the code manually and collecting specific sets of data we defined upfront.

Metrics 163

Metrics Monitoring Database Network 163

Dynatrace

AUGUST 18, 2022

Years later, a few configuration management solutions came into play that required heavy amounts of coding, but proved that the industry was moving toward compartmentalized automation solutions. These evaluations that I hard-coded into a script were now embedded into the back-end of Ansible’s modular approach.

Games 284

Games Monitoring Infrastructure DevOps 284

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.

Artificial Intelligence 176

Artificial Intelligence Innovation Servers Database 176

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security.

Database 130

Database Servers Storage Network 130

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 71

Servers Database Testing Open Source 71

Dynatrace

OCTOBER 5, 2020

The challenge with ASP.NET Web Service Observability, Diagnostics and Performance Optimization is that most monitoring & diagnostic tools only provide global Service Level Indicators metrics (SLIs) such as response time, failure rate, and throughput, but not metrics for each individual service endpoint. Dynatrace news.

Performance 151

Performance Best Practices Architecture Monitoring 151

Scalegrid

DECEMBER 19, 2019

It’s a very simple utility that does exactly one thing – it sits between the database and the clients and speaks the PostgreSQL protocol, emulating a PostgreSQL server. When PgBouncer receives a client connection, it first performs authentication on behalf of the PostgreSQL server. How Does PgBouncer Work?

Cache 246

Cache Architecture Database Servers 246

SQL Shack

FEBRUARY 3, 2022

In this article, we will go through the details of the trivial execution plans and we will also tackle some examples about the trivial plans to explore effects on query performance. Introduction SQL is a non-procedural programing language that means the database users only code what they want to do and they can’t describe how […].

Servers 83

Servers Programming Database Code 83