SQL Shack

AUGUST 8, 2019

This article gives an overview of Windows Failover Cluster Quorum modes that is necessary for SQL Server Always on Availability Groups. Introduction SQL Server Always On is a flexible design solution to provide high availability (HA) and disaster recovery (DR).

Availability 55

Availability Servers Design 55

DZone

MAY 10, 2023

CloudFront CDN and CloudFlare CDN are two popular services available on the market. It’s a network of geographically distributed servers and data centers designed to deliver higher performance and high availability of internet content. What Is a CDN? CDN stands for content delivery network.

Internet 161

Internet Internet Network Website 161

Dynatrace

MARCH 6, 2024

IBM i, formerly known as iSeries, is an operating system developed by IBM for its line of IBM i Power Systems servers. IBM i is designed to integrate seamlessly with legacy and modern applications, allowing businesses to run critical workloads and applications.

Monitoring 235

Monitoring Infrastructure Metrics Analytics 235

Scalegrid

JANUARY 25, 2024

You will need to know which monitoring metrics for Redis to watch and a tool to monitor these critical server metrics to ensure its health. Understanding Redis Performance Indicators Redis is designed to handle high traffic and low latency with its in-memory data store and efficient data structures. <code> 127.0.0.1:6379>

Metrics 130

Metrics Monitoring Latency Cache 130

Dynatrace

FEBRUARY 27, 2024

Organizations can also drill deeper to discover what’s happening on the server side. “Dynatrace PurePath can trace hop to hop what went on in a user interaction to give a highly sophisticated root-cause analysis,” Chandler noted. These are all metrics Dynatrace collects directly out of the box.

Best Practices 235

Best Practices Metrics AWS Innovation 235

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. Insecure design This broad category refers to fundamental design flaws in the application caused by a failure to implement necessary security controls during the design stage.

Open Source 198

Open Source Artificial Intelligence Internet Internet 198

SQL Server According to Bob

SEPTEMBER 9, 2019

The lock manager (LockMgr) is designed to track partitioned and non-partitioned locks. 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.

Servers 103

Servers Database Scalability Tuning 103

The Morning Paper

JUNE 6, 2019

Towards federated learning at scale: system design Bonawitz et al., The Federated Averaging algorithm addresses one of the key challenges in making this practical: reducing the communication volume (by 10-100x) between the model server and the devices. We call this rendezvous between devices and server a round. SysML 2019.

Systems 71

Systems Design Google Servers 71

Dynatrace

JANUARY 31, 2024

million AI server units annually by 2027, consuming 75.4+ Model observability provides visibility into resource consumption and operation costs, aiding in optimization and ensuring the most efficient use of available resources. For example, generating an image requires as much power as fully charging your smartphone.

Cache 205

Cache Azure Infrastructure Monitoring 205

The Netflix TechBlog

FEBRUARY 3, 2021

At Netflix we strongly prefer schema-first development because: The schema design is front and center of the developer experience. Although it might be marginally quicker to generate schema from the code, putting the time into designing your schema in a human readable, collaborative way is well worth the effort towards a better API.

Open Source 246

Open Source Java Architecture Metrics 246

High Scalability

FEBRUARY 17, 2021

Redis Server: 5.07, x86/64. MongoDB server: 4.4.2, BangDB server: 2.0.0, All of these dbs are available free of cost for download / install and it will be fairly straightforward to run these tests in your environment for further analysis. About YCSB. Following configurations were used for the evaluation purpose.

Benchmarking 308

Benchmarking Latency C++ Database 308

Scalegrid

JANUARY 8, 2024

Infrastructure Excellence ScaleGrid’s infrastructure is designed to facilitate hosting in your cloud account and provides cost-saving options with AWS or Azure Reserved Instances or GCP. Meeting Business Demands with Hybrid Cloud A range of business demands can be met by the design of hybrid cloud solutions.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Percona

DECEMBER 4, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. It is the most stable, scalable, and secure open source MySQL distribution based on Percona Server for MySQL. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 81

Open Source Azure Servers Programming 81

O'Reilly Software

DECEMBER 28, 2017

Learn how to properly design RESTful APIs communication with clients, accounting for request structure, authentication, and caching. In this second part, we will talk in more detail about how the server should react to incoming requests with status codes. We are using the principles of RESTful architecture over HTTP.

Servers 83

Servers Cache Mobile Architecture 83

Percona

OCTOBER 2, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. It is the most stable, scalable, and secure open source MySQL distribution, with two download options: one based on Percona Server for MySQL and one based on Percona XtraDB Cluster.

Open Source 82

Open Source Scalability Database Servers 82

Percona

AUGUST 7, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Update to the release of Percona Server for MySQL 8.0.33-25 25 An update to the release of Percona Server for MySQL 8.0.33-25 25 is available as of August 2, 2023.

Open Source 84

Open Source Scalability Servers Database 84

Tasktop

APRIL 20, 2021

In this new release, we’re making all that even easier with a design facelift to this all-important area. Filter faster: Click an available quick filter to focus on specific blockers and background jobs . Additional strong authentication options are now available for Jira (X.590) Enhanced Flow Fabric Support for Your Tools.

Design 52

Design Healthcare Azure Government 52

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server. Installation and support of SSRS can be confusing.

Tuning 67

Tuning Servers Database Best Practices 67

Dynatrace

DECEMBER 15, 2022

ITOps refers to the process of acquiring, designing, deploying, configuring, and maintaining equipment and services that support an organization’s desired business outcomes. Computer operations manages the physical location of the servers — cooling, electricity, and backups — and monitors and responds to alerts.

Artificial Intelligence 203

Artificial Intelligence DevOps Hardware Virtualization 203

