Percona

NOVEMBER 2, 2023

MongoDB is a dynamic database system continually evolving to deliver optimized performance, robust security, and limitless scalability. Our new eBook, “ From Planning to Performance: MongoDB Upgrade Best Practices ,” guides you through the entire process to ensure your database’s long-term success.

Best Practices 85

Best Practices Hardware Tuning Scalability 85

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

Percona

APRIL 10, 2023

During export, mydumper sends SELECT statements to the database. mydumper -o data -B test --defaults-file=mydumper.cnf -r 100000 -c real 0m19.964s user 0m48.396s sys 0m7.885s It took near 19.9 mydumper -o data -B test --defaults-file=mydumper.cnf -r 100000 -c real 0m19.964s user 0m48.396s sys 0m7.885s It took near 19.9

Testing 103

Testing C++ Open Source Database 103

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Through effortless provisioning, a larger number of small hosts provide a cost-effective and scalable platform. Strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Java, Go, and Node.js

Open Source 342

Open Source Java Operating System Programming 342

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

The Netflix TechBlog

MARCH 5, 2019

What will be the cost of rolling out the winning cell of an AB test to all users? Can we adjust our auto-scaling policies to be more efficiency without risking our availability during traffic spikes? Capacity and Efficiency Which resources (clusters, tables, …) are unused or under-utilized and why?

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

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 97

Monitoring Scalability Cache Database 97

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.

Benchmarking 308

Benchmarking Latency C++ Database 308

Percona

OCTOBER 13, 2023

Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. Let’s test it with InnoDB using the ibd2sdi tool. 1 mysql mysql 0 Sep 18 08:15 test_table.MYD [root@db3-node test]# RocksDb also supports SDI.

Storage 91

Storage Database Engineering Open Source 91

O'Reilly Software

JUNE 12, 2018

This meant a lot of time was spent on things like cycle time analysis, build pipeline design, test automation, and infrastructure automation. Back then, the most common pattern I saw for service-based systems was sharing a database among multiple services. But I kept hitting up against some fundamental issues.

Database 72

Database Cache Architecture Latency 72

High Scalability

JULY 18, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! Learn more here. Search like you mean it. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

High Scalability

MAY 4, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! Make your job search O (1), not O ( n ). Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100

Percona

SEPTEMBER 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. Percona Distribution for PostgreSQL is now available on Debian 12 (bookworm).

Open Source 76

Open Source Scalability Database Software 76

Dynatrace

SEPTEMBER 30, 2021

The breadth of fully-featured services, the pay-as-you-go scalability, and the agility of cloud platforms enable organizations to expand their modern approaches to building and managing digital services in a way they can’t with on-premises apps and infrastructure. Increased scalability. Migrate databases intelligently.

Cloud 165

Cloud Traffic Best Practices Strategy 165

High Scalability

JUNE 10, 2022

If you have a passion for databases (both SQL and NoSQL), significant experience building, managing, and monitoring infrastructure, databases, and backend services at scale and want to work with a rag-tag team of hardworking, but humble humans, then come check us out! Learn more here. Search like you mean it. Get started for free!

Education 100

Education DevOps Infrastructure Scalability 100

Percona

DECEMBER 7, 2023

When combined with the versatility of Docker containers, it becomes a dynamic duo, offering a scalable approach to data backup and recovery. Add data to the database Let’s add some data to the Percona Server database. Create a test database and add a table t1 inside with five rows. and Percona XtraBackup 2.4

C++ 91

C++ Open Source Servers Database 91

Percona

OCTOBER 17, 2023

List all non-system databases with query SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME NOT IN ('mysql', 'sys', 'information_schema', 'performance_schema'); Remove them one by one. Keep your existing MySQL schema If you do not want to re-install your instance, you can remove user data from it instead.

Open Source 96

Open Source Servers Database Strategy 96

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. Percona Distribution for MySQL (PS- based variant) 8.1.0 was released.

Open Source 78

Open Source Azure Servers Programming 78

Percona

NOVEMBER 6, 2023

localhost The use of the characters % and _ as wildcards in database-level grants is now deprecated. TO dave will grant user dave access to all the tables in database dave_ but not dave1, davex, or davey. Any comments in italics are mine and not the view of Percona, Oracle, or probably anyone else. So SET GRANT SELECT on dave_.*

Open Source 108

Open Source Database Servers Scalability 108

Percona

MAY 16, 2023

