Percona

DECEMBER 4, 2023

It is the most stable, scalable, and secure open source MySQL distribution based on Percona Server for MySQL. A release highlight is the implementation of telemetry in Percona Server for MySQL that fills in the gaps in our understanding of how you use Percona Server for MySQL to improve our products. Percona XtraBackup 8.0.35-30

Open Source 83

Open Source Azure Servers Programming 83

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. I always check backups first when looking at a new system.

Servers 49

Servers Azure Hardware Database 49

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. Host MySQL on AWS , or MySQL on Azure with configurable instance sizes through the top two cloud providers in the world.

Database 166

Database Cloud Website Azure 166

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. Be sure to deploy SQL Server 2017 CU6 or newer for best data durability and performance results. “. “Be

Servers 90

Servers Media Cache Storage 90

Scalegrid

JANUARY 3, 2020

ScaleGrid provides full admin access to your MySQL deployments – this makes it easier to integrate the existing MySQL ecosystem of tools with your ScaleGrid MySQL deployments on AWS or Azure. The MySQL Exporter tool can be installed locally on a MySQL server or centrally on the Prometheus server.

Monitoring 164

Monitoring Metrics Servers Database 164

SQL Server According to Bob

FEBRUARY 7, 2020

SQL Server dbcc clonedatabase ​​ - ​​ Gotcha The dbcc clonedatabase is a ​​ handy command to clone metadata and ​​ information such as ​​ query disk store. The new database generated from DBCC CLONEDATABASE is primarily intended for troubleshooting and diagnostic purposes.

Servers 45

Servers Azure Tuning Database 45

SQL Performance

OCTOBER 7, 2020

The documentation says only the following operators can rewind: Table Spool. 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? Row Count Spool.

Servers 106

Servers Cache Azure Performance 106

Dynatrace

AUGUST 24, 2020

Metrics to find out how the behavior of a system has changed over time . Traces help find the flow of a request through a distributed system . To provide actionable answers monitoring systems store, baseline, and analyze telemetry data. Dynatrace VMware and virtualization documentation . Kubernetes integration.

Analytics 135

Analytics Infrastructure AWS Operating System 135

Particular Software

AUGUST 16, 2021

How do I move from Azure Tables to Cosmos DB? ?? Cosmos DB is the primary database service provided by Azure. Under the hood, each “record” in Cosmos DB is a JSON document with an ID and partition key that, together, define its globally unique ID. Why should I use NServiceBus Cosmos DB persistence? What is Cosmos DB?

Azure 52

Azure Serverless Storage Database 52

Percona

DECEMBER 12, 2022

The percona-ppg-server meta-package installs PostgreSQL and the extensions, while percona-ppg-server-ha package installs high-availability components that are recommended by Percona. This release is focused on the Percona Server for MySQL-based deployment variant. It is based on Percona Server for MySQL 8.0.30-22.

Open Source 62

Open Source Azure Database Servers 62

SQL Server According to Bob

OCTOBER 26, 2017

Please check out these new resources for SQL Server 2017 and SQL Server on Linux and Docker: Brk2045 upgrade sql server 2017 (on prem, iaa-s and paas) from Bob Ward. Brk2051 sql server on linux and docker from Bob Ward. SQL Server 2017 Release Notes. SQL Server on Linux Release Notes. SQL Server on Linux.

Servers 40

Servers Azure Open Source Database 40

Particular Software

JANUARY 27, 2020

It is preceded in death by Windows Communication Foundation and Windows Workflow Foundation, and survived by Azure Queues and Azure Service Bus. Since it exists in Windows 10 and Windows Server 2019, MSMQ will continue to live on until at least 2029—and much longer assuming it isn't removed from future versions of Windows.

Transportation 98

Transportation Azure Open Source Systems 98

Dynatrace

JULY 10, 2019

What Dynatrace deployment is the best fit for your technology stack, and is the OneAgent compatible with your system? OneAgents are optimized to send data to the Dynatrace servers with the smallest possible impact, querying the metrics every minute, and the data is a first-class citizen for the Dynatrace AI root-cause analysis.

