Scalegrid

MARCH 8, 2024

This article delivers a practical roadmap for using backups and binary logs to achieve accurate MySQL recovery, detailed steps for setting up your server, and tips for managing recovery and backups effectively without overwhelming you with complexity. In such scenarios, PITR acts as an indispensable recovery mechanism.

Database 162

Database Strategy Servers Best Practices 162

Percona

AUGUST 1, 2023

Because of its NoSQL origin and document architecture design, MongoDB is much more flexible and scalable than SQL databases such as MySQL. LDAP support is available in MongoDB Enterprise but not in MongoDB Community Edition. However, it is available in other open-source versions of MongoDB, such as Percona Server for MongoDB.

Best Practices 40

Best Practices Transportation Open Source Traffic 40

Percona

SEPTEMBER 28, 2023

Whenever you install your favorite MySQL server on a freshly created Ubuntu instance, you start by updating the configuration for MySQL, such as configuring buffer pool, changing the default datadir director, and disabling one of the most outstanding features – query cache. It’s a nice thing to do, but first things first.

Servers 109

Servers Best Practices Database Open Source 109

Percona

JULY 7, 2023

With the average cost of unplanned downtime running from $300,000 to $500,000 per hour , businesses are increasingly using high availability (HA) technologies to maximize application uptime. Where a high availability design once worked well, it can no longer keep up with more complex requirements.

Availability 82

Availability Open Source Architecture Database 82

Scalegrid

DECEMBER 28, 2023

Offset-based involves utilizing functions such as skip , limit and a query which indicates how many documents should be skipped or returned at maximum. Its use includes the limit method, which establishes how many documents will be returned in a query result. This can be expressed as db.collection_name.find().limit(number).

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Scalegrid

FEBRUARY 15, 2024

Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections. Preparing SSL Certificates for MongoDB The SSL certificates are necessary for our MongoDB server to establish secure SSL/TLS communications.

Servers 130

Servers Best Practices Government Network 130

Dynatrace

JANUARY 19, 2020

Having released this functionality in a Preview Release back in May 2019, we’re now happy to announce the General Availability of our SAP ABAP monitoring extension. As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. Dynatrace news. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 155

Monitoring Best Practices Infrastructure Servers 155

Dynatrace

DECEMBER 16, 2020

The full list of secure development controls, along with many more details, are documented at Dynatrace secure development controls. All steps are fully automated, from source code being compiled to binaries, to the upload of the binaries to the AWS infrastructure where they are available for customers to download.

Software 239

Software Software Development AWS 239

Dynatrace

MAY 31, 2019

As of today, the SAP ABAP application server remains the central component of the SAP ERP solution. The ABAP platform monitoring solution is based on the remote monitoring approach and so relies on a Dynatrace ActiveGate extension: No agent installation on SAP servers is required. No ABAP code instrumentation or injection is performed.

Monitoring 161

Monitoring Best Practices Programming Infrastructure 161

The Netflix TechBlog

AUGUST 10, 2022

The incredible depth and flexibility of game engines also means there are infinite permutations and combinations of configurations and settings available to the operator. It acts as dynamic documentation, a checklist, and a co-pilot to allow the operator to focus on the creative aspects.

Virtualization 239

Virtualization Engineering Games C++ 239

Dynatrace

MAY 28, 2020

If you have a distributed environment with multiple servers hosting your webservers, app servers, and database, I suggest you install the OneAgent on all these servers to get full end-to-end visibility. This will enable deep monitoring of those Java,NET, Node, processes as well as your web servers.

Engineering 195

Engineering Performance Metrics Best Practices 195

IO River

NOVEMBER 2, 2023

While this information is often encrypted with public key cryptography, the CDN servers hold the private key, allowing them to decrypt incoming requests, process them, and route them to the origin. TLS certificates are typically installed and managed on the CDN's edge servers.

Strategy 52

Strategy Cache Best Practices Website 52

Scalegrid

DECEMBER 16, 2019

