Scalegrid

JUNE 22, 2020

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. MySQL on DigitalOcean is a natural fit, but what’s the best way to deploy your cloud database? higher throughput over DigitalOcean Managed Databases across all thread counts. At a glance – TLDR. Compare Latency.

Database 217

Database Benchmarking Latency Performance 217

Percona

AUGUST 31, 2018

Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. 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. This is called double buffering.

Tuning 57

Tuning Database Performance Benchmarking 57

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. We help you configure your MySQL deployment to optimize your performance based on the size of your databases.

Database 166

Database Cloud Website Azure 166

Percona

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 107

Database Benchmarking Latency C++ 107

Dynatrace

JUNE 16, 2022

At the same time, open source software (OSS) libraries now account for more than 70% of most applications’ code base, increasing the risk of application vulnerabilities. RASP capabilities aim to close the gap left by application security testing and network perimeter controls such as web application firewalls (WAFs).

Tuning 220

Tuning Cloud Open Source Network 220

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? That’s a heritage of the LAMP model when the same server would host both the database and the web server. Are these results good enough?

Tuning 137

Tuning Cache Servers Benchmarking 137

Percona

APRIL 13, 2023

PostgreSQL is a popular open source relational database management system that is widely used for storing and managing data. Replication lag is the delay between the time when data is written to the primary database and the time when it is replicated to the standby databases. What is replication lag?

Latency 83

Latency Tuning Open Source Network 83

Dynatrace

OCTOBER 6, 2022

OpenTelemetry is an exciting open source observability standard that provides a common collection of tools, APIs, and SDKs to help collect observability signals. You can also use it to test different OpenTelemetry features and evaluate how they appear on backends. To tackle this challenge, the?OpenTelemetry?community

Open Source 169

Open Source Metrics Tuning Technology 169

Dynatrace

OCTOBER 2, 2023

Because monolithic applications combine database, client-side interfaces, and server-side application elements in a single executable, they’re difficult to understand, even for their own administrators. remove the dependency on the monolith after all testing is successful. Migration is time-consuming and involved.

Architecture 228

Architecture Artificial Intelligence Cloud Open Source 228

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?

Open Source 80

Open Source Healthcare Social Media Database 80

Dynatrace

SEPTEMBER 29, 2021

The time and effort saved with testing and deployment are a game-changer for DevOps. This opens the door to auto-scalable applications, which effortlessly matches the demands of rapidly growing and varying user traffic. In production, containers are easy to replicate. Here the overlap with Kubernetes begins. What is Kubernetes?

Open Source 298

Open Source Traffic DevOps Cloud 298

Dynatrace

DECEMBER 8, 2020

Open source has also become a fundamental building block of the entire cloud-native stack. While leveraging cloud-native platforms, open-source and third-party libraries accelerate time to value significantly, it also creates new challenges for application security.

Cloud 287

Cloud Open Source Internet Internet 287

Percona

MARCH 6, 2023

If you want an answer based on detailed information about your database usage and patterns, it’s recommended to use Percona Management and Monitoring. Redo Logs Starting from MySQL 8.0.30, the variable that should be tuned for optimizing the Redo Logs is innodb_redo_log_capacity , and we start with good news here: It’s dynamic!

Tuning 92

Tuning Open Source Database Engineering 92

Percona

OCTOBER 11, 2023

I created a test account (replica set) and loaded sample data with one click in Atlas: Create an account in Atlas. Atlas atlas-mhnnqy-shard-0 [primary] test> show dbs sample_airbnb 52.69 GiB Atlas atlas-mhnnqy-shard-0 [primary] test> An EC2 instance with PSMDB installed. Prerequisites: A MongoDB Atlas account.

Database 89

Database Open Source Testing Servers 89

Percona

MARCH 23, 2023

Hardware Memory The amount of RAM to be provisioned for database servers can vary greatly depending on the size of the database and the specific requirements of the company. Storage The type of storage and disk used for database servers can have a significant impact on performance and reliability. Benchmark before you decide.

Performance 127

Performance Hardware Tuning Storage 127

Scalegrid

OCTOBER 24, 2019

AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. MySQL on AWS Performance Test. MySQL Performance Test Scenarios and Results. Amazon RDS. Instance Type. AWS High Performance XLarge (see system details below). DB Instance r4.xlarge xlarge (Multi-AZ).

AWS 183

AWS Latency Performance Benchmarking 183

Percona

MAY 15, 2023

version or Percona Server for MongoDB one, your database will no longer receive bug fixes, patches, or minor releases. That means that testing with 4.2 in April has reached its End of Life (EOL), and more versions are soon going to be decommissioned as well. What does that mean for me? If you are a user of MongoDB 4.2,

Servers 111

Servers Open Source Tuning Software 111

Percona

