Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 83

Servers C++ Database Systems 83

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 will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health.

Metrics 130

Metrics Monitoring Latency Cache 130

Testlodge

APRIL 14, 2021

A software tester’s work life includes making sure that systems that have been designed to achieve specific results behave exactly as they should. These systems are a combination of different hardware and software which have been configured to perform the desired task. What is Configuration Testing?

Testing 89

Testing Hardware Virtualization Operating System 89

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Scalegrid

JANUARY 20, 2020

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. This extra cluster, known as a follower cluster, can be leveraged for multiple use cases, including for analyzing, optimizing and testing your application performance for MongoDB , MySQL and PostgreSQL.

Analytics 185

Analytics Storage Database Systems 185

Scalegrid

AUGUST 22, 2019

On the first node, Patroni initializes the database, obtains the leader lock from DCS, and ensures the node is being run as the master. In a distributed system, consensus plays an important role in determining consistency, and Patroni uses DCS to attain consensus. High Availability Test Scenarios. Standby Server Tests.

Availability 277

Availability Servers Network Open Source 277

Dynatrace

JANUARY 31, 2024

GenAI is prone to erratic behavior due to unforeseen data scenarios or underlying system issues. 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.

Cache 204

Cache Azure Infrastructure Monitoring 204

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. and xtrabackup 2.4

Servers 103

Servers C++ Storage Systems 103

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

SQL Performance

APRIL 15, 2020

SQL Server has always provided the ability to capture actual queries in an easily-consumable rowset format – first with legacy SQL Server Profiler, later via Extended Events, and now with a combination of those two concepts in Azure SQL Database. Enter the New SQL Server Profiler. Legacy Profiler "Standard" trace events.

Azure 96

Azure Database Tuning Network 96

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Scalegrid

SEPTEMBER 18, 2020

One option is purchasing your own CA-signed SSL certificates and configuring them on the MongoDB server. If your application connects to the production database over a public network, do reach out to support@scalegrid.io Note: All the code samples have been tested using MongoDB Driver v2.8.1 to learn more about this.

C++ 244

C++ Programming Servers Database 244

SQL Server According to Bob

DECEMBER 3, 2019

I have previously tested and blogged about the NTFS, sparse, file system limitation error 665: [link] when running DBCC or using Snapshot databases with SQL Server. Recently a customer asked me if they would encounter the same limitation if they moved to Linux.

Servers 45

Servers Systems Storage Database 45

Dynatrace

AUGUST 18, 2022

Whether deployment of a new system, a new release, or a rolling patch update, I wanted it done consistently and successfully every time. In some cases, this meant testing my scripted methodology hundreds of times before deploying to production in order to catch every nuance and condition that could affect the result.

Games 293

Games Monitoring Infrastructure DevOps 293

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

Percona

JUNE 23, 2023

Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system. It does not follow the SQL Standard as closely as other databases, and some useful functions such as MERGE() are missing.

Database 119

Database Transportation Servers Cloud 119

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. PMM monitors the MySQL uptime: show global status like 'uptime'; Indicates the amount of time (seconds) the MySQL server has been running since the last restart.

Performance 104

Performance Monitoring Traffic Database 104

Percona

OCTOBER 3, 2023

Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. The value that appears between square brackets is the current value.

Database 87

Database Servers Open Source C++ 87

Scalegrid

NOVEMBER 20, 2019

During this time, you are also likely to experience a degraded performance of queries as your system resources are busy in index-creation work as well. There will be a short duration (tens of seconds) during which you will lose connectivity to your database due to the failover, but this can be overcome by having application-level retries.

Best Practices 239

Best Practices Latency Tuning Database 239

SQL Performance

APRIL 17, 2020

Ultimately, tables are stored as a sequence of bytes with some metadata elsewhere in the system to describe what each of those bytes mean, and how they relate to each of the table's various columns. It requires only a few changes to system tables, and a minimal amount of logging. Improvements in SQL Server 2016. ( SELECT.

Servers 63

Servers Database Testing Efficiency 63

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?!

Cache 98

Cache Database Virtualization Servers 98

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. is out , I thought it might be time to do a bit of testing myself.

Servers 95

Servers C++ Testing Systems 95

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 98

Monitoring Scalability Cache Database 98

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

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

Percona

OCTOBER 17, 2023

MySQL Clone plugin simplifies new replica provisioning but does not simplify server restore after failure unless you are ready to re-install your MySQL instance from scratch. Since you decided to clone a replica from another server, you agreed to lose your current data. After that, start the server.

Open Source 97

Open Source Servers Database Strategy 97

Percona

APRIL 20, 2023

It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8.

Open Source 89

Open Source Best Practices Servers Database 89

Percona

SEPTEMBER 26, 2023

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows and significantly enhancing data retrieval, manipulation, and overall system performance.

Database 99

Database Engineering Best Practices Open Source 99

Testsigma

DECEMBER 4, 2020

To ensure quality, mobile app testing is essential. In this blog, we will discuss a step-by-step mobile app testing checklist. This is where cross-platform testing comes into the picture. These may include screen resolution, orientation, different versions of operating systems, camera, motion sensor, etc.

Mobile 65

Mobile Testing Operating System Storage 65

The Netflix TechBlog

MAY 21, 2019

using RL agents for test case scheduling By: Stanislav Kirdey , Kevin Cureton , Scott Rick , Sankar Ramanathan Introduction Netflix brings delightful customer experiences to homes on a variety of devices that continues to grow each day. Detect a regression in a test case. These problems could be solved in several different ways.

Testing 163

Testing AWS Lambda Network 163

HammerDB

FEBRUARY 26, 2024

Many of the HammerDB TPROC-C workloads have included features to prevent the database doing maintenance tasks for the previous run whilst another run is taking place. This is particularly important when running automated workloads back-back to generate a performance profile for a progressively increasing number of virtual users.

C++ 62

C++ Cache Database Virtualization 62

Percona

MAY 16, 2023

As a database administrator, have you ever been in a situation when your database confronted a brute force attack? The connection control plugin library allows administrators to introduce an increasing delay in the server response to connections after a designated number of consecutive unsuccessful login attempts.

Servers 118

Servers Database Monitoring Testing 118

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

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

Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. What is PostgreSQL used for? Is PostgreSQL enterprise-ready?

Open Source 78

Open Source Healthcare Social Media Database 78

Alex Podelko

OCTOBER 20, 2016

I am looking forward to share my thoughts on ‘Reinventing Performance Testing’ at the imPACt performance and capacity conference by CMG held on November 7-10, 2016 in La Jolla, CA. Cloud seriously impacts system architectures that has a lot of performance-related consequences. First, we have a shift to centrally managed systems.

Performance Testing 100

Performance Testing Architecture Testing Performance 100