Java 139

Java Best Practices Metrics Azure 139

Percona

APRIL 12, 2023

Whereas many open source software offerings — like the community version of MySQL — use the GNU General Public License ( GPL ), MongoDB has been under the GNU Affero General Public License ( AGPL ) and more recently under the Server Side Public License ( SSPL ), introduced by MongoDB itself. Is MongoDB free to use?

Open Source 86

Open Source Programming Database Servers 86

Randon ASCII

JULY 11, 2022

This slowdown may be mitigated in Windows 11 but in the latest Windows Server editions – where it matters most – this bug is alive and well. This table told me that if I’m spending 16% of a core on page faults then I’m probably also spending – hidden in the System process – about 13.7% But I digress…. of a core on zeroing memory.

Cache 105

Cache Energy Google Processing 105

SQL Performance

MARCH 15, 2021

In my last post , I illustrated one reason you should stop using deprecated system tables like sysprocesses. This wasn't for performance reasons, directly, or to simply follow Microsoft's documented best practices, but revolved more around the decisions you might make when you only have access to some of the data.

Servers 64

Servers Azure Best Practices Monitoring 64

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. When you have multiple copies of your data on different database servers — or even better, in different data centers worldwide — replication provides a high level of fault tolerance in case of a disaster.

Database 84

Database Servers Storage Strategy 84

Percona

MAY 2, 2023

As a MongoDB user, it’s crucial to ensure that your data is safe and secure in the event of a disaster or system failure. Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks. Why are MongoDB database backups important?

Best Practices 52

Best Practices Database Storage Servers 52

Particular Software

MARCH 15, 2021

For NServiceBus systems, our SQL Persistence package allows you to use whatever flavor of SQL works best for you, supporting dialects for Microsoft SQL Server, MySQL, PostgreSQL, and Oracle. The same can be said for any system that uses SQL to store data. SQL Server Always Encrypted SQL Persistence 6.1 is a big release.

Transportation 52

Transportation Azure Database Servers 52

SQL Server According to Bob

JANUARY 26, 2017

My goal is to resolve mysteries about SQL Server I encounter but do this without going straight the source code first. The first case that helped me start this journey was asked by a MVP within the SQL Server community (his first name starts with Joey<g>). The question went something like this….

Servers 40

Servers Database Azure Cache 40

IO River

NOVEMBER 2, 2023

It’s not just limited to cloud resources like AWS and Azure; Terraform is versatile, extending its capabilities to key performance areas like Content Delivery Network (CDN) management, ensuring efficient content delivery and optimal user experience.‍Started ‍AutomationCode-based systems also shine in automation.

Open Source 52

Open Source DevOps AWS Azure 52

Percona

JANUARY 24, 2023

For the major clouds, read the following docs: Google – Documentation on Volume Snapshots for GKE AWS – Using EBS Snapshots for persistent storage with your EKS cluster Azure – AKS CSI documentation Once you have CSI configured and Volume Snapshot Class is in place, proceed to create a backup.

Database 70

Database Storage Open Source AWS 70

IO River

NOVEMBER 2, 2023

This means that with Terraform, you can manage resources across multiple cloud providers, including AWS, Azure, Google Cloud, and more, using a single tool.‍A This level of granularity is not found in UI-managed systems. AutomationCode-based systems also shine in automation. Hold that thought.

Open Source 40

Open Source DevOps AWS Azure 40

Smashing Magazine

NOVEMBER 8, 2018

Sharing Data Among Multiple Servers Through AWS S3. Sharing Data Among Multiple Servers Through AWS S3. After the file is uploaded to a server on step 1, the file must be available to whichever server handles the request for steps 2 and 3, which may or may not be the same one for step 1. Leonardo Losoviz.

AWS 44

AWS Servers Storage Cloud 44

Particular Software

MAY 28, 2018

Getting approval for more servers can be a bit dicey. You can reap the DevOps benefits of hosting your endpoints in Docker containers and use container orchestration technologies like Kubernetes on their own or through managed services like Azure Kubernetes Service or Amazon Elastic Container Service for Kubernetes. So are we done?

