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. The MariaDB 11 series did not yet have any long-term supported (LTS) releases, which are the releases most would consider for running mission-critical databases in production.

Database 77

Database Servers Innovation Open Source 77

DZone

FEBRUARY 25, 2023

We will show you exactly how to deploy a Nodejs app to the server using Docker containers, RDS Amazon Aurora, Nginx with HTTPS, and access it using the Domain Name. These APIs will be used to check the status of the app, insert data in the database and fetch and display the data from the database.

AWS 274

AWS Servers Internet Internet 274

Percona Community

FEBRUARY 22, 2023

In this blog, we will explore databases on containers. 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.

Database 89

Database Servers Open Source Engineering 89

DZone

OCTOBER 9, 2022

Witness Server and Witness Directory are the most critical components of the Database Availability Group (DAG). DAG requires Witness Server or File Share Witness (FSW) and Directory to maintain the Quorum. In case of Witness Server failure, the Quorum is no longer maintained, leading to inconsistent DAG.

Servers 242

Servers Database Availability 242

Scalegrid

MAY 22, 2020

MySQL does not limit the number of slaves that you can connect to the master server in a replication topology. A classic solution for this problem is to deploy a binlog server – an intermediate proxy server that sits between the master and its slaves. Ripple is an open source binlog server developed by Pavel Ivanov.

Servers 262

Servers Transportation Database Availability 262

Scalegrid

APRIL 28, 2020

If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on their database hosting. MongoDB® Database. EC2 instances.

Azure 344

Azure AWS Database Latency 344

DZone

OCTOBER 26, 2021

Database Availability Group (DAG) is a built-in framework in Microsoft Exchange Server that uses continuous replication and failover clustering to ensure high availability and site resilience. In DAG, there is one active server and a copy of the database on the active server is replicated across all passive servers.

Servers 188

Servers Database Availability Performance 188

Scalegrid

AUGUST 26, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. We measure latency in ms 95th percentile latency.

Azure 299

Azure Benchmarking Database Latency 299

DZone

MARCH 4, 2023

In any organization, it is a best security practice to have an SSL certificate installed on servers, applications, and databases. SSL Certificates and CA make communication secure between client and server or application. We will use a Windows server for it. You can use any number of SSL certificates free of cost.

Servers 130

Servers Database Systems 130

DZone

FEBRUARY 9, 2024

SQL Server Always on availability group is a great addition to SQL Server for providing high availability and disaster recovery. Always-on availability group support failover the environment for a discrete set of user databases, known as availability databases, that failover together.

Availability 277

Availability Database Servers 277

SQL Shack

OCTOBER 6, 2021

This article explains the internals of the Ghost cleanup task for SQL Server Databases. Introduction Each relational database consists of the background process and user processes.Similarly, SQL Server has many internal processes such as Checkpoint, Lazy Writer, Lock Monitor, System_Health_Monitor, Trace Queue Task and Ghost CleanUp.

Database 83

Database Servers Monitoring Processing 83

Percona

APRIL 10, 2024

It’s a common scenario to have a Percona Monitoring and Management (PMM) server running on Kubernetes and also desire to monitor databases that are running outside the Kubernetes cluster. The Ingress NGINX Controller is one of the most popular choices for managing the inbound traffic to K8s.

Database 80

Database Monitoring Traffic Servers 80

Percona

OCTOBER 10, 2023

Databases are different from a lot of software. 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?

Availability 99

Availability Servers Database Open Source 99

Dynatrace

DECEMBER 9, 2020

If you’re running SAP, you’re likely already familiar with the HANA relational database management system. However, if you’re an operations engineer who’s been tasked with migrating to HANA from a legacy database system, you’ll need to get up to speed quickly. Avoid false positives with auto-adaptive baselining.

Infrastructure 202

Infrastructure Database Monitoring Metrics 202

SQL Shack

OCTOBER 6, 2021

This article gives an insight into the configuration of Min and Max memory for SQL Server Database instances. Introduction The server performance depends on various factors such as CPU, Memory, and Storage configurations. SQL Server works on top of the operating system and works closely with these resources.

Database 88

Database Servers Operating System Storage 88

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 83

