Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. What is the Recovery Time Objective? How do you know the backup succeeded?

Best Practices 78

Best Practices Storage Strategy Database 78

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 104

Availability Database Open Source Hardware 104

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

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 40

Best Practices Transportation Open Source Traffic 40

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 85

Database Hardware Open Source Strategy 85

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 203

Open Source Artificial Intelligence Internet Internet 203

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 121

Database Servers Testing Programming 121

Dynatrace

MARCH 20, 2024

This approach can determine malicious activity and block it by monitoring the flow of data within the application, all the way from the user to the database. During the development stage, vulnerabilities can arise when developers use third-party open-source code or make an error in application logic.

Monitoring 217

Monitoring Analytics Traffic Best Practices 217

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 77

Cloud Open Source Strategy Best Practices 77

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 255

Open Source Benchmarking Best Practices Network 255

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 174

Infrastructure Open Source Virtualization Operating System 174

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. have adopted Kubernetes.

Efficiency 99

Efficiency Cloud Healthcare Open Source 99

Percona

AUGUST 16, 2023

In database management, well-formatted SQL code is easier to read and a vital aspect of maintaining clean, efficient, and error-free databases. PostgreSQL developers and database administrators often deal with complex SQL queries, making code readability a critical factor for productivity. What is pgFormatter?

Code 75

Code Best Practices Open Source C++ 75

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 73

Servers Monitoring Open Source Scalability 73

Official Blog - World Web Technology

NOVEMBER 9, 2023

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. It works with many databases, including well-known ones like Oracle, MySQL, and PostgreSQL.

Website 59

Website Development Open Source Database 59

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. The obvious answer is this: To achieve high availability.

Architecture 93

Architecture Availability Open Source Healthcare 93

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

Percona

NOVEMBER 2, 2023

On October 24th, the Percona Kubernetes Squad held the first Ask-me-Anything (AMA) session to address inquiries regarding the utilization of Kubernetes for database deployment. Q1: When is it appropriate to use Kubernetes for databases, and when is it not recommended? ” This talk covers this topic exactly.

Open Source 83

Open Source Hardware Storage Database 83

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 93

AWS Benchmarking Performance Traffic 93

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 205

Architecture Serverless Azure Programming 205

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 102

Performance Monitoring Traffic Database 102

Percona

APRIL 20, 2023

Percona Toolkit Percona Toolkit is a collection of advanced open source command-line tools developed and used by the Percona technical staff that are engineered to perform a variety of MySQL server and system tasks that are too difficult or complex to perform manually. Try Percona Distribution for MySQL today!

Open Source 87

Open Source Best Practices Servers Database 87

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. Therefore, disabling Transparent Huge Pages for database servers is advisable to avoid this situation. It’s a nice thing to do, but first things first.

Servers 109

Servers Best Practices Database Open Source 109

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. Therefore, DBAs must take a piecemeal approach to achieve HA with PostgreSQL, bringing together open source extensions and tools from multiple sources.

Availability 81

Availability Open Source Architecture Database 81

Dynatrace

JANUARY 5, 2022

In white-box testing, we combine open-source load testing tools such as JMeter with Dynatrace’s observability and analytics capabilities. Dynatrace back-end listener for JMeter: Dynatrace engineering open sourced a backend listener for JMeter that they use internally.

Testing 222

Testing Open Source Metrics Infrastructure 222

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

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 193

Azure Monitoring Virtualization Metrics 193

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.

Database 97

Database Engineering Best Practices Open Source 97

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. This is not a best practice at all, and we strongly encourage you to always create an explicit PK in your tables. Suppose you have SELECT * queries in your application code.

Best Practices 76

Best Practices Open Source Code Engineering 76

Percona

JUNE 7, 2023

Triggers on Data Definition Language (DDL) events are a powerful feature of PostgreSQL that allows you to perform additional actions in response to changes to the database schema. DDL events include operations such as CREATE, ALTER, and DROP statements on tables, indexes, and other database objects.

Database 73

Database Best Practices Open Source C++ 73

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 195

Engineering Performance Metrics Best Practices 195

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 192

Transportation Metrics Best Practices Code 192

Dynatrace

NOVEMBER 23, 2020

Traces represent causally related distributed events on a distributed system, showing, for example, how a request flows from the user to the database. Example: Your Kubernetes deployment uses virtual machines that run inside dynamically provisioned virtual machine image files (best practice or not). Possible solutions.

Virtualization 162

Virtualization Infrastructure Monitoring Cloud 162

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