Percona

SEPTEMBER 1, 2023

This post was originally published in June 2020 and was updated in September 2023. MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database.

Tuning 52

Tuning Database Performance Hardware 52

Official Blog - World Web Technology

JUNE 13, 2023

A WordPress developer should also be good at various content management systems such as Joomla and Drupal. What are the responsibilities of a WordPress developer? It includes downloading and setting up the software on a server, database configuration, and theme and plugin installation. It will help you become a master of WordPress.

Development 52

Development Website Ecommerce Code 52

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

Cloud 76

Cloud Open Source Strategy Best Practices 76

Official Blog - World Web Technology

APRIL 12, 2023

Because WordPress is one of the most preferred content management systems to develop highly user-friendly, competitive, and dynamic websites. WordPress is a comprehensive content management system with thousands of free and paid themes and plugins to develop a full-fledged website or web app. Why WordPress?

Development 52

Development Website Ecommerce Programming 52

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? Is PostgreSQL enterprise-ready?

Open Source 76

Open Source Healthcare Social Media Database 76

Dynatrace

JUNE 7, 2023

According to the Kubernetes in the Wild 2023 report, “Kubernetes is emerging as the operating system of the cloud.” Kubernetes also gives developers freedom of choice when selecting operating systems, container runtimes, storage engines, and other key elements for their Kubernetes environments. Ease of use.

Open Source 207

Open Source Social Media Infrastructure Operating System 207

Percona

MAY 16, 2023

As a database administrator, have you ever been in a situation when your database confronted a brute force attack? The connection control plugin library allows administrators to introduce an increasing delay in the server response to connections after a designated number of consecutive unsuccessful login attempts. and Newer

Servers 116

Servers Database Monitoring Testing 116

O'Reilly

OCTOBER 31, 2023

Instead of predictions, I’d prefer to look at questions: what are the questions to which I’d like answers as 2023 draws to a close? In 2023, the struggle resumed. Kubernetes was designed for Google-scale deployments; but very few organizations need that. What are the unknowns that will shape 2024? We haven’t seen it.

Open Source 83

Open Source Google Software Architecture Technology 83

Percona

FEBRUARY 24, 2023

As a result, it becomes increasingly important to protect the confidentiality of information to prevent data leaks and facilitate easy access to relevant data sources and tools for the related teams without having to sift through unrelated databases or environmental data. to monitor and diagnose. +50

Metrics 103

Metrics Monitoring Database Engineering 103

Percona

NOVEMBER 1, 2023

This blog was originally published in August of 2021 and updated in November of 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.

Scalability 57

Scalability Best Practices Servers Database 57

O'Reilly

DECEMBER 12, 2023

This may be too much information, but this process generally works by generating “embeddings” for the company’s documentation; storing those embeddings in a vector database; and retrieving the documents that have embeddings similar to the user’s original question. However, that design issue isn’t germane to this discussion.

Artificial Intelligence 104

Artificial Intelligence Media Google Processing 104

Testlodge

JULY 19, 2023

Australia has initiated the Corporate Law Economic Reform Program Act (CLERP 9), and a United Kingdom version, UK SOx, is anticipated to roll out towards the end of 2023. IT Security – This control refers to the security of the systems and their data. J-SOX and C-SOX are the Japanese and Canadian equivalents, respectively.

Testing 81

Testing Energy Programming Government 81

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). What is MariaDB? Enhanced security is another advantage MariaDB.

Open Source 52

Open Source Servers Storage Scalability 52

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

Monitoring 83

Monitoring Open Source Servers Scalability 83

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 88

Open Source Database Hardware Strategy 88

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

Innovation 82

Innovation Open Source Scalability Database 82

Percona

AUGUST 21, 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 August 7, 2023.

Open Source 80

Open Source AWS Servers Database 80

KeyCDN

FEBRUARY 22, 2023

Here is a roundup of frontend web development trends to keep an eye on in 2023. PWAs are designed to work offline, be fast, and provide a seamless user experience across different devices. Motion UI Motion UI is a design trend involving animation and other interactive elements to create a more dynamic and engaging user experience.

Artificial Intelligence 111

Artificial Intelligence Development Serverless Website 111

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 120

