Scalegrid

JULY 8, 2019

Are you looking to get started with the world’s most popular open-source database, and wondering how you should setup your MySQL hosting ? While Microsoft Azure does offer a managed solution, Azure Database, the solution has some major limitations you should know about before migrating your MySQL deployments.

Azure 219

Azure Cloud Virtualization Database 219

Testlodge

APRIL 14, 2021

Configuration testing is performed to discover the optimum combinations of software and hardware specifications that allow the system to work without flaws. What is Configuration Testing? However, configuration testing is a time-consuming technique, so the team must create a workable plan. Types of Configuration Testing.

Testing 89

Testing Hardware Virtualization Operating System 89

Scalegrid

JULY 29, 2020

PgBouncer defines one pool per user+database combination. A client benefits from a pooled connection only if it connects to a child which has previously served a connection for this database+user combination. PgBouncer allows limiting connections per-pool, per-database, per-user or per-client. Performance Testing.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Scalegrid

OCTOBER 17, 2019

In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. Developers are often strongly discouraged from holding a database connection while other operations take place.

Architecture 200

Architecture Database Latency Servers 200

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

Brendan Gregg

NOVEMBER 29, 2017

Hardware virtualization for cloud computing has come a long way, improving performance using technologies such as VT-x, SR-IOV, VT-d, NVMe, and APICv. It's an exciting development in cloud computing: hardware virtualization is now fast. Virtualized in Hardware**: Hardware support for virtualization, and near bare-metal speeds.

Virtualization 111

Virtualization AWS Hardware Storage 111

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. virtual = 2.2G virtual = 2.2G

Cache 101

Cache Database Virtualization Servers 101

Percona

APRIL 7, 2023

If we were to select the most important MySQL setting, if we were given a freshly installed MySQL or Percona Server for MySQL and could only tune a single MySQL variable, which one would it be? Sysbench ran on a third server, which I’ll refer to as the application server (APP).

Tuning 137

Tuning Cache Servers Benchmarking 137

Scalegrid

JANUARY 17, 2019

For our MongoDB Bring Your Own Cloud (BYOC) AWS deployments that are not open to the internet, this may mean selecting an instance that is allowed to connect to the Security Group and also has VPN connectivity to the Virtual Private Cloud (VPC). Database Specific Users. Server Name : SG-example-1234.servers.mongodirector.com.

Database 178

Database Servers Open Source AWS 178

Dynatrace

JULY 7, 2022

It’s easy to see why, with benefits such as better testing, easier deployment, faster performance, and more. These teams typically use standardized tools and follow a sequential process to build, review, test, deliver, and deploy code. Testing can be more complicated. Dynatrace news. Common problems with monolithic architecture.

Architecture 196

Architecture Serverless Azure Programming 196

Scalegrid

FEBRUARY 8, 2024

A distributed storage system is foundational in today’s data-driven landscape, ensuring data spread over multiple servers is reliable, accessible, and manageable. These storage nodes collaborate to manage and disseminate the data across numerous servers spanning multiple data centers.

Storage 130

Storage Systems Big Data Azure 130

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

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages? In this case, THP is enabled.

Database 90

Database Servers Open Source C++ 90

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. The Back Story.

Servers 90

Servers Media Cache Storage 90

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

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. DigitalOcean Droplets. minutes of downtime in one year.

Azure 187

Azure AWS Latency Database 187

Percona

NOVEMBER 2, 2023

Following the series of blogs started by Peter Zaitsev in Installing MySQL with Docker , on deploying Docker containers running open source databases, in this article, I’ll demonstrate how to install and run PostgreSQL using Docker. ” We intend to show how to bring up PostgreSQL instance(s) into Docker containers.

Database 71

Database Open Source Scalability Virtualization 71

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 101

Monitoring Scalability Cache Database 101

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 80

Availability Hardware Open Source Database 80

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 85

Availability Open Source Architecture Database 85

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. Another major trend is using multiple third-party components and services, which may be not easy to properly incorporate into testing. – Cloud.

