Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Think of us as the extra set of eyes, the extra layer of QA to ensure your safety passage to the next database version.

Availability 102

Availability Servers Database Open Source 102

Percona

JUNE 30, 2023

Percona, a leading provider of open-source database software and services, announced the general availability of Percona Operator for PostgreSQL version 2. The solution is 100% open source and automates the deployment and management of PostgreSQL clusters on Kubernetes. In version 1.x,

Availability 96

Availability Open Source Azure Hardware 96

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 90

Database Hardware Open Source Strategy 90

Percona

NOVEMBER 1, 2023

version, like this: ANALYZE TABLE removes the table from the table definition cache, which requires a flush lock. This makes the query wait for any long-running queries to finish but also can trigger cascading waiting for other incoming requests. In short, ANALYZE could lead to nasty stalls in busy production environments. x are all safe.

Servers 99

Servers Database Cache C++ 99

Percona

MAY 9, 2023

The term is inherently ominous, and a broad definition isn’t much cheerier. To determine whether that perception is warranted in the database software industry — and if so, how to avoid vendor lock-in pitfalls — let’s dig deeper. They both suggest limited or lost freedom. Ask about data portability.

Open Source 92

Open Source Database Innovation Cloud 92

Percona

APRIL 4, 2023

Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. Percona is an open source database software, support, and services company that helps make databases and applications run better. Reserved words added to 8.0 So what happens if I use a reserved word?

Open Source 118

Open Source Database Servers Scalability 118

Percona

OCTOBER 10, 2023

mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database 98

Database Performance C++ Engineering 98

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

OCTOBER 13, 2023

Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. mysql> create database test_rocksdb; Query OK, 1 row affected (0.01 mysql> create database test_rocksdb; Query OK, 1 row affected (0.01

Storage 96

Storage Database Engineering Open Source 96

Percona

APRIL 11, 2023

Indexes are crucial for optimizing query execution times in databases, but having an excessive number of indexes, or redundant ones, can negatively impact performance. The unique quiz Consider the following MySQL table definition. While these may not be exact duplicates, they can still negatively impact database performance.

Database 93

Database Open Source Testing Design 93

Percona

AUGUST 1, 2023

In the world of database management, ALTER TABLE operations are a crucial part of modifying database structures. MySQL, a popular database management system, offers online operations since version 5.6, sec) The alteration appears successful, and we see the table definition accordingly modified. However, there are caveats.

Storage 81

Storage Database Open Source Engineering 81

Percona

AUGUST 30, 2023

In this blog, I am trying to list the options available for users and list them in increasing order of priority. This can be changed later using the pg_checksums utility, but that will be a painful exercise on a big database. Database level setting All options discussed so far have a global scope.

Database 105

Database Servers Open Source Tuning 105

The Netflix TechBlog

JULY 30, 2019

and beyond By Anoop Panicker and Kishore Banala Conductor is a workflow orchestration engine developed and open-sourced by Netflix. The Netflix Media Database (NMDB) is one such example. This allows us to proactively push changes to the open source version while ensuring that the changes are fully functional and well-tested.

Lambda 189

Lambda Media Open Source Metrics 189

Dynatrace

JUNE 25, 2021

As a strong supporter of open source and open standards, I’m aware that the wide availability of standards, open-source tools, and some newly coined terms are causing a lot of confusion. The overall fallacy in this assumption becomes obvious when you look at the definitions of the terms.

Open Source 197

Open Source Monitoring Google Systems 197

Percona

APRIL 10, 2023

In this blog post, I’m going to present a new functionality that is available in MyDumper and will be available in the next release: we added the possibility to build random data based on a format that the user defines. During export, mydumper sends SELECT statements to the database. How does it work?

Testing 108

Testing C++ Open Source Database 108

Percona

SEPTEMBER 6, 2023

Functional indexes are found in both of Percona’s relational databases, MySQL and PostgreSQL, but they are probably the least used and most understood index type, aside from geospatial. Definitions The examples below use MySQL, but it is helpful to check their competition’s documentation to help explain what a functional index is.

Speed 84

Speed Virtualization Storage Open Source 84

Dynatrace

DECEMBER 18, 2023

Another source reported a 43% overall increase in Prometheus adoption for the last six months of 2021. As the two first graduates of the open source project incubator, the Cloud Native Computing Foundation (CNCF), Kubernetes and Prometheus are usually deployed together. What is Prometheus?

Metrics 175

Metrics Engineering Energy Tuning 175

Percona

JULY 25, 2023

Percona XtraBackup performs crash recovery on the files to make a consistent, usable database again. The redo apply phase wouldn’t make the database consistent with respect to a transaction. So, given a table_id, how do you get the table schema/definition? This phase has no concept of a row or a transaction.

Cache 87

Cache Benchmarking Servers Design 87

Percona

AUGUST 3, 2023

The definition looks strange, but everything should be more clear, providing a real use case for this feature. As an experienced database developer, you should know that these kinds of queries should not exist in any production code. You need to use the INVISIBLE keyword in the column definition. Definitively better.

Best Practices 79

Best Practices Open Source Code Engineering 79

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. The database(s) that run_maintenance() will run on. This step is not mandatory, but after installation, you cannot change it.

Storage 102

Storage Open Source Database Efficiency 102

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. You can read some optimization examples in the official doc: [link]. Results for Percona Server for MySQL 8.0 While you are on 5.7, Try Percona Distribution for MySQL today!

Cache 104

Cache Hardware Servers Benchmarking 104

Percona

OCTOBER 17, 2023

When multiple operations, such as reads and writes, attempt to access the database concurrently, WiredTiger uses tickets to ensure these operations do not conflict in a way that would compromise data integrity or performance. The dynamic allocation might have flaws, but it’s definitely a good addition. After the rapid release 6.2

Metrics 104

Metrics C++ Storage Database 104

Percona

APRIL 4, 2023

” While this is definitely a valid use case, I hadn’t personally come across an issue in the wild where the application fix wasn’t trivial. This is a great feature that is often used for sharding (I’ve written about this in the past at Horizontal Scaling in MySQL – Sharding Followup ).

Open Source 109

Open Source Servers Engineering Scalability 109

Percona

JANUARY 19, 2023

Some startups adopted MySQL in its early days such as Facebook, Uber, Pinterest, and many more, which are now big and successful companies that prove that MySQL can run on large databases and on heavily used sites. Some of them are: MySQL Cluster: MySQL NDB Cluster is an in-memory database clustering solution developed by Oracle for MySQL.

Open Source 90

Open Source Storage Database Big Data 90

Dynatrace

JUNE 1, 2021

Practitioners use APM to ensure system availability, optimize service performance and response times, and improve user experiences. Causes can run the gamut — from coding errors to database slowdowns to hosting or network performance issues. Mobile apps, websites, and business applications are typical use cases for monitoring.

Monitoring 148

Monitoring Mobile Social Media Artificial Intelligence 148

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL. The POC Why this POC?

Traffic 125

Traffic Scalability Database Servers 125

Percona

JULY 3, 2023

Partitioning is the concept of splitting large tables logically into smaller pieces for better performance of the database. However, a rule of thumb is that the size of the table should exceed the physical memory of the database server. The exact point at which a table will benefit from partitioning depends on the application.

Storage 84

Storage Database Performance Open Source 84

KeyCDN

OCTOBER 31, 2018

Consequently, there are so many free and premium PHP tools available online that it’s difficult for developers to determine which ones are worthwhile. PHPStorm PHPStorm streamlines application development by offering integration with relational databases and other PHP tools. Best PHP Development Environments 1.

Development 57

Development Open Source Java AWS 57

Percona

SEPTEMBER 1, 2023

MySQL triggers are a powerful tool for database administrators and developers, enabling them to automate tasks, enforce data consistency, and respond to events within the database seamlessly. A Trigger in MySQL is a database object that plays a pivotal role in database management.

Cache 62

Cache Database Games Healthcare 62

Testsigma

APRIL 8, 2020

BDD is ineffective without a proper definition of business requirements since it does not cope well with poorly written user stories. There are several open-source and paid tools available for BDD framework. BDD is incompatible with the waterfall approach. Behavior Driven Development Tools. 1) Cucumber Studio.

