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

OCTOBER 10, 2023

Your MySQL connection id is 256 Server version: 8.0.32-24.2 Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates. Type 'c' to clear the current input statement. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02

Database 92

Database Performance C++ Engineering 92

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

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++ 90

C++ Database Servers Open Source 90

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. for lib in $(psql -qtA pgbench -c"select extname||'.so'

C++ 81

C++ Open Source Database Programming 81

Percona

DECEMBER 29, 2023

Not everything can be addressed on the database side. These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive. Human factor: In an ideal case, there must be stringent restrictions and enforcement on what load and number of connections can be onboarded to the Database.

Servers 78

Servers Database C++ Airlines 78

Scalegrid

JUNE 18, 2019

In this blog, we’ll show you how to connect to a MongoDB server configured with self-signed certificates for SSL using both the Ruby MongoDB driver and the popular Object-Document-Mapper (ODM) mongoid. The connection options available for the driver are documented here , and the options we will need are: :ssl. ssl_verify.

C++ 100

C++ Servers Database Network 100

HammerDB

DECEMBER 5, 2020

compared to previous releases is that the workload names have changed from TPC-C and TPC-H to TPROC-C and TPROC-H respectively and therefore a key question is how are the v4.0 The simple answer is nothing, the workloads are exactly the same workloads derived from the TPC-C and TPC-H specifications and HammerDB v4.0

C++ 40

C++ Benchmarking Virtualization Open Source 40

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. while not overloading the CPU capacity on the production database. 0 document(s) failed to restore. %H-%M)/db2.zst

AWS 118

AWS Storage Database Open Source 118

Percona

JULY 19, 2023

Well, “easy” if you know just a tiny bit of C++. Our function will implement a ULID generator using a C++ library from ChrisBove/ulid. 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. $ mkdir ~/percona-server-8.0.32-24/plugin/ulid/

C++ 78

C++ Servers Benchmarking Best Practices 78

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? Why not just create another database on the same instance? 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. ln -s /usr/local/Percona-Server-8.0.19-10-Linux.x86_64.ssl101/

Programming 82

Programming Servers Database Hardware 82

Percona

JULY 5, 2023

Long database service downtime Some queries become slow Applications stop working due to incompatibilities Data loss This is what can happen if MySQL’s major upgrade to 8.0 You cannot load a dump of the MySQL system database from MySQL 8.0 Checking server version. Default database: 'test'. and restore to 5.7

C++ 114

C++ Database Servers Testing 114

Percona

MARCH 27, 2023

You might wonder why this error will come during PITR as the operations in the Oplog are idempotent, meaning they always result in the same change to the database no matter how many times they’re performed. I created a collection book with four documents with a unique compound index. sort({$natural:-1}).limit(1)

Games 91

Games Database Open Source C++ 91

Percona

AUGUST 21, 2023

While trying to be as complete yet succinct as possible, I’m detailing how to enable TLS between a PostgreSQL and the OpenLDAP server. Username accounts, but not passwords, are created on the Postgres server. Both username accounts and passwords are configured on the LDAP server. 0 ldap ldapserver=127.0.0.1

C++ 68

C++ Servers Open Source Testing 68

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. The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. But changing this is possible only at the server startup. 20150623 (Red Hat 4.8.5-44),

Database 99

Database Servers Open Source Tuning 99

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

SQL Performance

OCTOBER 9, 2019

The relevance to T-SQL is that sometimes we assume that we know everything there is to know about certain T-SQL features, and don't always bother checking the documentation to see if there's more to them. In my examples I'll use a sample database called TSQLV5. The EOMONTH function was introduced in SQL Server 2012.

C++ 111

C++ Database Servers Code 111

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “.

Servers 90

Servers Media Cache Storage 90

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. Stricter downgrade policy The upstream documentation highlights the following: Starting in MongoDB 7.0,

Metrics 98

Metrics C++ Storage Database 98

Percona

NOVEMBER 9, 2023

With this data, we’ll be able to better understand and tune our Postgres servers. The main idea is to be able to easily detect what the server is doing at any point in time so we can better understand how it reacts to the workload and tune accordingly. You can search the blog for more information on this if needed.

Monitoring 88

Monitoring Tuning Metrics Servers 88

HammerDB

JUNE 27, 2022

HammerDB is a software application for database benchmarking. It enables the user to measure database performance and make comparative judgements about database hardware and software. Databases are highly sophisticated software, and to design and run a fair benchmark workload is a complex undertaking. The HammerDB name.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

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

SQL Performance

JULY 1, 2021