Performance Testing 100

Performance Testing Architecture Testing Performance 100

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. The obvious answer is this: To achieve high availability.

Architecture 99

Architecture Availability Open Source Healthcare 99

HammerDB

APRIL 27, 2021

One of the first things you will want to do is make sure that we can access the 3rd party driver libraries for the database that we want to use. In this example we are using SQL Server so the message shows that everything is in order and we can proceed with running tests. Selecting a database. Select a database.

Virtualization 73

Virtualization Benchmarking Database Operating System 73

Dynatrace

MAY 28, 2020

After a new build gets deployed and automated tests executed, SLIs are evaluated against their SLOs and, depending on that result, a build is considered good (promoted) or bad (rolled back). “ The app description and supporting files such as load testing scripts are on the Keptn Example GitHub. This is what this blog is all about.

Engineering 189

Engineering Performance Metrics Best Practices 189

Percona

SEPTEMBER 6, 2023

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. Well, there is always a drawback to having the server do something complicated for you. id` AS `id` from `test`.`product`

Speed 84

Speed Virtualization Storage Open Source 84

HammerDB

MARCH 25, 2023

When you list the HammerDB directory you can now see a directory called “scripts” This directory contains CLI scripts to build, run, delete and query TPROC-C and TPROC-H workloads against all databases. If HammerDB is running on a separate system from the database under test then you should modify this value accordingly.

C++ 83

C++ Virtualization Benchmarking Database 83

HammerDB

JULY 16, 2021

One of the most important concepts in analysing database performance is that of understanding scalability. The way we measure this is through a ‘performance profile’ This simply means that we run a series of tests incrementally increasing the system load until we find the peak performance. and MySQL 8.0.25 and MySQL 5.7.33.

Virtualization 57

Virtualization Performance C++ Database 57

Dynatrace

MAY 8, 2023

DevOps aims to move applications more quickly into production by releasing new builds frequently — often several times per day — and incorporating constant feedback and testing, both during development and after software is deployed. But when and how does DevOps monitoring fit into the process?

DevOps 216

DevOps Efficiency Monitoring Infrastructure 216

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

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

Dynatrace

APRIL 21, 2022

Getting precise root cause analysis when dealing with several layers of virtualization in a containerized world. Too much data requested from a database. Some principles Microsoft provides to help organizations across this area include: Define and test availability targets such as service level agreements (SLAs) and SLOs.

Azure 184

Azure Monitoring Virtualization Metrics 184

Percona

MAY 15, 2023

In both cases, when using virtually-synchronous replication, the process will require certification from each node and local (by node) write; as such, the number of writes is NOT distributed across multiple nodes but duplicated. Also, in the case of multi-Primary, the writes will be distributed by transaction. The POC Why this POC?

Traffic 125

Traffic Scalability Database Servers 125

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS.

Servers 49

Servers Azure Hardware Database 49

Percona

JULY 15, 2023

One very common problem when trying to optimize a database environment is index usage. Introduction to MySQL Indexes Indexes in MySQL are database structures used to optimize data retrieval speed and efficiency. Need help managing complex database environments? This structure makes for faster data access.

Virtualization 78

Virtualization Speed Database Efficiency 78

HammerDB

DECEMBER 1, 2022

In particular, after a running a test it would be ideal to have a repository where we could verify the configuration of the workload that was run, the results and any timing or transaction count data generated to bring all the log output into a central location. . <commandline> This happens for both a schema build and running a test.

Virtualization 57

Virtualization C++ Storage Database 57

Dynatrace

APRIL 8, 2021

This means that there is no need to provision or manage servers (or even containers). When using Lambda, you might soon end up using more serverless offerings, like databases, which makes emulating the same environment locally even harder. Lambda handles all of the following for you: Load balancing. Auto scaling. Failure retries.

Lambda 218

Lambda AWS Serverless Monitoring 218

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62