High Scalability

SEPTEMBER 1, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. We measure latency in ms 95th percentile latency.

Azure 137

Azure Database Benchmarking Performance 137

Scalegrid

OCTOBER 31, 2019

Wondering which high availability framework to use for your PostgreSQL deployments ? We compared the top 3 frameworks, PostgreSQL Automatic Failover (PAF) vs. Replication Manager (repmgr) vs. Patroni , in our Managing High Availability in PostgreSQL series. PostgreSQL High Availability Framework Infographic.

Availability 187

Availability Azure AWS DevOps 187

Percona

FEBRUARY 1, 2024

This blog was originally published in June 2016 but was updated in February 2024.In In this blog post, we’ll look at various MySQL high availability (HA) solutions, detailing their advantages and disadvantages to equip you with the insight required for informed decision-making regarding your database infrastructure.

Availability 52

Availability Infrastructure Database 52

Percona

OCTOBER 20, 2023

Heck, typing “database migration plan” into Google and reading this blog could constitute planning. In brief, a proper database migration plan includes: Establishing clear objectives: Define what you want to achieve and how open source will get there. Some level of planning is expected when migrating to open source.

Open Source 85

Open Source Database Best Practices Strategy 85

Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. Database migration is almost always time-consuming, tedious, and full of potential pitfalls. Database migration is complex Let’s start here. What’s your documentation plan?

Database 80

Database Open Source Benchmarking Strategy 80

Scalegrid

MARCH 12, 2019

Are you deploying PostgreSQL in the cloud and want to understand your options for achieving high availability? In our previous blog post, Managing High Availability in PostgreSQL – Part I , we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. High Availability Test Scenarios.

Availability 147

Availability Servers Open Source Database 147

Dynatrace

AUGUST 3, 2020

For example: To provide support, you need a remote desktop service to be available. You also require part of your infrastructure to serve an MS SQL database with MS Distributed Transaction Coordinator. Easily create availability checks for your Windows services. Alerts for Windows service availability.

Infrastructure 156

Infrastructure Availability Monitoring Operating System 156

Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. For MySQL, both releases are made by the same company (Oracle), follow the same version numbering, and the Enterprise version is a superset of what is available in Community.

Database 77

Database Servers Innovation Open Source 77

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Feature-wise, it is up there with the best, if not the best.

Database 184

Database Open Source Storage Servers 184

Percona

DECEMBER 20, 2018

Let’s look at some of the most popular Percona Database Performance Blog posts in 2018. With the Percona Database Performance Blog, Percona staff and leadership work hard to provide the open source community with insights, technical support, predictions and metrics around multiple open source database software technologies.

Database 40

Database Tuning Performance AWS 40

Simform

MAY 19, 2022

With so many offerings available, it's a challenge for mobile app developers to select the right database for the right application. This blog consists of general criteria and some use cases based criteria to help developers to build scalable and fast mobile apps.

Mobile 98

Mobile Database Scalability Technology 98

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 93

Database C++ Servers Open Source 93

High Scalability

APRIL 16, 2019

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability.

Availability 149

Availability Network Azure AWS 149

High Scalability

JUNE 8, 2018

Severalnines has spent the last several years writing blogs and crafting content to help make your open source database solutions highly available. Top HA Resources for MySQL & MariaDB.

Open Source 130

Open Source Database Scalability Availability 130

Simform

MAY 9, 2022

Database administrators are responsible for ensuring an application’s availability, its performance, and incorporating changes that developers usually introduce to modify an application. The post Database DevOps: Extending the Power of DevOps for Database Management appeared first on Insights on Latest Technologies - Simform Blog.

DevOps 52

DevOps Database Technology Technology 52

Percona

NOVEMBER 1, 2023

Percona Distribution for MySQL is the most complete, stable, scalable, and secure open source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use! x are all safe. MariaDB users must upgrade to 10.5.4

Servers 93

Servers Database Cache C++ 93

Dynatrace

MARCH 27, 2024

As teams and their structure and metadata are often maintained in a dedicated database, such as Microsoft Entra ID (formerly Azure Active Directory) or ServiceNow. Keeping ownership teams and their properties up to date is essential, as is having the right contact information available when needed. Contact us to schedule a demo.

Best Practices 204

Best Practices Azure Database Code 204

Percona

MAY 1, 2023

This blog was originally published in August 2018 and was updated in May 2023. It has default settings for all of the database parameters. It has default settings for all of the database parameters. Out of the box, the default PostgreSQL configuration is not tuned for any particular workload.

Tuning 52

Tuning Efficiency Database Performance 52

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Type 'help;' or 'h' for help.

Database 92

Database Performance C++ Engineering 92

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

Dynatrace

JANUARY 31, 2024

This blog post explores how AI observability enables organizations to predict and control costs, performance, and data reliability. Model observability provides visibility into resource consumption and operation costs, aiding in optimization and ensuring the most efficient use of available resources.

Cache 209

Cache Azure Infrastructure Monitoring 209

The Netflix TechBlog

APRIL 27, 2023

