Download and Open Source - Technology Performance Pulse

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Scalegrid

JULY 13, 2020

The unstoppable rise of open source databases. One database in particular is causing a huge dent in Oracle’s market share – open source PostgreSQL. See how open source PostgreSQL Community version costs compare to Oracle Standard Edition and Oracle Enterprise Edition. What’s causing this massive shift?

Open Source

Open Source Tuning C++ Database

Debugging MySQL Core File in Visual Studio Code

Percona

OCTOBER 13, 2023

Visual Studio Code (VS) supports memory dump debugging via C/C++ extension: [link]. Installing c/c++ extension We need to install the c/c++ extension. ext install ms-vscode.cpptools Once we install the c/c++ extension, we can find it in extensions. Here are the instructions for doing so.

Code

Code C++ Storage Programming

Supporting Diverse ML Systems at Netflix

The Netflix TechBlog

MARCH 7, 2024

The Machine Learning Platform (MLP) team at Netflix provides an entire ecosystem of tools around Metaflow , an open source machine learning infrastructure framework we started, to empower data scientists and machine learning practitioners to build and manage a variety of ML systems.

Systems

Systems Media Cache Open Source

What the SEC cybersecurity disclosure mandate means for application security

Dynatrace

DECEMBER 5, 2023

Not only that, but the growing reliance on a complex software supply chain that includes homegrown, third-party, and open-source software makes it more difficult to manage risk throughout the software development lifecycle. How should C-level executives and boards of directors prepare for the SEC cybersecurity mandate?

Best Practices

Best Practices Government C++ Education

PostgreSQL Role Inheritance in Reverse: Discovering Descendant Roles in Reverse Gear

Percona

OCTOBER 4, 2023

As a result, both A and C directly inherit permissions from B and indirectly from D. As a result, both A and C directly inherit permissions from B and indirectly from D. In simpler language, we can view A and C as indirect descendants of D within the role hierarchy. Download Percona Distribution for PostgreSQL Today!

C++

C++ Open Source Tuning Database

Exploring the Improved CREATEROLE Attribute for User Management in PostgreSQL 16

Percona

DECEMBER 15, 2023

In PostgreSQL 15 and older versions postgres=#CREATE ROLE Alice CREATEROLE LOGIN; CREATE ROLE postgres=# CREATE role bob; CREATE ROLE postgres=# du bob List of roles Role name | Attributes | Member of --+ --+ -- bob | Cannot login | {} postgres=# c postgres alice You are now connected to database "postgres" as user "alice".

C++

C++ Database Open Source Systems

How to build HammerDB from source

HammerDB

MAY 26, 2022

Do you need to build from source? Before building from source, the first question should be, do you need to? HammerDB already provides pre-compiled packages from the download page so if you want to run HammerDB without building it then these packages are all you need. WHY build from source? Download HAMMERDB SOURCE.

C++

C++ Database Open Source Servers

MySQL 5.7 End of Life Six Months Away – Switch to Percona Server for MySQL Today!

Percona

MARCH 1, 2023

So you get the Umaluts, Cedils, and C-J-K Language support in your data, plus emojis. While you are downloading, please look at Percona Xtrabackup for MySQL and the Percona Toolkit. 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

Servers Open Source Tuning C++

Backup Mastery: Running Percona XtraBackup in Docker Containers

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

C++

C++ Open Source Servers Database

Streamline the SQL Code: Guide to pgFormatter

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. Download Percona Distribution for PostgreSQL Today! A powerful tool designed to beautify and standardize SQL code is pgFormatter. What is pgFormatter?

Code

Code Best Practices Open Source C++

Using MySQL Offline Mode To Disconnect All Client Connections

Percona

SEPTEMBER 29, 2023

