Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 82

Open Source Azure Servers Programming 82

Testsigma

APRIL 4, 2022

A common theme among most software testing organizations is their escalating interest in Test Automation. While test automation has grown in popularity, there are still many myths and biases surrounding it. Such myths can unknowingly create a self-limiting boundary and negatively impact the possibilities of test automation.

Testing 95

Testing Open Source IoT Programming 95

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 74

Servers Database Testing Open Source 74

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

C++ Open Source Servers Database 95

Percona

OCTOBER 17, 2023

MySQL Clone plugin simplifies new replica provisioning but does not simplify server restore after failure unless you are ready to re-install your MySQL instance from scratch. Since you decided to clone a replica from another server, you agreed to lose your current data. After that, start the server.

Open Source 101

Open Source Servers Database Strategy 101

Percona

JULY 10, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Take a look! Percona Monitoring and Management 2.38 was released.

Monitoring 79

Monitoring Open Source Scalability Database 79

Percona

APRIL 20, 2023

It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8.

Open Source 93

Open Source Best Practices Servers Database 93

The Netflix TechBlog

MARCH 5, 2019

Challenges & Opportunities in the Infra Data Space Security Events Platform for Anomaly Detection How can we develop a complex event processing system to ingest semi-structured data predicated on schema contracts from hundreds of sources and transform it into event streams of structured data for downstream analysis?

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

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

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

The Netflix TechBlog

MAY 21, 2019

using RL agents for test case scheduling By: Stanislav Kirdey , Kevin Cureton , Scott Rick , Sankar Ramanathan Introduction Netflix brings delightful customer experiences to homes on a variety of devices that continues to grow each day. Detect a regression in a test case. These problems could be solved in several different ways.

Testing 163

Testing AWS Lambda Network 163

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 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Advantages of migrating to open source For many reasons mentioned earlier, organizations are increasingly shifting towards open source databases for their data management needs.

Open Source 94

Open Source Database Hardware Strategy 94

Percona

NOVEMBER 6, 2023

Also deprecated is the use of % by the server as a synonym for localhost when checking privileges. Group replication relaxation Group Replication gets relaxed as version requirements for groups are relaxed beginning with this release: A server running any MySQL 8.0 In the cases of MySQL servers 8.0.35 release of version 8.0.35

Open Source 113

Open Source Database Servers Scalability 113

Percona

MARCH 27, 2023

On MySQL and Percona Server for MySQL , there is a schema called information_schema (I_S) which provides information about database tables, views, indexes, and more. The same tests have been executed in Percona Server for MySQL 5.7 Setup The setup consists of creating 10K tables with sysbench and adding 20 FKs to 20 tables.

Cache 104

Cache Hardware Servers Benchmarking 104

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

AUGUST 17, 2023

PostgreSQL is open source relational database management software. It has evolved steadily, however, during 25 years as an open source project. Another reason for PostgreSQL popularity (perhaps the biggest): It’s open source and free to use, distribute, and modify. What is PostgreSQL used for?

Open Source 80

Open Source Healthcare Social Media Database 80

Percona

SEPTEMBER 12, 2023

this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. This counter value is stored in memory and is not persistent across server restarts. Compared to MySQL 5.7, sec) Query OK, 1 row affected (0.00 Trying to reconnect.

Servers 113

Servers Storage Database Open Source 113

Percona

FEBRUARY 13, 2023

Recently, I was working with my colleagues Edwin Wang and Taras Onishchuk and found an interesting edge case involving a situation where a replica running Percona Server for MySQL 5.7 , external to AWS Aurora instance version 2.10.2 (5.7-compatible), Query: 'create database test' The interesting thing to note here is the character set ‘#255’.

AWS 92

AWS Database Open Source Servers 92

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

AUGUST 18, 2023

I tried the in-place upgrade on my test VM for my own curiosity and got some redo log format errors/Data Dictionary errors. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine. 2023-05-12T08:10:39.374389Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.

Open Source 67

Open Source Database Storage Engineering 67

Percona

OCTOBER 13, 2023

Let’s test it with InnoDB using the ibd2sdi tool. root@db3-node test]# ibd2sdi transaction_processing_flag.ibd -d transaction_processing_flag.sdi [root@db3-node test]# ls -lrth | grep transaction_processing_flag -rw-r --. 1 mysql mysql 0 Sep 18 08:15 test_table.MYD [root@db3-node test]# RocksDb also supports SDI.

Storage 96

Storage Database Engineering Open Source 96

Official Blog - World Web Technology

NOVEMBER 9, 2023

PHP is a language that has weathered the test of time and is still frequently used by web developers. PHP is a popular server-side programming language due to its simplicity of use, vast functionality, and robust community support. Regarding command-line and server-side scripts, PHP is easy for users to understand and use.

