Percona

APRIL 28, 2023

Did you notice that Percona Server for MongoDB 6.0.5-4 One key to rule them all — improvements to master key rotation With the improvements introduced in Percona Server for MongoDB 6.0.5-4, 4, one key path can be used for all servers in a clustered environment. Changes introduced with Percona Server for MongoDB 6.0.5-4

AWS 102

AWS Servers Scalability Database 102

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 73

Database Open Source Servers Code 73

Scalegrid

DECEMBER 9, 2019

Given such a scenario, MySQL documentation recommends that the crashed master must be discarded and should not be restarted. However, discarding a server like this is expensive and inefficient. Default database: 'test'. Re-Slaving a Crashed #MySQL Master Server in Semisynchronous Replication Setup Click To Tweet.

Servers 160

Servers Database Processing Availability 160

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

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

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. For example, for my MongoDB cluster, I have six PVCs: three x replica set nodes and three x config server nodes. But snapshots cannot provide you with the same RPO as native database mechanisms. AWS EBS Snapshots). Volume snapshots in the clouds store data in increments.

Database 65

Database Storage Open Source AWS 65

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

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. On-premises data centers invest in higher capacity servers since they provide more flexibility in the long run, while the procurement price of hardware is only one of many cost factors. Databases : Among databases, Redis is the most used at 60%.

Open Source 346

Open Source Java Operating System Programming 346

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 You can filter events based on a user account, audit event class name, audit event subclass name, and audit event fields (database name, table name, operation status, and so on). A server restart is not required to add or adjust existing filtering rules.

Open Source 103

Open Source Database Servers Storage 103

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. About YCSB.

Benchmarking 308

Benchmarking Latency C++ Database 308

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

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

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 191

Artificial Intelligence Innovation Servers Database 191

Percona Community

MARCH 19, 2023

We’ll get the data from the API and save it to the database. In the previous article, we developed a simple application that connects to the MongoDB database (Percona Server for MongoDB) and writes documents in a loop. We only used Composer packages to work with MongoDB.

Servers 52

Servers Database Code Development 52

Scalegrid

JANUARY 3, 2020

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance.

Monitoring 164

Monitoring Metrics Servers Database 164

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Jobs documentation has quite a few details for failure handling, retries, deadlines, etc. HaProxy was acting as a load balancer in front of the cluster. Commands end with ; or g.

Database 94

Database Performance C++ Engineering 94

Dynatrace

FEBRUARY 14, 2022

Among these, you can find essential elements of application and infrastructure stacks, from app gateways (like HAProxy), through app fabric (like RabbitMQ), to databases (like MongoDB) and storage systems (like NetApp, Consul, Memcached, and InfluxDB, just to name a few). documentation. Prometheus Data Source documentation.

Technology 222

Technology Technology Metrics Infrastructure 222

Dynatrace

NOVEMBER 3, 2023

already address SNMP, WMI, SQL databases, and Prometheus technologies, serving the monitoring needs of hundreds of Dynatrace customers. Dynatrace provides tooling and documentation to help you migrate your Extensions 1.0 Apache Kafka Server (JMX) The Apache Kafka extension offers valuable insights into your Kafka server.

Technology 250

Technology Technology Scalability Availability 250

Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 79

Open Source Azure Servers Programming 79

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The feedback from users was that “backup management is a must ” and “we need something that allows us to manage all of our database backups in one place, not server by server.”

Open Source 88

Open Source Database Operating System Programming 88

Percona

JUNE 20, 2023

Percona Operator for PostgreSQL offers a powerful solution for managing and scaling PostgreSQL databases in a Kubernetes environment, making it an ideal choice for developer use cases. I will use the regular kubectl approach: $ kubectl apply --server-side -f deploy/bundle.yaml Django application would require its own user and database.

Database 113

Database Open Source Engineering Efficiency 113

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The database is also widely loved for PostgreSQL extensions which enable users to extend the functionality of their database. PALO ALTO, Calif.,

Azure 182

Azure AWS Open Source Database 182

