Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Think of us as the extra set of eyes, the extra layer of QA to ensure your safety passage to the next database version.

Availability 101

Availability Servers Database Open Source 101

Percona

FEBRUARY 15, 2023

Bloom filters are an essential component of an LSM-based database engine like MyRocks. Tuning In terms of tuning, two parameters can be tuned, the size of the bitmap and the number of bits set by every value. A good understanding of how bloom filters work can only lead to improved database performance.

Storage 129

Storage Tuning Cache Engineering 129

Dynatrace

DECEMBER 18, 2023

For busy site reliability engineers, ensuring system reliability, scalability, and overall health is an imperative that’s getting harder to achieve in ever-expanding, cloud-native, container-based environments. Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. Please stay tuned!

Metrics 171

Metrics Engineering Energy Tuning 171

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

Percona

DECEMBER 13, 2023

Error logging is a critical aspect of database administration, providing insights into issues, warnings, and errors that may affect the system’s stability and performance. MySQL 8 introduces Error Log Filtering as a mechanism to fine-tune the error log, allowing administrators to focus on the most critical issues.

Database 95

Database Open Source Tuning Traffic 95

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 91

Tuning Open Source Database Engineering 91

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

Percona

AUGUST 7, 2023

Both logs are crucial in the ACID (Atomicity, Consistency, Isolation, Durability) properties of database systems. Crash recovery: In the event of a system crash or restart, the undo log helps restore the database to a consistent state by applying the necessary undo operations based on the recorded before-images.

Database 96

Database Tuning Storage Open Source 96

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. For storage, FIO is generally used.

Performance 54

Performance Benchmarking Cache Storage 54

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. You can read some optimization examples in the official doc: [link]. Results for Percona Server for MySQL 8.0 While you are on 5.7, Try Percona Distribution for MySQL today!

Cache 103

Cache Hardware Servers Benchmarking 103

Percona

OCTOBER 12, 2023

Manual flame graphs collection Although the tool is excellent and automatically provides flame graphs, we don’t have much control over tuning the selected profiler. The resulting file is a flame graph in SVG format that can be displayed in a web browser. Try Percona Distribution for MySQL today!

Code 111

Code Tuning C++ Benchmarking 111

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. Try Percona Distribution for MySQL today!

Servers 84

Servers Open Source Tuning Cache 84

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 117

Database Open Source Traffic Small Business 117

DZone

OCTOBER 1, 2023

Elasticsearch is an open-source search engine and analytics store used by a variety of applications from search in e-commerce stores, to internal log management tools using the ELK stack (short for “Elasticsearch, Logstash, Kibana”).

Open Source 247

Open Source Tuning Analytics Scalability 247

O'Reilly

MAY 25, 2021

Open source projects such as EleutherAI have drawn inspiration from GPT-3. It is likely that entire companies will be in the business of identifying these nuances and selling them as “fingerprint databases” for identifying fake news articles. These models will continue to become more powerful. HODL for Fun & Profit.

Social Media 138

Social Media Media Internet Internet 138

Dynatrace

SEPTEMBER 29, 2021

This opens the door to auto-scalable applications, which effortlessly matches the demands of rapidly growing and varying user traffic. Docker Engine is built on top containerd , the leading open-source container runtime, a project of the Cloud Native Computing Foundation (DNCF). What is Docker? What is Kubernetes?

Open Source 294

Open Source Traffic DevOps Cloud 294

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

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. An ideal RASP technology does not need training or fine-tuning to learn what bad application behavior looks like. Not scalable in cloud-native environments.

Tuning 216

Tuning Cloud Open Source Network 216

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. Many organizations also find it useful to use an open source observability tool, such as OpenTelemetry.

Architecture 224

Architecture Artificial Intelligence Cloud Open Source 224

Percona

JUNE 20, 2023

mysql> use app_schema Database changed mysql> show tables; ERROR 1226 (42000): User 'john_smith' has exceeded the 'max_questions' resource (current value: 10) max_updates_per_hour If the user tries to run more than the defined updates per hour, the following error message will appear. You can read more about it in MySQL 8.0

