article thumbnail

Exploring MySQL Binlog Server – Ripple

Scalegrid

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.

Servers 167
article thumbnail

How Do the Docker Client and Docker Servers Work?

DZone

It uses the Docker Client and Docker Server to provide a seamless workflow. Docker can be used across various cloud, desktop, and server platforms. It is available for macOS, Windows, Linux Distributions, Windows Server 2016, AWS, Google Compute Platform, Azure, and IBM Cloud.

Servers 224
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

article thumbnail

Important Health Checks for your MySQL Master-Slave Servers

Scalegrid

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 179
article thumbnail

Beginners’ Guide to Run a Linux Server Securely

DZone

Linux could be a fantastic choice for your next cloud server. Although connecting to a server just using a single line command, you are keeping it secure could be a bit tricky.

Servers 157
article thumbnail

Managing MySQL Server Logs: Rotate, Compress, Retain & Delete

Scalegrid

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 160
article thumbnail

Additional T-SQL Improvements in SQL Server 2022

SQL Performance

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.

Servers 112
article thumbnail

New Bit Manipulation Functions in SQL Server 2022

SQL Performance

Even SQL Server stores some flag-based data using bitwise representation. Setting the server configuration option “ user options” using bitwise representation. Prior to SQL Server 2022, T-SQL had minimal support for bit manipulation. SQL Server 2022 bit manipulation bitwise

article thumbnail

React Server Components

Addy Osmani

React Server Components aim to enable modern UX with a server-driven mental model. In this post I will share some notes I took while catching up on the latest RFC and talk around this work

Servers 114
article thumbnail

T-SQL Windowing Improvements in SQL Server 2022

SQL Performance

Microsoft recently released the first public preview of SQL Server 2022. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. Conclusion and Other T-SQL Improvements in SQL Server 2022.

Servers 114
article thumbnail

How to Change DAG Witness Server and Witness Directory

DZone

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.

Servers 205
article thumbnail

Monitoring Web Servers Should Never Be Complex

DZone

If you run several web servers in your organization or even public web servers on the internet, you need some kind of monitoring. If your servers go down for some reason, this may not be funny for your colleagues, customer, and even for yourself. Introduction.

article thumbnail

SQL Server On Linux: Forced Unit Access (Fua) Internals

SQL Server According to Bob

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
article thumbnail

LDAP Improvements in Percona Server for MySQL 8.0.30-22

Percona

Percona Server for MySQL 8.0.30-22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. For example, the variable authentication_ldap_simple_server_host is called authentication_ldap_sasl_server_host.

Servers 62
article thumbnail

Important Health Checks for your MySQL Master-Slave Servers

High Scalability

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 162
article thumbnail

Hybrid Buffer Pool in SQL Server 2019

SQL Shack

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. Buffer Pool Extension (BPE) Execution plans Performance SQL Server 2019

Cache 79
article thumbnail

FIDO Authentication in Percona Server for MySQL 8.0.30-22

Percona

Percona Server for MySQL 8.0.30-22 introduces a new authentication plugin, named authentication_fido. The server does accept the statement without the clause but the account is unusable because the user cannot connect to the server to register the device.

article thumbnail

Configure cross-platform SQL Server Always On Availability Groups

SQL Shack

This article for the Always On Availability Groups series will show how to configure SQL Server Always On Availability Groups between Windows and Linux SQL instances. Introduction Microsoft supports SQL Server on Linux, and it has many of the same features as the Windows version.

article thumbnail

Key Performance Measurements for App Servers: Cause, Impact, and Resolution

DZone

Server page faults/second. database performance garbage collection memory leaks app server performance monioringBelow are some of the key metrics that need to be monitored during performance testing: CPU utilization. Heap memory utilization. Number of active/daemon threads. Number of classes loaded. Cache hit ratio. Active total sessions. SSL transactions/second. Active/total DB pool connections. Application log. Load balancing. Requests/second.

Servers 122
article thumbnail

