Percona

FEBRUARY 2, 2023

PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server. The pg_hba.conf file is used to configure the authentication methods the PostgreSQL server uses and can specify different methods for different types of connections.

Database 121

Database Servers Testing Programming 121

Tasktop

JUNE 20, 2022

This is easier said than done, so we’ve designed three sets of OKRs examples for software companies to show how it’s possible. In these examples, the product value streams incorporate Flow Metrics into their key results to drive agility and a value focus. Examples of quarterly OKRs for software companies. Activities.

Software 96

Software Software Healthcare Mobile 96

Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. Setting Up MySQL Server Logging. As an example, let’s have some criteria for managing general MySQL query logs. Managing MySQL Server Logs: Rotate, Compress, Retain & Delete Click To Tweet.

Servers 247

Servers Best Practices Efficiency Availability 247

SQL Performance

AUGUST 1, 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here , and Aaron Bertrand covered additional improvements here. Microsoft just announced the release of SQL Server 2022 CTP 2.1. I’ll be using the sample database TSQLV6 in the examples in this article. Those improvements were introduced in CTP 2.0.

Servers 142

Servers Testing C++ Code 142

SQL Performance

SEPTEMBER 21, 2022

One example is using a bitwise representation of a set of user/role permissions. Another example is using a bitwise representation of a set of settings turned on or off in a given environment. Even SQL Server stores some flag-based data using bitwise representation. The returned value is of the BIT type.

Servers 122

Servers C++ Code Cache 122

Percona

JANUARY 2, 2024

Managing database servers involves different aspects, among which security is critical. However, we know having a “runaway” grant is always a possibility, especially in environments with a large number of servers. Fortunately, in Percona Server for MySQL , this feature is free to use. How does it work?

Servers 81

Servers Database Open Source Scalability 81

Simform

MARCH 31, 2022

Docker containers, being portable, light-weight, and self-contained, fast-track development, testing, and server deployments. The post Docker Use Cases: A Demonstrative Guide with Real-world Examples appeared first on Insights on Latest Technologies - Simform Blog.

Servers 105

Servers Technology Technology Testing 105

Percona

NOVEMBER 1, 2023

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 94

Servers Database Cache C++ 94

SQL Performance

MAY 24, 2022

Microsoft recently released the first public preview of SQL Server 2022. I’ll be using the sample database TSQLV6 in the examples in this article. This clause is now available in Azure SQL Database and SQL Server 2022, provided you use database compatibility level 160 or higher. This release has a number of T-SQL improvements.

Servers 145

Servers C++ Code Database 145

Percona

FEBRUARY 24, 2023

For example, the QA team would only have access to data from the QA environment rather than having access to the production environment. Enable Access Control Although Vanessa, a DBA, prefers to enable and configure Access Control via the UI, it is possible to enable it when deploying PMM Server via Docker. to monitor and diagnose. +50

Metrics 105

Metrics Monitoring Database Engineering 105

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 58

Servers Cache Retail Benchmarking 58

SQL Shack

AUGUST 27, 2021

In this article, we will take a glance at the fundamentals of SQL Server statistics and discover their interaction with the query processing steps with simple examples. Getting Started with SQL Server statistics SQL Server statistics are one of the key inputs for the query optimizer during generating a query plan.

Servers 109

Servers Processing Performance 109

Percona Community

MARCH 19, 2023

We learn how to work with HTTP requests in PHP and make API requests using the GitHub API as an example. In the previous article, we developed a simple application that connects to the MongoDB database (Percona Server for MongoDB) and writes documents in a loop. We’ll get the data from the API and save it to the database.

Servers 52

Servers Database Code Development 52

Percona

FEBRUARY 16, 2023

We can verify that through the following example: We started MySQL with the configuration of “ early-plugin-load=keyring_file.so mysql> select * from t2; ERROR 3185 (HY000): Can't find master key from keyring, please check in the server log if a keyring is loaded and initialized successfully.

