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. Through this meticulous process, commits are accurately logged in their respective sequences.

Database 162

Database Strategy Servers Best Practices 162

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.

Best Practices 71

Best Practices Traffic Database Servers 71

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 109

Servers Best Practices Database Open Source 109

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

Cloud monitoring is a set of solutions and practices used to observe, measure, analyze, and manage the health of cloud-based IT infrastructure. Continuous cloud monitoring with automation provides clear visibility into the performance and availability of websites, files, applications, servers, and network resources. Website monitoring.

Cloud 214

Cloud Monitoring Best Practices Infrastructure 214

SQL Performance

AUGUST 14, 2019

This article is the fourth installment in a series about T-SQL bugs, pitfalls and best practices. The focus of this month's article is bugs, pitfalls and best practices related to window functions. In my examples I'll use a sample database called TSQLV5. Figure 1: Plan for Query 1, row-mode processing.

Best Practices 108

Best Practices Servers Database Azure 108

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. It’s a complex process involving various factors and meticulous planning. Flexibility and scalability Open source databases provide much greater flexibility regarding customization and configuration.

Open Source 90

Open Source Database Hardware Strategy 90

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

JANUARY 31, 2024

SAP Basis teams have established best practices for managing their SAP systems. Teams benefit from a boost in aligning SAP operations practices with the operation of all surrounding systems that SAP depends on and those that depend on SAP. SAP HANA server infrastructure monitored with OneAgent.

Java 178

Java Analytics Best Practices Monitoring 178

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. In the realm of cloud-based business operations, there is an increasing dependence on complex information processing patterns. What is workload in cloud computing?

Cloud 130

Cloud Virtualization Storage Efficiency 130

Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

Scalegrid

APRIL 5, 2024

Grasping the concept of Redis sharding is essential for expanding your Redis database. This method involves splitting data over various nodes to improve the database’s efficiency. The purpose is scaling out distributed systems effectively and offering improved management and performance while processing numerous keys.

Scalability 130

Scalability Efficiency Java Database 130

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

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. One such solution is pagination, which divides large datasets into manageable “pages” of data to be displayed or processed.

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Scalegrid

JANUARY 9, 2024

The selection process for a suitable cloud provider is crucial as it involves aligning business objectives, regulatory requirements, and current technological infrastructure with strong cloud security measures. This process involves converting regular data into a coded form, which helps to protect its privacy and guard against cyber threats.

Strategy 130

Strategy Cloud Best Practices Government 130

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. Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security.

Database 130

Database Servers Storage Network 130

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. You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health.

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

JANUARY 19, 2020

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. SAP technology and process awareness.

Monitoring 152

Monitoring Best Practices Infrastructure Servers 152

SQL Performance

JUNE 14, 2019

This article is the third installment in a series about T-SQL bugs, pitfalls and best practices. Some of the bugs and best practices that I cover here are a result of a survey I did among fellow MVPs. In my examples I’ll use a sample database called TSQLV5. Previously I covered determinism and subqueries.

Best Practices 93

Best Practices C++ Database Processing 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

Dynatrace

MAY 31, 2019

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. SAP technology and process awareness.

Monitoring 160

Monitoring Best Practices Infrastructure Programming 160

Dynatrace

MAY 19, 2022

However, many teams struggle with knowing which ones to use and how to incorporate them into the processes. Below, several Dynatrace customers shared their SLO management journey and discussed the resulting dashboards they rely on daily to manage their mission-critical business processes and applications. What are SLOs? Saturation.

Automotive 260

Automotive Latency Architecture Azure 260

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. 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.

Open Source 187

Open Source Artificial Intelligence Internet Internet 187

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

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. Cloud migration is the process of transferring some or all your data, software, and operations to a cloud-based computing environment that offers unlimited scale and high availability.

Cloud 158

Cloud Traffic Best Practices Strategy 158

Percona

APRIL 20, 2023

Such major version upgrades are rarely simple, but thankfully there are tools that can help smooth the process and ensure a successful upgrade. With that disclaimer out of the way, let’s examine some of the tools that are available to simplify the upgrade process.

Open Source 87

Open Source Best Practices Servers Database 87

Dynatrace

JULY 7, 2022

These teams typically use standardized tools and follow a sequential process to build, review, test, deliver, and deploy code. This distributed microservices approach gives applications more flexibility and enables them to spread processing requests across many resources, reducing bottlenecks. API gateways. Serverless platforms.

Architecture 189

Architecture Serverless Azure Programming 189

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. PMM monitors the MySQL uptime: show global status like 'uptime'; Indicates the amount of time (seconds) the MySQL server has been running since the last restart.

Performance 102

Performance Monitoring Traffic Database 102

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

MAY 28, 2020

While Google’s SRE Handbook mostly focuses on the production use case for SLIs/SLOs, Keptn is “Shifting-Left” this approach and using SLIs/SLOs to enforce Quality Gates as part of your progressive delivery process. This will enable deep monitoring of those Java,NET, Node, processes as well as your web servers.

Engineering 185

Engineering Performance Metrics Best Practices 185

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

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS.

Servers 49

Servers Azure Hardware Database 49

O'Reilly

NOVEMBER 21, 2019

This is precisely the kind of problem that robotic process automation (RPA) aims to address. She’s the vestigial human link in a process—insurance claims processing—that has a mostly automated workflow. Prior to RPA, enterprises used several different techniques to automate workflows and back-office processes.

Processing 84

Processing Programming Virtualization Technology 84

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. According to the Dynatrace Kubernetes in the Wild 2023 report , a significant 71% (with 48% year-over-year growth!)

Cloud 77

Cloud Open Source Strategy Best Practices 77

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

Dynatrace

JULY 29, 2020

Rich Lane : In the digital age where so much of an enterprise’s revenue and customer engagement comes from digital interaction, IT needs to shift from measuring success in terms of server up-time or number of incidents to business outcomes (e.g. Did our latest marketing push achieve a greater number of sales conversions?

Best Practices 179

Best Practices Mobile Architecture Monitoring 179

Dynatrace

AUGUST 30, 2019

Infrastructure Optimization: 100% improvement in Database Connectivity. Impacting Server-Side Requests: Dynatrace allows you to drill into your server-side requests to understand why your business logic is executing slow or fails. Too much data requested from a database, e.g. Request all and filter in memory.

Cache 190

Cache Architecture Database Government 190