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 82

Open Source Healthcare Social Media Database 82

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

Alex Podelko

SEPTEMBER 8, 2020

Some time ago Federico Toledo published Performance Testing with Open Source Tools- Busting The Myths. Otherwise we wouldn’t see so many commercial tools built on the top of open source including BlazeMeter (it is ironic that the article is posted on the BlazeMeter site), Flood, and OctoPerf.

Open Source 223

Open Source Performance Testing Testing Performance 223

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 93

Open Source Best Practices Servers Database 93

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

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 123

Database Transportation Servers Cloud 123

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. respectively.

C++ 96

C++ Open Source Servers Database 96

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 103

Database Engineering Best Practices Open Source 103

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 93

Database Open Source Testing Design 93

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 91

Database Servers Open Source C++ 91

Percona

DECEMBER 2, 2022

Many community members joined Hacktoberfest this year and contributed to various open source projects, and we would like to highlight the most active contributors to Percona software during this fantastic event. Each of them will receive a T-shirt and a mug with a unique design. daniel-shuy fixed the database migration test.

Open Source 55

Open Source Azure Database Speed 55

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. Make sure you design the data types correctly while planning for the future growth of the table. ibd -rw-r --.

Open Source 91

Open Source Storage Database Big Data 91

Percona

JULY 25, 2023

Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. ibd in the test directory. For example, mysql datadir/test/t1.ibd. ibd2sdi data/test/t1.ibd ibd2sdi data/test/t1.ibd

Cache 89

Cache Benchmarking Servers Design 89

The Netflix TechBlog

OCTOBER 19, 2020

Now let’s look at how we designed the tracing infrastructure that powers Edgar. 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. This approach paints a richer observability portrait of application health.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 78

Open Source Database Storage Scalability 78

Testsigma

NOVEMBER 11, 2020

Having an effective test automation system is an absolute necessity in today’s agile software development environments. Automation works great, especially in case of smoke and regression tests and helps the QA teams to easily create and execute test cases that are complex in nature. Test Script Issues. Fixing Code Smell.

Testing 85

Testing Mobile Network Analytics 85

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. Connection id: 2 Current database: db1 + -+ -+ | id | username | + -+ -+ | 1 | user1 | | 2 | user2 | + -+ -+ 2 rows in set (0.01 Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00

Servers 113

Servers Storage Database Open Source 113

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). While originally designed to be a drop-in replacement for MySQL, it evolved into its own distinct database management system and is now maintained and supported by the MariaDB Foundation.

Open Source 52

Open Source Servers Storage Scalability 52

Percona

APRIL 28, 2023

We are a company of open source proponents. We’re also dedicated and active participants in the global open source community. Both open source and proprietary options have advantages. With open source database software , anyone in the general public can access the source code, read it, and modify it.

Open Source 116

Open Source Database Software Software 116

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

JUNE 20, 2023

In order to overcome these issues, the concept of paging and segmentation was introduced, where physical address space and virtual address space were designed. Paging This was designed to allow non-contiguous space allocation to processes. Enable core dump generation Every database has different methods to generate core dump files.

Programming 87

Programming C++ Database Virtualization 87

Percona

AUGUST 31, 2018

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. It is important to pay attention to performance when writing database queries. PostgreSQL’s Tuneable Parameters. shared_buffer.

Tuning 58

Tuning Database Performance Benchmarking 58

Testsigma

NOVEMBER 23, 2019

The concept of DevTestOps was introduced to put special focus on continuous testing for each step of the development process along with DevOps to produce quick, frequent and quality releases. DevTestOps is a combination of DevOps and Continuous Testing. Let us discuss about Continuous Testing.

Testing 52

Testing DevOps Open Source Mobile 52

Percona

JANUARY 5, 2023

Recently, we performed a database engine major version upgrade in one of our customers’ environments from MySQL 5.7.26 To begin with, we upgraded all the database nodes from 5.7.26 Physical backups are being taken using Percona XtraBackup (PXB) so it does not lock the database during the backup. With MySQL 5.7, from PXB 2.4.20.

Database 73

Database Servers Open Source Engineering 73

Percona

OCTOBER 5, 2023

Today’s businesses face two major challenges when it comes to managing databases: vendor lock-in of public cloud providers and the inherent complexity of running and managing databases. Furthermore, managing a myriad of databases across multiple environments poses a daunting task, requiring significant effort and resources.

Open Source 95

Open Source Social Media Database Media 95

Percona

APRIL 21, 2023

This could result from a mistake (the application wrote to a replica instead of writing to the source) or by design (you need additional tables for reports). 3306, I created a test database: mysql> create database test; Query OK, 1 row affected (0.00 Thus they only exist on a specific replica.

C++ 87

C++ Monitoring Database Open Source 87

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 91

Database Hardware Open Source Strategy 91

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

Testsigma

DECEMBER 28, 2019

During the entire SDLC phase, there are various kinds of testing performed at different stages. Each stage of testing has different objectives to fulfil. The testing phase starts with unit testing followed by integration testing, system testing, system integration testing, acceptance testing, and regression testing.

Testing 53

Testing Hardware Testing Tools Strategy 53

HammerDB

DECEMBER 5, 2020

Additionally both commercial and open source tools based on the specifications also continued to use TPC-C and TPC-H to describe these workloads. A full understanding of why this is important requires some knowledge of the evolution of database hardware and software. But why is this important?

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. The first one, written by Peter Zaitsev, was Installing MySQL with Docker.

Scalability 61

Scalability Best Practices Servers Database 61

Jos

JUNE 2, 2018

You will work hard on implementing features, collaborating with other teams (eg adding scripts for analytics, ads, retargeting, A/B test), setting up CI/CD, ensuring security, and making sure the project is usable and pleasant to the eye. And don’t forget about covering your back with tests.

Performance 237

Performance Speed Google Media 237

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 127

Database Servers Testing Programming 127

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 119

Database Open Source Traffic Small Business 119

Testsigma

OCTOBER 6, 2020

Test case management tools. A tester’s life moves around test cases and bugs. For management of test cases of different features the test case management tools are used. Some examples of test case management tools are: TestRail, Practitest, TestCollab. Test case generation tools. Test execution tools.

Java 65

Java Testing Tools Performance Testing Testing 65

Percona

OCTOBER 16, 2023

This software is under active development and at a very early stage of design and implementation. In the spirit of open and transparent communication, we would appreciate your feedback and invite PostgreSQL users to test the extension and provide feedback either via the GitHub repository or in the forum. What is TDE?

Open Source 115

Open Source Testing Database Design 115

O'Reilly

MAY 25, 2021

There have also been colorful conversations about whether GPT-3 can pass the Turing test, or whether it has achieved a notional understanding of consciousness, even amongst AI scientists who know the technical mechanics. Indeed, Google recently announced LaMDA , a model at GPT-3 scale that is designed to participate in conversations.

Social Media 138

Social Media Media Internet Internet 138