Percona

APRIL 28, 2023

Did you notice that Percona Server for MongoDB 6.0.5-4 One key to rule them all — improvements to master key rotation With the improvements introduced in Percona Server for MongoDB 6.0.5-4, 4, one key path can be used for all servers in a clustered environment. Changes introduced with Percona Server for MongoDB 6.0.5-4

AWS 100

AWS Servers Scalability Database 100

Dynatrace

OCTOBER 7, 2021

Serverless architecture shifts application hosting functions away from local servers onto those managed by providers. This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Scalability. Finally, there’s scalability.

Serverless 269

Serverless AWS Lambda Storage 269

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 109

Servers Best Practices Database Open Source 109

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 85

Database Hardware Open Source Strategy 85

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 74

Database Open Source Servers Code 74

Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. Offset-based involves utilizing functions such as skip , limit and a query which indicates how many documents should be skipped or returned at maximum.

Best Practices 130

Best Practices Efficiency Strategy Speed 130

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 333

Open Source Java Operating System Programming 333

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

DECEMBER 28, 2023

Starting with Percona Server for MySQL 8.0.34-26 You can filter events based on a user account, audit event class name, audit event subclass name, and audit event fields (database name, table name, operation status, and so on). A server restart is not required to add or adjust existing filtering rules.

Open Source 101

Open Source Database Servers Storage 101

Percona

DECEMBER 18, 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. Initially a standalone client for PMM Server, PMM Dump is now accessible in the PMM user interface.

Monitoring 84

Monitoring Open Source Servers Scalability 84

Percona

DECEMBER 6, 2022

Percona Server for MySQL 8.0.30-22 22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. Because of this, using the simple plugin with an SSL connection between the MySQL server and client should be preferred over the SASL plugin where possible.

Servers 66

Servers Open Source Scalability Availability 66

Percona

NOVEMBER 13, 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. Find more information in the Telemetry on Percona XtraDB Cluster document. 26 was released.

Innovation 83

Innovation Open Source Scalability Database 83

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. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 77

Open Source Azure Servers Programming 77

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. About YCSB.

Benchmarking 308

Benchmarking Latency C++ Database 308

Percona

APRIL 4, 2023

There is a list of the new reserved words later in this document that you need to review. If you try to use a reserved word, the server will not explicitly admonish you that you are trying to use a reserved word. Instead, the server informs you that you have a syntax error. Reserved words added to 8.0

Open Source 114

Open Source Database Servers Scalability 114

Percona

JUNE 20, 2023

Percona Operator for PostgreSQL offers a powerful solution for managing and scaling PostgreSQL databases in a Kubernetes environment, making it an ideal choice for developer use cases. I will use the regular kubectl approach: $ kubectl apply --server-side -f deploy/bundle.yaml Django application would require its own user and database.

Database 112

Database Open Source Engineering Efficiency 112

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. Percona XtraBackup 8.1

C++ 90

C++ Open Source Servers Database 90

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. The popularity of MongoDB MongoDB has emerged as a popular database platform. 5 among all database management systems and No. It ranks No.

Open Source 75

Open Source Database Scalability Software 75

Percona

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Jobs documentation has quite a few details for failure handling, retries, deadlines, etc. HaProxy was acting as a load balancer in front of the cluster. Commands end with ; or g.

Database 92

Database Performance C++ Engineering 92

Official Blog - World Web Technology

AUGUST 27, 2023

It is a server-side scripting language that is highly secure, open-source, and versatile. Mostly, web servers are created with PHP. In PHP, code is directly executed on the server and generates HTML to send to the client. Also, high-quality documentation is available for developers with any development issues and queries.

Development 98

Development Ecommerce Open Source Website 98

Percona

JULY 24, 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 July 10, 2023.

Open Source 72

Open Source Scalability Database Monitoring 72

Percona

FEBRUARY 24, 2023

In the Home Dashboard of PMM, a low CPU utilization on any of the database services that are being monitored could mean that the server is inactive or over-provisioned. Marked in red in Figure 1 is a server with less than 30% of CPU usage. Configuration of the CPU metrics can be changed in the dashboard.

Cloud 116

Cloud Serverless AWS Storage 116

Percona

APRIL 19, 2023

The Performance Shema now has a Server Telemetry Traces service. We are directed to the Server telemetry traces service section in the MySQL Source Code documentation The SSL library has been updated to OpenSSL version 1.1.1t. Hopefully, UTF8MB4 is good enough. This work started in 2020 and hopefully will be done soon.

Open Source 89

Open Source Servers Scalability Database 89

Percona

MARCH 8, 2023

Over the years of being a DBA, I had to deal with all kinds of problems in the database. Still, the users keep falling into this trap, maybe because of a poorly configured database, a change in the application components, or just because of a sudden increase of connections in the application. A lot has been written about this error.

C++ 91

C++ Database Servers Open Source 91

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. As said, the last one is probably the most powerful, scalable, and difficult to design, and unfortunately, it represents probably less than 5% of the solution currently deployed.

Traffic 122

Traffic Scalability Database Servers 122

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

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 97

Database Engineering Best Practices Open Source 97

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. Is MongoDB free to use?

Open Source 81

Open Source Programming Database Servers 81

Highly Scalable

MARCH 1, 2012

NoSQL databases are often compared by various non-functional criteria, such as scalability, performance, and consistency. At the same time, NoSQL data modeling is not so well studied and lacks the systematic theory found in relational databases. Document databases advance the BigTable model offering two significant improvements.

Database 279

Database Ecommerce Efficiency Engineering 279

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. How-to documentation is readily available.

Open Source 77

Open Source Healthcare Social Media Database 77

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. on, you can use mysqlbinlog to stream binary logs from a remote server.

Best Practices 77

Best Practices Storage Strategy Database 77

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 82

Availability Open Source Architecture Database 82

Percona

JULY 19, 2023

Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $ cd $HOME $ wget [link] $ tar -xvzf percona-server-8.0.32-24.tar.gz mkdir ~/percona-server-8.0.32-24/plugin/ulid/ 24/plugin/ulid/ $ cd ~/percona-server-8.0.32-24/plugin/ulid/

C++ 79

C++ Servers Benchmarking Best Practices 79

Percona

DECEMBER 12, 2022

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. This release is focused on the Percona Server for MySQL-based deployment variant. It is based on Percona Server for MySQL 8.0.30-22.

Open Source 61

Open Source Azure Servers Database 61

Percona

AUGUST 1, 2023

Source: “Meowing” attack completely destroyed more than 1000 databases These are the words of Bob Diachenko, one of the most respected cybersecurity researchers in relation to a “Meowing” attack, which destroyed between 1000-4000 databases around the world. MongoDB databases commonly exceed a terabyte of data.

Best Practices 40

Best Practices Transportation Open Source Traffic 40

Percona

SEPTEMBER 6, 2023

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is.

Speed 80

Speed Virtualization Storage Open Source 80

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40