Ruchir Jha , Brian Harrington , Yingwu Zhao TL;DR Streaming alert evaluation scales much better than the traditional approach of polling time-series databases. It allows us to overcome high dimensionality/cardinality limitations of the time-series database. The internals here are outside the scope of this blog post.

Storage 288

Storage Cache Metrics Database 288

KeyCDN

OCTOBER 2, 2018

Reading and following the right web development blogs makes it much easier to get a solid education. That’s why in this post, we’ve compiled a list of the top web development blogs that will help you find your footing and acquire essential skills in modern web dev. Visit website 3. Visit website 5. Visit website 9.

Development 75

Development Website Design Code 75

Scalegrid

NOVEMBER 29, 2023

In today’s rapidly evolving digital landscape, the way we manage databases is undergoing a transformative shift. The rise of Database-as-a-Service (DBaaS) is not just a trend but a strategic response to the growing complexities of data management. However, using a database as a service is not without its set of challenges.

Healthcare 130

Healthcare Hardware Database Scalability 130

Scalegrid

MAY 22, 2020

This way, the load on the master is tremendously reduced, and at the same time, the binlog server serves the binlogs more efficiently to slaves since it does not have to do any other database server processing. mysql> create database d12; Query OK, 1 row affected (3 min 0.01 MySQL High Availability. More tips for you.

Servers 262

Servers Transportation Database Availability 262

Percona

MARCH 1, 2023

In this blog post, we will see how running databases on Kubernetes with Percona Operators can reduce your cloud bill when compared to using AWS RDS. Managed Database Services like RDS remove a lot of toil from operation teams and provide self-service for developers. Discount is great, but what about availability?

Cloud 129

Cloud Storage AWS Database 129

Alex Podelko

FEBRUARY 28, 2021

Can’t say that it changed much since then industry-wise – but great free MongoDB courses are available to everybody). There are many great blog posts: Performance Best Practices 7-parts series. Impact of Available IOPS On Your Database Performance. What is MongoDB FTDC (aka. diagnostic.data).

Performance 200

Performance IoT Education Best Practices 200

Percona

OCTOBER 17, 2023

This blog post discusses using the CLONE INSTANCE command with the safety option DATA DIRECTORY when you do not have enough disk space to store two datasets. This way, you will have a new instance with a small data directory, so you can use option DATA DIRECTORY without fear of exceeding available disk space.

Open Source 95

Open Source Servers Database Strategy 95

Dynatrace

MAY 19, 2022

Every organization’s goal is to keep its systems available and resilient to support business demands. This view shows the availability SLO for key application functions, like login and vehicle list, as well as a large set of timeframes, like last 30 minutes, last hour, today, and last six days. Dynatrace news. Saturation.

Automotive 274

Automotive Latency Architecture Azure 274

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. In this blog, we will explore various MySQL KPIs that are basic and essential to track using monitoring tools like PMM.

Performance 102

Performance Monitoring Traffic Database 102

Percona

JUNE 2, 2023

WordPress, the ubiquitous publishing platform that launched millions of blogs and websites, turned 20 on May 27th. WordPress also benefited from and popularized MySQL, introducing the LAMP stack – and open source – to an audience that might never have touched a database before or had any intro to open source.

Open Source 92

Open Source Traffic Tuning Database 92

Scalegrid

SEPTEMBER 18, 2020

When deploying MongoDB in production, it is strongly recommended that you use an SSL-enabled geo-distributed replica-set configuration for maximum security and availability. If your application connects to the production database over a public network, do reach out to support@scalegrid.io to learn more about this. Troubleshooting.

C++ 244

C++ Programming Servers Database 244

Percona

JANUARY 3, 2024

That blog introduced a command-line interface. If you are a database administrator or developer, you may encounter some issues that require external assistance. Whether you seek help from Percona Support or the Community, you must provide sufficient information about your database performance and configuration.

Monitoring 87

Monitoring Open Source Database Servers 87

Dynatrace

DECEMBER 9, 2020

Most applications communicate with databases to, for example, pull a catalog entry or submit a new record when an order is placed. To achieve this, there must be a healthy connection between the application and the database. Application servers use connection pools to maintain connections with the databases that they communicate with.

Traffic 139

Traffic Performance Database Metrics 139

Percona

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. Since your dataset is 100 GB and you have 500 GB of RAM, you can allocate a significant portion of the available memory to the InnoDB buffer pool. How large does my innodb_redo_log_capacity need to be?

Social Media 119

Social Media Database Servers Cache 119

Percona

JUNE 9, 2023

Percona Monitoring and Management (PMM) boasts many functionalities that support its extension, be it by using Custom Queries, Custom Scripts, or by collecting data from already available External Exporters. In this short blog post, we will see how to quickly (and easily) monitor a PostgreSQL cluster managed by Patroni.

Monitoring 123

Monitoring Metrics Open Source Database 123

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. Redis returns a big list of database metrics when you run the info command on the Redis shell. This blog post lists the important database metrics to monitor.

Metrics 130

Metrics Monitoring Latency Cache 130