It’s a cross-platform document-oriented database that uses JSON-like documents with schema, and is leveraged broadly across startup apps up to enterprise-level businesses developing modern apps. Sharding is ideal for very large data sets or high throughput deployments that require more capacity that you can get with a single server.

Azure 187

Azure AWS Latency Database 187

The Netflix TechBlog

DECEMBER 11, 2020

We partnered with Netflix’s Developer Experience (DevEx) team to build out documentation, training materials, and tutorials for developers. We engaged with them to determine graph schema best practices to best suit the needs of Studio Engineering. DGS developers can choose a solution based on their needs.

Architecture 249

Architecture Best Practices Engineering Open Source 249

Percona

AUGUST 30, 2023

Hot backups vs. cold backups: A hot backup — used to minimize downtime and ensure data availability for critical applications — allows you to create a copy of a database while the system is still actively serving user requests and processing transactions. In a cold backup, the database is taken offline. .”

Database 85

Database Hardware Open Source Strategy 85

IO River

NOVEMBER 2, 2023

While this information is often encrypted with public key cryptography, the CDN servers hold the private key, allowing them to decrypt incoming requests, process them, and route them to the origin. TLS certificates are typically installed and managed on the CDN's edge servers.

Strategy 40

Strategy Cache Best Practices Website 40

The Netflix TechBlog

FEBRUARY 25, 2021

Our experience using GQLMS for rapid proof-of-concept applications confirmed two theories regarding the advertised benefits of GraphQL: The GraphiQL IDE displays any available GraphQL documentation right alongside the schema, dramatically improving developer ergonomics for API consumers (in contrast to the best-in-class Swagger UI ).

Database 201

Database Entertainment Infrastructure Architecture 201

Percona

OCTOBER 18, 2023

Our goal with this post is to equip you with a comprehensive understanding of the steps, best practices, and pros and cons to ensure a smooth — and successful — transition to an open source database environment. Does anyone on my team require further training before we start?

Open Source 89

Open Source Database Hardware Strategy 89

Percona

SEPTEMBER 26, 2023

From the MySQL documentation: The PRIMARY KEY clause is a critical factor affecting the performance of MySQL queries and the space usage for tables and indexes. When a delete or update operation is executed on the primary database, affecting multiple rows, it may execute swiftly on the primary server. or a later release.

Database 97

Database Engineering Best Practices Open Source 97

Percona

AUGUST 3, 2023

Metadata regarding invisibility is available on the information_schema, and the INVISIBLE/VISIBLE keyword is preserved in the binlog, so all changes are correctly replicated. This is not a best practice at all, and we strongly encourage you to always create an explicit PK in your tables.

Best Practices 76

Best Practices Open Source Code Engineering 76

HammerDB

OCTOBER 8, 2018

available cpufreq governors: performance powersave. GHz. The governor "performance" may decide which speed to use. D isabling all C-states or Idle states is likely to reduce overall performance by reducing the available turbo frequency. Available idle states: POLL C1 C1E C6. 'on'.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Dynatrace

JULY 10, 2019

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. Check out the best practices for accelerating Dynatrace APIs if you select this approach! Extending Dynatrace is easy!

Java 140

Java Best Practices Metrics Azure 140

Percona

JULY 19, 2023

Creating the build environment The first step is downloading the source code to MySQL / Percona Server for MySQL 8.0.32 , then extracting the tarball. $ cd $HOME $ wget [link] $ tar -xvzf percona-server-8.0.32-24.tar.gz mkdir ~/percona-server-8.0.32-24/plugin/ulid/ 24/plugin/ulid/ $ cd ~/percona-server-8.0.32-24/plugin/ulid/

C++ 79

C++ Servers Benchmarking Best Practices 79

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. It provides redundancy and data availability for your data. Replication provides redundancy, and having multiple copies of the same data increases data availability. MongoDB is popular with developers as it is easy to get started with.

Database 78

Database Servers Storage Strategy 78