Database Servers Testing Programming 120

Percona

MAY 29, 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 May 8, 2023.

Open Source 75

Open Source Servers Scalability Database 75

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. Unrestricted connection settings: Leaving connection settings, such as max_connections and per-user limits, wide open exposes the system to malicious Denial-of-Service (DoS) attacks. App-Dev often demands unrestricted, uncontrolled access to the database.

Servers 77

Servers Database C++ Airlines 77

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 72

Open Source Database Storage Scalability 72

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 81

Scalability Database Open Source Traffic 81

Percona

SEPTEMBER 25, 2023

PostgreSQL is a powerful and popular open source relational database management system. Ensuring the safety of your PostgreSQL data through regular backups is an important concern for database administrators. The /etc/pgbackrest/pgbackrest.conf file contains crucial information related to our primary database server.

Database 89

Database Open Source Storage Servers 89

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. That’s why it’s essential to implement the best practices and strategies for MongoDB database backups.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

OCTOBER 20, 2023

You can read part one here: Scalable Solutions With Percona Distribution for PostgreSQL: Set Up Three PostgreSQL Database Instances. Citus is an open-source extension for PostgreSQL that expands its capacity to manage databases of varying scales, ranging from individual nodes to extensively distributed database clusters.

Scalability 88

Scalability Database Open Source Systems 88

Dynatrace

JULY 11, 2023

What the software has been designed to log is what we get. The MOVEit vulnerability is a critical SQL injection flaw in the web application MOVEit Transfer , which MITRE published as CVE-2023-34362 on May 31, 2023. For example, if the database name is prepended or the table name has backticks around it.

Database 159

Database Government Games Servers 159

Percona

NOVEMBER 30, 2023

pgBackRest is the backup tool used to perform Postgres database backup, restoration, and point-in-time recovery (PITR). In this demonstration, it is assumed that the pgBackRest is already installed and configured on the dedicated backup node and configured to take backups from the remote database node.

Open Source 75

Open Source Database Processing Performance 75

Percona

OCTOBER 11, 2023

Atlas atlas-mhnnqy-shard-0 [primary] test> To install MongoShake, follow these steps: Step 1: Install Go Ensure that Go is installed on your system. Below is the sample log when you start MongoShake: [2023/09/25 21:09:13 UTC] [INFO] New session to mongodb+srv://gautam: @cluster0.teeeayh.mongodb.net/ cd MongoShake.

Database 83

Database Open Source Testing Servers 83

Percona

DECEMBER 14, 2023

s, system: 0.01 s, system: 0.01 s, system: 0.01 Percona Distribution for PostgreSQL provides the best and most critical enterprise components from the open-source community, in a single distribution, designed and tested to work together. Create a logical replication slot on the primary node. s, elapsed: 1638.50

Servers 74

Servers Open Source Database Systems 74

Percona

JANUARY 30, 2023

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. Today’s post includes those releases and updates that have come out since January 9, 2023. was made available on January 23, 2023.

Open Source 80

Open Source Storage AWS Cloud 80

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 73

Open Source Database Scalability Software 73

Percona

OCTOBER 3, 2023

In database management, job scheduling has always played an important role. However, there is another job scheduler called pg_timetable, which is completely database-driven and provides a couple of advanced concepts. Download and install GO on your system. Local installation, i.e., build from sources.

Open Source 75

Open Source Database Servers Programming 75

Percona

AUGUST 30, 2023

This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. cat /usr/lib/systemd/system/postgresql-14.service. 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 That is where all “ALTER SYSTEM SET/RESET” commands keep the information.

Database 97

Database Servers Open Source Tuning 97

Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL. Though it is not at all recommended to touch the / data / base / directory and go through files under this / var / lib / postgresql / 14 / main / base / , however, sometimes it happens.

Hardware 73

Hardware C++ Database Open Source 73

Percona

AUGUST 18, 2023

Why not just create another database on the same instance? We split databases by function/team to give each team full autonomy over their schema, And if someone screws up, it breaks their cluster, not all databases. So you put multiple MySQL servers on a single machine instead of multiple databases inside one MySQL instance.

Programming 82

Programming Servers Database Hardware 82

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 108

Open Source Database Software Software 108