Percona

AUGUST 3, 2023

For further details, you can have a look at the documentation: [link] Generated Invisible Primary Keys This feature has been deployed in MySQL 8.0.30; it’s more recent. This is not a best practice at all, and we strongly encourage you to always create an explicit PK in your tables. Let’s see how it works.

Best Practices 76

Best Practices Open Source Code Engineering 76

Percona

JUNE 22, 2023

Defining high availability In general terms, high availability refers to the continuous operation of a system with little to no interruption to end users in the event of hardware or software failures, power outages, or other disruptions. Some disruption might occur, but it will be minimal. Fault tolerance aims for zero downtime and data loss.

Availability 105

Availability Database Open Source Hardware 105

HammerDB

OCTOBER 8, 2018

This post gives a HOWTO guide on system configuration for achieving top levels of performance with the HammerDB PostgreSQL TPC-C test. Firstly for system choice a 2 socket system is optimal for PostgreSQL OLTP performance at the time of writing. dev/nvme0n1p1 /mnt/ssd xfs noatime.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Smashing Magazine

NOVEMBER 19, 2021

Unfortunately, there aren’t any special systems to provide custom statically generated pages for different wildcard subdomains like you may with dynamic routing for example (where you have [slug].js With 100s of real-life examples , guidelines and best practices that you can apply right away. Server Side In getServerSideProps.

Servers 84

Servers Website Code Best Practices 84

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. provides the following guidance in its release notes: [link] The guidance here would be to use MongoDB 5.0.11 , as this has the required updates in place. It is best practice to have an odd number of replica set members to maintain voting quorum.

Database 78

Database Servers Storage Strategy 78

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. As well, very few cases are in need to have a full system/solution to provide scalability with sharding. The POC Why this POC?

Traffic 121

Traffic Scalability Database Servers 121

Smashing Magazine

OCTOBER 28, 2021

With 100s of real-life examples , guidelines and best practices that you can apply right away. You need to adapt your scraper’s code for a specific system , and if you use the same script on a new kind of page, you’d have to rewrite parts of it. More after jump! Online, and live. Oct 25 – Nov 8, 2021. Large preview ).

Website 115

Website Code Retail Best Practices 115

Percona

JULY 7, 2023

We’ll examine the intricacies of establishing high availability with PostgreSQL software and provide links to Percona HA PostgreSQL reference architectures for businesses of every size (startup/small, medium, large, and enterprise). When the primary server fails, a standby server takes over as the new primary.

Availability 82

Availability Open Source Architecture Database 82

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

Enprowess

SEPTEMBER 28, 2021

developers realize it is hard to understand the documentation of JSX React. This article has listed the top six best React JS alternatives for developers/business owners’ experience. Source: [link]. Developers can get help from the Preact documentation and official website examples to kick-start your application development.

Open Source 52

Open Source Mobile Entertainment Virtualization 52

Smashing Magazine

MAY 23, 2022

