Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! Copyright (c) 2016, 2023, Oracle and/or its affiliates.

C++ 124

C++ Servers Storage Speed 124

Percona

MARCH 1, 2023

has had a good, long run, but the official End of Life is October of 2023. So you get the Umaluts, Cedils, and C-J-K Language support in your data, plus emojis. Free from locked-in licenses or commercial upsells, our products are open source, enterprise-ready, and backed by 24/7 support and on-demand services.

Servers 133

Servers Open Source Tuning C++ 133

Sutter's Mill

JULY 29, 2024

Safety and simplicity are the two core things I want to try to dramatically improve in C++, and are why I’m doing my cppfront experiment, so although the above absorbed some time away from cppfront coding it all contributes to the same goal. (If Jul 10, 2024), new things include: Added. Jul 10, 2024), new things include: Added.

C++ 116

C++ Lambda Code Open Source 116

Percona

MARCH 13, 2023

On the replica mysql8 server, run: [root@mysql8 ~]# nc -l -p 2222 | unpigz -c | xbstream -x -C /var/lib/mysql The above command would be there to receive the backup until the stream copy was done. 2023-03-01T04:28:38.397836Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.31-23) On primary server mysql5.7,

Servers 122

Servers C++ Storage Systems 122

Percona

JUNE 26, 2023

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. If we have a table-level logical backup, then we can restore the “test” table backup, and our database will be in good shape.

Hardware 98

Hardware C++ Database Open Source 98

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 98

Servers C++ Storage Best Practices 98

Percona

MARCH 28, 2023

wt list -c WiredTigerCheckpoint.33: These checkpoints are stored in WiredTiger.wt The above diagram shows the information present in a checkpoint, while the below output shows how it looks when listed using the “wt” utility. $ MongoD attempts to go into crash recovery and looks for anything there in the Journal files.

Hardware 111

Hardware C++ Storage Cache 111

Percona

AUGUST 29, 2023

Step three: Check packages Inspecting the nodes confirms Citus has been correctly installed: for u in citus1 citus2 citus3 citus4 citus-coord-01 do echo " = NODE: $u =" lxc exec $u -- su - postgres -c 'psql db01'<<_eof_ select extname, extversion from pg_extension; _eof_ done | less -S = NODE: citus1 = extname | extversion -+ plpgsql | 1.0

C++ 98

C++ Database Storage Testing 98

Percona

AUGUST 16, 2023

pgFormatter is an open source utility that takes SQL code as input and outputs beautifully formatted, indented, and aligned SQL code following a set of predefined rules. A powerful tool designed to beautify and standardize SQL code is pgFormatter. What is pgFormatter? Download Percona Distribution for PostgreSQL Today!

Code 98

Code Best Practices Open Source C++ 98

Percona

OCTOBER 10, 2023

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. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement. 2023-07-26T12:22:43 Analyzing new table.

Database 114

Database Performance C++ Engineering 114

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 136

Engineering Serverless Lambda AWS 136

Percona

OCTOBER 17, 2023

Percona Distribution for MongoDB is a freely available MongoDB database alternative, giving you a single solution that combines the best and most important enterprise components from the open source community, designed and tested to work together. Download Percona Distribution for MongoDB Today!

Metrics 120

Metrics C++ Database Storage 120

Percona

JUNE 15, 2023

20 Percona Server (GPL), Release '20', Revision 'fd4b5a776a6' Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement. Your MySQL connection id is 8 Server version: 8.0.28-20

Servers 98

Servers C++ Database Systems 98

Percona

DECEMBER 29, 2023

The point forgotten is that c onnections are owned by clients but maintained by a database. Despite being tailored for PostgreSQL, pgBouncer is not immune to sudden connection terminations: 2023-11-14 16:17:21.967 UTC [4630] WARNING S-0x10b7940: postgres/authuser@127.0.0.1:5432 It’s like a bank account.

Servers 107

Servers Database C++ Airlines 107

Percona

MARCH 8, 2023

21 Percona Server (GPL), Release 21, Revision c59f87d2854 Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement. Type 'c' to clear the current input statement.

C++ 114

C++ Database Servers Open Source 114

Percona

JUNE 7, 2023

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. Download Percona Distribution for PostgreSQL Today!

Database 109

Database Best Practices Open Source Testing 109

Percona

AUGUST 18, 2023

er tail: cannot open ‘/data/mysql/prod3306.er’ 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) er tail: cannot open ‘/data/mysql/prod3306.er’

Programming 98

Programming Servers Database Open Source 98

Percona

SEPTEMBER 27, 2023

PostgreSQL Partition Manager — ‘pg_partman’ — is an open source extension freely available, widely supported, and actively maintained by the PostgreSQL community. pg_partman creates and manages both time-based and serial-based table partition sets.

