Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 78

Database Open Source Servers Code 78

Percona

MAY 2, 2023

The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other third-party team troubleshoot database-related issues. Let’s look at a couple of examples where the sensitive data has been altered or masked. shell> /home/vagrant/pt -rw -. shell> sudo.

Database 95

Database Systems Open Source Engineering 95

Percona

NOVEMBER 1, 2023

Without going further into the reasons for such a need, I wanted to refresh this subject in terms of overhead related to running the command on production systems. A lot has changed since then, but many production systems alive today still run with affected versions. Let’s recap how the situation has evolved over the years.

Servers 99

Servers Database Cache C++ 99

Dynatrace

JUNE 7, 2023

Kubernetes is an open source container orchestration platform that enables organizations to automatically scale, manage, and deploy containerized applications in distributed environments. According to the Kubernetes in the Wild 2023 report, “Kubernetes is emerging as the operating system of the cloud.”

Open Source 205

Open Source Social Media Infrastructure Operating System 205

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. For example, for GKE, you must create a VolumeSnapshotClass resource first. For example, for my MongoDB cluster, I have six PVCs: three x replica set nodes and three x config server nodes. Example for mongod-data-my-cluster-name-cfg-0 : apiVersion: snapshot.storage.k8s.io/v1

Database 69

Database Storage Open Source AWS 69

Dynatrace

OCTOBER 13, 2021

Vulnerability assessment is the process of identifying, quantifying, and prioritizing the cybersecurity vulnerabilities in a given IT system. The goal of an assessment is to locate weaknesses that can be exploited to compromise systems. NMAP is an example of a well-known open-source network scanner. Assess risk.

Infrastructure 169

Infrastructure Open Source Virtualization Operating System 169

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 100

Database C++ Servers Open Source 100

Dynatrace

APRIL 11, 2023

Log4Shell required many organizations to take devices and applications offline to prevent malicious attackers from gaining access to IT systems and sensitive data. As a result, organizations need to be vigilant in identifying and addressing vulnerabilities to protect their systems and data.

Cloud 185

Cloud DevOps Open Source Retail 185

Dynatrace

DECEMBER 18, 2023

For busy site reliability engineers, ensuring system reliability, scalability, and overall health is an imperative that’s getting harder to achieve in ever-expanding, cloud-native, container-based environments. Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. What is Prometheus?

Metrics 176

Metrics Engineering Energy Tuning 176

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The following are a few examples of decisions that came from this data and some of what comes next in terms of additional telemetry in Percona products. One such feature was managed backups.

Open Source 92

Open Source Database Operating System Programming 92

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 107

Performance Monitoring Traffic Database 107

Official Blog - World Web Technology

NOVEMBER 9, 2023

On top of that, PHP is used to run famous content management systems like Joomla, WordPress, and Drupal. Creating tools and systems and offering online resources help the language keep growing and improving. Windows, macOS, Linux, and other running systems can use it and provide easy PHP development in India.

Website 59

Website Development Open Source Database 59

Dynatrace

AUGUST 18, 2022

But managing the breadth of the vulnerabilities that can put your systems at risk is challenging. Security vulnerabilities are weaknesses in applications, operating systems, networks, and other IT services and infrastructure that would allow an attacker to compromise a system, steal data, or otherwise disrupt IT operations.

Traffic 163

Traffic Java Network DevOps 163

Percona

JANUARY 11, 2023

PostgreSQL is a powerful and flexible open-source database management system that allows users to install and use extensions to add additional functionality to their databases. The pg_stat_monitor is a PostgreSQL extension that provides real-time monitoring and analysis of database activity. to version 2.0,

Database 102

Database Open Source Monitoring Servers 102

HammerDB

JULY 14, 2021

However, as the two databases diverged from a shared common codebase, this presented a challenge in that it was not possible to modify the workload for MySQL or MariaDB without also changing the other. Checking database library for MariaDB Error: failed to load mariatcl - couldn't load file "/home/HammerDB-4.2/lib/mariatcl0.1/libmariatcl0.1.so":

Testing 57

Testing C++ Virtualization Tuning 57

Percona

OCTOBER 3, 2023

Transparent Huge Pages (THP) is a memory management feature in Linux operating systems that aims to enhance system performance. While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. As such, it is generally recommended to disable THP for most database workloads.

Database 91

Database Servers Open Source C++ 91

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. In this blog post, we dig into the steps to track down the DROP statements in our database server. sec) We will narrow down the events to log only the drop events for the database-related objects. How does it work?

Servers 86

Servers Database Open Source Scalability 86

Percona

DECEMBER 23, 2022

One of the routine operations when administering PostgreSQL is periodic updates to the database system’s architecture. The easiest way to identify changes between schemas from one database to another is to compare schema dump manifests. . The following is an example implementation of the open source tool apgdiff. .

Open Source 84

Open Source Database Architecture Google 84

Dynatrace

NOVEMBER 23, 2020

Nevertheless, there are related components and processes, for example, virtualization infrastructure and storage systems (see image below), that can lead to problems in your Kubernetes infrastructure. Configuring storage in Kubernetes is more complex than using a file system on your host. The Kubernetes experience.

Virtualization 160

Virtualization Infrastructure Monitoring Cloud 160

Percona

DECEMBER 19, 2023

