Percona

NOVEMBER 13, 2023

To maintain competitiveness and operational efficiency — not to mention ensure security and compliance when your database version reaches End of Life (EOL) – it’s crucial to upgrade your database systems from time to time. One of the most compelling reasons to choose a professional service is the reduced risk.

Database 90

Database Open Source Best Practices Strategy 90

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

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

SEPTEMBER 1, 2023

Database architects working with MongoDB encounter specific challenges related to database systems and system growth. Scalability is a significant concern, as databases must handle growing data volumes and user demands while maintaining peak performance. Learn more: View our webinar on How to Scale with MongoDB.

Best Practices 70

Best Practices Traffic Database Servers 70

Percona

NOVEMBER 9, 2023

If you have any experience working with database software, you have undoubtedly heard the term Kubernetes a lot. Cost and resource efficiency One of Kubernetes’ main advantages is its efficient use of resources. You may already be using it daily and find it makes running applications in the cloud much more manageable.

Efficiency 99

Efficiency Cloud Healthcare Open Source 99

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. It is important to begin with a thorough database backup to prepare for such situations.

Database 162

Database Strategy Servers Best Practices 162

Dynatrace

DECEMBER 21, 2023

Most approaches focus on improving Power Usage Effectiveness (PUE), a data center energy-efficiency measure. energy-efficient data centers—cloud providers—achieve values closer to 1.2. This computational efficiency also reduces energy consumption, which in turn reduces carbon emissions. A PUE of 1.0

Cloud 214

Cloud Energy Best Practices Cache 214

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 89

Open Source Database Hardware Strategy 89

Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. How to Implement Pagination in MongoDB® Big datasets require efficient data retrieval and processing for effective management. limit(number).

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Scalegrid

JANUARY 12, 2024

Simply put, it’s the set of computational tasks that cloud systems perform, such as hosting databases, enabling collaboration tools, or running compute-intensive algorithms. This article analyzes cloud workloads, delving into their forms, functions, and how they influence the cost and efficiency of your cloud infrastructure.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Scalegrid

JANUARY 9, 2024

Governance and compliance are also crucial factors in ensuring enterprise cloud security as they enforce regulatory requirements and best practices within organizations. Data encryption should be applied along with robust access controls and efficient encryption key management procedures.

Strategy 130

Strategy Cloud Best Practices Government 130

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

Dynatrace

JANUARY 11, 2023

Database monitoring. This ensures the database queries are performant, while also identifying host problems. For example, uptime detection can identify database instability and help to improve mean time to restoration. Best practices to consider. Website monitoring. Cloud storage monitoring.

Cloud 227

Cloud Monitoring Best Practices Infrastructure 227

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

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

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130

SQL Performance

MAY 8, 2019

This article is the second in a series about T-SQL bugs, pitfalls and best practices. As for best practices that can help you avoid such bugs, there are two main ones. They’re also quite efficient, using a Left Semi Join optimization with a short-circuit. This time I focus on classic bugs involving subqueries.

Best Practices 68

Best Practices C++ Code Servers 68

Dynatrace

OCTOBER 10, 2023

Process Improvements (50%) The allocation for process improvements is devoted to automation and continuous improvement SREs help to ensure that systems are scalable, reliable, and efficient. Reality In practice, while both these categories have equal attention, project improvements hold paramount importance for business outcomes.

Engineering 231

Engineering DevOps Innovation Strategy 231

Dynatrace

SEPTEMBER 30, 2021

Not only will they get much more out of the tools they use daily, but they’ll also be able to deliver superior functionality, efficiency, and performance to your customers. In addition, 45% of them have gone on to implement efficiencies in their roles, and 43% reported they were able to do their job more quickly after getting certified.

AWS 214

AWS Best Practices Analytics Cloud 214

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

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. Query performance Query performance is a key performance indicator (KPI) in MySQL, as it measures the efficiency and speed of query execution.

Performance 102

Performance Monitoring Traffic Database 102

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.

Code 75

Code Best Practices Open Source C++ 75

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. Customers will increasingly prioritize AI efficiency and education to tackle legal and ethical concerns.

Cloud 77

Cloud Open Source Strategy Best Practices 77

Dynatrace

SEPTEMBER 30, 2021

We’ll answer that question and explore cloud migration benefits and best practices for how to go through your migration smoothly. In cloud computing environments, infrastructure and services are maintained by the cloud vendor, allowing you to focus on how best to serve your customers. Migrate databases intelligently.

Cloud 169

Cloud Traffic Best Practices Strategy 169

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Understanding the PostgreSQL Hostname Hostname is a key factor for the effective management of PostgreSQL databases and providing secure access.

Database 130

Database Servers Storage Network 130

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

Dynatrace

APRIL 21, 2022

The Framework is built on five pillars of architectural best practices: Cost optimization. Performance efficiency. 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.

Azure 193

Azure Monitoring Virtualization Metrics 193

Adrian Cockcroft

NOVEMBER 26, 2023

SUS101: Sustainability innovation in AWS Global Infrastructure AWS is determined to make the cloud the cleanest and most energy-efficient way to run customers’ infrastructure and business. This includes providing the efficient, resilient services AWS customers expect, while minimizing their environmental footprint. AWS speaker: T.

AWS 52

AWS Energy IoT Best Practices 52

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . Initially it is best leave all of these states enabled. cat /proc/meminfo.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Official Blog - World Web Technology

NOVEMBER 9, 2023

Easy to Integrate with Databases PHP has built-in solid support for working with databases, making it perfect for making websites driven by databases. It works with many databases, including well-known ones like Oracle, MySQL, and PostgreSQL. PHP’s execution speed and efficiency are significant factors.

Website 59

Website Development Open Source Database 59

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

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. Think of a user login which requires your back-end systems to validate user credentials and query required user profile information from the backend databases. Too much data requested from a database, e.g. Request all and filter in memory.

Cache 201

Cache Database Architecture Government 201

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. Take a look.

Servers 73

Servers Monitoring Open Source Scalability 73

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.

Architecture 205

Architecture Serverless Azure Programming 205

Dynatrace

SEPTEMBER 23, 2021

Best practices for container security. Here is a checklist of best practices for how to approach container security. Secrets, such as database credentials, API keys, SSL keys or encryption keys, need to be managed to protect them from discovery. Pretty neat, isn’t it? Manage secrets.

Open Source 255

Open Source Benchmarking Best Practices Network 255

The Netflix TechBlog

MARCH 5, 2019

As a micro-service owner, a Netflix engineer is responsible for its innovation as well as its operation, which includes making sure the service is reliable, secure, efficient and performant. In the Efficiency space, our data teams focus on transparency and optimization.

Infrastructure 182

Infrastructure Cloud Scalability AWS 182

Percona

SEPTEMBER 1, 2023

Web applications rely on databases to run the internet, powering everything from e-commerce platforms to social media networks to streaming services. MySQL is one of the most popular database management systems, playing a pivotal role in the functionality and performance of web applications.

Performance 52

Performance Storage Social Media Database 52