Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 85

Servers C++ Database Systems 85

Testsigma

APRIL 23, 2021

So, there’s a solid reason why mobile app testing is a crucial step in any app development process. To ensure our users get a seamless experience across any device — we perform mobile app testing. . That’s where mobile app automation testing comes into the picture. Best Mobile App Automation Testing Tools.

Testing Tools 86

Testing Tools Mobile Testing Open Source 86

Testsigma

APRIL 28, 2021

Selenium is a tremendously popular automated testing tool for desktop, web applications. Testing on mobile devices is a major requirement that has grown exponentially in recent years. Why has the mobile testing requirement grown so much? Thus, mobile application testing will play a crucial part here. Test Management.

Mobile 69

Mobile Testing Open Source Java 69

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

C++ Database Open Source Systems 96

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

MARCH 8, 2023

Your MySQL connection id is 144 Server version: 8.0.29-21 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. Your MySQL connection id is 144 Server version: 8.0.29-21 Commands end with ; or g.

C++ 96

C++ Database Servers Open Source 96

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

C++ Servers Storage Speed 107

Percona

JUNE 26, 2023

To restore, we can follow either of below approaches: If the standby server is there and the issue does not persist on that, then we can fix the issue by taking logical backup from the standby server, dropping the table on primary, and recreating it using the backup taken. Download Percona Distribution for PostgreSQL Today!

Hardware 77

Hardware C++ Database Open Source 77

Testlodge

MARCH 15, 2023

White box testing is a software testing approach based on an analysis of the internal structure of the component or system. Why is White Box Testing Performed? Testers perform white box testing for several reasons. Suppose developers perform unit testing before delivering code to testers.

Testing 83

Testing Testing Tools Java Programming 83

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

C++ Servers Open Source Testing 71

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

C++ Database Cache Storage 104

HammerDB

MAY 26, 2022

You may want to become familiar with all the underlying source code in C or wish to build a distribution where you can verify every single line of source code that goes into HammerDB. The build has been tested on x64 Red Hat 8.X The build has been tested on x64 Windows 10 and 11. Download HAMMERDB SOURCE.

C++ 113

C++ Database Open Source Servers 113

Percona

APRIL 21, 2023

