Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 105

Availability Database Open Source Hardware 105

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 85

Database Hardware Open Source Strategy 85

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database 166

Database Cloud Website Azure 166

Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. Percona Advisors is an open source framework, meaning you can create your own checks by following our documentation. It is partially true.

Database 101

Database Open Source Monitoring Innovation 101

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

Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. One such solution is pagination, which divides large datasets into manageable “pages” of data to be displayed or processed. limit(number).

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Scalegrid

DECEMBER 9, 2019

Given such a scenario, MySQL documentation recommends that the crashed master must be discarded and should not be restarted. However, discarding a server like this is expensive and inefficient. Default database: 'test'. Re-Slaving a Crashed #MySQL Master Server in Semisynchronous Replication Setup Click To Tweet.

Servers 160

Servers Database Processing Availability 160

Dynatrace

JANUARY 31, 2024

With PowerConnect, collecting data from SAP systems and fueling the Dynatrace platform, Dynatrace automatically uncovers the topology model of the SAP landscape, providing a clear and comprehensive view of the relationships and dependencies among different systems, servers, databases, applications, and interfaces.

Java 194

Java Analytics Best Practices Monitoring 194

Dynatrace

OCTOBER 7, 2021

Serverless architecture shifts application hosting functions away from local servers onto those managed by providers. This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Serverless architecture: A primer. Application integration.

Serverless 286

Serverless AWS Lambda Storage 286

Dynatrace

AUGUST 29, 2023

Dynatrace has announced that it has successfully achieved the Google Cloud Ready – Cloud SQL designation for Cloud SQL, Google Cloud’s fully-managed, relational database service for MySQL, PostgreSQL, and SQL Server.

Google 209

Google Cloud Design Programming 209

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 73

Database Open Source Servers Code 73

Scalegrid

OCTOBER 17, 2019

In that environment, the first PostgreSQL developers decided forking a process for each connection to the database is the safest choice. It would be a shame if your database crashed, after all. On modern Linux systems, the difference in overhead between forking a process and creating a thread is much lesser than it used to be.

Architecture 200

Architecture Database Latency Servers 200

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

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

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

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

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. Databases : Among databases, Redis is the most used at 60%.

Open Source 347

Open Source Java Operating System Programming 347

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

Percona

OCTOBER 11, 2023

There are a couple of third-party tools in the market to migrate data from Atlas to Pecona Server for MongoDB (PSMDB), like MongoPush, Hummingbird, and MongoShake. Once you have installed MongoShake, you need to configure it for the migration process. NOTE : These tools are not officially supported by Percona. cd MongoShake.

Database 84

Database Open Source Testing Servers 84

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. For example, for my MongoDB cluster, I have six PVCs: three x replica set nodes and three x config server nodes. You can use this restoration process to clone existing clusters as well, just make sure you change the cluster, PVCs, and Secret names. AWS EBS Snapshots).

Database 65

Database Storage Open Source AWS 65

Dynatrace

NOVEMBER 18, 2021

Logs include critical information that can’t be found elsewhere, like details on transactions, processes, users, and environment changes. Starting with user interactions, PurePath technology automatically collects all code execution details, executed database statements, critical transaction-based metrics, and topology information end-to-end.

Analytics 229

Analytics Cloud Java Serverless 229

Percona

DECEMBER 18, 2023

These days, there’s been a lot of talk in the industry about setting up one’s database system on PostgreSQL. It can perform ETL transforms from one database to another and, under certain special circumstances, can even be implemented as a poor man’s replication solution. MYSQL: OS: Ubuntu 16.04 MySQL version 5.7

Open Source 118

Open Source Database Architecture Design 118

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

Dynatrace

JANUARY 31, 2024

The RAG process begins by summarizing and converting user prompts into queries that are sent to a search platform that uses semantic similarities to find relevant data in vector databases, semantic caches, or other online data sources. million AI server units annually by 2027, consuming 75.4+

Cache 209

Cache Azure Infrastructure Monitoring 209

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. SAP technology and process awareness.

Monitoring 155

Monitoring Best Practices Infrastructure Servers 155

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). documentation. Prometheus Data Source documentation.

Technology 222

Technology Technology Metrics Infrastructure 222

Dynatrace

FEBRUARY 9, 2023

In Memory profiling view, we would normally expect to see allocations for protocols and database calls at the top of the list of allocation hotspots. TiB in allocations within 2 hours, allocating and removing about 75 billion objects during the process. The handler is responsible for ~3.5

Java 214

Java Metrics Servers Code 214

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. The feedback from users was that “backup management is a must ” and “we need something that allows us to manage all of our database backups in one place, not server by server.”

Open Source 86

Open Source Database Operating System Programming 86

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read.

Database 106

Database AWS Network Design 106

Percona

APRIL 4, 2023

There is a list of the new reserved words later in this document that you need to review. Those are a lot more common and may be in your table definitions, so your upgrade process will be harder. If you try to use a reserved word, the server will not explicitly admonish you that you are trying to use a reserved word.

Open Source 114

Open Source Database Servers Scalability 114

Percona

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. Let’s look at some questions I did that a MySQL DBA usually needs to answer in an interview process. Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB.

Social Media 119

Social Media Database Servers Cache 119

The Netflix TechBlog

NOVEMBER 4, 2019

Specifically, how our team uses the relationships and schemas defined within GraphQL to automatically build and maintain a search database. Each service could potentially implement its own search database, but then we would still need an aggregator. This post looks at the other side of search: how to index data and make it searchable.

Cache 240

Cache Database Servers Latency 240

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. SAP technology and process awareness.

Monitoring 161

Monitoring Best Practices Programming Infrastructure 161

Percona

AUGUST 18, 2023

Why do you need multiple instances on the same server? Why not just create another database on the same instance? You can have a host with two or three instances configured as a delayed replica of the source server with SQL Delay of, let’s say, 24hr, 12hr, and 6/3hrs. ln -s /usr/local/Percona-Server-8.0.19-10-Linux.x86_64.ssl101/

Programming 83

Programming Servers Database Hardware 83

Scalegrid

JANUARY 3, 2020

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. It’s also a good way to determine which components of the database can be enhanced or optimized to increase your efficiency and performance.

Monitoring 164

Monitoring Metrics Servers Database 164

Particular Software

NOVEMBER 30, 2020

SQL Server Transport is one of our most popular transports. SQL Server Transport version 6.2.0 For extra secure systems, we’ve added support for SQL Server Always Encrypted so that messages can be encrypted so deeply that even SQL Server itself can’t read the messages without the correct keys. In version 6.2.0,

Transportation 52

Transportation Servers Database Systems 52

Percona

FEBRUARY 20, 2023

Recently, one of our customers approached us with a unique challenge: they needed to migrate their entire PostgreSQL cluster from DigitalOcean’s Database as a Service (DBaaS) to a DigitalOcean Droplet. ” In short, we have to migrate the database as per the client’s request, and we gave them two options: 1.

Database 91

Database Open Source Servers Internet 91