The Netflix TechBlog

JUNE 15, 2022

This post will discuss how Studio Search supports querying the data available in these indices. One other challenge for the users when writing the search queries is to understand the fields that are available in the index and the associated types. We chose to apply “late binding” (or “query time”) security?—?on

Engineering 183

Engineering Architecture Availability Tuning 183

Percona

JANUARY 3, 2024

The daemon accepts incoming traffic from MySQL clients and forwards it to backend MySQL servers. The proxy is designed to run continuously without needing to be restarted. These include runtime parameters, server grouping, and traffic-related settings. Below are backup methods to perform a backup restore of the ProxySQL server.

Traffic 110

Traffic Hardware Cache Servers 110

High Scalability

DECEMBER 16, 2022

It allows users to access and use shared computing resources, such as servers, storage, and applications, on demand and without the need to manage the underlying infrastructure. Another key benefit of cloud computing is its reliability and availability. Finally, cloud computing enables greater collaboration and innovation.

Cloud 201

Cloud Serverless Internet Internet 201

Percona

MAY 2, 2023

Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. Since your dataset is 100 GB and you have 500 GB of RAM, you can allocate a significant portion of the available memory to the InnoDB buffer pool. A commonly recommended value for the buffer pool size is between 50% to 75% of the available memory.

Social Media 120

Social Media Database Servers Cache 120

Scalegrid

JANUARY 11, 2024

Key Takeaways Cloud security monitoring is a comprehensive approach involving both manual and automated processes to oversee servers, applications, platforms, and websites, using tools that are customized to fit unique cloud architectures. This includes servers, applications, software platforms, and websites.

Best Practices 130

Best Practices Cloud Monitoring Strategy 130

Percona

JUNE 23, 2023

When you look at the multi-version concurrency control (MVCC) design that PostgreSQL uses and compare it to the designs of other databases, it looks chaotic. Both have various ways of replicating data to other servers, but the implementation details of one particular approach might be unpalatable for you.

Database 118

Database Transportation Servers Cloud 118

Percona

JULY 25, 2023

The data is internally inconsistent because the server concurrently modifies the data files while they are being copied. The changes done by an uncommitted transaction can be flushed or written to the redo log by the server. Initializing a DD engine and the cache adds complexity and other server dependencies.

Cache 84

Cache Benchmarking Servers Design 84

cdemi

DECEMBER 4, 2016

Maximizing Availability : Delays or Downtime of the service does not affect the application generating the messages. Control Costs : You don't have to design your service to meet peak load, but rather average load. Message Brokers are servers that take care of Queue Handling , Routing Messages, High Availability and Scaling out.

Design 47

Design Azure Scalability Latency 47

Dynatrace

SEPTEMBER 8, 2023

SQL Username: Username of the user who has permission to login on the SQL server remotely and access the database. To achieve this, we’ll create a Grail bucket specifically designed to retain data for a duration of 10 years (3,657 days). Configuration details Database configuration Endpoint name: Any label to identify this connection.

Database 270

Database Artificial Intelligence Metrics Monitoring 270

Percona

DECEMBER 7, 2023

Ensuring the security and resilience of your data hinges on having a robust backup strategy, and Percona XtraBackup (PXB), our open source backup solution for all versions of MySQL, is designed to make backups a seamless procedure without disrupting the performance of your server in a production environment. Percona XtraBackup 8.1

C++ 94

C++ Open Source Servers Database 94

Scalegrid

NOVEMBER 29, 2023

This blog post will explore some of the major challenges in database management that businesses can expect, especially when transitioning from traditional database servers. Automated backups mean your database will never be lost and it will always be available for your company.

Healthcare 130

Healthcare Hardware Database Scalability 130

Dynatrace

NOVEMBER 23, 2020

Kubernetes Dashboard as a part of a comprehensive monitoring solution This article introduces the key building blocks to consider when designing your Kubernetes monitoring solution. After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

Official Blog - World Web Technology

JANUARY 18, 2024

This universal approach enables feature-rich app creation with cohesive integration between client and server. Laravel web application development offers a streamlined solution for crafting modern and scalable design and development experiences. Developers compose intricate designs effortlessly as it enables rapid development.

Development 59

Development Website Efficiency Technology 59

Percona

SEPTEMBER 12, 2023

The auto-increment feature, which generates unique values for primary key columns, is an integral part of the database’s design. this enhancement ensures that the maximum auto-increment counter value persists between server restarts, providing enhanced consistency and reliability in data management. Compared to MySQL 5.7,

Servers 112

Servers Storage Database Open Source 112

Percona

OCTOBER 3, 2023

While THP can be beneficial for many applications, enabling it on a database server could have unintended consequences. In this post, we will explore THP, its impact on database servers, and how to disable it for optimal performance and stability. What are Transparent Huge Pages? In this case, THP is enabled.

Database 89

Database Servers Open Source C++ 89

Percona

APRIL 20, 2023

It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8.

Open Source 91

Open Source Best Practices Servers Database 91

The Netflix TechBlog

OCTOBER 7, 2021

However, Netflix is available for streaming on thousands of types of devices and it is powered by hundreds of micro-services which are deployed independently, making it extremely challenging to comprehensively test internally. So the main design tenets for this service along with reusability and extensibility are testability and traceability.

Metrics 197

Metrics Mobile Testing Strategy 197

Dynatrace

DECEMBER 8, 2022

DevOps platform engineers are responsible for cloud platform availability and performance, as well as the efficiency of virtual bandwidth, routers, switches, virtual private networks, firewalls, and network management. Open source CI/CD pipeline tool with extensible server automation for distributed builds and scaling. Atlassian Jira.

DevOps 191

DevOps Engineering Testing Open Source 191