Storage 114

Storage Open Source Database Efficiency 114

Percona

AUGUST 30, 2023

2023-08-04 06:53:09.637 UTC [5787] LOG: starting PostgreSQL 15.3 44), 64-bit 2023-08-04 06:53:09.637 UTC [5787] LOG: listening on IPv6 address "::1", port 5434 2023-08-04 06:53:09.637 UTC [5787] LOG: listening on IPv4 address "127.0.0.1", port 5434 2023-08-04 06:53:09.639 UTC [5787] LOG: listening on Unix socket "/tmp/.s.PGSQL.5434"

Database 120

Database Servers Open Source Tuning 120

Percona

APRIL 17, 2023

DD_SITE="datadoghq.eu" bash -c "$(curl -L [link] After execution, I can see the logs of Datadog agent installation and configuration and at the end: Installed: datadog-agent.x86_64 1:7.43.1-1 Percona Monitoring and Management is a best-of-breed open source database monitoring solution. I have a command like: DD_API_KEY=2.6

Monitoring 98

Monitoring Metrics Database Open Source 98

Percona

OCTOBER 2, 2023

Percona Toolkit is a collection of advanced open source command-line tools, developed and used by the Percona technical staff, that are engineered to perform a variety of MySQL, MariaDB, MongoDB, and PostgreSQL server and system tasks that are too difficult or complex to perform manually. And did I mention they are open source?!

Cache 114

Cache Database Virtualization Servers 114

Sutter's Mill

DECEMBER 31, 2022

117 issues (3 open), 74 pull requests (9 open), 6 related projects, and new collaborators I started cppfront with “just a blank text editor and the C++ standard library.” Support today’s C++ (Cpp1) multi-token fundamental types (e.g., All I did was change the default to enable them.

C++ 76

C++ Lambda Open Source Design 76

Percona

DECEMBER 5, 2023

p 5432 -S slot_logical_upgrade -R -c fast -Xs -P -D /data/PG12_new -C 32610/32610 kB (100%), 1/1 tablespace 8. 2023-11-08 05:31:06.030 UTC [108718] LOG: listening on IPv4 address "0.0.0.0", port 5433. Create a REPLICATION SLOT Create a replication slot to capture changes. pg_basebackup -h 127.0.0.1 -p

Database 103

Database Traffic C++ Servers 103

Percona

AUGUST 17, 2023

MySQL localhost:3308 ssl JS > c iroot@127.0.0.1:3308 3308 ssl JS > c iroot@127.0.0.1:3311 3311 ssl JS > c iroot@localhost:3308 MySQL localhost:3308 ssl JS > cluster1 = dba.getCluster(); MySQL localhost:3308 ssl JS > cluster1.setupRouterAccount('router_usr') Node ( 127.0.0.1:3311 3308 MySQL 127.0.0.1:3308

C++ 98

C++ Availability Processing Database 98

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 million apps available for download on the Google Play Store 21% of Millennials open an app 50+ times per day. It is open-source, hence free to use.

Mobile 69

Mobile Testing Open Source Java 69

Percona

JUNE 4, 2023

This blog post was originally published in November 2017 and was updated in June 2023. MariaDB is a popular SQL open source relational database management system that originated as a fork of MySQL after MySQL was acquired by Sun Microsystems in 2008 and later Oracle in 2010. What is MariaDB? Contact us to learn more!

Open Source 52

Open Source Servers Storage Scalability 52

Percona

AUGUST 25, 2023

3311", "receiverStatus": "ON", "receiverThreadState": "Waiting for source to send event", "source": "127.0.0.1:3308" 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 98

Traffic Database Servers C++ 98

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload. Default values are set to ensure that PostgreSQL runs everywhere, with the least resources it can consume, and so that it doesn’t cause any vulnerabilities.

Tuning 52

Tuning Database Efficiency Performance 52

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. You can find more information about Percona Server for MongoDB Hot Backup here.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

MARCH 27, 2023

sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1) sort({$natural:-1}).limit(1)

Games 107

Games Database Open Source C++ 107

Percona

JUNE 28, 2023

2023-06-22T08:23:29.003334Z 0 [ERROR] [MY-000000] [Galera] gcs/src/gcs_group.cpp:group_post_state_exchange():433: Reversing history: 171 -> 44, this member has applied 127 more events than the primary component.Data loss is possible. C It fails, as it should. C It fails? Why did it fail? You are still writing to your node.

C++ 98

C++ Open Source Servers Monitoring 98

Sutter's Mill

JANUARY 2, 2025

. (*) But because it will take time and effort for the world to adopt any solution that requires making source code changes, I wondered how much of the safety we might be able to get, at what overhead cost, just by recompiling existing code in a way that instruments ordinary union objects?

C++ 69

C++ Cache Programming Code 69