Scalegrid

NOVEMBER 25, 2021

Migrating ScaleGrid for Redis™ data from one server to another is a common requirement that we hear from our customers. Two of the main reasons we hear are often due to migration of hardware, or the need to split data between servers.

Hardware 246

Hardware Servers 246

Percona

OCTOBER 17, 2023

This blog post discusses using the CLONE INSTANCE command with the safety option DATA DIRECTORY when you do not have enough disk space to store two datasets. MySQL Clone plugin simplifies new replica provisioning but does not simplify server restore after failure unless you are ready to re-install your MySQL instance from scratch.

Open Source 104

Open Source Servers Database Strategy 104

Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 273

Servers Monitoring Availability Programming 273

DZone

JULY 3, 2023

Data engineering projects often require the setup and management of complex infrastructures that support data processing, storage, and analysis. In this article, we will explore the benefits of leveraging IaC for data engineering projects and provide detailed implementation steps to get started.

Data Engineering 141

Data Engineering Infrastructure Engineering Code 141

SQL Shack

AUGUST 28, 2020

In this 15th article of SQL Server Always On Availability Groups series, we will cover Transparent Data Encryption (TDE) for AG databases. Introduction In the previous articles of SQL Server Always On series, we explored the following topics so far.

Availability 94

Availability Servers Virtualization Database 94

Percona

NOVEMBER 1, 2023

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 102

Servers Database Cache C++ 102

Percona

OCTOBER 10, 2023

This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Why choose Percona Server for MongoDB? Why release Percona Server for MongoDB 7 now? which was released as Percona Server for MongoDB RC 7.0.2-1.

Availability 106

Availability Servers Database Open Source 106

DZone

FEBRUARY 15, 2022

Fetching data from the server and maintaining it is a very crucial issue in frontend development. library applications and how we maintain the server state with the library called React-Query. To manage the server state in the frontend and sync with the backend, we need to update, cache, or re-fetch the data efficiently.

Cache 130

Cache Servers Efficiency Performance 130

SQL Shack

SEPTEMBER 23, 2020

In this 26th article for SQL Server Always On Availability Groups series, we will discuss the process to suspend and resume data movements between AG replicas.

Availability 104

Availability Servers Network Processing 104

SQL Shack

OCTOBER 14, 2021

Transparent Data Encryption (TDE) encrypts database files to secure your data. It also encrypts the tempdb database to secure your data in a temporary space. Even non-encrypted databases hosted on the same SQL Server instance would have some performance degradation because of […].

Servers 79

Servers Performance Database Systems 79

Dynatrace

APRIL 13, 2023

The massive volumes of log data associated with a breach have made cybersecurity forensics a complicated, costly problem to solve. As organizations adopt more cloud-native technologies, observability data—telemetry from applications and infrastructure, including logs, metrics, and traces—and security data are converging.

Analytics 185

Analytics Java Infrastructure Cloud 185

Percona

MARCH 26, 2024

Grafana uses PostgreSQL instead of SQLite database to store users, dashboards, and other persistent data. This aids in getting some useful information related to [configured alerts] directly via querying from the Postgres backend.Sometimes we need to migrate only alert rules from one PMM server to another for some […]

Monitoring 87

Monitoring Servers Database Cloud 87

Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. Setting Up MySQL Server Logging. Managing MySQL Server Logs: Rotate, Compress, Retain & Delete Click To Tweet. MySQL Tutorial – Configuring and Managing SSL On Your MySQL Server.

Servers 247

Servers Best Practices Efficiency Availability 247

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. For example, suppose that prior to SQL Server 2022 you had the following query: SELECT. So far so good. FROM T1 INNER JOIN T2 ON T1.

Servers 142

Servers Testing C++ Code 142

Smashing Magazine

SEPTEMBER 28, 2022

Five Data-Loading Patterns To Improve Frontend Performance. Five Data-Loading Patterns To Improve Frontend Performance. Data loading patterns are an essential part of your application as they will determine which parts of your application are directly usable by visitors. But isn’t waiting for the data the point?

Performance 125

Performance Cache Servers Social Media 125

Percona

APRIL 14, 2023

A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory. So, how do you know if your hot data is in memory? MySQL does.

Cache 96

Cache Efficiency Database Monitoring 96

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 89

Servers Database Open Source Scalability 89

Percona

MARCH 1, 2023

So you get the Umaluts, Cedils, and C-J-K Language support in your data, plus emojis. EXPLAIN without the ANALYSE gives you the server’s estimated analysis of the performance of your query. But before going with the MySQL Community Edition, you should look at Percona Server for MySQL. Why Percona Server for MySQL?

Servers 123

Servers Open Source Tuning C++ 123

DZone

NOVEMBER 15, 2022

Ransomware attacks on on-premises Exchange Servers are quite common as they store sensitive and confidential information and business data. The attackers often exploit vulnerabilities to gain access to the organization's network and steal or encrypt data for ransom.

Strategy 109

Strategy Servers Network 109

Percona

OCTOBER 31, 2023

Having seen this, the most advisable action is to run pt-table-checksum , and if any differences appear, use pt-table-sync to fix the data drift. As this is a dual-primary topology, it is advisable to perform a checksum on the other primary server as well, which is PS-primary-2. With larger volumes, the same scenario also applies.)

Database 108

Database Servers Efficiency Performance 108

Percona