This was the first official image and since then, we have been improving our testing and packaging procedures based on Docker, CircleCI, and GitHub Actions. However, when I’m coding, I’m not testing in Docker. o /backups/data -B test -v 3 -r 1000 -L /backups/mydumper.log ; myloader -h 172.17.0.4 -d

C++ 93

C++ Open Source Database Testing 93

Percona

APRIL 11, 2023

Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, can negatively impact performance. In this blog post, we’ll put ourselves to the test and see if we can identify duplicate and redundant indexes in MySQL.

Database 89

Database Open Source Testing Design 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. Let’s test this.

Database 98

Database Engineering Best Practices Open Source 98

High Scalability

FEBRUARY 1, 2022

Pinecone is a vector database that makes it easy to add semantic search to your applications. The geolocation database or API detects location, proxy and other >20 parameters. Learn how engineering teams are using products like StackHawk and Snyk to add security bug testing to their CI pipelines. Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100

Dynatrace

APRIL 16, 2020

With most employees now working from home, and the demand on e-commerce platforms hits an all-time high, applications and infrastructure are under intense pressure with new usage patterns that have never been planned for or tested against. Government agencies coping with COVID-19.

Traffic 201

Traffic Government Database Infrastructure 201

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 88

Open Source Best Practices Servers Database 88

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 99

Cache Hardware Servers Benchmarking 99

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. As such, it is generally recommended to disable THP for most database workloads.

Database 86

Database Servers Open Source C++ 86

High Scalability

DECEMBER 9, 2021

Pinecone is a vector database that makes it easy to add semantic search to your applications. The geolocation database or API detects location, proxy and other >20 parameters. Learn how engineering teams are using products like StackHawk and Snyk to add security bug testing to their CI pipelines. Apply here. Try it today!

Education 100

Education DevOps Infrastructure Scalability 100

Percona

JULY 10, 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. Today’s post includes those releases and updates that have come out since June 26, 2023.

Monitoring 75

Monitoring Open Source Scalability Database 75

High Scalability

AUGUST 24, 2021

Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. The geolocation database or API detects location, proxy and other >20 parameters. Learn how engineering teams are using products like StackHawk and Snyk to add security bug testing to their CI pipelines. Apply here.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

OCTOBER 27, 2021

Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. The geolocation database or API detects location, proxy and other >20 parameters. Learn how engineering teams are using products like StackHawk and Snyk to add security bug testing to their CI pipelines. Apply here.

Education 100

Education DevOps Infrastructure Benchmarking 100

Percona

JUNE 30, 2023

Percona, a leading provider of open-source database software and services, announced the general availability of Percona Operator for PostgreSQL version 2. Kubernetes provides many benefits, such as automation and scalability, but it also introduces new complexities when it comes to managing databases.

Availability 92

Availability Open Source Azure Hardware 92

High Scalability

SEPTEMBER 29, 2021

Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. The geolocation database or API detects location, proxy and other >20 parameters. Learn how engineering teams are using products like StackHawk and Snyk to add security bug testing to their CI pipelines. Apply here.

Education 100

Education DevOps Infrastructure Benchmarking 100

High Scalability

SEPTEMBER 15, 2021

Pinecone is a fully managed vector database that makes it easy to add vector search to production applications. The geolocation database or API detects location, proxy and other >20 parameters. Learn how engineering teams are using products like StackHawk and Snyk to add security bug testing to their CI pipelines. Apply here.

Education 100

Education DevOps Infrastructure Benchmarking 100

The Netflix TechBlog

OCTOBER 19, 2020

An additional implication of a lenient sampling policy is the need for scalable stream processing and storage infrastructure fleets to handle increased data volume. The next challenge was to stream large amounts of traces via a scalable data processing platform. Mantis is our go-to platform for processing operational data at Netflix.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Percona

AUGUST 18, 2023

I tried the in-place upgrade on my test VM for my own curiosity and got some redo log format errors/Data Dictionary errors. But after that, we also had to test the ‘unsupported’ replication setup to ensure data can be synced from MariaDB 10.4 to test the binlog compatibility. to MySQL 8.x to MySQL 5.7 And it worked!

Open Source 65

Open Source Database Storage Engineering 65

Percona

AUGUST 1, 2023

In the world of database management, ALTER TABLE operations are a crucial part of modifying database structures. MySQL, a popular database management system, offers online operations since version 5.6, providing a convenient way to perform these alterations without locking the table. However, there are caveats.

Storage 77

Storage Database Open Source Engineering 77