Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 PSMDB), the best practice to create an index was doing it in a rolling manner. Many folks used to create directly on Primary, resulting in the first index being created successfully on Primary and then replicated to Secondary nodes. Starting from PSMDB 4.4, Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function

Servers 84

Servers C++ Storage Best Practices 84

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 108

Servers C++ Storage Systems 108

Dynatrace

JULY 11, 2023

When working with logs originating from an out-of-the-box software such as Progress MOVEit Transfer, we can’t do much. What the software has been designed to log is what we get. This uncertainty is because they may not have collected enough logs, or the logs don’t contain enough information. ai and others.

Database 160

Database Government Games Servers 160

Percona

SEPTEMBER 19, 2023

This issue most often occurs when there is significant MySQL server activity during the backup operation, and the redo log file storage media operates faster than the backup storage media. Enabling redo log archiving on the server requires setting a value for the innodb_redo_log_archive_dirs system variable.

C++ 109

C++ Servers Storage Speed 109

Dynatrace

MAY 8, 2023

In fact, the Dynatrace 2023 CIO Report found that 78% of respondents deploy software updates every 12 hours or less. This demand for rapid innovation is propelling organizations to adopt agile methodologies and DevOps principles to deliver software more efficiently and securely. What is DevOps monitoring?

DevOps 222

DevOps Efficiency Monitoring Infrastructure 222

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. You can run multiple instances on a server to test your backups with the correct version and configs.

Programming 89

Programming Servers Database Hardware 89

Percona

JULY 17, 2023

MongoDB Community Edition software might set the stage for achieving your high-volume database goals, but you quickly learn that its features fall short of your enterprise needs. So you look at MongoDB Enterprise software, but its costly and complex licensing structure does not meet your budget goals. It ranks No.

Open Source 80

Open Source Database Scalability Software 80

Percona

DECEMBER 27, 2023

As we at Percona wind down 2023 and look into what the next year holds, our attention is drawn to the cloud-native landscape and how it is maturing, growing, and evolving. KubeCon NA 2023 recap The theme for KubeCon NA was very clear — AI and Large Language Models (LLMs). We expect that number to rise higher in 2024.

Cloud 83

Cloud Open Source Strategy Best Practices 83

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. The call for participation ends on March 2nd 23:59 SGT!

Performance 110

Performance Latency Cache Virtualization 110

Percona

JUNE 23, 2023

It is a good practice to compress the backups to save costs on storage and to encrypt the backups so those can’t be used if the files are compromised as long as you keep your encryption keys safe! If you have multiple CPUs on the server, you can increase the number of threads for each operation.

Servers 85

Servers Processing Speed Open Source 85

Percona

NOVEMBER 1, 2023

This blog was originally published in January 2021 and updated in November of 2023. The output is larger than for physical backup, particularly when saved in text format, but it can be compressed on the fly depending on the software you are using. on, you can use mysqlbinlog to stream binary logs from a remote server.

Best Practices 79

Best Practices Storage Strategy Database 79

Percona

AUGUST 17, 2023

PostgreSQL is open source relational database management software. In another survey, using multiple metrics for overall popularity, PostgreSQL ranks as the fourth most popular database management system ( DB-Engines, March 2023 ). What is PostgreSQL used for? Is PostgreSQL enterprise-ready?

Open Source 83

Open Source Healthcare Social Media Database 83

Percona

MAY 15, 2023

This operation is quite expensive but our database can run it in a few milliseconds or less, thanks to several optimizations that allow the node to execute most of them in memory with no or little access to mass storage. The key factor is that the whole data structure resides in the same location (node), facilitating the operations.

Traffic 128

Traffic Scalability Database Servers 128

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on.

Performance 140

Performance Latency Hardware Storage 140

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Despite all its upside, PostgreSQL software presents such challenges. PostgreSQL software supports synchronous streaming replication, asynchronous streaming replication, and logical replication.

Availability 88

Availability Open Source Architecture Database 88

Percona

AUGUST 29, 2023

A single command to deploy the operator would be: kubectl apply -f [link] --server-side Init SQL script Init SQL allows the creation of the database cluster with some initial data in it. In this case, the backups should be stored on some object storage. Please follow our installation instructions and use your favorite way.

Storage 99

Storage Database Media Open Source 99

Percona

JULY 24, 2023

PBM) introduced a GA version of incremental physical backups , which can greatly impact both the recovery time and the cost of backup (considering storage and data transfer cost). Snapshot backup/restore Technical Preview As already promised during Percona Live 2023, it’s my pleasure to deliver on that promise.

Availability 80

Availability Open Source Strategy Storage 80

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). MariaDB Server, on the other hand, is a fork of MySQL 5.5.

Open Source 52

