Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. They’re proven and ready-to-go.

Architecture 99

Architecture Availability Open Source Healthcare 99

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges.

Availability 85

Availability Open Source Architecture Database 85

Percona

APRIL 17, 2023

In this blog post, we will discuss the best practices on the MongoDB ecosystem applied at the Operating System (OS) and MongoDB levels. We’ll also go over some best practices for MongoDB security as well as MongoDB data modeling. The Linux default is usually 60 , which is not ideal for database usage.

Best Practices 52

Best Practices Design Tuning Database 52

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013. Compare Costs.

Open Source 244

Open Source Tuning C++ Database 244

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

AUGUST 1, 2023

Source: “Meowing” attack completely destroyed more than 1000 databases These are the words of Bob Diachenko, one of the most respected cybersecurity researchers in relation to a “Meowing” attack, which destroyed between 1000-4000 databases around the world. Thankfully, LDAP can fill many of these gaps.

Best Practices 41

Best Practices Transportation Open Source Traffic 41

Dynatrace

MARCH 22, 2023

For this, best practices would be to segregate commands from data, use parameterized SQL queries, and eliminate the interpreter by using a safe application program interface, if possible. Numerous organizations offer databases of these weaknesses, such as the Snyk Intel Vulnerability Database.

Open Source 194

Open Source Artificial Intelligence Internet Internet 194

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 125

Database Servers Testing Programming 125

Percona

DECEMBER 27, 2023

of respondents are currently utilizing databases in Kubernetes (k8s). These indicators suggest that the adoption of databases on k8s is in its early stages and is likely to continue growing in the future. The newly formed Open Source AI Alliance , led by META and IBM, promises to support open-source AI.

Cloud 82

Cloud Open Source Strategy Best Practices 82

Percona

NOVEMBER 9, 2023

If you have any experience working with database software, you have undoubtedly heard the term Kubernetes a lot. At its core, Kubernetes (often abbreviated as K8s) is an open source tool that automates the deployment, scaling, and management of containerized applications.

Efficiency 105

Efficiency Cloud Healthcare Open Source 105

Dynatrace

SEPTEMBER 23, 2021

Application developers commonly leverage open-source software when building containerized applications. In fact, the market research firm Forrester says that the average container image is comprised of 70% open-source software.[1] 1] And unfortunately, open-source software is often fraught with security vulnerabilities.

Open Source 247

Open Source Benchmarking Best Practices Network 247

Percona

OCTOBER 16, 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. you can now use an external VictoriaMetrics database for monitoring in PMM.

Servers 77

Servers Monitoring Open Source Scalability 77

Dynatrace

OCTOBER 13, 2021

Examples of such weaknesses are errors in application code, misconfigured network devices, and overly permissive access controls in a database. NMAP is an example of a well-known open-source network scanner. That said, vulnerability databases such as CVE , help identify known vulnerabilities. Analyze findings.

Infrastructure 168

Infrastructure Open Source Virtualization Operating System 168

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 106

Performance Monitoring Traffic Database 106

Official Blog - World Web Technology

NOVEMBER 9, 2023

Community-wide Support Available Another significant benefit of PHP is its large and active community of developers. Developers can stay up to date and improve their skills with the help of many community-made tools, like lessons, groups, and open-source projects, thus building a successful PHP Development Company in India.

Website 59

Website Development Open Source Database 59

Percona

SEPTEMBER 28, 2023

Let’s review the best practices we usually follow in Managed Services before using your MySQL server in production and stage env, even for home play purposes. The kernel’s memory allocation function allocates the requested page size, and sometimes more, rounded up to fit within the available memory.

Servers 115

Servers Best Practices Database Open Source 115

Percona

APRIL 20, 2023

With that disclaimer out of the way, let’s examine some of the tools that are available to simplify the upgrade process. pt-query-digest As best practice dictates gathering and testing all application queries by activating the slow log for a period of time, most companies will end up with an enormous amount of slow log data.

Open Source 93

Open Source Best Practices Servers Database 93

Percona

DECEMBER 11, 2023

Here, we will discuss a notable new feature in Amazon RDS, the Dedicated Log Volume (DLV), that has been introduced to boost database performance. A Dedicated Log Volume (DLV) is a specialized storage volume designed to house database transaction logs separately from the volume containing the database tables.

AWS 99

AWS Benchmarking Performance Traffic 99

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. minutes of downtime in one year.

Azure 187

Azure AWS Latency Database 187

Dynatrace

JULY 7, 2022

