Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 90

Open Source Database Hardware Strategy 90

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

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 104

Availability Database Open Source Hardware 104

Scalegrid

APRIL 5, 2024

Grasping the concept of Redis sharding is essential for expanding your Redis database. This method involves splitting data over various nodes to improve the database’s efficiency. Redis isn’t alone in utilizing sharding strategies — it’s a common concept found throughout database technologies to distribute workload efficiently.

Scalability 130

Scalability Efficiency Java Database 130

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

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 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 152

Monitoring Best Practices Infrastructure Servers 152

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

Percona

OCTOBER 18, 2023

See more details in the documentation. Backups server-side encryption (SSE) JIRA Github Whether it is compliance or security requirements, there is often a need to encrypt database backups. But what about logical backups, where data from your databases is copied as is to the object storage? serverSideEncryption section.

Best Practices 90

Best Practices Storage AWS Big Data 90

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 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 185

Engineering Performance Metrics Best Practices 185

Scalegrid

DECEMBER 16, 2019

MongoDB is the #3 open source database and the #1 NoSQL database in the world. 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. minutes of downtime in one year.

Azure 187

Azure AWS Latency Database 187

Percona

JULY 19, 2023

Start it up Deploy and prepare ArgoCD ArgoCD has quite detailed documentation explaining the installation process. I did the following: kubectl create namespace argocd kubectl apply -n argocd -f [link] Expose the ArgoCD server. Install it by following the CLI installation documentation. ArgoCD supports Server-Side apply.

Servers 78

Servers Best Practices DevOps Open Source 78

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

SQL Performance

JUNE 21, 2019

I've been teaching and writing about common SQL Server mistakes for many years. This article will expand on my previous article and point out how these apply to SQL Server , Azure SQL Database , and Azure SQL Managed Instance. SQL Server Agent alerts. This situation applies to on-premises SQL Server and IaaS.

Servers 49

Servers Azure Hardware Database 49

Percona

JULY 26, 2023

MongoDB is a non-relational document database that provides support for JSON-like storage. First released in 2009, it is the most used NoSQL database and has been downloaded more than 325 million times. The bigger the database, the bigger the damage from a leak.

Database 79

Database Servers Storage Strategy 79

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

HammerDB

OCTOBER 8, 2018

This limitation is at the database level rather than the hardware level, nevertheless with up to date hardware (from mid-2018) PostgreSQL on a 2 socket system can be expected to deliver more than 2M PostgreSQL TPM and 1M NOPM with the HammerDB TPC-C test. . Start the PostgreSQL Database. cat /proc/meminfo. HugePages_Total: 35000.

Best Practices 40

Best Practices Scalability Performance Hardware 40

Percona

JULY 7, 2023

Unfortunately, using certain open source database software as part of an HA architecture can present significant challenges. This blog highlights considerations for keeping your own PostgreSQL databases highly available and healthy. The same changes made in the primary database are made in the replicas.

Availability 82

Availability Open Source Architecture Database 82

Percona

JULY 2, 2023

The size of the database and your database environment—if it is on colo or cloud—matters. 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.

Strategy 52

Strategy Database Storage Open Source 52

Percona

AUGUST 3, 2023

As an experienced database developer, you should know that these kinds of queries should not exist in any production code. For further details, you can have a look at the documentation: [link] Generated Invisible Primary Keys This feature has been deployed in MySQL 8.0.30; it’s more recent.

Best Practices 77

Best Practices Open Source Code Engineering 77

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 78

Database Best Practices Open Source Testing 78

SQL Server According to Bob

JANUARY 11, 2020

Copyright The information ​​ that is contained ​​ in this document represents the current view of Microsoft Corporation on the issues discussed as of the date of publication. Complying with all applicable copyright laws is the responsibility of the user.

Servers 40

Servers Cache Database Media 40

Percona

MAY 15, 2023

The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In shard-nothing, each shard can live in a totally separate logical schema instance / physical database server/data center/continent. The POC Why this POC?

Traffic 122

Traffic Scalability Database Servers 122

Smashing Magazine

MAY 5, 2021