Development 96

Development Programming Testing Java 96

Dynatrace

MAY 28, 2020

You may have seen over the past few months we have been extensively promoting Service Level Indicators (SLIs) and Service Level Objectives (SLOs) as part of our Open Source project Keptn. Keptn uses SLO definitions to automatically configure Dynatrace or Prometheus alerting rules. This opens up new analytics use case to e.g:

Engineering 189

Engineering Performance Metrics Best Practices 189

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). On high-performance multi-core systems all the supported databases can return performance in the many millions of transactions per minute.

Programming 67

Programming Benchmarking Virtualization C++ 67

O'Reilly Software

OCTOBER 23, 2018

This is my tailored view of it; others will have different definitions. Notice that in this definition, the role of the architect and technology strategist is not to merely serve the business but to play together. So, we will define the role of the architect in order to proceed from common ground. Contain entropy.

Strategy 100

Strategy Architecture Technology Technology 100

The Netflix TechBlog

JULY 26, 2021

From the moment a Netflix film or series is pitched and long before it becomes available on Netflix, it goes through many phases. Data connectivity across Netflix Studio and availability of Operational Reporting tools also incentivizes studio users to avoid forming data silos. When an upstream schema evolves (e.g.

Big Data 253

Big Data Government Analytics Processing 253

Alex Russell

JUNE 22, 2022

There's no point in recommending a better browser because none is available. Despite being largely open source, browsers and their engines are not loss leaders. Lagging engines taxed developers and businesses, too, and in the era before pervasive open-source engines, the loss of one lineage may have been a deep loss.

Engineering 110

Engineering Traffic Government Google 110

Smashing Magazine

AUGUST 3, 2023

Core Web Vital metrics definitions. Image source: web.dev ) ( Large preview ) While optimizing for FID and CLS was relatively straightforward, LCP posed a greater challenge due to the multiple factors involved. Note : Google plans to replace this metric with another one called Interaction to Next Paint (INP) beginning in 2024.

Performance 74

Performance Cache Traffic Metrics 74

Smashing Magazine

JUNE 28, 2021

It definitely is. We definitely have a lot more need for UI than marketing stuff. You just plug the theme provider in there and Chakra does the rest of the work and it just becomes available everywhere. I’ve definitely seen it. That you, is available from the makers of Chakra, but as a commercial offering.

Website 62

Website Design Open Source Software 62