Microservices development is intrinsically optimized for continuous integration/continuous deployment ( CI/CD ) processes that apply agile development best practices for the rapid delivery of reliable code. Additionally, typical SOA models use larger relational databases. Systems monitoring and alerting.

Architecture 196

Architecture Serverless Azure Programming 196

Dynatrace

APRIL 21, 2022

The Framework is built on five pillars of architectural best practices: Cost optimization. Each pillar brings business and technology leaders together to help organizations choose architecture options that best strategically align to their specific business priorities as they begin their cloud journey. Operational excellence.

Azure 184

Azure Monitoring Virtualization Metrics 184

Percona

SEPTEMBER 26, 2023

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows and significantly enhancing data retrieval, manipulation, and overall system performance. or a later release.

Database 103

Database Engineering Best Practices Open Source 103

Adrian Cockcroft

NOVEMBER 26, 2023

AWS speaker: Aditi Suresh, Customer speaker: Brian Rowe SUS205: Slowing down deforestation by using AI, ML, and open source data Organizations worldwide are developing solutions to evaluate, monitor, or predict land use and cover change in order to identify potential carbon credit projects, deforestation trends, and future wildfire risk areas.

AWS 52

AWS Energy IoT Best Practices 52

Percona

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. Metadata regarding invisibility is available on the information_schema, and the INVISIBLE/VISIBLE keyword is preserved in the binlog, so all changes are correctly replicated.

Best Practices 79

Best Practices Open Source Code Engineering 79

Dynatrace

NOVEMBER 23, 2020

Fortunately, monitoring solutions are available to analyze and display such data, provide deep insights, and take automated actions based on those insights (for example, alerting or remediation). A wide range of monitoring products with distinct functions, alerting methods, and integrations are available. The Kubernetes experience.

Virtualization 160

Virtualization Infrastructure Monitoring Cloud 160

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

Dynatrace

MAY 17, 2023

OpenTelemetry , the open source observability tool, has become the go-to standard for instrumenting custom applications to help software developers and operations teams understand what their software is doing and where it’s running into snags. We also defined the metrics and traces for our demo application using OpenTelemetry.

Transportation 183

Transportation Metrics Best Practices Code 183

Percona

APRIL 24, 2023

Here we are just highlighting one of the scenarios during work on the client environment where we noticed that the ProxySQL mysql_users table had more than 100 user entries, but some of them were available/inserted into the clear text password, whereas some were inserted properly into hashed entries.

Database 82

Database Best Practices Open Source Testing 82

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. Please note – there is no need to restart your database servers. This opens up new analytics use case to e.g:

Engineering 189

Engineering Performance Metrics Best Practices 189

IO River

NOVEMBER 2, 2023

Started years ago with a focus on cloud management, Terraform built a massive community around its open-source license–up until two weeks ago, but more on that later. A significant factor that contributed to Terraform's rise to prominence is its open-source nature. ‍Why Manage Infrastructure by Code?

Open Source 52

Open Source DevOps AWS Azure 52

The Netflix TechBlog

MARCH 5, 2019

This operational component places some cognitive load on our engineers, requiring them to develop deep understanding of telemetry and alerting systems, capacity provisioning process, security and reliability best practices, and a vast amount of informal knowledge about the cloud infrastructure.

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

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. This blog was originally published in August of 2021 and updated in November of 2023.

Scalability 60

Scalability Best Practices Servers Database 60

Percona

JULY 19, 2023

You can build within the extracted source tree, but this goes against best practices. Once inside the build directory, execute cmake targeted to the source tree. Now that we have the code tree extracted and our plugin code ready, we need to create a build location. Look for part two, where we benchmark ULID in MySQL!

C++ 82

C++ Servers Benchmarking Best Practices 82

Percona

JUNE 29, 2023

PSMDB), the best practice to create an index was doing it in a rolling manner. There are other options available too when using commitQuorum: “Voting Members” – This is the default behavior when an index will be created on all data-bearing voting replica set members (Default). . Starting from PSMDB 4.4,

Servers 82

Servers C++ Storage Best Practices 82

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. First released in 2009, it is the most used NoSQL database and has been downloaded more than 325 million times. The bigger the database, the bigger the damage from a leak. This can leave your database instances exposed and vulnerable.

Database 81

Database Servers Storage Strategy 81

IO River

NOVEMBER 2, 2023

significant factor that contributed to Terraform's rise to prominence is its open-source nature. Being open-source, Terraform invited a vast community of developers and companies to rally around it. Take Cloudflare as an example; they have an entire service called Cloudflare Terraform.

Open Source 40

Open Source DevOps AWS Azure 40