Scalegrid

FEBRUARY 15, 2024

In a world where data security is essential, enabling MongoDB SSL is critical in fortifying your database. Each section is crafted to elevate your database’s security protocol, from acquiring the necessary SSL certificates to configuring server and client connections.

Servers 130

Servers Best Practices Government Network 130

Scalegrid

DECEMBER 9, 2019

However, when the crashed master comes back, you may find that it has transactions that are not present in the current master (which was previously a slave). However, discarding a server like this is expensive and inefficient. Default database: 'test'. Remember that you need to retain the UUID of this server as before.

Servers 160

Servers Database Processing Availability 160

Scalegrid

DECEMBER 14, 2023

How the MongoDB timeout is set up can significantly affect your application’s performance, no matter if you are an experienced MongoDB user or just starting with NoSQL databases. Typical applications are interacting with different database servers based on the business logic.

Java 130

Java Network Servers Database 130

Scalegrid

NOVEMBER 23, 2023

Imagine a world where your PostgreSQL® database connections are seamless and secure. Key Takeaways Understanding PostgreSQL hostname is essential for successful database connections. Configure the PostgreSQL hostname by editing configuration files and restarting the server, with secure storage of connection details to enhance security.

Database 130

Database Servers Storage Network 130

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. On-premises data centers invest in higher capacity servers since they provide more flexibility in the long run, while the procurement price of hardware is only one of many cost factors. Kubernetes is emerging as the “operating system” of the cloud.

Open Source 346

Open Source Java Operating System Programming 346

Speed Curve

FEBRUARY 5, 2024

Server-timing headers are a key tool in understanding what's happening within that black box of Time to First Byte (TTFB). Cue server-timing headers Historically, when looking at page speed, we've had the tendency to ignore TTFB when trying to optimize the user experience. I mean, why wouldn't we?

Servers 57

Servers Cache Retail Benchmarking 57

Scalegrid

JANUARY 25, 2024

Redis® is an in-memory database that provides blazingly fast performance. This makes it a compelling alternative to disk-based databases when performance is a concern. 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.

Metrics 130

Metrics Monitoring Latency Cache 130

The Netflix TechBlog

JUNE 12, 2023

In its typical configuration the Crypt agent enforces FileVault upon login and escrows the resulting recovery key to a corresponding Crypt server. Relatively few authorization plugins are broadly used within the Mac admin community, but one popular example is the Crypt agent. We call this new tool Escrow Buddy.

Open Source 194

Open Source Database Servers Storage 194

Dynatrace

MAY 27, 2022

At Dynatrace Perform 2022 , David Walker, a Lockheed Martin Fellow, and William Swofford, a full-stack engineer at Lockheed Martin, discuss how to create a self-diagnosing and self-healing IT server environment using this AIOps combination for auto-baselining, auto-remediation, monitoring as code, and more. An example of the self-healing web.

Artificial Intelligence 192

Artificial Intelligence Innovation Servers Database 192

DZone

JANUARY 29, 2021

Application Programming Interface acts as the center level between the database and presentation layer in the software development procedure. It is mainly the channel that links the client to the server, drives business procedures, and gives the services which give worth to users.

Testing 207

Testing Programming Performance Database 207

SQL Performance

JANUARY 20, 2022

All through my career as a data professional, both inside Microsoft and as a consultant, I’ve found one of the most misunderstood parts of a SQL Server database is the transaction log. A transaction encompasses a change or a set of changes to a database. Logging, Log Records, and the SQL Server Transaction Log.

Servers 54

Servers Database Architecture Performance 54

Percona

MAY 2, 2023

The common use cases involve sharing pt-mysql-summary, pt-stalk, and other OS-related details to assist Support Engineers or any other third-party team troubleshoot database-related issues. Sometimes crucial data sharing is avoided because of compliance rules, organizational policies, or numerous security concerns.

Database 89

Database Systems Open Source Engineering 89

Dynatrace

