Percona

OCTOBER 4, 2023

We discussed how roles can inherit permissions from other roles, simplifying access control in your database. Documentation: Document your role hierarchy in reverse for reference, compliance, and auditing purposes. But what if you need to discover which roles inherit from a specific role?

C++ 102

C++ Open Source Tuning Database 102

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

AUGUST 17, 2023

PostgreSQL is open source relational database management software. Most recently, in StackOverflow’s 2022 Stack Developer Survey , PostgreSQL took a slight lead over MySQL (46.48% to 45.68%) as the most popular database platform among professional developers. How-to documentation is readily available.

Open Source 79

Open Source Healthcare Social Media Database 79

Percona

FEBRUARY 24, 2023

Today, we are excited to announce the release of Percona Monitoring and Management (PMM) V2.35 , including a tech preview of label-based access control, the general availability of Helm Chart, and a range of enhancements to our Database as a Service (DBaaS) offerings, among other improvements and features. Stay tuned!

Availability 96

Availability Metrics Monitoring Open Source 96

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

HammerDB

APRIL 19, 2023

Among the different components of modern software solutions, the database is one of the most critical. There are many times we get asked why some cloud instance performed poorly for their database application and almost always turned out to be some configuration error. Instead, readers should refer to the HammerDB documentation.

Performance 54

Performance Benchmarking Cache Storage 54

Percona

APRIL 17, 2023

The main objective of this post is to share my experience over the past years tuning MongoDB and centralize the diverse sources that I crossed in this journey in a unique place. The Linux default is usually 60 , which is not ideal for database usage. Spoiler alert: This post focuses on MongoDB 3.6.X

Best Practices 52

Best Practices Design Tuning Database 52

Percona

OCTOBER 17, 2023

Many changes and new features are brought to the system, and as part of keeping in tune with the changes and how they can impact us, we go through the changes to better understand them. Stricter downgrade policy The upstream documentation highlights the following: Starting in MongoDB 7.0, From that, this article is born. x -> 5.0.x

Metrics 103

Metrics C++ Storage Database 103

Percona

OCTOBER 12, 2023

The documentation mentions that the supported languages to profile are Go, Java (any JVM-based language), Python, Ruby, and NodeJS. Manual flame graphs collection Although the tool is excellent and automatically provides flame graphs, we don’t have much control over tuning the selected profiler. Then, the pod is deleted.

Code 112

Code Tuning C++ Benchmarking 112

Percona

AUGUST 30, 2023

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. But there could be reasons why a PostgreSQL user wants to change that at a specific database level.

Database 104

Database Servers Open Source Tuning 104

Percona

JULY 2, 2023

The size of the database and your database environment—if it is on colo or cloud—matters. Having a backup strategy in place that takes regular backups and has secure storage is essential to protect the database in an enterprise-grade environment to ensure its availability in the event of failures or disasters.

Strategy 52

Strategy Database Storage Open Source 52

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. You can refer to the documentation for further details. It supports native sharding being transparent for the application.

Open Source 90

Open Source Storage Database Big Data 90

Adrian Cockcroft

NOVEMBER 26, 2023

In this session, learn how to build automated, serverless AWS architectures to upload, extract, process, verify, and validate supply chain documents, accelerating end-to-end supply chain transparency. Programs like Open Data on AWS provide free, publicly available datasets, accelerating sustainability innovation. AWS speaker: T.

AWS 52

AWS Energy IoT Best Practices 52

Dynatrace

JULY 23, 2019

When comparing Django and Flask , developers like to highlight that Django provides an all-inclusive experience for developers: you get an admin panel, database interfaces, ORM, and directory structure for your applications and projects out of the box. Tracing database requests. In case of issues, take a look at our documentation.

Monitoring 136

Monitoring Software Software Database 136

KeyCDN

OCTOBER 31, 2018

Thanks to its reliable performance, extensive documentation and dedicated user community, PHP is one of the preferred server-side scripting language of many web developers. 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

JULY 6, 2023

Performance is one of the essential aspects of a database management system. One way to verify a column’s number of distinct values is by querying the pg_stats view in our database. Tune the random_page_cost parameter. Tune the effective_cache_size parameter. Download Percona Distribution for PostgreSQL Today!

Best Practices 92

Best Practices Tuning Database Testing 92

HammerDB

MAY 5, 2019

Note that the main developer of HammerDB is Intel employee (#IAMINTEL) however HammerDB is a personal open source project and HammerDB has no optimization whatsoever for a database running on any particular architecture. In the recent MySQL 8.0.16 In the recent MySQL 8.0.16

Testing 48

Testing Tuning Latency Storage 48

All Things Distributed

APRIL 11, 2012

Many organizations have large collections of documents, structured and unstructured, that can benefit from a specialized search service. With the rise of the App developer culture there is an increasing number of consumer data sources that cannot be simply queried with a web search engine. How it Works.

Cloud 149

Cloud AWS Technology Technology 149

O'Reilly

MAY 25, 2021

Open source projects such as EleutherAI have drawn inspiration from GPT-3. It is likely that entire companies will be in the business of identifying these nuances and selling them as “fingerprint databases” for identifying fake news articles. An amazing feature of GPT-3 is its ability to generate source code.

Social Media 138

Social Media Media Internet Internet 138

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

NOVEMBER 28, 2023

16% of respondents working with AI are using open source models. If we asked whether their companies were using databases or web servers, no doubt 100% of the respondents would have said “yes.” But 18% already have applications in production. 54% of AI users expect AI’s biggest benefit will be greater productivity.

Open Source 107

Open Source Artificial Intelligence Google Infrastructure 107

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Triggering repairs at any time.

Database 212

Database Traffic Transportation Open Source 212

The Netflix TechBlog

DECEMBER 17, 2019

Andreas Andreakis , Ioannis Papapanagiotou Overview Change-Data-Capture (CDC) allows capturing committed changes from a database in real-time and propagating those changes to downstream consumers [1][2]. In databases like MySQL and PostgreSQL, transaction logs are the source of CDC events. Triggering repairs at any time.

Database 197

Database Traffic Transportation Open Source 197

O'Reilly

JANUARY 17, 2023

You’ll try this with a few other algorithms, and their respective tuning parameters–maybe even break out TensorFlow to build a custom neural net along the way–and the winning model will be the one that heads to production. This person is comfortable talking to databases to pull data, then calling Pandas to transform it.

Tuning 130

Tuning Open Source AWS Software 130

The Netflix TechBlog

NOVEMBER 2, 2021

It has become a de facto standard for perceptual quality measurements within Netflix and, thanks to its open-source nature , throughout the video industry. For example, VQS relies on the Netflix Media Database (NMDB) to store and index the quality scores, while the Reloaded system uses a mix of non-queryable data models and files.

Media 171

Media Innovation Metrics Latency 171

O'Reilly

JULY 25, 2023

I guessed that maybe ChatGPT only knew about v2 since it was trained on open-source code from before September 2021 (its knowledge cutoff date) and v2 was the dominant format before that date. And ChatGPT didn’t warn me about this. I saw an example for Node.js Can you adapt it to fit my chrome extension? [I

Programming 98

Programming Code Design Benchmarking 98

Smashing Magazine

OCTOBER 22, 2021

The first prototype was built using the open-source game engine Phaser.js , mostly for the included physics engine and because I already had some experience with it. database and outputs the game PIN as a response. database and displayed on the “Create” page. is an open-source alternative to Firebase.

Games 94

Games Servers Database Virtualization 94