50642 | NULL | Binlog Dump | 2129 | Source has sent all binlog to replica; waiting for more updates | NULL | 2129291 | 0 | 0 | | 14 | bhuvan | localhost | NULL | Query | 0 | init | show processlist | 0 | 0 | 0 | + -+ --+ + + -+ + --+ + + --+ + 3 rows in set (0.01 Download Percona Monitoring and Management Today

C++

C++ Servers Open Source Database

HammerDB for Managers

HammerDB

JUNE 27, 2022

As the TPC makes its specifications available for free, the need was seen for an open source benchmarking application that could leverage the standards written by the TPC yet implemented quickly, easily and at low cost by anyone. HammerDB maintains a web page under the stats link where the number of downloads can be tracked.

Benchmarking

Benchmarking Open Source C++ Cache

Extensibility in MySQL Is Easy

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. $ Plugin compiled.

C++

C++ Servers Benchmarking Best Practices

PostgreSQL Role Inheritance at a Glance

Percona

DECEMBER 22, 2022

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!

C++

C++ Database Open Source Monitoring

PostgreSQL Upgrade: Tricks With OID Columns and Extensions

Percona

APRIL 3, 2023

oid_test" SET WITHOUT OIDS; ALTER TABLE postgres=# c abs_test You are now connected to database "abs_test" as user "postgres". craft" SET WITHOUT OIDS; ALTER TABLE "public"."ports" ALTER TABLE "public"."oid_test" oid_test" SET WITHOUT OIDS; (1 row) Now we can execute the DDL to ALTER these tables. postgres=# ALTER TABLE "public"."oid_test"

C++

C++ Database Cache Storage

What To Do When a Data File in PostgreSQL Goes Missing

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

Hardware

Hardware C++ Database Open Source

How To Scale a Single-Host PostgreSQL Database With Citus

Percona

NOVEMBER 3, 2023

And now, execute the benchmark: -- execute the following on the coordinator node pgbench -c 20 -j 3 -T 60 -P 3 pgbench The results are not pretty. The default number of shards generated for a given table is 32. psql pgbench <<_eof1_ qecho adding node citus3. psql pgbench <<_eof1_ qecho adding node citus3.

Database

Database Benchmarking Latency C++

Platform Engineering Teams Done Right…

Adrian Cockcroft

FEBRUARY 9, 2023

The next layer is defined by the languages you want to use, Java, Python, Go, , Javascript, Rust etc, and the ecosystem of library functions you bought from a vendor or downloaded. Open source tools which have an open development model that allows your team to make contributions may be a better approach.

Engineering

Engineering Serverless Lambda AWS

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

Percona

DECEMBER 5, 2022

This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. 22 Percona Server (GPL), Release '22', Revision '7e301439b65' Copyright (c) 2009-2022 Percona LLC and/or its affiliates Copyright (c) 2000, 2022, Oracle and/or its affiliates. Type 'help;' or 'h' for help.

Open Source

Open Source C++ Servers Database

WiredTiger Logging and Checkpoint Mechanism

Percona

MARCH 28, 2023

wt list -c WiredTigerCheckpoint.33: Download Percona Distribution for MongoDB Today! 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. $

Hardware

Hardware C++ Storage Cache

Configuring PgBouncer for Multi-Port Access

Percona

JUNE 5, 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! 22 0.0.0.0:* LISTEN tcp 0 0 127.0.0.1:5432 5432 0.0.0.0:* LISTEN tcp 0 0 127.0.0.53:53

Database

Database Open Source Servers C++

How To Start Logical Replication in PostgreSQL for Specific Tables Based on a pg_dump

Percona

MAY 8, 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! Step 4: Pause replication on replica2::10.0.0.40

C++

C++ Servers Database Open Source

Using the Transparent Data Encryption Extension PG_TDE With PostgreSQL

Percona

DECEMBER 19, 2023

This, with some additional information, is what gets stored in the.tde file: hexdump -C /tmp/tdedata/postgresql/data/base/5/16397.tde This is open source software, and the old adage about having many eyeballs on the code to ensure its quality is applicable here, as Percona wants your input.

Open Source

Open Source Storage Database C++

Mobile app automation testing Tools: An exhaustive list

Testsigma

APRIL 23, 2021

Appium: Appium is one of the most preferred testing tools, especially by the open-source community. It also supports the testing of native, hybrid, and mobile web apps across various programming languages like Java, Ruby, C#, Javascript, PHP, Python. Being open-source, it also has a rich community! .

Testing Tools

Testing Tools Mobile Testing Open Source

Consequences of Forcing Bootstrap on Percona XtraDB Cluster

Percona

JUNE 28, 2023

C It fails, as it should. C It fails? Minimize unexpected downtime and data loss with a highly available, open source MySQL clustering solution. Download Percona XtraDB Cluster today With dbdeployer, this will translate to: $./sandboxes/pxc_msb_8_0_31/node1/stop Nightmare ensues We are a few days later.

C++

C++ Open Source Servers Monitoring

Configuring PostgreSQL and LDAP Using StartTLS

Percona

AUGUST 21, 2023

Download Percona Distribution for PostgreSQL Today! Even though there is an encrypted session between psql and the Postgres server, there is no encrypted session between Postgres and LDAP as authentication is performed: SSL connection (protocol: TLSv1.3,

C++

C++ Servers Open Source Testing

MariaDB vs MySQL: Key Differences and Use Cases

Percona

JUNE 4, 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. It continues to be developed and maintained by the open source community and remains free to use under the GNU General Public License.

Open Source

Open Source Servers Storage Scalability

Public Schema Security Upgrade in PostgreSQL 15

Percona

JUNE 28, 2023

postgres=# create database d1; CREATE DATABASE postgres=# postgres=# c d1 You are now connected to database "d1" as user "postgres". link] [link] 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.

Transportation

Transportation Database Open Source C++

Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor

Percona

DECEMBER 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. Download Percona Distribution for PostgreSQL Today! tps, lat 11.718 ms stddev 3.951 progress: 4440.0 Happy monitoring!

Benchmarking

Benchmarking Metrics C++ Database

Data Redundancy With the PostgreSQL Citus Extension

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

C++ Database Storage Testing

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Percona

JUNE 15, 2023

Download specific Percona Server for MySQL 8 tarball packages and install them manually. Install the curl download utility $ sudo apt install curl Reading package lists. Install the curl download utility $ sudo apt install curl Reading package lists. Type 'c' to clear the current input statement. Setting up curl (7.74.0-1.3+deb11u7).

Servers

Servers C++ Database Systems

Selenium and Mobile Test Automation – Can Selenium Be Used for Mobile Testing?

Testsigma

APRIL 28, 2021

million apps available for download There are 2.87 million apps available for download on the Google Play Store 21% of Millennials open an app 50+ times per day. We understand that Selendroid and Appium are open-source automation tools. It is open-source, hence free to use. Test Management.

Mobile

Mobile Testing Open Source Java

The Magic of PITR, pg_upgrade, and Logical Replication When Used Together for PostgreSQL Version Upgrades

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

Database

Database Traffic C++ Servers

Identify Active Databases and Users in MySQL

Percona

JANUARY 25, 2023

sudo grep Schema: /var/lib/mysql/mysql-slow.log| awk -F' ' '{print $4 $5}' | sort | uniq -c 2717 Schema:mytestdb 123 Schema:percona 762238 Schema:sbtest Example for 8.0 Download Percona Distribution for MySQL Today Now parse the output table_usage.log using the below command to identify unique database objects. $

Database

Database C++ Servers Open Source

How to Monitor Your MySQL Database Restore Progress

Percona

AUGUST 2, 2023

while true; do if [ -f /proc/<RESTORE_PID>/io ] then bytes_progress=$(cat /proc/<RESTORE_PID>/io | awk '/^rchar/ {print $2}') bytes_total=$(cat <BACKUP_FILE> | wc -c) progress=$(awk "BEGIN {printf "%.2f", Percona Monitoring and Management is a best-of-breed open source database monitoring solution.

Database

Database Monitoring C++ Speed

PostgreSQL Checkpoints, Buffers, and WAL Usage with Percona Monitoring and Management

Percona

NOVEMBER 9, 2023

For generating load, we used pgbench with the following commands: shell> pgbench -i -s 100 sbtest shell> pgbench -c 8 -j 3 -T $((60*60*4)) -N -S -P 1 sbtest Creating a custom query collector Note: This step will not be needed with soon-to-come postgresql_exporter PMM versions! Download Percona Monitoring and Management Today

Monitoring

Monitoring Tuning Metrics Servers

PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)

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. Download Percona Distribution for PostgreSQL Today! pg_partman creates and manages both time-based and serial-based table partition sets.

Storage

Storage Open Source Database Efficiency

5 Changes You Should Know in MongoDB 7.0

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

Metrics C++ Storage Database

Human Factors Behind Incidents: Why Settings Like “idle_session_timeout” Can Be a Bad Idea

Percona

DECEMBER 29, 2023

The point forgotten is that c onnections are owned by clients but maintained by a database. age=236s) 2023-11-14 16:17:40.533 UTC [4630] LOG C-0x10af130: postgres/pgbtestapp@[::1]:39470 closing because: server conn crashed? Download Percona Distribution for PostgreSQL Today! It’s like a bank account.

Servers

Servers Database C++ Airlines

Reactjs vs React Native – Differences, Advantages, and Disadvantages

Enprowess

MAY 24, 2022

Both are open-sourced frameworks using JavaScript. ReactJS is an open-source JavaScript library. React Native is an open-source JavaScript framework. Often, it becomes necessary to download another react-enabled library, which increases cost and time overheads. Facebook introduced both. What is React?

Mobile

Mobile Open Source Virtualization Speed

Percona Monitoring and Management and Datadog Integration

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

Monitoring Metrics Database Open Source

Streaming MongoDB Backups Directly to S3

Percona

FEBRUARY 23, 2023

join('n')") $ for i in $mycolls; do mongoexport -d $mydb -c $i |zstd| s3cmd put - s3://mbackups/$ts/$mydb/$i.json.zst; done 2023-02-07T19:30:37.163+0100 connected to: mongodb://localhost/ 2023-02-07T19:30:38.164+0100 [#######.] Download Percona Distribution for MongoDB today! ts=$(date +%Y-%m-%d.%H-%M) eu-central-2.wasabisys.com"}})