JULY 1, 2020

In fact, one of the most challenging areas is the use of thick client presentation layers, such as SAP’s Graphical User Interface (SAPGUI). . SAP provides SAP GUI , known as one of the presentation layers to access ECC and S/4HANA applications. ABAP task performance and database response time.

Database 245

Database Servers Monitoring Code 245

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

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. It is also important to monitor your server’s memory usage regularly to ensure that it is not being exhausted by the buffer pool.

Social Media 119

Social Media Database Servers Cache 119

Dynatrace

OCTOBER 23, 2023

This presents a challenge for IT operations teams, specifically in identifying and addressing performance issues or planning how to prevent future issues. Determining the root cause of these issues can be difficult when the underlying “hardware” is a virtualization software stack rather than a bare-metal server.

Efficiency 219

Efficiency Virtualization Hardware Performance 219

Percona

OCTOBER 17, 2023

MySQL Clone plugin simplifies new replica provisioning but does not simplify server restore after failure unless you are ready to re-install your MySQL instance from scratch. Since you decided to clone a replica from another server, you agreed to lose your current data. After that, start the server.

Open Source 95

Open Source Servers Database Strategy 95

Dynatrace

JANUARY 31, 2024

While off-the-shelf models assist many organizations in initiating their journeys with generative AI (GenAI), scaling AI for enterprise use presents formidable challenges. million AI server units annually by 2027, consuming 75.4+ For example, generating an image requires as much power as fully charging your smartphone.

Cache 209

Cache Azure Infrastructure Monitoring 209

Percona

SEPTEMBER 21, 2023

Percona has sponsored this show for many years, provided presenters, and participated in the expo hall. The presentations have always come from the community and run the gambit from well-known individuals in the community to those less famous but still passionate about their subjects. First-time presenters welcome!

Open Source 108

Open Source Programming Software Software 108

CSS Wizardry

AUGUST 7, 2019

A lot of people surmise that TTFB is merely time spent on the server, but that is only a small fraction of the true extent of things. TTFB isn’t just time spent on the server, it is also the time spent getting from our device to the sever and back again (carrying, that’s right, the first byte of data!). But what else is TTFB?

Latency 269

Latency Ecommerce Servers Mobile 269

Percona

NOVEMBER 6, 2023

localhost The use of the characters % and _ as wildcards in database-level grants is now deprecated. TO dave will grant user dave access to all the tables in database dave_ but not dave1, davex, or davey. Also deprecated is the use of % by the server as a synonym for localhost when checking privileges. release of version 8.0.35

Open Source 107

Open Source Database Servers Scalability 107

SQL Performance

OCTOBER 21, 2021

How the presentation layer deals with empty strings or NULLs shouldn’t be the driver for your table design and data model. Well, I’ve seen this in current systems where they use some arbitrary-sounding date in views to act as a magic filter, only presenting rows where the value can be trusted. I’m sorry, but that’s not a good reason.

Servers 103

Servers Design Speed Code 103

Scalegrid

AUGUST 22, 2019

On the first node, Patroni initializes the database, obtains the leader lock from DCS, and ensures the node is being run as the master. The yaml configuration file must be present using these high level configuration settings: Global/Universal. Standby Server Tests. Reboot the server. Master/Primary Server Tests.

Availability 277

Availability Servers Network Open Source 277

Dynatrace

FEBRUARY 14, 2022

Among these, you can find essential elements of application and infrastructure stacks, from app gateways (like HAProxy), through app fabric (like RabbitMQ), to databases (like MongoDB) and storage systems (like NetApp, Consul, Memcached, and InfluxDB, just to name a few). Many technologies expose their metrics in the Prometheus data format.

Technology 222

Technology Technology Metrics Infrastructure 222

SQL Performance

APRIL 17, 2020

When we ask SQL Server to change some aspect of a column's definition, it needs to check that the existing data is compatible with the new definition. Depending on the type of change and the configuration of the database, an ALTER COLUMN command will need to perform one of the following actions: Change metadata in system tables only.