Dynatrace

JANUARY 19, 2020

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 154

Monitoring Best Practices Infrastructure Servers 154

Percona

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. It is also important to monitor your server’s memory usage regularly to ensure that it is not being exhausted by the buffer pool.

Social Media 119

Social Media Database Servers Cache 119

Dynatrace

JANUARY 31, 2024

The RAG process begins by summarizing and converting user prompts into queries that are sent to a search platform that uses semantic similarities to find relevant data in vector databases, semantic caches, or other online data sources. million AI server units annually by 2027, consuming 75.4+

Cache 208

Cache Azure Infrastructure Monitoring 208

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment. Percona XtraBackup 8.1

C++ 92

C++ Open Source Servers Database 92

Scalegrid

JUNE 18, 2019

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. The connection options available for the driver are documented here , and the options we will need are: :ssl. ssl_verify.

C++ 100

C++ Servers Database Network 100

Smashing Magazine

OCTOBER 29, 2018

Measuring Performance With Server Timing. Measuring Performance With Server Timing. That issue is slow server response times. There’s very little browser optimisations can do to improve a page that is simply slow to build on the server. Encompassed in that wait time is everything the server needs to do to build the page.

Servers 87

Servers Performance Metrics Database 87

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. Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only.

Servers 63

Servers Database Testing Efficiency 63

Percona

JANUARY 3, 2024

If you are a database administrator or developer, you may encounter some issues that require external assistance. Whether you seek help from Percona Support or the Community, you must provide sufficient information about your database performance and configuration. A week later, PMM 2.0.41.0 was released with GUI for the PMM Dump.

Monitoring 89

Monitoring Open Source Database Servers 89

Dynatrace

MAY 31, 2019

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 161

Monitoring Best Practices Infrastructure Programming 161

SQL Server According to Bob

FEBRUARY 7, 2020

SQL Server dbcc clonedatabase ​​ - ​​ Gotcha The dbcc clonedatabase is a ​​ handy command to clone metadata and ​​ information such as ​​ query disk store. The new database generated from DBCC CLONEDATABASE is primarily intended for troubleshooting and diagnostic purposes.

Servers 45

Servers Azure Tuning Database 45

Percona

APRIL 20, 2023

TDE is a database encryption technique that encrypts data at the column or table level, as opposed to full-disk encryption (FDE), which encrypts the entire database. parameters: type: pd-standard disk-encryption-kms-key: KMS_KEY_ID Get KMS_KEY_ID by following the instructions in this document. apiVersion: storage.k8s.io/v1

Storage 118

Storage AWS Cloud Database 118

Percona

FEBRUARY 24, 2023

As a result, it becomes increasingly important to protect the confidentiality of information to prevent data leaks and facilitate easy access to relevant data sources and tools for the related teams without having to sift through unrelated databases or environmental data. to monitor and diagnose. +50

Metrics 106

Metrics Monitoring Database Engineering 106

Percona

JUNE 27, 2023

Percona Alerting was introduced in Percona Monitoring and Management (PMM) 2.31, and it brought a range of custom alerting templates that makes it easier to create Alert rules to monitor your databases. GF_SMTP_HOST: Host address of your SMTP server. GF_SMTP_USER: Username for SMTP authentication.

Monitoring 75

Monitoring Open Source Database Servers 75

Dynatrace

NOVEMBER 16, 2021

It records real-time metrics in a time series database with flexible queries and real-time alerting. It then compresses and stores them in a time-series database on a regular cadence. This means Dynatrace isn’t collecting the metrics on the Prometheus server, but directly at the source of truth – the exporters.

Metrics 206

Metrics Infrastructure Open Source Database 206

SQL Performance

MARCH 29, 2022

When SQL Server applies simple parameterization to an ad-hoc statement, it makes a guess about the data type of the replacement parameter. For the time being, let’s look at some examples using the Stack Overflow 2010 database on SQL Server 2019 CU 14. The bigint type isn’t used for server-side parameterization.

Cache 90

Cache Servers Database Testing 90