Percona

JUNE 29, 2023

When all data-bearing replica set members are available, and the index is created with default commitQuorum , below are the details from the Primary and the Secondary nodes. Status of nodes: rs1:PRIMARY> rs.status().members.forEach(function members.forEach(function (d) {print(d.name) + " " + print(d.stateStr)}); 127.0.0.1:27017

Servers 82

Servers C++ Storage Best Practices 82

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. Copyright (c) 2009-2023 Percona LLC and/or its affiliates Copyright (c) 2000, 2023, Oracle and/or its affiliates.

Database 97

Database Performance C++ Engineering 97

Percona

MARCH 13, 2023

Announcement I will be speaking at Percona Live 2023 about serverless PostgreSQL. Deploy pageserver docker run -d -t --name pageserver --net=host --entrypoint "pageserver" perconalab/neon:latest -D /data -c "id=1" -c "broker_endpoint='[link] -c "listen_pg_addr='0.0.0.0:6400'" 6400'" -c "listen_http_addr='0.0.0.0:9898'"

Serverless 120

Serverless C++ Storage Latency 120

Sutter's Mill

SEPTEMBER 28, 2023

Since the 2022-12-31 year-end mini-update and the 2023-04-30 spring update , progress has continued on cppfront. (If If you don’t know what this personal project is, please see the CppCon 2022 talk on YouTube for an overview, and the CppNow 2023 talk on YouTube for an interim update.) I hope to see many of you there!

C++ 89

C++ Cache Code Design 89

Percona

SEPTEMBER 15, 2023

In this blog, we’ll show you how to convert MariaDB binary log file and position-based replication to GTID replication. 200 OK Length: 36188 (35K) [application/octet-stream] Saving to: ‘mariadb_repo_setup’ 2023-08-30 14:42:51 (26.0 on REPLICA root@deb11m8s: nc -l -p 2222 | mbstream& -x -C /var/lib/mysql 2.2

Servers 102

Servers C++ Processing Testing 102

Dynatrace

DECEMBER 13, 2023

As 2023 shifts into the rearview mirror, technology and business leaders are preparing their organizations for the upcoming year. 5: Observability will become mission-critical for the C suite in the drive to support the organization’s sustainability and FinOps objectives. Technology prediction No.

Technology 205

Technology Technology Artificial Intelligence Analytics 205

Percona

JUNE 28, 2023

This blog post is a warning tale, an invitation to try yourself and break stuff (not in production, right?). C It fails, as it should. First error to notice: 2023-06-22T08:00:48.322148Z 0 [ERROR] [MY-000000] [Galera] It may not be safe to bootstrap the cluster from this node. C It fails? Why did it fail?

C++ 79

C++ Open Source Servers Monitoring 79

Adrian Cockcroft

FEBRUARY 9, 2023

Picture by Adrian — Ka’anapali sunset 2023 There’s been a lot of discussion about platforms recently, I talked about why I think it’s a current hot meme on the WTF Podcast with Charles Humble recently, and Sam Newman just wrote a blog post “ Don’t call it a platform ”.

Engineering 137

Engineering Serverless Lambda AWS 137

Scalegrid

FEBRUARY 15, 2024

MongoDB® SSL with Self-Signed Certificates in C# Configuring MongoDB Server for SSL/TLS Encryption Once your certificates are ready, the next step is configuring the MongoDB server for SSL/TLS encryption, allowing you to securely connect to MongoDB. Further reading: MongoDB SSL with Self-Signed Certificates in Node.js

Servers 130

Servers Best Practices Government Network 130

Percona

FEBRUARY 16, 2023

I asked ChatGPT the question: “C an we backup and then remove the keyring file used for encryption at rest plugin after MySQL starts? ” 2023-02-09T00:14:56.719139Z 1 [ERROR] [MY-012657] [InnoDB] Encryption can't find master key, please check the keyring is loaded. mysql> [ec2-user@ip-172-31-32-242 ~]$ sudo cat /var/log/mysqld.log.

Database 119

Database Servers Engineering Testing 119

Percona

APRIL 17, 2023

In this blog post, I’ll show you a simple example of collecting all rich data about databases using PMM and a way to send some of it to Datadog for general dashboards with main metrics to monitor. I have a command like: DD_API_KEY=2.6 1 Complete! openmetrics.d/conf.yaml

Monitoring 72

Monitoring Metrics Database Open Source 72

Testlodge

JULY 19, 2023

J-SOX and C-SOX are the Japanese and Canadian equivalents, respectively. 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. appeared first on TestLodge Blog. The post What is SOX Compliance Testing?

Testing 81

Testing Energy Programming Government 81

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. In this blog post, we will delve into the world of PostgreSQL performance tuning and establish some basic guidelines for setting database parameters to enhance the performance of your PostgreSQL database, based on the workload.

Tuning 52

Tuning Efficiency Database Performance 52

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 ). Discover the crucial MySQL setting that can optimize your database performance – check out our blog now !

Open Source 52

Open Source Servers Storage Scalability 52

Percona

MARCH 27, 2023

In this blog, we will talk about in what scenario you might face this error when restoring Oplog for PITR (point-in-time recovery). ‘ E11000 duplicate key error ’ is an error that you might have encountered during the restore process. sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1)