There was the case where a colleague constantly promoted the deprecated backward compatibility view sys.sysprocesses instead of newer dynamic management views (DMVs), and another case where a different colleague took down a production server using SQL Server Profiler. name , [ Column ] = c. system_type_id <> c.

C++ 58

C++ Database Servers Performance 58

HammerDB

FEBRUARY 25, 2021

HammerDB is a load testing and benchmarking application for relational databases. All the databases that HammerDB tests implement a form of MVCC (multi-version concurrency control). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

HammerDB

OCTOBER 17, 2018

This is a very typical FAQ and although detailed in the documentation some extra details may help in sizing and configuration. For a really quick answer create a schema with 250-500 warehouses per server CPU socket for more details size as follows. .

C++ 40

C++ Testing Virtualization Cache 40

Percona

APRIL 17, 2023

Still, as DBA, you want to use Percona Monitoring and Management (PMM) for better database insights and maintain a common policy of Datadog as a standard alerting or high-level observability tool. We’ll use here “up” metrics for different databases to reflect database status. 1 Complete!

Monitoring 69

Monitoring Metrics Database Open Source 69

HammerDB

NOVEMBER 22, 2021

HammerDB included a graphical performance metrics view for the Oracle database only. HammerDB includes the same functionality for PostgreSQL enabling the user to drill down on database metrics in real time. usr/bin/install -c -m 644./pg_stat_statements--1.4.sql./pg_stat_statements--1.8--1.9.sql./pg_stat_statements--1.7--1.8.sql./pg_stat_statements--1.6--1.7.sql./pg_stat_statements--1.5--1.6.sql./pg_stat_statements--1.4--1.5.sql.

Metrics 62

Metrics Benchmarking C++ Database 62

HammerDB

NOVEMBER 30, 2022

If you need a different version of Python you can build HammerDB from source as detailed in the documentation to use any version of Python 3 that you wish. Copyright (C) 2003-2022 Steve Shaw. Copyright (C) 2003-2022 Steve Shaw. Red Hat Enterprise Linux. Starting the CLI in Python Mode. Type "help()" for a list of commands.

Virtualization 44

Virtualization C++ Lambda Monitoring 44

O'Reilly

DECEMBER 12, 2023

It may not be possible if you use a generative model configured as a chat server by itself. RAG takes your prompt, loads documents in your company’s archive that are relevant, packages everything together, and sends the prompt to the model. They make it possible to search for relevant or similar documents.) We have provenance.

Artificial Intelligence 101

Artificial Intelligence Media Google Processing 101

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. Instead, readers should refer to the HammerDB documentation.

Performance 54

Performance Benchmarking Cache Storage 54

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

SQL Performance

AUGUST 12, 2020

In my examples I’ll use a sample database called TSQLV5. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors. So it could be that the term originated in one of the database products and later adopted by some of the other database vendors.

C++ 140

C++ Code Design Database 140

SQL Performance

OCTOBER 29, 2019

There are multiple methods to look at poorly performing queries in SQL Server, notably Query Store, Extended Events, and dynamic management views (DMVs). In order to use Query Store and Extended Events, you have to configure them in advance – either enabling Query Store for your database(s), or setting up an XE session and starting it.

C++ 74

C++ Database Servers Tuning 74

Percona

DECEMBER 23, 2022

Patroni is one of the most used high availability (HA) solutions with the PostgreSQL database. This is one of the most used backup tool used for PostgreSQL databases. In this blog, we will integrate both of these tools and understand how they can work together to reduce the server load. 0 md5 - host replication all 0.0.0.0/0

Open Source 61

Open Source Servers Database Availability 61

Enprowess

SEPTEMBER 7, 2021

Software Developers got to use JavaScript CLI tools to create the back-end part of web applications or server-side. allows creating web application’s server-side or back-end components. is a server-side, open-source, JavaScript runtime environment that allows developers to write JavaScript on the client and the server-side.

Open Source 52

Open Source Virtualization Programming Servers 52

Percona

JANUARY 4, 2023

Recently I was working with a customer wherein our focus was to carry out a performance audit of their multiple MySQL database nodes. We started looking into the stats of the performance schema. I realized that it is important to understand the insights of the performance schema and how we can make effective use of it.

Performance 98

Performance C++ Monitoring Servers 98

HammerDB

APRIL 27, 2021

One of the first things you will want to do is make sure that we can access the 3rd party driver libraries for the database that we want to use. In this example we are using SQL Server so the message shows that everything is in order and we can proceed with running tests. Selecting a database. Select a database.

Virtualization 73

Virtualization Benchmarking Database Operating System 73