Tuning 107

Tuning Database Open Source Scalability 107

Dynatrace

MAY 17, 2023

OpenTelemetry , the open source observability tool, has become the go-to standard for instrumenting custom applications to collect observability telemetry data. Database monitoring Once more, under Applications & Microservices, we’ll also find Databases. And that’s where Dynatrace OneAgent comes in.

Metrics 166

Metrics Monitoring Database Network 166

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 284

Cloud Open Source Internet Internet 284

All Things Distributed

MARCH 19, 2018

At AWS, we continue to strive to enable builders to build cutting-edge technologies faster in a secure, reliable, and scalable fashion. While building Amazon SageMaker and applying it for large-scale machine learning problems, we realized that scalability is one of the key aspects that we need to focus on. Factorization Machines.

Scalability 159

Scalability Hardware AWS Tuning 159

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Triggering repairs at any time.

Database 212

Database Traffic Transportation Open Source 212

Percona

JANUARY 4, 2024

Managing storage and performance efficiently in your MySQL database is crucial, and general tablespaces offer flexibility in achieving this. Flexible location : Data files can reside within the MySQL data directory or an independent location, enabling finer control over storage management and performance tuning.

Storage 89

Storage Engineering Database Hardware 89

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Triggering repairs at any time.

Database 197

Database Traffic Transportation Open Source 197

The Netflix TechBlog

OCTOBER 18, 2022

As Big data and ML became more prevalent and impactful, the scalability, reliability, and usability of the orchestrating ecosystem have increasingly become more important for our data scientists and the company. Motivation Scalability and usability are essential to enable large-scale workflows and support a wide range of use cases.

Java 202

Java Scalability Traffic Architecture 202

The Netflix TechBlog

NOVEMBER 2, 2021

It has become a de facto standard for perceptual quality measurements within Netflix and, thanks to its open-source nature , throughout the video industry. As VMAF evolves and is integrated with more encoding and streaming workflows within Netflix, we need scalable ways of fostering video quality innovations.

Media 171

Media Innovation Metrics Latency 171

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

KeyCDN

OCTOBER 31, 2018

PHPStorm PHPStorm streamlines application development by offering integration with relational databases and other PHP tools. It might have more features than you need, but it’s especially helpful if you use MySQL for database management. Aptana Studio Aptana Studio boasts a surprising amount of features for an open source IDE.

Development 57

Development Open Source Java AWS 57

Percona

JULY 30, 2018

Please join Percona’s CEO, Peter Zaitsev as he presents Using MySQL for Distributed Database Architectures on Tuesday, July 31st, 2018 at 7:00 AM PDT (UTC-7) / 10:00 AM EDT (UTC-4). Such architectures bring many benefits (such as scalability and resiliency), but can also bring a lot of pain if incorrectly designed and executed.

Architecture 41

Architecture Database Open Source Internet 41

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

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. HammerDB has a signficant advantage of being able to run on multiple databases allowing this sort of question again to be answered from your running your own tests.

Benchmarking 63

Benchmarking Performance Hardware C++ 63

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013.

Open Source 244

Open Source Tuning C++ Database 244

Percona

AUGUST 30, 2018

One of the common ways to classify database workloads is whether it is “read intensive” or “write intensive”. Because recognizing if the workload is read intensive or write intensive will impact your hardware choices, database configuration as well as what techniques you can apply for performance optimization and scalability.

Benchmarking 47

Benchmarking Database Operating System Architecture 47

All Things Distributed

APRIL 11, 2012

Werner Vogels weblog on building scalable and robust distributed systems. And increasingly, search is applied to data that, though called a "document" for the purposes of search, is really just a record in a database or an object in a NoSQL system. All Things Distributed. Expanding the Cloud â?? Introducing Amazon CloudSearch.

Cloud 149

Cloud AWS Technology Technology 149