Website 59

Website Development Open Source Database 59

Percona

JULY 27, 2023

is an evolution of the MySQL server and related software. The statements include ALTER TABLE, ANALYZE TABLE, CACHE INDEX, CHECK TABLE, CREATE INDEX, CREATE TABLE, DROP INDEX, LOAD INDEX, OPTIMIZE TABLE, REPAIR TABLE, TRUNCATE TABLE, DROP TABLE, and any open cursors. Do you have suspicious group replication servers showing up?

Servers 84

Servers Open Source Tuning Cache 84

Percona

SEPTEMBER 26, 2023

When a delete or update operation is executed on the primary database, affecting multiple rows, it may execute swiftly on the primary server. However, this action can introduce delays on replica servers due to the need to scan each modified row. Let’s test this. Let’s test this. Default database: 'test'.

Database 103

Database Engineering Best Practices Open Source 103

Percona

AUGUST 10, 2023

You will get the following error: percona labs MySQL 8.0.34 > alter user 'test'@'localhost' identified by 'Test@321'; ERROR 3892 (HY000): Current password needs to be specified in the REPLACE clause in order to change it. Creating a test environment I have installed the MySQL 8.0.34

Open Source 81

Open Source Testing Database Servers 81

KeyCDN

AUGUST 15, 2019

Web performance is a broad subject, and you’ll find no shortage of performance testing tips and tutorials all over the web. What is Performance Testing? In the context of web development, performance testing entails using software tools to simulate how an application runs under specific circumstances.

Testing Tools 55

Testing Tools Best Practices Performance Testing Testing 55

Percona

DECEMBER 12, 2023

Sometimes, the replica server might have replication errors, and the replica might be out of sync with the primary. In this case, we can use Percona Toolkit’ s pt-table-checksum and pt-table-sync to check the data drift between primary and replica servers and make the replica in sync with the primary.

Servers 93

Servers Database Testing Open Source 93

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. about to fork child process, waiting until server is ready for connections. connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb

Scalability 60

Scalability Best Practices Servers Database 60

Percona

MARCH 21, 2023

If REQUIRE ROW FORMAT is enabled, row-based binary logging (binlog format=ROW) is required on the source server. Configure REQUIRE_ROW_FORMAT mysql> STOP REPLICA; mysql> CHANGE REPLICATION SOURCE TO REQUIRE_ROW_FORMAT = 1; mysql> START REPLICA; 1 row in set (0.00

Storage 89

Storage Open Source Database Engineering 89

Testsigma

MARCH 23, 2021

It is open source and its development can be ported across devices with relative ease. And, precisely due to this diversity, the need for testing on many devices is paramount. With the ever-increasing and evolving sector of Android users, Android device testing is of the essence. . Why Is Android Device Testing Important?

Testing 52

Testing Mobile Testing Tools Strategy 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

MARCH 3, 2023

23] (Slave_delay: 0) This means the following: A primary server, with Percona Server for MySQL installed (in Read/Write mode) version 8.0.31-23. Check the database’s topology, whether one or more servers were replicating, if it was a Percona XtraDB Cluster , etc. mysqlserver01=127.0.0.2 [RW] RW] [ver: 8.0.31-23]

Database 102

Database Testing Servers Open Source 102

Percona

AUGUST 3, 2023

The simple idea is that you can make an index invisible to the optimizer in order to test the performance of a query if that index did not exist. Rebuilding an index could require a lot of time and overloading the server, depending on the size of the table. The great advantage is that you don’t need to drop the index.

Best Practices 79

Best Practices Open Source Code Engineering 79

Percona

APRIL 21, 2023

3306, I created a test database: mysql> create database test; Query OK, 1 row affected (0.00 So with injecting an empty transaction, the Orchestrator will inject the empty transaction from the top, it will replicate to the bottom, and that GTID will be ignored by the replica server, which already has it. 3306 0s ok 5.7.41-44-log

C++ 86

C++ Monitoring Database Open Source 86

Tech News Gather

JULY 18, 2023

Considering the usability, today, healthcare apps are also used for self-screening for symptoms, tracking their exposure, and getting tested or vaccinated if needed. The web apps built on this platform are easy to use, secure, scalable, and flexible. Thanks to its modular architecture and caching system that offer queued service.

Healthcare 52

Healthcare Social Media Development Artificial Intelligence 52

HammerDB

APRIL 19, 2023

Therefore, before we attempt to measure our database performance, we should know the system or cloud instance to be tested in detail. For the network, we can use Iperf to assess the network bandwidth between the client and the database server to ensure it will be enough to meet our peak requirement. For storage, FIO is generally used.

Performance 54

Performance Benchmarking Cache Storage 54