However, in our pages, the case was different as our database stores lots of data, and we need to serve thousands of landing pages at scale. Well, Bookaway works with 1,500 operators and provide over 20k services in 63 countries with 200% growth year over year (pre Covid-19). .” — “ Advanced SEO ,” Google Search Central Documentation.

Google 111

Google Architecture Servers Speed 111

Percona

AUGUST 5, 2023

Partitioning is a way in which a database (MySQL in this case) splits its actual data down into separate tables but still gets treated as a single table by the SQL layer. As the data is distributed into smaller partitions, the database engine only needs to scan relevant partitions, leading to faster query responses.

Strategy 40

Strategy Storage Database Best Practices 40

Percona

JUNE 6, 2023

A full backup is a comprehensive data backup strategy that involves creating a complete, exact copy of all data and files in a database. In order to implement effective full backups of your database, you must follow some best practices. Get started today with Percona Backup for MongoDB. What is a full backup?

Storage 66

Storage Strategy Network Efficiency 66

Smashing Magazine

AUGUST 3, 2023

Time To First Byte (TTFB) This is the time it takes for the first piece of information from the server to reach the user’s browser. You need to beware that slow server response times can significantly increase TTFB, often due to server overload, network issues, or un-optimized logic on the server side.

Performance 75

Performance Cache Traffic Metrics 75

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 86

Servers Website Code Best Practices 86

SQL Performance

DECEMBER 11, 2019

Even among people who do have a good grasp of relational theory and SQL, you will hear very strong opinions both in favor and against using NULLs in your database. 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.

Best Practices 117

Best Practices C++ Database Code 117

Smashing Magazine

OCTOBER 2, 2023

for the web app, Sanity CMS, Firebase Auth, and Firestore database. Now, let’s dive into the technical features and best practices that my team adopted in the process of building the WaterBear web app. Finally, we covered how my team handled dynamic server-side rendered sitemaps using the next-sitemap plugin for Next.js.

Cache 73

Cache Strategy Best Practices Design 73

SQL Server According to Bob

JULY 13, 2016

20+ years ago when I joined Microsoft I was handed a diskette (maybe it was two), and was told “Here is SQL Server. So I proceeded to install SQL Server 4.20 There was a GUI as part of setup but within just a few clicks, SQL Server was installed and ready for use. So now there are more choices to make when installing SQL Server.

Servers 40

Servers Media Engineering Virtualization 40

HammerDB

OCTOBER 17, 2018

This is a very typical FAQ and although detailed in the documentation some extra details may help in sizing and configuration. For a really quick answer create a schema with 250-500 warehouses per server CPU socket for more details size as follows. .

C++ 40

C++ Testing Virtualization Cache 40

All Things Distributed

APRIL 5, 2012

One of the services that is very successful in driving innovation at our customers in this context is Amazon RDS , the Relational Database Service. Amazon RDS removes the headaches of running a relational database service reliably at scale, allowing Amazon RDS customers to focus on innovation for their customers. hands freeÃ?

Innovation 146

Innovation AWS Education Network 146

VoltDB

MAY 2, 2017

We recently received a question from a customer who was looking for a quick way to repurpose some VoltDB production servers to create a disaster recovery site. Say you have five VoltDB servers in production, with k-factor=2, and no disaster site. You want to shift some of these servers to create a disaster recovery site.

Hardware 40

Hardware Database Servers Tuning 40

IO River

NOVEMBER 2, 2023

When you codify infrastructure, you can integrate it with DevOps pipelines to automate various tasks like server provisioning, database scale, and security audits. ‍This workflow not only streamlines processes but also ensures that any changes are in line with the organization's best practices and compliance standards.‍Advantages

Open Source 52

Open Source DevOps AWS Infrastructure 52

SQL Performance

NOVEMBER 13, 2019

Never mind the likelihood for this to happen in practice in SQL Server; if I run the query again, theoretically, the row with id 2 could be assigned with row number 3 and the row with id 11 could be assigned with row number 2. So apparently the window order clause is mandatory for the ROW_NUMBER function in SQL Server.

Servers 104

Servers C++ Storage Performance 104