Games 96

Games Database Open Source C++ 96

Percona

AUGUST 29, 2023

There are two parts to this POC; Part A: Setup Part B: Redundancy demonstration Part A: POC setup Step one: Getting and installing Citus Referring to this earlier blog , you’ll see how to get and install Citus into your environment. citus_columnar | 11.1-1 1 citus | 11.1-1 1 = NODE: citus2 = extname | extversion -+ plpgsql | 1.0

C++ 81

C++ Database Storage Testing 81

Percona

MARCH 28, 2023

In this blog post, we will dive deep into WiredTiger’s Logging and Checkpoint mechanism. wt list -c WiredTigerCheckpoint.33: Every database system has to ensure durability and reliability. MongoDB uses classic Write-Ahead-Logging (WAL) using Journals and Checkpoints. Starting with the basics, why is WAL needed in the first place?

Hardware 89

Hardware C++ Storage Cache 89

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. zst 2023-02-07T19:33:58.138+0100 writing db2.products products to archive on stdout 2023-02-07T19:33:58.140+0100 writing db2.people

AWS 122

AWS Storage Database Open Source 122

Percona

JUNE 26, 2023

We have faced different levels of corruption related to databases in PostgreSQL.

Hardware 77

Hardware C++ Database Open Source 77

Percona

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. 2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 psql "host=localhost user=postgres options='-c synchronous_commit=off'" psql (14.8) And there could be conflicts. 20150623 (Red Hat 4.8.5-44),

Database 104

Database Servers Open Source Tuning 104

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. err 2023-07-10T05:26:42.521994Z 0 [System] [MY-010910] [Server] /usr/bin/mysqld: Shutdown complete (mysqld 8.0.19-10) 2023-07-10T05:26:48.210107Z 0 [System] [MY-010116] [Server] /usr/bin/mysqld (mysqld 8.0.19-10) Version: '8.0.19-10' Version: '8.0.19-10'

Programming 86

Programming Servers Database Hardware 86

Percona

SEPTEMBER 27, 2023

Cron scheduler 00 01,12 * * * psql -c “SELECT pg_partman.run_maintenance()” Advantages of pg_partman Using pg_partman, you can define data retention to automatically move data into archived partitions or drop the partition. I will provide a more detailed usage of pg_partman in upcoming blog posts.

Storage 101

Storage Open Source Database Efficiency 101

Percona

DECEMBER 5, 2023

Recently, I was reading a brilliant blog by Perconian David Gonzalez titled The 1-2-3 for PostgreSQL Logical Replication Using an RDS Snapshot , exploring the intricacies of setting up logical replication on Amazon RDS using RDS snapshots. 2023-11-08 05:31:06.030 UTC [108718] LOG: listening on IPv4 address "0.0.0.0", port 5433.

Database 78

Database Traffic C++ Servers 78

Percona

MARCH 8, 2023

The main objective of this blog post is to point out the new administrative connections allowed on MySQL 8, as these connections can save us from restarting the instance in case this happens. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement. Type 'help;' or 'h' for help.

C++ 95

C++ Database Servers Open Source 95

Percona

JUNE 7, 2023

In this blog post, we will explore using triggers on DDL events in PostgreSQL to implement custom logic and automate database management tasks. Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema.

Database 76

Database Best Practices Open Source C++ 76

Percona

AUGUST 17, 2023

This blog post will cover the basic setup of the InnoDB ClusterSet environment, which provides disaster tolerance for InnoDB Cluster deployments by associating a primary InnoDB Cluster with one or more replicas in alternate locations/different data centers. MySQL localhost:3308 ssl JS > c iroot@127.0.0.1:3308 Node ( 127.0.0.1:3311

C++ 78

C++ Availability Processing Database 78

Testsigma

APRIL 28, 2021

Below are few statistics that will give you an idea: Mobile applications are expected to generate over $935 billion in revenue by 2023 The Apple App Store has 1.96 It supports Selenium WebDriver compatible programming languages- Java, C#, Python, etc. appeared first on Testsigma Blog. are clients for Appium. Signup Now.

Mobile 69

Mobile Testing Open Source Java 69

Percona

MAY 2, 2023

This blog was originally published in September 2020 and was updated in May 2023. In this blog, we will be discussing different MongoDB database backup strategies and their use cases, along with pros and cons and a few other useful tips. We will be discussing more about Percona Backup for MongoDB in an upcoming blog post.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

AUGUST 25, 2023

This blog post will focus on failover and recovery scenarios inside the InnoDB Cluster and ClusterSet environment. 3308 ssl JS > c root@localhost:3308 MySQL localhost:3308 ssl JS > cluster1=dba.getCluster() MySQL localhost:3308 ssl JS > cluster1.status() MySQL 127.0.0.1:3308 3308": { "address": "127.0.0.1:3308",

Traffic 78

Traffic Database C++ Servers 78

Smashing Magazine

AUGUST 26, 2021

That comments system you can drop at the bottom of your blog? Most browsers have delivered excellent work towards preventing tracking on the Web, and the biggest holdout, Chrome, has promised change in 2023. That free widget to make it easy to share pages on social media? It’s probably a data broker. Still, things are looking up.

Social Media 134

Social Media Technology Technology Website 134