Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. In this blog post, we describe some best practices for setting up and managing MySQL error logs, general logs and slow query logs for your MySQL deployments. Setting Up MySQL Server Logging.

Servers 247

Servers Best Practices Efficiency Availability 247

SQL Performance

SEPTEMBER 12, 2019

This article is the fifth part in a series about T-SQL bugs, pitfalls and best practices. In my examples, I'll use a sample database called TSQLV5. You can find the script that creates and populates this database here , and its ER diagram here. In the meanwhile, there's a best practice that can help you avoid the bug.

Best Practices 103

Best Practices C++ Code Design 103

Percona

SEPTEMBER 1, 2023

MySQL performance tuning offers several significant advantages for effective database management and optimization. Enhanced Database Efficiency By adjusting configuration settings, you can markedly enhance the overall efficiency of your MySQL database. Experiencing database performance issues?

Tuning 52

Tuning Database Performance Hardware 52

Scalegrid

FEBRUARY 1, 2024

Dive in to uncover the essentials of different backup types, command-line tools, and strategic practices for robust data protection. MySQL is a popular open-source relational database management system for online applications and data warehousing. Having MySQL backups for your database can speed up and simplify the recovery process.

Best Practices 130

Best Practices Storage Strategy Database 130

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

SQL Performance

JUNE 14, 2019

This article is the third installment in a series about T-SQL bugs, pitfalls and best practices. Some of the bugs and best practices that I cover here are a result of a survey I did among fellow MVPs. In my examples I’ll use a sample database called TSQLV5. Previously I covered determinism and subqueries.

Best Practices 93

Best Practices C++ Database Processing 93

Scalegrid

JANUARY 9, 2024

Governance and compliance are also crucial factors in ensuring enterprise cloud security as they enforce regulatory requirements and best practices within organizations. 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

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

SQL Shack

NOVEMBER 9, 2020

In this 34th article on SQL Server Always On Availability Groups, we will explore policy-based management features for the AG’s. Introduction to policy-based management Policy-Based Management feature allows database professional in defining the best practices, standards for SQL Server and database related configurations.

Availability 89

Availability Servers Best Practices Database 89

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

Percona

JUNE 29, 2023

Before Percona Server for MongoDB 4.4 PSMDB), the best practice to create an index was doing it in a rolling manner. Still, the best practice is to create indexes in a rolling manner. Starting from PSMDB 4.4, there was a new parameter commitQuorum introduced in the createIndex command.

Servers 78

Servers C++ Storage Best Practices 78

Percona

MAY 1, 2023

It has default settings for all of the database parameters. It is primarily the responsibility of the database administrator or developer to tune PostgreSQL according to their system’s workload. The performance of a PostgreSQL database has a significant impact on the overall effectiveness of an application.

Tuning 52

Tuning Efficiency Database Performance 52

Dynatrace

JANUARY 19, 2020

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. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 154

Monitoring Best Practices Infrastructure Servers 154

SQL Performance

SEPTEMBER 17, 2019

Many database administrators find themselves having to support instances of SQL Server Reporting Services (SSRS), or at least the backend databases that are required for SSRS. These topics apply to both SQL Server Reporting Services as well as Power BI Report Server.

Tuning 67

Tuning Servers Database Best Practices 67

Dynatrace

MARCH 22, 2023

This method involves providing the lowest level of access by default, deleting inactive accounts, and auditing server activity. For this, best practices would be to segregate commands from data, use parameterized SQL queries, and eliminate the interpreter by using a safe application program interface, if possible.

Open Source 200

Open Source Artificial Intelligence Internet Internet 200

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. Why SAP ABAP platform monitoring in Dynatrace?

Monitoring 160

Monitoring Best Practices Infrastructure Programming 160

Dynatrace

MAY 19, 2022

To ensure their global service levels, they fully embraced the best practices outlined in Google’s SRE handbook , called the “Four Golden Signals,” to standardize what they show on their SRE dashboards. This refers to the load on your network and servers. The “Four Golden Signals” include the following: Latency. Saturation.

Automotive 272

Automotive Latency Architecture Azure 272

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. PMM monitors the MySQL uptime: show global status like 'uptime'; Indicates the amount of time (seconds) the MySQL server has been running since the last restart.

Performance 102

Performance Monitoring Traffic Database 102

DZone

OCTOBER 14, 2020

call to database or service) with artificial functionality that has the same return type. There are different approaches to this practice. Here, I explain best practices and why you better avoid mocking practice in order to have real code quality. Mocking Test Methodology.

Testing 187

Testing Best Practices Database Code 187

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Percona

MARCH 17, 2023