AWS

AWS Storage Database Open Source

Unleashing the Power of PostgreSQL Event-Based Triggers

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

Database Best Practices Open Source C++

HammerDB Concepts and Architecture

HammerDB

NOVEMBER 30, 2018

HammerDB is open source and all of the source code is available at the sourceforge Git development site here [link] or the github mirror here [link]. In fact all of this source code is also included in readable form with each and every release. These bin and lib directories are not included with the source code.

Architecture

Architecture Virtualization Open Source C++

PostgreSQL vs. Oracle: Difference in Costs, Ease of Use & Functionality

Debugging MySQL Core File in Visual Studio Code

Trending Sources

Supporting Diverse ML Systems at Netflix

What the SEC cybersecurity disclosure mandate means for application security

PostgreSQL Role Inheritance in Reverse: Discovering Descendant Roles in Reverse Gear

Exploring the Improved CREATEROLE Attribute for User Management in PostgreSQL 16

How to build HammerDB from source

MySQL 5.7 End of Life Six Months Away – Switch to Percona Server for MySQL Today!

Backup Mastery: Running Percona XtraBackup in Docker Containers

Streamline the SQL Code: Guide to pgFormatter

Using MySQL Offline Mode To Disconnect All Client Connections

HammerDB for Managers

Extensibility in MySQL Is Easy