See the Pen [all property]([link] by Adrian Bece. See the Pen [all property - revert-layer]([link] by Adrian Bece. See the Pen [curentColor alerts]([link] by Adrian Bece. In my opinion, one of the best use-cases for currentColor is styling inlined SVG elements. See the Pen [currentColor svg]([link] by Adrian Bece.

Media 141

Media Tuning Design Website 141

Smashing Magazine

JULY 6, 2021

This data would be collated and authored in a Web Content Management System (WCMS) by a content editor. We had marketers from a Traditional CMS background who resisted the idea of delving into multiple systems and services when using a headless CMS. Tree structure, search and data type editors ( Large preview ). Content Previews.

Cache 143

Cache Website Mobile Google 143

Smashing Magazine

SEPTEMBER 6, 2021

Next, we’ll look at how to set up servers and clients (that’s the hard part unless you’re using a content delivery network (CDN)). You would, however, be hard-pressed even today to find a good article that details the nuanced best practices. Server Sharding and Connection Coalescing. However, if you’re still on HTTP/1.1,

Network 105

Network Servers Cache Traffic 105

Smashing Magazine

MAY 20, 2020

This metric shows how much time it takes for the server to respond with something. This metric is important, but quite vague because it can include anything — starting from server rendering time and ending up with latency problems. For more precise configuration, check the documentation. It’s up to you! Using Lighthouse.

Performance 99

Performance Metrics Best Practices Code 99

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

JANUARY 11, 2021

You can download the spreadsheet as Google Sheets, Excel, OpenOffice document or CSV. This knowledge will give you the best optimization target for ongoing efforts. In the end, it’s not the load events or server response times that define the experience, but the perception of how snappy the interface feels. Large preview ).

Performance 145

Performance Cache Media Metrics 145

Smashing Magazine

JULY 20, 2021

A Headless CMS is a system that provides the same features as a Content Management System (CMS) and more, all exposed through an API.”. A content delivery network (CDN), is a geographically distributed network of proxy servers and their data centers. Coupled: linked back-end front-end. <link rel="[link] href="[link].

Website 142

Website Architecture Technology Technology 142

Enprowess

MAY 20, 2022

Quick Links. Following are the responsibilities of Angular developers: Design and developing high-end user interface with the use of Angular best practices. Working With Version Control System. Following are the best version control system: HelixCore. Git is a project management system. Conclusion. #1

Development 52

Development Best Practices Code Testing 52

Enprowess

SEPTEMBER 20, 2021

link] Rendering. You’ll be able to use a scaffolding tool referred to as create-react-app to begin building your project , establish a local development server, check your code for errors, and execute unit tests/e2e. It provides scaffolding which can be used with build systems such as Browserify or Webpack (or no build system at all).

Open Source 52

Open Source Mobile Scalability Google 52

Smashing Magazine

NOVEMBER 4, 2021

Drew McLellan: He’s an engineer at Skypack and a major contributor to a new project called Astro, which aims to combine performance best practices with the developer experience improvements we see from component based approaches. Drew: So I’ve seen the documentation refer to the approach of islands rather than one big land mass.

Media 88

Media Website Architecture Servers 88

Smashing Magazine

FEBRUARY 2, 2022

In this article, we’re going to cover code-splitting best practices and showcase some examples using React, so we load the minimum JavaScript necessary to render a page and dynamically load sizeable non-critical bundles. On design systems, CSS/JS and UX. Image from bundlesizes documentation) ( Large preview ).

Code 89

Code Performance Network Website 89

O'Reilly

NOVEMBER 21, 2019

In a classic 1983 paper , cognitive psychologist Lisanne Bainbridge drew attention to a curious irony: so-called “automated” systems were, in practice, usually attended by one or more human operators. The more advanced the system, she observed, “the more crucial…the contribution of the human operator.”

Processing 83

Processing Programming Virtualization Technology 83

Rigor

SEPTEMBER 3, 2019

What you may be overlooking is that peak-event readiness is about more than just load testing or ensuring that your servers are up throughout a specific timeframe. Servers down or server health issues [APM]. Review OWASP’s recommendations and best practices with your developers.

Website 74

Website Cache Ecommerce Traffic 74

Smashing Magazine

JANUARY 7, 2019

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? Long FMP usually indicates JavaScript blocking the main thread, but could be related to back-end/server issues as well.

Performance 104

Performance Cache Network Metrics 104

Smashing Magazine

AUGUST 22, 2021

Latency can be roughly defined as the time it takes to send a packet from point A (say, the client) to point B (the server). It is physically limited by the speed of light or, practically, how fast signals can travel in wires or in the open air. As such, even low latencies of less than 50 milliseconds can add up to considerable delays.

Performance 106

Performance Network Latency Servers 106

SQL Performance

NOVEMBER 13, 2019

When I ran this query on my system, I got the following output: id grp datacol n - --. When I executed this query on my system for the first time, the row with id 2 got row number 2 and the row with id 11 got row number 3. So apparently the window order clause is mandatory for the ROW_NUMBER function in SQL Server.

Servers 104

Servers C++ Storage Performance 104

Smashing Magazine

JANUARY 6, 2020

Is it worth exploring tree-shaking, scope hoisting, code-splitting, and all the fancy loading patterns with intersection observer, server push, clients hints, HTTP/2, service workers and — oh my — edge workers? This knowledge will give you the best optimization target for ongoing efforts. What does it mean?

Performance 145

Performance Cache Network Metrics 145

Smashing Magazine

NOVEMBER 30, 2021

We last talked to him in July 2020 , where we asked if modern best practices about for the web. Last time we talked, we posed this question of if modern best practices, the use of reactive frameworks and these sorts of things were actually bad for the progress of the web. Drew: You want it to remain unspoiled.

Technology 94

Technology Technology Servers Code 94

O'Reilly

JULY 25, 2023

While this has the benefit of respecting user privacy by minimizing permissions (which is a best practice that ChatGPT may have learned from its training data), it made my coding efforts a lot more painful since I kept running into unexpected errors when I tried adding new functionality to my Chrome extension.

Programming 98

Programming Code Design Benchmarking 98

Smashing Magazine

JUNE 28, 2021

I’m not sure how I’d missed it because it seems to be maturing and well documented and a real… Just a great project. Drew: It’s an off the shelf design system that you can drop in to build the UI for your project. Drew: As you’d expect to find with a design system of this kind, it comes with components for typography.

Website 62

Website Design Open Source Software 62

Smashing Magazine

MARCH 7, 2022

In the past, Chrome used to perform changes to the website by proxying requests via their servers (similar to how Opera Mini works), but doing that is usually frowned upon these days. You can view all the client hints available for your browser at [link] (hint: use a Chromium-based browser to view this website or you won’t see much!).

Website 103

Website Media Mobile Network 103