OCTOBER 4, 2023

We discussed how roles can inherit permissions from other roles, simplifying access control in your database. Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together.

C++ 102

C++ Open Source Tuning Database 102

Percona

FEBRUARY 24, 2023

Today, we are excited to announce the release of Percona Monitoring and Management (PMM) V2.35 , including a tech preview of label-based access control, the general availability of Helm Chart, and a range of enhancements to our Database as a Service (DBaaS) offerings, among other improvements and features. Stay tuned!

Availability 96

Availability Metrics Monitoring Open Source 96

Percona

NOVEMBER 9, 2023

With this data, we’ll be able to better understand and tune our Postgres servers. The main idea is to be able to easily detect what the server is doing at any point in time so we can better understand how it reacts to the workload and tune accordingly. You can search the blog for more information on this if needed.

Monitoring 92

Monitoring Tuning Metrics Servers 92

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7

Cache 104

Cache Hardware Servers Benchmarking 104

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. TB)) for storage of database tablespaces and logging.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

The Netflix TechBlog

OCTOBER 19, 2020

Troubleshooting a session in Edgar When we started building Edgar four years ago, there were very few open-source distributed tracing systems that satisfied our needs. Our tactical approach was to use Netflix-specific libraries for collecting traces from Java-based streaming services until open source tracer libraries matured.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

HammerDB

JULY 14, 2021

However, as the two databases diverged from a shared common codebase, this presented a challenge in that it was not possible to modify the workload for MySQL or MariaDB without also changing the other. Also, the additional installation of the MySQL client libraries was needed when testing MariaDB. Prior to HammerDB v4.2 HammerDB v4.2

Testing 57

Testing C++ Virtualization Tuning 57

Percona

FEBRUARY 2, 2023

Recall that logical replication works by using the PUB/SUB mode, where individual tables are published and are then subscribed by remotely connected databases/tables. Stay tuned folks; the game is afoot. DML operations, such as INSERT, UPDATE, DELETE, TRUNCATE, etc., For the most part it’s a pretty straightforward operation.

Games 91

Games Open Source Tuning Speed 91

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. sec) db1 test> CREATE TABLE tb3 (id int auto_increment primary key, test_text tinytext); Query OK, 0 rows affected (0.13

Open Source 90

Open Source Storage Database Big Data 90

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope. But there could be reasons why a PostgreSQL user wants to change that at a specific database level.

Database 105

Database Servers Open Source Tuning 105

Percona

JULY 2, 2023

The size of the database and your database environment—if it is on colo or cloud—matters. Having a backup strategy in place that takes regular backups and has secure storage is essential to protect the database in an enterprise-grade environment to ensure its availability in the event of failures or disasters.

Strategy 52

Strategy Database Storage Open Source 52

Percona

JULY 27, 2023

While this is a great idea for security reasons, there will be many more posts on websites like Stackoverflow bemoaning that their old code and connector can not connect to the new version of the database. This could be handy for tracking query tuning and performance auditing. For those wondering when Percona’s 8.0.34

Servers 84

Servers Open Source Tuning Cache 84

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. So to test I took a system with Skylake CPUs and all storage on a P4800X SSD. In the recent MySQL 8.0.16

Testing 48

Testing Tuning Latency Storage 48

HammerDB

JANUARY 5, 2019

Some opinions claim that “Benchmarks are meaningless”, “benchmarks are irrelevant” or “benchmarks are nothing like your real applications” However for others “Benchmarks matter,” as they “account for the processing architecture and speed, memory, storage subsystems and the database engine.”

Benchmarking 40

Benchmarking Database Social Media Scalability 40

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

Percona

OCTOBER 17, 2023

Many changes and new features are brought to the system, and as part of keeping in tune with the changes and how they can impact us, we go through the changes to better understand them. Bounce the database, replacing the binaries with the older release. From that, this article is born. Remove backward-incompatible features.

Metrics 104

Metrics C++ Storage Database 104

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice. then true else false end FROM generate_series(1, 10000000); Now we have our test table with some dummy data so we can practice.

Best Practices 92

Best Practices Tuning Database Testing 92

All Things Distributed

MARCH 19, 2018

Finally, traditional machine learning algorithms usually consume data from persistent data sources such as local disk, Amazon S3, or Amazon EBS. Streaming algorithms also natively consume ephemeral data sources such as Amazon Kinesis streams, pipes, database query results, and almost any other data source.

Scalability 159

Scalability Hardware AWS Tuning 159

Dynatrace

JULY 23, 2019

When comparing Django and Flask , developers like to highlight that Django provides an all-inclusive experience for developers: you get an admin panel, database interfaces, ORM, and directory structure for your applications and projects out of the box. Tracing database requests. Tracing database requests.

Monitoring 136

Monitoring Software Software Database 136