Database 115

Database Servers Engineering Testing 115

HammerDB

MARCH 25, 2023

Docker build, example CLI scripts were added to build and run the TPROC-C workload in the Tcl language. This post will give an overview of the example CLI scripts that you can run directly or use as a template to write your own. Linux example For a first example we will look at the TPROC-C workload in Tcl running on MariaDB on Linux.

C++ 83

C++ Virtualization Benchmarking Database 83

Dynatrace

FEBRUARY 11, 2020

OneAgent knows where to connect for further runtime configuration and where to send data because the installer itself is pre-configured to connect to the exact tenant and server that it’s downloaded from. But what if your environment grows and you decide to distribute data between two Dynatrace servers?

Servers 155

Servers Tuning Systems Availability 155

Smashing Magazine

MAY 16, 2022

Rethinking Server-Timing As A Critical Monitoring Tool. Rethinking Server-Timing As A Critical Monitoring Tool. In the world of HTTP Headers, there is one header that I believe deserves more air-time and that is the Server-Timing header. Setting Server-Timing. Sean Roberts. 2022-05-16T10:00:00+00:00.

Servers 92

Servers Monitoring Cache Network 92

Scalegrid

DECEMBER 9, 2019

However, discarding a server like this is expensive and inefficient. In this blog post, we will explain an approach to detect and fix transactions on the crashed MySQL master server in a semisynchronous replication setup, and how to re-slave it back into your master-slave setup. Let’s use an example to understand this.

Servers 160

Servers Database Processing Availability 160

Dynatrace

MARCH 18, 2024

For example, Amazon Web Services (AWS) charges for data transfer between Amazon EC2 instances within the same region. For example, poorly written code can consume a lot of resources, or an application can make unnecessary calls to cloud services. They can send a notification saying, “This server is oversized.”

Best Practices 231

Best Practices Strategy Cloud AWS 231

Brendan Gregg

JANUARY 1, 2019

What is an example of eBPF tracing? For example, it does not trace every packet like older techniques, which can add too much performance overhead. Companies including Netflix and Facebook have bcc installed on all servers by default, and maybe you'll want to as well. ## 4. What's missing is production examples.

C++ 111

C++ Virtualization Programming Code 111

Percona

DECEMBER 6, 2022

Percona Server for MySQL 8.0.30-22 22 introduces several improvements for the LDAP plugin: SASL support, support for fallback servers, and support for LDAP-based authorization. For example, the variable authentication_ldap_simple_server_host is called authentication_ldap_sasl_server_host. Fallback server.

Servers 68

Servers Open Source Scalability Availability 68

DZone

JANUARY 3, 2024

The Raspberry Pi is one example of a small, low-cost device that is embracing this idea, even though it has traditionally been associated with powerful servers and expensive computers.

Virtualization 313

Virtualization Education Media Hardware 313

Dynatrace

MARCH 15, 2024

Syslog is a protocol with clear specifications that require a dedicated syslog server. For example, a supported syslog component must support the masking of sensitive data at capture to avoid transmitting personally identifiable information or other confidential data over the network. Take a look at this example for configuration.

Open Source 199

Open Source Infrastructure Network Government 199

HammerDB

OCTOBER 24, 2023

by @krithikasatish and @JoshInnis to provide accelerated load performance for both SQL Server TPROC-C and TPROC-H schemas. In this example on a development PC the regular build started at 10:48:35 and ended at 10:54:46 meaning it took 6 minutes 11 seconds to build our 20 warehouse schema. With the default for v4.9

Servers 62

Servers C++ Benchmarking Virtualization 62

HammerDB

DECEMBER 14, 2022

In this post, we will do a walk through example of installing and configuring unixODBC and the SQL Server on Linux drivers as well as the HammerDB connection options to enable HammerDB on Linux to be able to connect to SQL Server. bin/odbcinst -d -q [ODBC Driver 17 for SQL Server] [ODBC Driver 18 for SQL Server].

