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. The binlog server is set up as a slave to the master, and in turn, acts as a master to the original set of slaves. Ripple is an open source binlog server developed by Pavel Ivanov. Ripple server management.

Servers 139

Servers Transportation Database Processing 139

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. Assuming that the monitoring script is running on the same server as your MySQL server, you can check for the following: Ensure the MySQL service is running. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 205

Servers Availability Programming Database 205

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. Always On Availability Groups Security SQL Server 2019

Availability 84

Availability Servers Database 84

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. Check out these other posts to learn more about optimizing your MySQL deployments: Calculating InnoDB Buffer Pool Size for your MySQL Server. MySQL Tutorial – Configuring and Managing SSL On Your MySQL Server.

Servers 172

Servers Best Practices Efficiency Database 172

SQL Shack

SEPTEMBER 28, 2020

In this article, we will explore a new SQL Server 2019 feature which is Scalar UDF (scalar user-defined) inlining. Development Functions Performance SQL Server 2019

Servers 76

Servers Programming Code Software 76

SQL Shack

OCTOBER 6, 2020

In this 29th article of the SQL Server Always On Availability Groups series, we configure the AG between SQL Server Linux instances. Introduction SQL Server 2017 & 2019 works on the cross-platform operating system: Windows and Linux.

Availability 52

Availability Servers Operating System Systems 52

High Scalability

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. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

Servers 176

Servers Programming Database Availability 176

SQL Shack

JULY 15, 2020

In this article, we will proceed with configuring a SQL Server Always On Availability Groups and perform failover validations. A comprehensive guide to SQL Server Always On Availability Groups on Windows Server 2016 Configuration of virtual machines on Oracle […]. AlwaysOn Availability Groups Installation, setup and configuration SQL Server 2019

Servers 55

Servers Virtualization Availability Infrastructure 55

SQL Shack

OCTOBER 14, 2020

In this 32nd article on SQL Server Always On Availability Group series, we will discuss the process to apply a service pack or Cumulative packs for AG replica instances.

Availability 76

Availability Servers Processing 76

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 82

Tuning Servers Database Performance 82

SQL Shack

JULY 2, 2020