How It Works: SQL Server Lock Partitioning

SQL Server According to Bob

The partitioned memory and latch objects protect in-memory structures for short durations and can be sized according to available memory for SQL Server. Bob Dorr – Principal Software Engineer SQL Server Previous posts have discussed partitioning, for example, a partitioned memory object [link] and how a latch maintains the desired access (exclusive, shared, …) [link]. Quick Refresher Over Partitioned Protection/Locking.

Servers 82
article thumbnail

Configuring unixODBC and SQL Server Drivers for HammerDB on Linux

HammerDB

In this post, we will do a walk through example of installing and configuring unixODBC and the SQL Server on Linux drivers as well as the HammerDB connection options to enable HammerDB on Linux to be able to connect to SQL Server.

Servers 59
article thumbnail

Scalar UDF Inlining in SQL Server 2019

SQL Shack

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 88
article thumbnail

Fundamentals of SQL Server Statistics

SQL Shack

In this article, we will take a glance at the fundamentals of SQL Server statistics and discover their interaction with the query processing steps with simple examples.

Servers 87
article thumbnail

Column-level SQL Server encryption with SQL Server Always On Availability Groups

SQL Shack

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

article thumbnail

SQL Server Log Writer Workers

SQL Server According to Bob

SQL Server 2017 leverages up to 4 log writer workers, on hidden schedulers, to assist in transaction log processing activities. You may find the number of log write workers has been increased to 8 when running newer releases of SQL Server to accommodate larger systems. During SQL Server startup the number of log writer workers is determined. SQL Server 2017 General How It Works It Just Runs Faster NUMA Performance Scheduler

Servers 40
article thumbnail

Take the SQL Server Mac challenge

SQL Server According to Bob

When I joined Microsoft in 1993, I would embark on a 25 year journey working only on Windows laptops and Windows Server computers. Last October we released SQL Server 2017 including support for Linux and Docker Containers. Since then, I have spent a great deal of my time talking to customers directly and at events about SQL Server on Linux. So here in this blog post, I will show you my journey in taking the SQL Server Mac Challenge. Take the SQL Server Mac Challenge!

Servers 40
article thumbnail

SQL Server Linux: Directory fsync Activities

SQL Server According to Bob

The SQL Server Host Extension provides file level integrity. Bob Dorr – Principal Software Engineer SQL Server. SQL Server 2017 How It Works SQL Server on LinuxWhen Creating, Renaming or Deleting (remove/unlinking) a file, Linux requires the direct parent directory to be synchronized. As documented in the manpage for fsync core changes to the directory require the directory itself to be synchronized.

Servers 40
article thumbnail

tempdb Enhancements in SQL Server 2019

SQL Performance

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
article thumbnail

SQL Server Extended Events tips

SQL Shack

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 77
article thumbnail

Install SQL Server 2019 on Windows Server 2016 with SQL Server Always On Availability Groups

SQL Shack

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 […].

Servers 63
article thumbnail

Monitor Your Servers With Cockpit

DZone

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.

article thumbnail

SQL Mysteries: SQL Server Login Timeouts – A Debugging Story

SQL Server According to Bob

Failures occur from remote clients or sqlcmd executed directory on the server (/opt/mssql-tools/bin). SQL Server 2017 CU10 does not show behavior. · SQL Server 2017 CU12 exhibits the behavior. Server is a Superdome with lots of CPUs and RAM. One of the first stops in debugging this issue is the SQL Server health session traces located in the /var/opt/mssql/log/system_health*.xel sp_server_diagnostics_component_result.

Servers 40
article thumbnail

SQL Server Hardware Optimization

SQL Server Performance

You monitor the server over time so that you can determine Server average […]. An important concern in optimizing the hardware platform is hardware components that restrict performance, known as bottlenecks. Quite often, the problem isn’t correcting performance bottlenecks as much as it is identifying them in the first place. Start with obtaining a performance baseline. General DBA Performance Tuning hardware

article thumbnail