Open Source Servers Storage Scalability 52

Brendan Gregg

FEBRUARY 28, 2023

My personal opinion is that I don't see a widespread need for more capacity given horizontal scaling and servers that can already exceed 1 Tbyte of DRAM; bandwidth is also helpful, but I'd be concerned about the increased latency for adding a hop to more memory. It was a great privilege.

Performance 52

Performance Latency Cache Virtualization 52

Percona

OCTOBER 18, 2023

The findings from our 2023 Open Source Database Report highlight that a substantial 42% of all database instances are now licensed through community-supported open source models, and GitHub reports that over 30% of Fortune 100 companies have established open source program offices (OSPO) to coordinate and manage their open source initiatives.

Open Source 96

Open Source Database Hardware Strategy 96

Percona

APRIL 10, 2023

In March 2023, we discovered an issue with physical backups, which, under certain conditions, can cause the restore to fail ( PBM-1058 ). includes this fix and was released on March 23, 2023. With PBM v2.0.0, the ability to take physical backups , in addition to logical ones, has been made Generally Available. as a technical preview.

Open Source 81

Open Source Storage Availability Processing 81

Percona

JUNE 6, 2023

This blog was originally published in January 2012 and was updated in June 2023. Increased Storage Requirements : One of the disadvantages of full backups is the increased storage requirements due to the fact that they capture a complete copy of all data and files. What is an incremental backup? What is an incremental backup?

Storage 68

Storage Strategy Network Efficiency 68

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. Also, we will take a look at our open-source backup utility custom-built to help avoid costs and proprietary software – Percona Backup for MongoDB or PBM. Logical backups such as mongodump are, in general, very time-consuming for large systems.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

JULY 1, 2023

This post was originally published in July 2018 and was updated in July 2023. Understanding DBaaS DBaaS cloud services allow users to use databases without configuring physical hardware and infrastructure or installing software. What are the differences between Aurora and RDS? How do I choose which one to use?

AWS 52

AWS Database Serverless Storage 52

Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. Reduced Resource Usage Optimizing resource-intensive queries and configurations can lead to a reduced burden on your server. An improperly configured server may not allocate sufficient resources or be optimized for the specific workload.

Tuning 52

Tuning Database Performance Hardware 52

Brendan Gregg

JULY 4, 2021

AWS Graviton2); for memory with the arrival of DDR5 and High Bandwidth Memory (HBM) on-processor; for storage including new uses for 3D Xpoint as a 3D NAND accelerator; for networking with the rise of QUIC and eXpress Data Path (XDP); and so on.

Performance 52

Performance Latency Hardware Storage 52

Percona

SEPTEMBER 1, 2023

This blog was originally published in October 2017 and was updated in September 2023. Sharding in MongoDB is a technique used to distribute a database horizontally across multiple nodes or servers, known as “shards.” MongoDB distributes data across these shard servers to ensure an even distribution.

Best Practices 75

Best Practices Traffic Database Servers 75

Sutter's Mill

MARCH 11, 2024

To talk about C++’s current safety problems and solutions well, I need to include the context of the broad landscape of security and safety threats facing all software. Software security ” (or “cybersecurity” or similar) means making software able to protect its assets from a malicious attacker.

C++ 139

C++ Programming Code Java 139

Percona

JULY 15, 2023

This blog was originally published in January 2022 and was updated in July 2023. is scheduled for October 21, 2023, signifying the end of updates and, crucially, the discontinuation of security fixes for identified vulnerabilities. How do indexes affect database storage and resource usage in MySQL 8.0? Indexes in MySQL 8.0

Virtualization 77

Virtualization Speed Database Efficiency 77

Enprowess

JANUARY 12, 2022

Other benefits: It has other benefits like a Quicker launch to the market, Easier distribution, saving device power and storage, seamless maintenance, and updating. Technology helps companies offer their software services to customers quickly, creating personalized experiences. Famous PWA Use Examples. Image Source. billion by 2025.

Blockchain 59

Blockchain IoT Development Serverless 59

Testsigma

JUNE 5, 2021

billion people are projected (by 2023) to keep this small device in their pockets and use it daily. There are two main reasons why people keep mobile browsers installed in their system even after storage issues. They are just software running on an operating system. In a world with a 7.5 billion population, 4.3 Conclusion.

Mobile 52

Mobile Testing Website Testing Tools 52

O'Reilly

JULY 25, 2023

I really wanted to go beyond these quick gut reactions that I’ve seen so much of online, so I tried using ChatGPT for a few weeks to help me implement a hobby software project and took notes on what I found interesting. or “ha look how incompetent it is … it couldn’t even get my simple question right!”

Programming 98

Programming Code Design Benchmarking 98