Remove 2020 Remove Availability Remove Database Remove Servers
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. Ripple is an open source binlog server developed by Pavel Ivanov.

Servers 262
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. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here.

Servers 142
Insiders

Sign Up for our Newsletter

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

Trending Sources

article thumbnail

T-SQL Windowing Improvements in SQL Server 2022

SQL Performance

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. You can download this sample database here. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher.

Servers 145
article thumbnail

DBaaS Pros & Cons

Scalegrid

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

article thumbnail

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

This post was originally published in June 2020 and was updated in September 2023. MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database.

Tuning 52
article thumbnail

The new normal of digital experience delivery – lessons learned from monitoring mission-critical websites during COVID-19

Dynatrace

Readers who share our privacy concerns, please note, all the data we monitor is publicly available. . In the first two weeks in April , this state has had more web traffic than it had experience in 2020 to date. Monitoring with ?the the Dynatrace®? Digital Experience Management? The sessions continue to mount. .

Website 211
article thumbnail

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, logs, …

SQL Server According to Bob

SQL Server BDC Hints and Tips: Contained AGs, Ports, containedag_msdb, ​​ logs, ​​ … This blog ​​ post ​​ focuses on connecting to the SQL Server BDC, ​​ some ​​ helpful ​​ log files ​​ and utility outputs.

Servers 40