Re-Slaving a Crashed MySQL Master Server in Semisynchronous Replication Setup

Scalegrid

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 104
article thumbnail

Bad Habits: Avoiding NULL in SQL Server

SQL Performance

The post Bad Habits: Avoiding NULL in SQL Server appeared first on SQLPerformance.com. A long time ago, I answered a question about NULL on Stack Exchange entitled, “ Why shouldn’t we allow NULLs? ”

article thumbnail

SQL Server Worker Thread Default Calculation

SQL Server According to Bob

SQL Server 2017 introduced a small change to SQL Server’s default worker thread calculation, accounting for smaller environments. When running on smaller environments SQL Server reduces the worker target. For an X64 installation, using the sp_configure ‘max worker threads’ value of 0 SQL Server uses the following calculation. On small environments SQL Server always uses 256 as the target. SQL Server 2017

Servers 40
article thumbnail

Monitoring SQL Server blocking problems

SQL Shack

In this article, we will learn how to monitor SQL Server blocking issues with different methods. How does a blocking occur in SQL Server? SQL Server uses the lock mechanism to protect […].

article thumbnail

Query Tuning with SQL Server 2019

SQL Shack

In this article, we will talk about the query tuning features that were announced with SQL Server 2019. Performance SQL Server 2019Introduction Sometimes, tuning the queries can be a tough task for database developers or administrators.

Tuning 68
article thumbnail

SQL Server on Linux: Why Do I Have Two SQL Server Processes

SQL Server According to Bob

When starting SQL Server on Linux why are there two (2) sqlservr processes? systemctl status mssql-server mssql-server.service – Microsoft SQL Server Database Engine … CGroup: /system.slice/mssql-server.service ??85829 For those signals that default to capturing a full process CORE DUMP, SQL Server on Linux installs alternate signal handlers. Bob Dorr – Principle SQL Server Software Engineer. Linux SQL Server 2017 SQL Server on Linux

Servers 40
article thumbnail

SQL Server for Linux Performance Monitoring Improvements

SQL Server According to Bob

SQL Server for Linux Performance Monitoring ​​ Improvements Last year I posted a blog ​​ with examples ​​ using ​​ Performance Co-Pilot, ​​ [link] , to monitor SQL Server on Linux.

article thumbnail

SQL Server dbcc clonedatabase – Gotcha

SQL Server According to Bob

SQL Server dbcc clonedatabase ​​ - ​​ Gotcha The dbcc clonedatabase is a ​​ handy command to clone metadata and ​​ information such as ​​ query disk store. I have been testing ​​ SQL Server ​​ High Availability failovers ​​ in combination with database creates and drops, including clonedatabase.

article thumbnail

Unrevealed tips of SQL Server Statistics

SQL Shack

In this article, we will explore some internal working principles of SQL Server statistics. The Cardinality Estimator (CE) is the core subunit of the SQL Server query optimizer and its responsibility is to predict how many rows will be returned from a query.

Servers 75
article thumbnail

HOW IT WORKS: SQL Server Scheduler Affinity

SQL Server According to Bob

HOW IT WORKS: SQL Server Scheduler Affinity SQL Server uses 3 types of affinity to control where the SQL Server worker threads execute. Node Types SQL Server makes a specific distinction between scheduling and memory nodes. SQL Server may choose to divide the memory node allow ing ​​ for better partitioning and performance. This allows you to scale up or down the SQL Server schedulers without restarting the SQL Server.

Azure 40
article thumbnail

SQL Server Linux: fsync and Buffered I/O

SQL Server According to Bob

I was asked to validate the SQL Server behavior in light of the error condition involving fsync/fdatasync outlined in this article. SQL Server does NOT do this, in fact I made sure SQL Server on Linux does not allow this to occur. This issue does NOT impact SQL Server database, log and backup files. SQL Server opens these file types using O_DIRECT to bypass file system cache. Bob Dorr – Principal Software Engineer SQL Server.

Cache 40