Azure 49

Azure Open Source DevOps Storage 49

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40

Smashing Magazine

JUNE 25, 2020

Today, we’ll address storing and serving files for both single-server and scalable deployments while considering factors like compression, caching, and availability. Any file uploaded by a user, from profile pictures to personal documents, is called a media file. The two types of Django deployments are: Single-Server.

Media 69

Media Cache Storage AWS 69

O'Reilly

NOVEMBER 12, 2019

Rather than buying racks and racks of servers that need to handle the maximum potential traffic and be idle most of the time, it seems that serverless’ method of paying by compute is proving to be beneficial to the bottom lines of organizations. The third stand-out issue was “no server maintenance.” 1 reported benefit. 1 in tools used.

Serverless 88

Serverless Architecture FinTech Infrastructure 88

Adrian Cockcroft

NOVEMBER 13, 2023

The carbon footprint of a large rack mounted server is order-of-magnitude a ton of carbon a year. A rough guide if you don’t have any better data is that with no traffic to a system it will be 10% utilization and use 30% of peak power, 25% utilization uses 50% of peak power, and at 50% utilization it uses 75% of peak power.

Energy 52

Energy Cloud Traffic Transportation 52

cdemi

DECEMBER 4, 2016

Message Brokers are servers that take care of Queue Handling , Routing Messages, High Availability and Scaling out. Azure Service Bus - The Go-To choice if you're already on Azure, High Throughput, Predictable Performance, Predictable Pricing, Secure, Scalable on Demand. Message Brokers.

Design 47

Design Azure Scalability Latency 47

Enprowess

JANUARY 12, 2022

IoT tracking systems. Use in traffic systems: Using IoT technology, delivery, traffic or transportation tracking, asset tracking, inventory control, customer management, and individual order tracking can be more cost-effective with the right tracking system. Blockchain technology is an encrypted database storage system.

Blockchain 59

Blockchain IoT Development Serverless 59

SQL Performance

MAY 7, 2019

I’m going to introduce you to wait statistics and explain how critical they are for troubleshooting workload performance in SQL Server. The execution of SQL Server’s internal code is done using a mechanism called threads. When that happens, SQL Server makes a note of why the thread had to wait and this is called the wait type.

Servers 40

Servers Azure Metrics Tuning 40

Smashing Magazine

NOVEMBER 5, 2019

The last thing users want is to sift through lengthy documentation or video tutorials to upload a simple spreadsheet. Although engineers understand the complexities of importing data into an advanced system (like Microsoft Azure ), there is still an exhaustive amount of content they need to understand before the first import even happens.

Azure 51

Azure Website Code Systems 51

Particular Software

AUGUST 8, 2017

We believe it's better for you as a developer, better for DevOps, and better for the future evolution of your NServiceBus systems. Better for you The headline feature of SQL Persistence is its support for multiple engines, which currently includes Microsoft SQL Server, Oracle, and MySQL. It's worth it.

DevOps 40

DevOps Database Education Engineering 40

Smashing Magazine

JUNE 1, 2022

These services use requests to external hosts (not servers you control) to deliver JavaScript framework libraries, custom fonts, advertising content, marketing analytics trackers, and more. RUM systems embed a small JavaScript payload onto every page of your site. The CSS-Tricks website has good documentation on font-display.

Website 131

Website Design Network Best Practices 131

Scalegrid

MAY 2, 2019

Like the driver documentation says, this is not recommended as it makes the connection susceptible to man-in-the-middle attacks. With MongoDB deployments, failovers aren’t considered major events as they were with traditional database management systems. Testing Failover Behavior. Configuring the Network Timeout Values.

Testing 55

Testing Network Database Servers 55

Abhishek Tiwari

NOVEMBER 3, 2018

Recently I was asked about content management systems (CMS) of the future - more specifically how they are evolving in the era of microservices, APIs, and serverless computing. If you put your whole website on CDN, technically you don’t need a large number of server infrastructure and CMS licenses. Decoupled CMS vs. headless CMS.

Systems 63

Systems Cache Website Network 63