Testlodge

MARCH 15, 2023

Good test documentation comes in very handy at this time because issue resolution is time-sensitive. With the rise of CI servers and GitHub actions, these tools have evolved to analyze the code whenever it is committed to a central repository. Many tools are available, and again, your choice will depend on your code’s language.

Testing 83

Testing Testing Tools Java Programming 83

The Netflix TechBlog

OCTOBER 23, 2019

This combination of code, data and execution results into a single document makes notebooks powerful, but also difficult to reproduce. Indeed, the scientific computing community has documented some notebook reproducibility concerns as well as some best practices for reproducible notebooks.

Open Source 233

Open Source Code Website Design 233

CSS Wizardry

MARCH 3, 2019

This includes CDNs, proxy servers, and the like. Once the 60 seconds is up, the browser will head back to the server to revalidate the file. It means ‘do no t serve a copy from cache until you’ve revalidated it with the server and the server said you can use the cached copy’. public and private. Cache-Control: no-cache.

Cache 264

Cache Latency Strategy Servers 264

Dynatrace

APRIL 22, 2020

In this article, I will share some of the best practices to help you understand and survive the current situation — as well as future proof your applications and infrastructure for similar situations that might occur in the months and years to come. Documentation is good. There are proven strategies for handling this.

Traffic 208

Traffic Ecommerce Retail Government 208

Dynatrace

OCTOBER 17, 2019

We’re no longer living in an age where large companies require only physical servers, with similar and rarely changing configurations, that could be manually maintained in a single Datacenter. Treating these different processes as code will ensure that best practices are followed. Dynatrace news. Benefits of Everything as Code.

Code 110

Code Infrastructure DevOps Serverless 110

CSS - Tricks

DECEMBER 23, 2020

If you don’t use Chrome or Chromium-based browsers, like Microsoft Edge or Brave, you can run Lighthouse through its web interface but it only works with publicly available web pages. Once the CLI has been installed successfully, ru lhci --help to view all the available commands that the tool provides.

Performance 78

Performance Storage Servers Virtualization 78

MachMetrics

APRIL 3, 2020

And if you absolutely have to have it on a device, most of them are available via Kindle as well. Author Steve Souders writes about the best practices that he gained as the Chief Performance Yahoo! Even Faster Web Sites: Performance Best Practices For Web Developers. Let’s get started!

Speed 85

Speed Performance Best Practices Website 85

Percona

JULY 2, 2023

Having a backup strategy in place that takes regular backups and has secure storage is essential to protect the database in an enterprise-grade environment to ensure its availability in the event of failures or disasters. Automatic Backups Setting up automated backup procedures in PostgreSQL is important for data safety and availability.

Strategy 52

Strategy Database Storage Open Source 52

ACM Sigarch

JULY 17, 2023

One such challenge has been the emergence of marginal defect-driven faults that are difficult to address solely using best practices in manufacturing test and screening. The differences in the environment and conditions between Automated Test Equipment (ATE) and regular server platforms also provide challenges.

Energy 52

Energy Hardware Best Practices Architecture 52

Smashing Magazine

MAY 5, 2021

While LCP is a user-centric metric, reducing it should make a big help to Google bots as Googe states: “The web is a nearly infinite space, exceeding Google’s ability to explore and index every available URL. For Googlebot, a speedy site is a sign of healthy servers so that it can get more content over the same number of connections.”.

Google 111

Google Architecture Servers Speed 111

Smashing Magazine

NOVEMBER 19, 2021

We’ll be focusing on three places where you can get the wildcard: Server Side In getServerSideProps , Client Side With useEffect , Server Side On API Routes And Edge Functions. 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

APRIL 24, 2023

Here we are just highlighting one of the scenarios during work on the client environment where we noticed that the ProxySQL mysql_users table had more than 100 user entries, but some of them were available/inserted into the clear text password, whereas some were inserted properly into hashed entries.

Database 78

Database Best Practices Open Source Testing 78

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