Servers Database Open Source Scalability 83

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Why not have this built it into the server?

Database 184

Database Open Source Storage Servers 184

SQL Shack

APRIL 7, 2021

This article will explore the process to capture deadlock XML and deadlock graphs for AWS RDS SQL Server databases. Introduction As a database professional, you confront the performance issues with databases. It is essential to […].

AWS 74

AWS Database Servers Processing 74

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 81

Monitoring Servers Database Cloud 81

SQL Shack

NOVEMBER 9, 2021

This is the second article in the series of Migrating SQL Server Objects using SSDT 2017. In this article, we will learn how to copy user stored procedures created in the SQL Server master database. You can […].

Database 81

Database Servers Monitoring Performance 81

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 95

Database C++ Servers Open Source 95

Percona

FEBRUARY 9, 2023

Now it is time to get your databases ready for the rest of the year. If you replicate from one server to the next, are you replicating what you need? Take some to check how the server is being accessed, as you do not want a project to use the root access for all queries. Welcome to 2023! First, how are your backups?

Database 90

Database Open Source Hardware Operating System 90

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 112

Servers Best Practices Database Open Source 112

SQL Shack

SEPTEMBER 16, 2020

In the previous article, Transparent Data Encryption for SQL Server Always On Availability Groups, we discussed enabling TDE for the existing database in AG. In this article, we will explore options for a compressed backup of a TDE database. It uses the […].

Database 104

Database Availability Servers 104

SQL Shack

JULY 30, 2020

This is the 8th article in the series for SQL Server Always On Availability Groups. Introduction SQL Server Always On Availability Groups create a group of databases that fails over together in case the primary replica is unavailable. By default, SQL Server […].

Availability 88

Availability Database Servers 88

High Scalability

JUNE 27, 2019

Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy?

Open Source 196

Open Source Database Cloud Strategy 196

SQL Shack

MAY 13, 2020

In this article, we will learn latch contention issues that we might experience in the SQL Server TempDB database. Especially, we will mention the Memory-Optimized TempDB Metadata feature that was introduced with the SQL Server 2019. We will also discuss reasons and the solution method of these latch contention issues.

Database 68

Database Servers Performance Testing Testing 68

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON is popular. Very popular.

Database 91

Database Servers Processing Efficiency 91

SQL Shack

SEPTEMBER 22, 2020

This is the 25th article in SQL Server Always On Availability Groups series. In this article, we will explore the high availability configuration for reporting services databases.

Servers 65

Servers Availability Database Mobile 65

SQL Shack

OCTOBER 29, 2020

In this article, we will uncover some secrets about the SQL Server tempdb database. Tempdb is a system database and it is used for various internal and user operations. Besides this, the tempdb has many unique characteristics, unlike the other databases.

Database 63

Database Servers Systems Design 63

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

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 73

Database Open Source Servers Code 73

SQL Shack

SEPTEMBER 7, 2021

This article explores auto-update SQL Server Statistics asynchronous configuration for Azure SQL Database and On-premises SQL instance. The query optimizer uses SQL Server statistics as an informational source to know about the data distribution of […].

Azure 65

Azure Database Servers Performance 65

SQL Shack

OCTOBER 4, 2021

This article explores the MSDB SQL Database maintenance and cleanup process essential for every DBA. Introduction SQL Server system database – MSDB stores SQL Server agent jobs, History, schedules, database mail, service broker, backup, and restore History.

Database 97

Database Servers Systems Processing 97

Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. For the sake of simplicity and speed, I will use Percona Operator for MySQL (based on Percona Server for MySQL which is in tech preview).

Database 103

Database Open Source Monitoring Innovation 103

SQL Shack

AUGUST 31, 2020

This is the 16th article for SQL Server Always On Availability Groups series and explores SQL replication integration with AGs. Introduction Recently, I received a requirement to configure the SQL Replication for the availability group database. The specific requirements were as below.

Servers 67

Servers Availability Database 67

SQL Shack

APRIL 13, 2020

This article explores SQL Server Update Statistics using the database maintenance plan. Introduction SQL Server query optimizer uses statistics to build an optimized execution plan. SQL Server automatically creates and updates the statistics based on a predefined threshold.

Database 63

Database Servers Performance 63