Percona

OCTOBER 20, 2023

Heck, typing “database migration plan” into Google and reading this blog could constitute planning. In brief, a proper database migration plan includes: Establishing clear objectives: Define what you want to achieve and how open source will get there. Use ETL (Extract, Transform, Load) tools to assist with this process.

Open Source 90

Open Source Database Best Practices Strategy 90

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. It’s a complex process involving various factors and meticulous planning. Flexibility and scalability Open source databases provide much greater flexibility regarding customization and configuration.

Open Source 94

Open Source Database Hardware Strategy 94

Percona

DECEMBER 14, 2023

I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. This streamlined process reduces the risk of errors and simplifies the downgrade procedure. implemented improved data integrity checks during the downgrade process.

Database 89

Database Artificial Intelligence Servers Operating System 89

Percona Community

JANUARY 8, 2023

If you need test data for the database of your project, you can get a dataset from Kaggle or use a data generator. In the first case, if you need to process the data before inserting it into the database, you can use Pandas, a widely used Python library for data analysis.

Database 82

Database Testing Processing 82

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 125

Database Servers Testing Programming 125

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 110

Availability Database Open Source Hardware 110

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 90

Database Hardware Open Source Strategy 90

Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. So it is only for debugging and testing purposes. The process of registering PMM in the Platform is described in the documentation.

Database 106

Database Open Source Monitoring Innovation 106

Percona

JANUARY 30, 2023

As Ibrar Ahmed noted in his blog post on Transparent Database Encryption (TDE). PostgreSQL is a surprising outlier when it comes to offering Transparent Database Encryption. If database files are copied or otherwise exposed in their raw form, exposure does not happen. Does PostgreSQL Need TDE (Transparent Data Encryption)?

Database 126

Database Storage Government Open Source 126

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

Percona

AUGUST 2, 2023

Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Monitoring the progress of the restore process is essential to estimate completion time and ensure everything is proceeding smoothly.

Database 84

Database Monitoring C++ Speed 84

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Feature-wise, it is up there with the best, if not the best.

Database 184

Database Open Source Storage Servers 184

Scalegrid

NOVEMBER 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. We’ve heard a lot about this rising database from the DBA community and our users, and decided to become a sponsor for this years Scylla Summit to learn more about the deployment trends from its users.

Big Data 187

Big Data Database Open Source Azure 187

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. Through this meticulous process, commits are accurately logged in their respective sequences.

Database 162

Database Strategy Servers Best Practices 162

DZone

MARCH 24, 2021

We typically understand software testing by the everyday definition of the word: making sure a piece of software performs the way it is supposed to in a production-like environment. For a complex distributed application with several external dependencies there is nothing that can beat a full end-to-end test. Or is there?

Design 193

Design Testing Software Performance Database 193

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 99

Database C++ Servers Open Source 99

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

Percona

JANUARY 29, 2024

PostgreSQL differs from certain other databases as it lacks a native solution to encrypt data on disk transparently. At Percona, we are in the process of developing PG_TDE, a tool designed to encrypt data using the AES-CTR encryption algorithm.

Testing 95

Testing Database Design Code 95

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. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database 166

Database Cloud Website Azure 166

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 87

Scalability Database Open Source Traffic 87

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 77

Open Source Database Storage Scalability 77

Dynatrace

APRIL 30, 2021

As organizations develop more applications and microservices, they are discovering they also need to run more performance tests in the same amount of time or less to meet service-level objectives (SLOs) that fulfill service-level agreements (SLAs). How can organizations address this process bottleneck and run more tests in less time?

Engineering 197

Engineering Testing Performance Performance Testing 197

Dynatrace

MAY 14, 2020

Dynatrace PurePath technology captures and analyzes transactions end to end across every tier of your application technology stack, from the browser all the way down to the code and database level. A Dynatrace Managed cluster may lack the necessary hardware to process all the additional incoming data. Impact on disk space.

Processing 152

Processing Hardware Traffic Storage 152

Percona

AUGUST 9, 2023

This upgrade has vastly improved the management and storage of metadata, resulting in better reliability and scalability for various database objects. The primary goal of the Transaction Data Dictionary (TDD) is to enhance the overall performance, stability, and scalability of MySQL databases. In MySQL 5.7,

Database 79

Database Storage Scalability Games 79

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read.

Database 106

Database AWS Network Design 106

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

Dynatrace

FEBRUARY 12, 2024

At the 2024 Dynatrace Perform conference in Las Vegas, Michael Winkler, senior principal product management at Dynatrace, ran a technical session exploring just some of the many ways in which Dynatrace helps to automate the processes around development, releases, and operation. Ensure seamless user journeys in every new release.

Engineering 179

Engineering Development Infrastructure Cloud 179

Testlodge

JULY 19, 2023

SOX compliance testing validates changes made to code and verifies adherence to internal controls. Testers are responsible for testing code changes to ensure accuracy. The overall intention of SOX testing is to protect stakeholders and other investors from corporate fraud. Audits can be internal or external.

Testing 81

Testing Energy Programming Government 81

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

Dynatrace

OCTOBER 10, 2023

Process Improvements (50%) The allocation for process improvements is devoted to automation and continuous improvement SREs help to ensure that systems are scalable, reliable, and efficient. A few avenues for elevating CI/CD pipelines are: Enhancing the extent of automated test coverage during the testing phase.

Engineering 222

Engineering DevOps Innovation Strategy 222

Dynatrace

JANUARY 5, 2022

Credits on content go to him and the work he has been doing around performance & resiliency testing automation. Our Application Performance Management (APM) and load test team at T-Systems MMS helps our customers reduce the risk of failed releases. Automation : Single load test executions can be repeated and tracked.

Testing 214

Testing Open Source Metrics Infrastructure 214

Scalegrid

FEBRUARY 1, 2024

MySQL is a popular open-source relational database management system for online applications and data warehousing. Because of this, preserving the availability and integrity of the data stored in MySQL databases requires regular backups. Having MySQL backups for your database can speed up and simplify the recovery process.

Best Practices 130

Best Practices Storage Strategy Database 130

Dynatrace

JANUARY 31, 2024

The RAG process begins by summarizing and converting user prompts into queries that are sent to a search platform that uses semantic similarities to find relevant data in vector databases, semantic caches, or other online data sources. Observing AI models Running AI models at scale can be resource-intensive.

Cache 201

Cache Azure Infrastructure Monitoring 201

Scalegrid

JULY 29, 2020

It uses only one process which makes it very lightweight. If we require N parallel connections, this forks N child processes. By default, there are 32 child processes that are forked. PgBouncer defines one pool per user+database combination. Pgpool-II defines one process per child process. Pooling modes.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Dynatrace

APRIL 10, 2023

Further, Tractor Supply’s transition to Kubernetes introduced many new processes—particularly regarding security. With Dynatrace deep cluster monitoring, “we were able to do upfront detection of security processes consuming higher CPU time on the cluster,” Bollampally said. Further, as Tractor Supply Co.

Cloud 168

Cloud Ecommerce Performance Retail 168

Scalegrid

JANUARY 8, 2024

Key Takeaways AI integration in cloud computing increases operational efficiency by automating processes, optimizing resource allocation, and improving scalability, leading to cost savings and allowing IT teams to concentrate on strategic initiatives. Discover how AI is reshaping the cloud and what this means for the future of technology.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

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