APRIL 28, 2023

Did you notice that Percona Server for MongoDB 6.0.5-4 This time around, it introduced improvements to the way we handle master key rotation for data at rest encryption as well as AWS IAM integration. 4, one key path can be used for all servers in a clustered environment. Changes introduced with Percona Server for MongoDB 6.0.5-4

AWS 109

AWS Servers Scalability Database 109

Scalegrid

DECEMBER 9, 2019

However, discarding a server like this is expensive and inefficient. In this blog post, we will explain an approach to detect and fix transactions on the crashed MySQL master server in a semisynchronous replication setup, and how to re-slave it back into your master-slave setup. As a result, the data inconsistency may go undetected.

Servers 160

Servers Database Processing Availability 160

Dynatrace

APRIL 23, 2024

When operational disruptions strike—whether it’s a rogue server or a cyberattack—Dynatrace services remain in harmony. How Dynatrace will support you The Dynatrace secret weapon is data. Imagine a dashboard that whispers, “Hey, there’s a vulnerability brewing in Server Room B.” The show must go on.

Tuning 243

Tuning Strategy Servers Technology 243

SQL Shack

OCTOBER 12, 2020

It is the 30th article in the SQL Server Always On Availability Groups series and explores column-level SQL Server encryption with AG groups. Introduction We might have sensitive data in our SQL database such as customers’ credit card details, bank account details, social security numbers, and medical history.

Servers 105

Servers Availability Database 105

Speed Curve

FEBRUARY 5, 2024

Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. I mean, why wouldn't we?

Servers 57

Servers Cache Retail Benchmarking 57

SQL Shack

AUGUST 17, 2021

This article intends to give information about the SQL Server filtered indexes and their performance impacts. Introduction Indexes are the special data structures that help to improve the performance of the queries in SQL Server.

Servers 110

Servers Performance 110

Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. Percona plans As you read this on the Percona Blog, you may be interested in Percona’s plan for Percona Server for MySQL regarding announced changes.

Database 83

Database Servers Innovation Open Source 83

Dynatrace

MARCH 18, 2024

Following FinOps practices, engineering, finance, and business teams take responsibility for their cloud usage, making data-driven spending decisions in a scalable and sustainable manner. Empowering teams to manage their FinOps practices, however, requires teams to have access to reliable multicloud monitoring and analysis data.

Best Practices 232

Best Practices Strategy Cloud AWS 232

Percona

JANUARY 5, 2024

The AWS KMS component is now available in Percona Server for MySQL starting from version 8.0.30. This addition enables data-at-rest encryption by utilizing the AWS KMS component, providing the functionality to create and manage cryptographic keys across AWS services.How do we set up encryption using AWS KMS?You

AWS 93

AWS Servers Availability Cloud 93

Percona Community

FEBRUARY 22, 2023

We will use Docker as a container engine tool and Percona Server for MySQL as a database administration tool. MySQL is a relational database management system that stores data on disk. Percona Server for MySQL is a fork of MYSQL, providing much more advanced features. Both are open source tools.

Database 89

Database Servers Open Source Engineering 89

DZone

JANUARY 30, 2024

The evolution of enterprise software engineering has been marked by a series of "less" shifts — from client-server to web and mobile ("client-less"), data center to cloud ("data-center-less"), and app server to serverless.

Software Engineering 266

Software Engineering Engineering Software Software 266

SQL Shack

OCTOBER 14, 2021

This article explores the Causality tracking option in the SQL Server Extended Events session(XEvents) and its usefulness in troubleshooting performance issues. Introduction to SQL Server Extended Events(XEvent) The SQL Server Extended event (XEvent) is a lightweight tool to collect data for troubleshooting.

Servers 99

Servers Performance Monitoring 99

SQL Shack

NOVEMBER 17, 2021

This article aims to provide some beneficial tips about SQL Server extended events that make it easier to create and use event sessions. Introduction SQL Server extended events is a performance monitoring tool that has the ability to collect various event data of the SQL Server.

Servers 89

Servers Monitoring Performance 89

SQL Shack

NOVEMBER 23, 2021

This article explores the Hybrid Buffer Pool feature available in the SQL Server 2019. Introduction SQL Server uses Dynamic Random Access Memory (D-RAM) buffer pool for caching data pages retrieved from the disk. The buffer cache stores the page and writes back to disk only if it is modified.

Servers 93

Servers Cache Availability Performance 93

SQL Shack

AUGUST 27, 2020

In this article, we will learn some basic tips for SQL Server performance tuning. Tuning the SQL Server performance will help to access data faster so the applications data interaction performances will enhance. SQL Server […].

Tuning 114

Tuning Servers Performance Database 114

Percona

MARCH 13, 2023

to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 server with Percona XtraBackup. In my lab, we have two test nodes: PRIMARY: mysql57 (192.168.56.111) with Percona Server 5.7 server instances are ready for an upgrade. On primary server mysql5.7,

Servers 110

Servers C++ Storage Systems 110

SQL Shack

SEPTEMBER 29, 2020

In this 28th article for SQL Server Always On Availability Group series, we explore the high-availability for the SQL Server PolyBase(SSB) external tables using AG groups. SQL Server PolyBase Introduction It is a new feature from SQL Server 2016 to query the relational and non-relational database using data virtualization techniques.

Servers 99

Servers Availability Virtualization Database 99