PostgreSQL Role Inheritance at a Glance

PostgreSQL Upgrade: Tricks With OID Columns and Extensions

What To Do When a Data File in PostgreSQL Goes Missing

How To Scale a Single-Host PostgreSQL Database With Citus

Platform Engineering Teams Done Right…

Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price

WiredTiger Logging and Checkpoint Mechanism

Configuring PgBouncer for Multi-Port Access

How To Start Logical Replication in PostgreSQL for Specific Tables Based on a pg_dump

Using the Transparent Data Encryption Extension PG_TDE With PostgreSQL

Mobile app automation testing Tools: An exhaustive list

Consequences of Forcing Bootstrap on Percona XtraDB Cluster

Configuring PostgreSQL and LDAP Using StartTLS

MariaDB vs MySQL: Key Differences and Use Cases

Public Schema Security Upgrade in PostgreSQL 15

Grafana Dashboards: A PoC Implementing the PostgreSQL Extension pg_stat_monitor

Data Redundancy With the PostgreSQL Citus Extension

How to Install or Upgrade Percona Server for MySQL/MySQL 8 to a Specific Version on Debian/Ubuntu

Selenium and Mobile Test Automation – Can Selenium Be Used for Mobile Testing?

The Magic of PITR, pg_upgrade, and Logical Replication When Used Together for PostgreSQL Version Upgrades

Identify Active Databases and Users in MySQL

How to Monitor Your MySQL Database Restore Progress

PostgreSQL Checkpoints, Buffers, and WAL Usage with Percona Monitoring and Management

PostgreSQL Partitioning Made Easy Using pg_partman (TimeBased)

5 Changes You Should Know in MongoDB 7.0

Human Factors Behind Incidents: Why Settings Like “idle_session_timeout” Can Be a Bad Idea

Reactjs vs React Native – Differences, Advantages, and Disadvantages

Percona Monitoring and Management and Datadog Integration

Streaming MongoDB Backups Directly to S3

Unleashing the Power of PostgreSQL Event-Based Triggers

HammerDB Concepts and Architecture

Stay Connected