Servers 62

Servers Virtualization Code Testing 62

SQL Performance

JULY 19, 2022

An example of this is updating a fixed-width column in a single row—it will do the following: Perform the update, which generates one log record. You can read a bit more about rollbacks in my article A Complete Introduction to SQL Server Transactions on the SentryOne blog, and I’ll cover them in depth in the next article.

Servers 94

Servers Database Storage Engineering 94

Percona

JUNE 1, 2023

In this case, we will be analyzing the migration of MariaDB to Percona Server for MySQL 8 in particular. the same does not happen with MariaDB, which from a specific version, we could say in some way, distanced itself from MySQL and Percona Server for MySQL. Upload that dump to the Percona Server for MySQL using myloader.

Servers 71

Servers Database Testing Open Source 71

Dynatrace

JANUARY 23, 2024

XML external entity (XXE) exploit The aXMLRPC library allows its users to connect to a server and perform RPC calls using the XML-RPC protocol over HTTP. A possibility to make this exploit successful is a man-in-the-middle attack that intercepts the connection to a legitimate server.

Java 205

Java Servers Code Software 205

SQL Shack

JULY 15, 2020

In this article, we will talk about the deadlocks in SQL Server, and then we will analyze a real deadlock scenario and discover the troubleshooting steps. In general, we can find out various theoretical advice and examples about the deadlock problems on the web but, in this article, we will tackle a true deadlock story […].

Servers 110

Servers Performance 110

SQL Performance

FEBRUARY 17, 2022

Since SQL Server 2005, the trick of using FOR XML PATH to denormalize strings and combine them into a single (usually comma-separated) list has been very popular. A Quick Example. In the SQL Server 2005 days, I would have offered this solution: SELECT DISTINCT UserID , Bands =. ( I was a little appalled at what I found.

Servers 82

Servers Code Efficiency Performance 82

Testsigma

FEBRUARY 3, 2021

Example: Let’s take an example of an e-commerce mobile app. Example: We are considering the same e-commerce app example, a small unit like ‘login’ may be tested during the unit testing. Example: Here, we test the integration of two or more modules like- from cart to make a payment module. Reference: [link].

Mobile 82

Mobile Testing Hardware C++ 82

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 81

Servers C++ Database Systems 81

The Netflix TechBlog

FEBRUARY 13, 2024

Inability to test segments of the app, for example if a component is only visible after clicking a button and waiting for a 60 second timer to countdown, the test will need to run those actions and will be at least a minute long. For more information and examples, refer to the Overrides section on the README.

Testing 244

Testing Code Servers Testing Tools 244

SQL Performance

OCTOBER 7, 2020

The canonical example of a plan operator that can rewind is the lazy 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). This first example features two table variables.

Servers 106

Servers Cache Azure Performance 106

The Morning Paper

NOVEMBER 15, 2020

Achieving 100 Gbps intrusion prevention on a single server , Zhao et al., Today’s paper choice is a wonderful example of pushing the state of the art on a single server. Moreover, Pigasus wants to do all this on a single server! Can you really do all this on a single server?? OSDI’20. We always want more!

Servers 128

Servers Hardware Latency Design 128

SQL Performance

OCTOBER 21, 2021

For a real-world example, what was the average release speed, in seconds, for a quarterback who played in the 1970s, before we measured or tracked such a thing? Let’s look at a couple of these with an example based loosely on the recent question mentioned above. For example: SELECT COUNT ( * ) FROM dbo. Query Execution.

Servers 103

Servers Design Speed Code 103

Scalegrid

NOVEMBER 4, 2020

MySQL configuration variables are a set of server system variables used to configure the operation and behavior of the server. Configuration variables that can be set at run time are called Dynamic variables and those that need a MySQL server restart to take effect are called Non-Dynamic variables. and MySQL 8.0. In MySQL 5.7,

Servers 287

Servers Programming Processing Testing 287