This article gives you an insight into SQL Server Index properties in SSMS. Introduction We can create indexes in SQL Server using both GUI and t-SQL method. Development Indexes SQL Server Management Studio (SSMS Once we create an index using t-SQL, we specify the index name, key columns, included columns, filter to create it. We do not consider other index options. While […].

Servers 57

Servers Development 57

SQL Shack

OCTOBER 20, 2020

In this 33rd article of SQL Server Always On Availability Group series, we will use extended events to monitor the availability group. Introduction Database professionals’ primary role is to do proactive monitoring for ensuring system availability.

Availability 81

Availability Monitoring Database Servers 81

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.

Availability 66

Availability Virtualization Database Servers 66

SQL Shack

OCTOBER 7, 2020

In this article, we will learn how to use Apache JMeter to perform a load test on SQL Server.

Latency 92

Latency Servers Performance Testing 92

SQL Shack

AUGUST 17, 2020

In this article, we will discuss how to resolve I/O problems that is a very important point for the SQL Server troubleshooting. Detecting and identifying I/O problems in SQL Server can be a tough task for the database administrators (DBAs).

Storage 76

Storage Database Servers Monitoring 76

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. Re-Slaving a Crashed #MySQL Master Server in Semisynchronous Replication Setup Click To Tweet. Remember that you need to retain the UUID of this server as before. In a MySQL 5.7

Servers 113

Servers Availability Database Processing 113

SQL Shack

SEPTEMBER 22, 2020

This is the 25th article in SQL Server Always On Availability Groups series. Configure SQL Server Reporting Services for standalone databases SQL Server Reporting Services (commonly known as SSRS) is a service to deploy paginated reports for web and mobile.

Availability 64

Availability Mobile Database Servers 64

SQL Performance

AUGUST 2, 2019

I have been making the same recommendations about tempdb since I started working with SQL Server over 15 years ago, when I was working with customers running version 2000. From the customer side, this has been the limit of what can be done*, until SQL Server 2019. The SQL Server team has made many changes over the years to try and mitigate issues, but the abuse continues. I have SQL Server 2019 CTP 3.2

Servers 77

Servers C++ Testing Virtualization 77

SQL Shack

MARCH 10, 2020

Introduction In this article, I’m going to explain what the Execution Plans in SQL Server are and how to understand the details of an execution plan by reading the various metrics available once we hover over the components in the plan. Execution plans SQL Server Management Studio (SSMS

Servers 44

Servers Metrics Availability 44

SQL Performance

OCTOBER 7, 2020

The Sort operator’s rewind behaviour may seem strange, but it has been this way from (at least) SQL Server 2000 to SQL Server 2019 inclusive (as well as Azure SQL Database). The post When Do SQL Server Sorts Rewind? Introduction.

Servers 65

Servers Cache Azure Storage 65

SQL Shack

AUGUST 25, 2020

In the previous article, An overview of distributed SQL Server Always On Availability Groups, we explored the concept of the distributed availability groups in SQL Server always on availability group. It is available from Windows Server 2016 and SQL Server 2017.

Availability 76

Availability Servers 76

SQL Shack

DECEMBER 23, 2019

This article targets the beginners and gives an introduction of the clustered index in SQL Server. Introduction An index plays a crucial role in SQL Server query performance. Indexes Performance SQL Server Management Studio (SSMS Consider a book library with thousands of books. You want to search for a specific book that contains the keyword “adventure” in the title. The books in […].

Servers 53

Servers Performance 53

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.

Availability 75

Availability Database Servers 75

SQL Shack

SEPTEMBER 29, 2020

In this article, we will learn the Delayed Durability feature that helps to improve transaction log file write throughput in SQL Server. OLTP (Online Transaction Processing) databases should process a huge number of transactions within the shortest time and concurrently.

Database 78

Database Servers Processing Performance 78

DZone

APRIL 30, 2020

Following on my previous article. Run your own Video Conference Service with Jitsi , I started looking for a reliable solution to monitor my instance that runs Jitsi. I needed basic information on RAM, CPU, Disk, Networking, and I/O to assess the performance bottleneck for the serve. I was familiar with the tools I used in the past, like Cacti , Nagios , and Zabbix.

Monitoring 118

Monitoring Servers Open Source Hardware 118

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 76

Availability Virtualization Database Servers 76

SQL Shack

MAY 27, 2020

In this article, we will explain batch mode on rowstore feature, which was announced with SQL Server 2019. Performance Performance Testing SQL Server 2019The main benefit of this feature is that it improves the performance of analytical queries, and it also reduces the CPU utilization of these types of queries. Behind the scene, this performance enhancement uses the batch mode […].

Analytics 55

Analytics Servers Performance Testing Testing 55

SQL Shack

OCTOBER 13, 2020

In this 31st article of the SQL Server Always On Availability Group series, we will explore how you can use the secondary replica SQL database for your workloads.

Availability 87

Availability Database Servers 87

SQL Shack

APRIL 14, 2020

SQL Server Performance Tuning can be a difficult assignment, especially when working with a massive database where even the minor change can raise a significant impact on the existing query performance. Performance Tuning always plays a vital role in database performance as well as product performance. A query can be optimized with the proper evaluation […]. Performance

Hardware 64

Hardware Tuning Database Servers 64

SQL Shack

SEPTEMBER 1, 2020

In this 17h article of the SQL Server Always On Availability Group series, we are going to explore the SQL Server replication for the distribution database in the availability group.

Availability 66

Availability Database Servers 66

SQL Shack

SEPTEMBER 29, 2020

In this 27th article of the SQL Server Always On Availability Group series, we will discuss various failover modes for AG databases.

Availability 62

Availability Database Servers 62

SQL Shack

JULY 10, 2019

By removing disk-based storage and the challenge of copying data in and out of memory, query speeds in SQL Server can be improved by orders of magnitude. Migration Performance SQL Server 2019Introduction In-memory technologies are one of the greatest ways to improve performance and combat contention in computing today. TempDB is one of the biggest sources of latency in […].

Latency 73

Latency Servers Storage Speed 73

SQL Performance

MARCH 31, 2020

SQL Server 2019 Cumulative Update #4 is available, with 50 enhancements. The post SQL Server 2019 Cumulative Update #4 appeared first on SQLPerformance.com. SQL Server 2019The build number is 15.0.4033.1.

Servers 40

Servers Availability 40

SQL Shack

NOVEMBER 25, 2019

In an article, An overview of the SQL table variable, we explored the usage of SQL table variables in SQL Server in comparison with a temporary table. Development Performance SQL Server 2019Let’s have a quick recap of the table variable: We can define a table variable and use it similar to a temporary table with few differences. The table […].

Servers 64

Servers Development Performance 64

SQL Server According to Bob

DECEMBER 18, 2018

SQL Server relies on Forced-Unit-Access (Fua) I/O subsystem capabilities to provide data durability, detailed in the following documents: SQL Server 2000 I/O Basic and SQL Server I/O Basics, Chapter 2. Durability is a cornerstone of any database system and starting with SQL Server 2017 on Linux Cumulative Update 6 (CU6), SQL Server on Linux enables “Forced Flush” behavior as described in this article , improving durability on non-Fua optimized systems. “Be

Servers 73

Servers Media Cache Storage 73

SQL Shack

AUGUST 21, 2020

This is the 12th article in the series of SQL Server Always On Availability Groups. Introduction SQL Server 2016 provides a new feature Distributed Availability Group for disaster recovery purposes.

Availability 76

Availability Servers 76

SQL Performance

MARCH 13, 2020

SQL Server 2019 Cumulative Update #3 is available, with 56 enhancements. The post SQL Server 2019 Cumulative Update #3 appeared first on SQLPerformance.com. SQL Server 2019The build number is 15.0.4023.6.

Servers 40

Servers Availability 40

SQL Shack

JULY 15, 2020

In this article, we will talk about the deadlocks in SQL Server, and then we will analyze a real deadlock scenario and discover the troubleshooting steps. In general, we can find out various theoretical advice and examples about the deadlock problems on the web but, in this article, we will tackle a true deadlock story […]. Deadlocks Performance

Servers 68

Servers Performance 68

SQL Performance

FEBRUARY 13, 2020

SQL Server 2019 Cumulative Update #2 is now available, with 134 fixes and improvements. The post SQL Server 2019 Cumulative Update #2 appeared first on SQLPerformance.com. SQL Server 2019Build # is 15.0.4013.40.

Servers 40

Servers Availability 40

SQL Shack

SEPTEMBER 20, 2019

In this article, we will discuss a few very common questions that you may be asked during a SQL Server administrator or developer technical job interview. Q1: What is a SQL Server Execution Plan? SQL Server Execution Plan is a binary representation of the steps that are followed by the SQL Server Engine to execute the query. […].

Servers 75

Servers Engineering Development 75

SQL Shack

APRIL 21, 2020

Query tuning is a very wide topic to talk about, but some essential techniques never change in order to tune queries in SQL Server. This article will cover some essential techniques for SQL query tuning. Particularly, it is a difficult issue for those who are a newbie to SQL query tuning or who are thinking […]. Performance Query analysis

Tuning 72

Tuning Servers Performance 72

SQL Shack

JULY 13, 2020

In this article, we will configure a SQL Server Always On Availability Group on the Windows Server 2016. We use SQL Server 2019 for configuration. Introduction SQL Server Always On Availability Groups offers high availability and disaster recovery solution for mission-critical databases. It also supports to offload some read workloads to the secondary replica. We […]. AlwaysOn Availability Groups Clustering High Availability

Availability 55

Availability Database Servers 55

SQL Shack

JULY 28, 2020

The storage subsystem is one of the key performance factors for SQL Server because SQL Server storage engine stores database objects, tables, and indexes on the physical files. In this article, we will learn how to test our storage subsystems performance using Diskspd.

Storage 70

Storage Engineering Database Servers 70