They are widely used in web development, APIs, and cloud services to create more dynamic and responsive systems. curl -X POST -d /tmp/file.json -H "Content-Type: application/json" [link] There are a few use cases where webhook would be useful: Webhooks allow systems to receive real-time updates when certain events occur.

Monitoring 93

Monitoring Database Open Source Java 93

Percona

AUGUST 7, 2023

Both logs are crucial in the ACID (Atomicity, Consistency, Isolation, Durability) properties of database systems. In this blog post, we will delve into the differences between the InnoDB undo log and redo log, exploring their significance and providing code examples to illustrate their usage.

Database 97

Database Tuning Storage Open Source 97

Official Blog - World Web Technology

AUGUST 27, 2023

For example, website design is very crucial to impress your website visitors. It is a server-side scripting language that is highly secure, open-source, and versatile. PHP is Open Source Language The most important thing for a business is to optimize costs to make operations more cost-effective and improve profit margins.

Development 98

Development Ecommerce Open Source Website 98

Dynatrace

AUGUST 5, 2022

A message queue is a form of middleware used in software development to enable communications between services, programs, and dissimilar components, such as operating systems and communication protocols. A message queue enables the smooth flow of information to make complex systems work. Neither requires information about the other.

Monitoring 198

Monitoring Serverless Programming Speed 198

Dynatrace

AUGUST 5, 2022

A message queue is a form of middleware used in software development to enable communications between services, programs, and dissimilar components, such as operating systems and communication protocols. A message queue enables the smooth flow of information to make complex systems work. Neither requires information about the other.

Monitoring 197

Monitoring Serverless Programming Speed 197

Scalegrid

JANUARY 3, 2020

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance.

Monitoring 164

Monitoring Metrics Servers Database 164

Percona

JUNE 4, 2023

Before we dive into the differences between MariaDB and MySQL, we will provide a thorough examination of each relational database management system (RDBMS). It continues to be developed and maintained by the open source community and remains free to use under the GNU General Public License. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JUNE 23, 2023

Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system. It does not follow the SQL Standard as closely as other databases, and some useful functions such as MERGE() are missing.

Database 123

Database Transportation Servers Cloud 123

Percona

APRIL 26, 2023

Even though open source software is firmly in the mainstream, used widely by businesses, governments, and everyone who owns a cell phone or computer, the question repeatedly arises: “Is open source software safe?” Is open source software as stable as other software? Our bar is higher than that.

Open Source 87

Open Source Software Software Social Media 87

Percona

DECEMBER 29, 2022

While working as a DBA, we perform many regular tasks, and one of them is upgrading our database systems. There are some techniques to perform a PostgreSQL database upgrade, such as data dump and import, logical replication, or in-site upgrade using pg_upgrade. Example case. ” Let’s review the case.

C++ 82

C++ Open Source Database Programming 82

Dynatrace

APRIL 5, 2021

These include website hosting, database management, backup and restore, IoT capabilities, e-commerce solutions, app development tools and more, with new services released regularly. You will likely need to write code to integrate systems and handle complex tasks or incoming network requests. A new record entering a database table.

Lambda 179

Lambda AWS Serverless Hardware 179

Dynatrace

AUGUST 9, 2023

Procedures describe the specific technical details that an adversary used to carry out an attack, for example, what script they ran to exploit a weakness. Attack tactics describe why an attacker performs an action, for example, to get that first foothold into your network. Attackers often probe systems using automated scanning tools.

Analytics 194

Analytics AWS Strategy Infrastructure 194

The Netflix TechBlog

OCTOBER 19, 2020

a Netflix member via Twitter This is an example of a question our on-call engineers need to answer to help resolve a member issue?—?which which is difficult when troubleshooting distributed systems. By 2017, open source projects like Open-Tracing and Open-Zipkin were mature enough for use in polyglot runtime environments at Netflix.

Infrastructure 233

Infrastructure Transportation Storage Open Source 233

Testsigma

DECEMBER 28, 2019

The testing phase starts with unit testing followed by integration testing, system testing, system integration testing, acceptance testing, and regression testing. System testing- checks end to end flows works as expected. Acceptance testing- to validate the system is developed as per business requirement. Re-execute all.

Testing 53

Testing Hardware Testing Tools Strategy 53

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 78

Open Source Database Storage Scalability 78

The Morning Paper

SEPTEMBER 14, 2020

Aligning superhuman AI with human behavior: chess as a model system , McIlroy-Young et al., we also have large databases of human games available though, we have a recognised method of assessing player skill levels (rating points). The evaluation in this paper is done using the Leela open source implementation.

Systems 85

Systems Games Engineering Open Source 85

Percona

JANUARY 26, 2023

This is a prime example of how a minor bug could have a significant impact on your life and a detrimental impact on your company or project. Most MySQL bug reports come with an example of the problem. The author of this bug, Markus Winand, is well-known in the database world and wrote a beautiful, clear example of reporting a bug.

Database 101

Database Open Source Monitoring Testing 101

Percona

APRIL 4, 2023

It takes its values from the mysql.user system table. How to create a user with attributes Let’s see how we can create a user with attributes, by example. The user should have the UPDATE or SELECT privilege for the mysql.user system table. Let’s see an example of modifying attributes to the user.

Open Source 82

Open Source Database Mobile Scalability 82