Servers 63

Servers Database Testing Efficiency 63

Percona Community

OCTOBER 17, 2018

System-versioned tables, or temporal tables, are a typical feature of proprietary database management systems like DB2, Oracle and SQL Server. My presentation will be useful for analysts, and some managers, who will definitely benefit from learning how to use temporal tables.

Systems 40

Systems Open Source Database Servers 40

Percona

DECEMBER 6, 2023

In this post, I will present a new Percona tool: Percona Monitoring and Management (PMM) Dump. The PMM Dump performs a logical backup of the performance metrics collected by the PMM Server and imports them into a different PMM Server instance. You can read more about Percona security and data privacy practices at [link].

Monitoring 93

Monitoring Metrics Analytics Open Source 93

Dynatrace

APRIL 15, 2022

The agency executed one of the largest email migrations from on-premises Exchange servers to Microsoft Office 365 — moving almost 480,000 mailboxes to the cloud. “We used Dynatrace to monitor that large increase in servers. We started out by instrumenting 2,000 servers overnight.

Cloud 181

Cloud Infrastructure Innovation Monitoring 181

Percona

JUNE 4, 2023

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL ). Introduction: MariaDB vs. MySQL The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. What is MariaDB?

Open Source 52

Open Source Servers Storage Scalability 52

Percona

JULY 19, 2023

For example, a table statistics limit is introduced to avoid querying information_schema.tables that may impact DB performance, especially with a high number of DBs / tables present in an instance. In the example, we run PMM server in a docker container. What if you want to change the value later on?

Monitoring 79

Monitoring Entertainment Open Source Tuning 79

Percona

MAY 9, 2023

Background story I recently worked with a company running a large four-shard MongoDB Enterprise Server database cluster on VMs on premises that decided to migrate to the Google Cloud Platform. This can be MongoDB Enterprise Server, MongoDB Community Edition, or Percona Server for MongoDB. Don’t start the server yet!

Storage 102

Storage Cloud Servers Google 102

Percona

SEPTEMBER 20, 2023

Here’s a brief story of how this could happen, to make it clearer: You’re a DBA managing a few MySQL servers. One of those tools is pt-config-diff ; this tool can show differences within MySQL configuration files and server variables. Example: The parameter is not present in the configuration file.

Open Source 87

Open Source Servers Scalability Database 87

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++ 78

C++ Servers Benchmarking Best Practices 78

Percona

NOVEMBER 7, 2023

The author has done an excellent job of presenting all this information in a clear, concise fashion in small, easy-to-consume tidbits so that the reader does not feel swamped with details. Buy this book if you are looking for a deeper understanding of how the PostgreSQL server really works, and you will not be disappointed. Version 14?

Cache 84

Cache Servers Operating System Database 84

Percona

MARCH 22, 2023

One of the installation methods we support for our database software is through Helm. For an easy way to deploy the Kubernetes cluster, check Percona My Database as a Service (MyDBaaS) , a Percona Labs project. MyDBaaS will help you with cluster creation. Run this command to get this value.

Monitoring 96

Monitoring AWS Database Infrastructure 96

Percona

OCTOBER 13, 2023

the information is presented within serialized objects within the dictionary. Purpose of.sdi files Serialized dictionary information (SDI) files store serialized metadata about various database objects, such as tables, indexes, and other schema-related details. mysql> create database test_rocksdb; Query OK, 1 row affected (0.01

Storage 90

Storage Database Engineering Open Source 90

Scalegrid

JANUARY 9, 2024

This presents enterprises with a wide range of options that cater specifically to their needs within this new framework created by multiple trusted cloud service providers. They seamlessly integrate with popular databases including MongoDB, Redis, MySQL, and PostgreSQL while utilizing their respective built-in security frameworks.

Strategy 130

Strategy Cloud Best Practices Government 130