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 92

Open Source Database Hardware Strategy 92

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. In each of the deployment models, the role of the database administrator is to make sure that SSRS is stable, dependable, and recoverable.

Tuning 67

Tuning Servers Database Best Practices 67

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

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 79

Cloud Open Source Strategy Best Practices 79

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

Percona

DECEMBER 6, 2023

This blog is regarding some of the usual MySQL database conversations and responses, which can appear “wrong” or “funny,” but there’s actually more to them. Additional read Mike’s blog on How to Find and Tune a Slow SQL Query Q: What is your disaster recovery (DR) strategy? What is that?

Strategy 78

Strategy Database Best Practices Tuning 78

Alex Podelko

FEBRUARY 28, 2021

There are many great blog posts: Performance Best Practices 7-parts series. Impact of Available IOPS On Your Database Performance. (I admired MongoDB classes long before I started to work there – in 2013, 8 years ago, I wrote Revolution in Vendor Education? What is MongoDB FTDC (aka. diagnostic.data).

Performance 200

Performance IoT Education Best Practices 200

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

Adrian Cockcroft

NOVEMBER 26, 2023

In this session, learn how AWS has been supporting customers like the Territorial Intelligence Centre (CIT) in designing cutting-edge tools to address traceability in supply chains with deforestation risks by integrating governmental databases, innovative map services, and land-use data from high spatial resolution satellite imagery.

AWS 52

AWS Energy IoT Best Practices 52

Dynatrace

SEPTEMBER 20, 2019

Stay tuned for further updates! Within minutes you can download and deploy a single Dynatrace node, (or cluster of nodes) that contains all the key components needed to run Dynatrace (no requirement for separate databases). Dynatrace Managed. So, it’s great that a FedRAMP certified offering is coming, but what about today?

Software 122

Software Software Logistics Government 122

Adrian Cockcroft

JUNE 21, 2022

I was mostly coding in C, tuning FORTRAN, and when I needed to do a lot of data analysis of benchmark results used the S-PLUS statistics language, that is the predecessor to R. We had specializations in hardware, operating systems, databases, graphics, etc. Rich Pettit is one of the best programmers I ever met.

Tuning 52

Tuning Benchmarking Engineering C++ 52

Percona

JULY 6, 2023

Performance is one of the essential aspects of a database management system. I included a sequence creation statement for the id column since one best practice is always to have a primary key column, but for the specific examples we will go through, we don’t need it. Tune the random_page_cost parameter.

Best Practices 89

Best Practices Tuning Database Testing 89

Dynatrace

JANUARY 13, 2021

Dynatrace’s OneAgent automatically captures PurePaths and analyzes transactions end-to-end across every tier of your application technology stack with no code changes, from the browser all the way down to the code and database level. Stay tuned for an upcoming Performance Clinic !

Open Source 139

Open Source Code Monitoring Azure 139

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

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. As the data is distributed into smaller partitions, the database engine only needs to scan relevant partitions, leading to faster query responses.

Strategy 40

Strategy Storage Database Best Practices 40

SQL Performance

JUNE 21, 2019

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. When looking at backups, I check for recovery model and the current history of backups for each database. Azure SQL Database and Azure Managed Instance have managed backups.

Servers 49

Servers Azure Hardware Database 49

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 126

Speed Java AWS Virtualization 126

SQL Server According to Bob

FEBRUARY 15, 2018

Microsoft engineering is actually sending quite a few folks over the Atlantic to come talk about SQL Server 2017, SQL Server on Linux, GDPR, Performance, Security, Azure Data Lake, Azure SQL Database, Azure SQL Data Warehouse, and Azure CosmosDB. Best practices on Building a Big Data Analytics Solution – Michael Rys.

Engineering 40

Engineering Azure Best Practices Servers 40

HammerDB

OCTOBER 18, 2019

HammerDB doesn’t publish competitive database benchmarks, instead we always encourage people to be better informed by running their own. HammerDB has a signficant advantage of being able to run on multiple databases allowing this sort of question again to be answered from your running your own tests.

Benchmarking 63

Benchmarking Performance Hardware C++ 63

SQL Performance

OCTOBER 18, 2022

In my examples, I’ll use the sample database TSQLV6. You can download the script file to create and populate this database here and find its ER diagram here. Naturally, the best thing you can do as a developer is to be familiar with best practices and ensure that you write your queries with SARGable predicates, such as Query 6.

Servers 144

Servers Code Best Practices Database 144

Brendan Gregg

APRIL 30, 2018

In this year's CFP we’re looking for topics covering the latest trends and best practices in cloud computing, containerization, machine learning, big data, infrastructure, scalability, DevOps, IT management, automation, reliability, monitoring, performance tuning, security, databases, programming, datacenters, and more.

DevOps 43

DevOps Network Best Practices Programming 43

Brendan Gregg

APRIL 29, 2018

In this year's CFP we’re looking for topics covering the latest trends and best practices in cloud computing, containerization, machine learning, big data, infrastructure, scalability, DevOps, IT management, automation, reliability, monitoring, performance tuning, security, databases, programming, datacenters, and more.

DevOps 40

DevOps Network Best Practices Programming 40

Brendan Gregg

SEPTEMBER 25, 2021

A Cassandra database cluster had switched to Ubuntu and noticed write latency increased by over 30%. top(1) showed that only the Cassandra database was consuming CPU. Amazon even provides an official [recommendation] (2021): "For EC2 instances launched on the AWS Xen Hypervisor, it's a best practice to use the tsc clock source.

Speed 40

Speed Java AWS Virtualization 40

VoltDB

MAY 2, 2017

This has always been a supported configuration of VoltDB database replication. Here’s how we explain it in our Documentation: Support for different cluster sizes in passive Database Replication (DR). Once the replication of changes has resumed, pause the database at the backup site.

Hardware 40

Hardware Database Servers Tuning 40

SQL Server According to Bob

JANUARY 11, 2020

KB sectors run on smaller sectors   14 System and sample databases   15 Determining the formatted sector size of database   15 What sector sizes does SQL Server support? SQL Server 2005 introduces the snapshot database feature for point-in-time databases ​​ and online DBCC operations.

Servers 40

Servers Cache Database Media 40

O'Reilly

JULY 25, 2023

While this has the benefit of respecting user privacy by minimizing permissions (which is a best practice that ChatGPT may have learned from its training data), it made my coding efforts a lot more painful since I kept running into unexpected errors when I tried adding new functionality to my Chrome extension.

Programming 98

Programming Code Design Benchmarking 98

O'Reilly

OCTOBER 11, 2022

However, one thing should be obvious: to fill a prescription, you need to access many different kinds of data, in many different databases. Never assume that most businesses are well run, and that they represent some sort of “best practice.” Is special-purpose training to fine-tune a model’s behavior an option?

Games 116

Games Healthcare Processing Retail 116