Below is my current topology: [root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 Below is my current topology: [root@monitor ~]# orchestrator-client -c topology-tabulated -alias testcluster | tr '|' 't' 192.168.56.10:3306 3306 0s ok 5.7.41-44-log 3306 0s ok 5.7.41-44-log

C++ 86

C++ Monitoring Database Open Source 86

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 is open source software licensed under the. How to build HammerDB from source.

Benchmarking 62

Benchmarking Open Source C++ Cache 62

Percona

MAY 8, 2023

Lab environment – The lab environment contains below servers: One primary and two replicas running on Postgres version 12 One server running on PostgreSQL version 15 Server Details IP Address PostgreSQL Version Primary 10.0.0.25 The publication is now ready to replicate changes made to table1 on the primary server.

C++ 102

C++ Servers Database Open Source 102

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

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages? In this case, THP is enabled.

Database 90

Database Servers Open Source C++ 90

Percona

DECEMBER 29, 2023

Inadequate application-side pooling: Suboptimal application-side pooling can lead to opening a large number of connections, and they may remain open and unused, consuming valuable resources. These connections can accumulate, eventually exhausting server resources and causing the system to become unresponsive.

Servers 82

Servers Database C++ Airlines 82

Percona

NOVEMBER 3, 2023

PostgreSQL Cluster One coordinator node citus-coord-01 Three worker nodes citus1 citus2 citus3 Hardware AWS Instance Ubuntu Server 20.04, SSD volume type 64-bit (x86) c5.xlarge 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.

Database 107

Database Benchmarking Latency C++ 107

Percona

JUNE 5, 2023

The problem is you either don’t or can’t refactor your application servers; something, maybe, about not having enough time in the day. Scenario Configure the system such that Postgres resides on its default port of 5432 and PgBouncer sits on three ports, i.e., 6432, 6433, and 6433, accessing the resident Postgres server.

Database 122

Database Open Source Servers C++ 122

Percona

FEBRUARY 10, 2023

Percona XtraBackup is an open source hot backup utility for MySQL-based servers. version is affected by this, as per my tests. This feature is available in Percona Server for MySQL 5.6+. So for Percona Server for MySQL 5.7 versions only; Percona Server for MySQL/Percona XtraDB Cluster/MySQL 8.0

Storage 103

Storage Engineering Open Source Servers 103

Dynatrace

MAY 23, 2022

Shifting from monolith to microservices makes it easier to test, develop, and release innovative features more rapidly. C-level executives “must race to reinvent their organizations for the fast-paced, multiplied innovation world,” says Frank Gens, senior vice president and chief analyst at IDC. Server-side application.

Architecture 192

Architecture DevOps Monitoring Programming 192

Testsigma

APRIL 16, 2021

Android developers and testers perform mobile tests to deliver apps that drive a high user retention rate through a great user interface. While mobile automation tests are performed for Android, iOS, and Windows devices, in this post, we’ll dive into the UI frameworks for Android automation testing. The Importance Of UI Testing.

Testing 52

Testing Open Source Mobile Java 52

Percona

DECEMBER 5, 2022

This functionality is available in the free, open source Audit Plugin that is included in Percona Server for MySQL. The prerequisite for installing Percona’s Audit Log Plugin is to first install Percona Server for MySQL. Percona Server for MySQL is a drop-in replacement for MySQL. Commands end with ; or g.

Open Source 69

Open Source C++ Servers Database 69

Percona

DECEMBER 19, 2023

Since our previous blog post, Adding Transparent Data Encryption to PostgreSQL with pg_tde: Please Test , it received new features such as TOAST data encryption and HashiCorp Vault support for key storage. deb package, or as source code on github. tde 00000000 6d 61 73 74 65 72 2d 6b 65 79 00 00 00 00 00 00 |master-key.|

Open Source 85

Open Source Storage Database C++ 85

Percona

DECEMBER 5, 2023

Inspired by David’s insights, I embarked on a journey to explore logical replication from a different perspective – within the realm of on-premises server databases. Prerequisites A DB user with privileges to create the PUBLICATION on source and the SUBSCRIPTION on target. done server stopped 16.

Database 78

Database Traffic C++ Servers 78

Percona

JANUARY 25, 2023

During our tests, we observed that the above methods helped us identify the active databases; however, we sometimes had to use two or more ways to get the best result. This ensures that the statistics collection doesn’t cause any extra load on the server unless desired. Find the updated timestamp on datadir files.

Database 99

Database C++ Servers Open Source 99

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 92

Monitoring Tuning Metrics Servers 92

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? 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. Backup testing. ln -s /usr/local/Percona-Server-8.0.19-10-Linux.x86_64.ssl101/ 10-Linux.x86_64.ssl101.tar.gz

Programming 86

Programming Servers Database Hardware 86

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 101

Cache Database Virtualization Servers 101

Testsigma

NOVEMBER 18, 2021

Over the course of two decades, he has helped Fortune 500 companies implement Agile testing practices. He has also authored a number of books on quality engineering and test automation. When I started my career, automation was used for automating UI-based regression testing. This changes how teams test for quality.

Engineering 104

Engineering Social Media DevOps Azure 104

Smashing Magazine

JULY 18, 2022

Segmented Rendering is a new pattern for the Jamstack that lets you personalize content statically, without any sort of client-side rendering or per-request Server-Side Rendering. There are many use cases: personalization, internationalization, theming, multi-tenancy, A/B tests…. There was something he wanted to C.";

Cache 114

Cache Website Energy Servers 114

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

FEBRUARY 23, 2023

It is a common practice that before a backup can be stored in the cloud or on a dedicated backup server, it has to be prepared first locally and later copied to the destination. I used Wasabi in my tests as it offers very easy registration for a trial and takes just a few minutes to get started if you want to test the service.

AWS 122

AWS Storage Database Open Source 122

Percona

AUGUST 30, 2023

The most common parameter used by the PostgreSQL server (postmaster) will be PGDATA, which sets the parameter data_directory. Here is an example: $ export PGDATA=/home/postgres/data $ export PGPORT=5434 $ pg_ctl start waiting for server to start.2023-08-04 But changing this is possible only at the server startup.

Database 105

Database Servers Open Source Tuning 105

All Things Distributed

DECEMBER 1, 2016

I was joined by 32,000 James Bonds at the conference today from all around the world, and we introduced new services focused on accelerating this transformation across development, testing and operations, data and analytics, and computation itself. Transformation in Development, Testing, & Operations.

AWS 162

AWS Development Lambda Open Source 162

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). For HammerDB both TPROC-C and TPROC-H run all of their workloads on the database being tested in SQL. and the following from TPROC-H.

Programming 67

Programming Benchmarking Virtualization C++ 67