DZone

MAY 23, 2019

How do you tune the Snowflake data warehouse when there are no indexes, and few options available to tune the database itself? This article summarizes the top five best practices to maximize query performance. Snowflake was designed for simplicity, with few performance tuning options.

Best Practices 100

Best Practices Tuning Performance Database 100

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. mongos --configdb <configReplSetName>/<cfg1.example.net:27019>,<cfg2.example.net:27019>,<cfg3.example.net:27019>

Best Practices 70

Best Practices Traffic Database Servers 70

Percona

OCTOBER 20, 2023

Open source migration can be a game-changer, offering flexibility, scalability, and cost-effectiveness. Heck, typing “database migration plan” into Google and reading this blog could constitute planning. Inadequate training Transitioning to open source requires a team that understands your target database solution.

Open Source 85

Open Source Database Best Practices Strategy 85

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

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

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. MongoDB databases commonly exceed a terabyte of data.

Best Practices 40

Best Practices Transportation Open Source Traffic 40

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

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. Strategic allocation of these resources plays a crucial role in achieving scalability, cost savings, improved performance, and staying ahead of advancements in the field.

Cloud 130

Cloud Virtualization Storage Efficiency 130

Dynatrace

DECEMBER 21, 2023

The Application Performance Management (APM) best practices we recommend to optimize user experience and application performance—driven initially by on-premises workloads and finite compute capacity—contribute to improved computational efficiency by reducing CPU cycles, optimizing inter-process communications, and lowering memory footprints.

Cloud 214

Cloud Energy Best Practices Cache 214

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

Scalegrid

JANUARY 9, 2024

As more companies move away from traditional on-premises data centers, they enter into an era where scalability, flexibility, and cost-effectiveness become possible through various services offered by different providers in the market today. This ensures the highest level of protection for data stored in these databases on the cloud.

Strategy 130

Strategy Cloud Best Practices Government 130

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

HammerDB

OCTOBER 12, 2018

This post complements the previous best practice guides this time with the focus on MySQL and MariaDB and achieving top levels of performance with the HammerDB MySQL TPC-C test. Similarly for this guide MySQL can be swapped for a mySQL based databases such as MariaDB. 10 rows in set (0.02 order by c. 7 rows in set (0.00

Best Practices 40

Best Practices Scalability Performance C++ 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. Not available.

Open Source 244

Open Source Tuning C++ Database 244

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

We’ll answer that question and explore cloud migration benefits and best practices for how to go through your migration smoothly. Increased scalability. From a scalability perspective, cloud providers offer computing resources as they are needed, enabling organizations to scale with demand. What is cloud migration?

Cloud 169

Cloud Traffic Best Practices Strategy 169

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. In this example, we have a CRM database of user data that we need to page through and display 10 users at a time. So in effect, our page size is 10. The result?

Best Practices 130

Best Practices Efficiency Strategy Speed 130

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

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. . Start the PostgreSQL Database. cat /proc/meminfo. HugePages_Total: 35000.

Best Practices 40

Best Practices Scalability Performance Hardware 40

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

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 95

Monitoring Scalability Cache Database 95

Percona

NOVEMBER 9, 2023

If you have any experience working with database software, you have undoubtedly heard the term Kubernetes a lot. But for those who are not so familiar, in this post, we will discuss how Kubernetes has emerged as the unsung hero in an industry where agility and scalability are critical success factors. have adopted Kubernetes.

Efficiency 99

Efficiency Cloud Healthcare Open Source 99

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

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

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

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. This marks the end of an era of chaos, paving the way for efficiency gains, quicker innovation, and standardized practices.

Cloud 77

Cloud Open Source Strategy Best Practices 77

VoltDB

JULY 10, 2018

But that fully self sufficient nature means that each of these services have their own end-to-end full stack of technology, including database. If the data is common between multiple services, the database layer gets extricated out of microservices in favor of the creation of a common shared data layer. Problem solved, right?

Architecture 40

Architecture Scalability Ecommerce Latency 40

VoltDB

JULY 10, 2018

But that fully self sufficient nature means that each of these services have their own end-to-end full stack of technology, including database. If the data is common between multiple services, the database layer gets extricated out of microservices in favor of the creation of a common shared data layer. Problem solved, right?

Architecture 40

Architecture Scalability Ecommerce Latency 40

Dynatrace

JANUARY 5, 2022

To do so we have successfully established AI-based White box load and resiliency testing with JMeter and Dynatrace, helping identify and resolve major performance and scalability problems in recent projects before deploying to production. Our customers usually involve us 2-4 weeks before the production release.

Testing 222

Testing Open Source Metrics Infrastructure 222

The Netflix TechBlog

MARCH 10, 2023

Production Use Cases Real-Time APIs (backed by the Cassandra database) for asset metadata access don’t fit analytics use cases by data science or machine learning teams. Such clusters may have different configurations of thread pools to read and write data from database, logging levels and connection configuration with external dependencies.

Media 237

Media Traffic Processing Design 237

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

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. Scalability and resource management : MongoDB containers and other containers are very scalable.

Scalability 57

Scalability Best Practices Servers Database 57

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

Percona

APRIL 20, 2023

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. Several of these tools can help with upgrade planning, making the entire process much easier and less prone to downtime or issues.

Open Source 87

Open Source Best Practices Servers Database 87

High Scalability

DECEMBER 18, 2018

Senior DevOps Engineer : Your engineering work will focus on using your deep knowledge of the web stack including firewalls, web applications, caches and data stores ­ to create innovative infrastructure architectures that are resilient, scalable, and blazingly fast. Need excellent people? Advertise your job here!

Healthcare 122

Healthcare Best Practices DevOps Cache 122

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. As said, the last one is probably the most powerful, scalable, and difficult to design, and unfortunately, it represents probably less than 5% of the solution currently deployed.

Traffic 121

Traffic Scalability Database Servers 121

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. It’s compatible with numerous databases and frameworks.

Website 59

Website Development Open Source Database 59