These updates are designed to keep databases running at peak performance and simplify database operations. But as companies grow and see more demand for their databases, we need to ensure that PMM also remains scalable so you don’t need to worry about its performance while tending to the rest of your environment.

Monitoring 95

Monitoring Scalability Cache Database 95

Dynatrace

SEPTEMBER 30, 2021

We’ll answer that question and explore cloud migration benefits and best practices for how to go through your migration smoothly. Cloud providers manage all the underlying hardware, server maintenance, and security practices, allowing you to spend less on expensive IT operations and maintenance. Reduced cost.

Cloud 167

Cloud Traffic Best Practices Strategy 167

Percona

APRIL 20, 2023

It should be noted that while the technical aspects of the upgrade process are beyond the scope of this blog post, it is crucial to create a testing environment to verify the upgrade before proceeding to upgrade your production servers, particularly with MySQL 8.

Open Source 87

Open Source Best Practices Servers Database 87

Percona

DECEMBER 27, 2023

of respondents are currently utilizing databases in Kubernetes (k8s). These indicators suggest that the adoption of databases on k8s is in its early stages and is likely to continue growing in the future. This marks the end of an era of chaos, paving the way for efficiency gains, quicker innovation, and standardized practices.

Cloud 77

Cloud Open Source Strategy Best Practices 77

Percona

SEPTEMBER 26, 2023

As MySQL database administrators, we are well aware of the significance of implementing a primary key within a table. Primary keys play an indispensable role in sound database design by uniquely identifying individual rows and significantly enhancing data retrieval, manipulation, and overall system performance.

Database 97

Database Engineering Best Practices Open Source 97

Official Blog - World Web Technology

NOVEMBER 9, 2023

PHP is a popular server-side programming language due to its simplicity of use, vast functionality, and robust community support. Regarding command-line and server-side scripts, PHP is easy for users to understand and use. PHP can work perfectly on shared hosting and private servers, making it an excellent choice for building websites.

Website 59

Website Development Open Source Database 59

Percona

NOVEMBER 1, 2023

Following the series of blogs written with the intention to describe basic operations matching Docker and open source databases, in this article, I will demonstrate how to proceed with installing MongoDB with Docker. about to fork child process, waiting until server is ready for connections. connecting to: mongodb://127.0.0.1:27017/?compressors=disabled&gssapiServiceName=mongodb

Scalability 57

Scalability Best Practices Servers Database 57

Dynatrace

JULY 29, 2020

Rich Lane : In the digital age where so much of an enterprise’s revenue and customer engagement comes from digital interaction, IT needs to shift from measuring success in terms of server up-time or number of incidents to business outcomes (e.g. Did our latest marketing push achieve a greater number of sales conversions?

Best Practices 184

Best Practices Mobile Architecture Monitoring 184

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 121

Database Servers Testing Programming 121

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

MachMetrics

DECEMBER 14, 2019

How fast is the average time to first byte (server delay)? Google’s best practice is to have a speed index under 3 seconds. Google’s best practice is to be below 0.5 However, Google’s best practice is to keep the number of requests below 50, so there is still work to be done.

Best Practices 105

Best Practices Speed Mobile Google 105

Dynatrace

NOVEMBER 23, 2020

After applying the first manifests (which are likely copied and pasted from a how-to tutorial ), a web server is up and running within minutes. Traces represent causally related distributed events on a distributed system, showing, for example, how a request flows from the user to the database.

Virtualization 161

Virtualization Infrastructure Monitoring Cloud 161

High Scalability

DECEMBER 18, 2018

You will bring best practices for automating the provisioning and patching of servers, replicating and versioning configuration changes, monitoring and alerting, deploying application and data store updates, and high availability / disaster recovery. Need excellent people? Advertise your job here! Fun and Informative Events.

Healthcare 122

Healthcare Best Practices DevOps Cache 122

Percona

APRIL 24, 2023

Plain text passwords are extremely vulnerable to unauthorized access, as anyone with access to the database or configuration files can easily read them. Hashed passwords, on the other hand, are stored in the same format as passwords in the MySQL server’s “mysql.user.password” (before MySQL 8.0

Database 77

Database Best Practices Open Source Testing 77

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. It is important to begin with a thorough database backup to prepare for such situations.

Database 162

Database Strategy Servers Best Practices 162

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. Learn more: Discover six of the most common causes of poor database performance in our free eBook. on, you can use mysqlbinlog to stream binary logs from a remote server.

Best Practices 78

Best Practices Storage Strategy Database 78

Percona

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. This is not a best practice at all, and we strongly encourage you to always create an explicit PK in your tables. Suppose you have SELECT * queries in your application code.

Best Practices 76

Best Practices Open Source Code Engineering 76