Scalegrid

FEBRUARY 17, 2020

In a MySQL master-slave high availability (HA) setup, it is important to continuously monitor the health of the master and slave servers so you can detect potential issues and take corrective actions. MySQL Master Server Health Checks. Important Health Checks for your MySQL Master-Slave Servers Click To Tweet.

Servers 273

Servers Monitoring Availability Programming 273

Scalegrid

MAY 13, 2019

MySQL Server generates several logs that can help you monitor the activities of the server. Setting Up MySQL Server Logging. Managing MySQL Server Logs: Rotate, Compress, Retain & Delete Click To Tweet. MySQL Tutorial – Configuring and Managing SSL On Your MySQL Server.

Servers 247

Servers Best Practices Efficiency Availability 247

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. Why not have this built it into the server?

Database 184

Database Open Source Servers Storage 184

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

Scalegrid

FEBRUARY 27, 2025

Incremental Backups: Speeds up recovery and makes data management more efficient for active databases. Improved JSON Handling & Security: Improved logical replication and the new MAINTAIN privilege give database administrators more control and flexibility. Start your free trial today!

Speed 130

Speed Database Storage Efficiency 130

Scalegrid

SEPTEMBER 16, 2019

PostgreSQL graphical user interface (GUI) tools help these open source database users to manage, manipulate, and visualize their data. PostgreSQL is the fourth most popular database management system in the world, and heavily used in all sizes of applications from small to large. Why Use a GUI Tool? Top PostgreSQL GUI Tools.

Open Source 262

Open Source Database Azure Cloud 262

DZone

FEBRUARY 10, 2025

Although traditional CMS solutions are versatile, they involve the burden of taking care of databases and server-side rendering. In this way, Drupal can act as a powerful backend for handling the content while allowing for the development of fast, secure, and lightweight static websites.

Website 147

Website Scalability Efficiency Database 147

Dynatrace

APRIL 9, 2025

A critical security threat for cloud-native architectures SSRF is a web security vulnerability that allows an attacker to make a server-side application send requests to unintended locations. SSRF can lead to unauthorized access to sensitive data, such as cloud metadata, internal databases, and other protected resources.

Java 147

Java Programming Architecture Cloud 147

Scalegrid

MAY 2, 2019

Python is a powerful and flexible programming language used by millions of developers around the world to build their applications. It comes as no surprise that Python developers commonly leverage MongoDB hosting , the most popular NoSQL database , for their deployments due to its flexible nature and lack of schema requirements.

Testing 55

Testing Network Database Servers 55

Scalegrid

APRIL 2, 2019

PostgreSQL is an open source relational database system that has soared in popularity over the past 30 years from its active, loyal, and growing community. For the 2nd year in a row, PostgreSQL has kept the title of #1 fastest growing database in the world according to the DBMS of the Year report by the experts at DB-Engines.

Database 185

Database Cloud Open Source Azure 185

DZone

JULY 11, 2022

If you are a software developer, sooner or later you’ll have to connect to a Linux machine to perform administrative tasks, access remote database servers, or deploy applications, among other things. Getting comfortable using the command-line interface (CLI) is a must if you want to be proficient with Linux.

Virtualization 278

Virtualization Database Servers Software 278

High Scalability

FEBRUARY 17, 2021

This article is to simply report the YCSB bench test results in detail for five NoSQL databases namely Redis, MongoDB, Couchbase, Yugabyte and BangDB and compare the result side by side. I have used latest versions for each NoSQL DB and have followed the recommendations to run all the databases in optimized conditions. About YCSB.

Benchmarking 308

Benchmarking Latency C++ Database 308

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 117

Servers Database Cache C++ 117

Scalegrid

SEPTEMBER 5, 2024

Managing High Availability (HA) in your PostgreSQL hosting is very important to ensuring your database deployment clusters maintain exceptional uptime and strong operational performance so your data is always available to your application. The primary server is responsible for handling all write operations and maintaining data accuracy.

Availability 257

Availability Servers Database Open Source 257

The Netflix TechBlog

SEPTEMBER 18, 2024

Central to this infrastructure is our use of multiple online distributed databases such as Apache Cassandra , a NoSQL database known for its high availability and scalability. Over time as new key-value databases were introduced and service owners launched new use cases, we encountered numerous challenges with datastore misuse.

Latency 260

Latency Storage Cache Servers 260

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. Data Store.

Serverless 325

Serverless AWS Lambda Storage 325

Scalegrid

JANUARY 10, 2025

Heading into 2024, SQL databases will remain essential in data management, increasingly using distributed systems to meet growing needs for scalability and reliability. According to 2023 statistics, 49% of web applications use an SQL-based database , with SQL having a 75% adoption rate in the IT industry.

Database 130

Database Scalability Best Practices Blockchain 130

Dynatrace

JANUARY 11, 2023

Continuous cloud monitoring with automation provides clear visibility into the performance and availability of websites, files, applications, servers, and network resources. Database monitoring. This ensures the database queries are performant, while also identifying host problems. Cloud-server monitoring.

Cloud 295

Cloud Monitoring Best Practices Infrastructure 295

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. Kubernetes is emerging as the “operating system” of the cloud.

Open Source 358

Open Source Java Operating System Programming 358

Scalegrid

AUGUST 22, 2019

On the first node, Patroni initializes the database, obtains the leader lock from DCS, and ensures the node is being run as the master. All of these tests were performed while the application was running and inserting data to the PostgreSQL database. Standby Server Tests. Reboot the server. Master/Primary Server Tests.

Availability 277

Availability Servers Network Testing 277

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. The MariaDB 11 series did not yet have any long-term supported (LTS) releases, which are the releases most would consider for running mission-critical databases in production.

Database 98

Database Servers Innovation Open Source 98

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. Developers are often strongly discouraged from holding a database connection while other operations take place.

Architecture 200

Architecture Database Latency Servers 200

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. Default database: 'test'. Want to give it a try?

Servers 160

Servers Database Processing Availability 160

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 132

Availability Database Open Source Hardware 132

CSS Wizardry

AUGUST 7, 2019

However, one metric I feel that front-end developers overlook all too quickly is Time to First Byte (TTFB). A lot of people surmise that TTFB is merely time spent on the server, but that is only a small fraction of the true extent of things. can all provide valuable insights. Expect closer to 75ms. It all gets added to your TTFB.

Latency 270

Latency Ecommerce Servers Mobile 270

DZone

JUNE 30, 2023

Developers were told to use ORMs and prepared statements to avoid SQL injections for a long time now. Modern languages and frameworks often also abstract away the need to write raw queries, offering high-level interfaces around our database models.

Infrastructure 273

Infrastructure Database Servers Design 273

Scalegrid

JULY 8, 2020

If the script has already performed writes to the server and must still be killed, use the SHUTDOWN NOSAVE to shutdown the server completely. In fact, this discussion applies to any high availability system that depends on polling the Redis servers for health: Long-running scripts will initially block client commands.

Servers 239

Servers Database Availability Monitoring 239

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 139

Database Open Source Traffic Small Business 139

Scalegrid

DECEMBER 6, 2023

In the digital age, data management has transformed from locally hosted servers to cloud solutions. The choice of self-managed cloud databases vs DBaaS is a common debate among those who are looking for the best option that will cater to their particular needs.

Database 130

Database Cloud Hardware Storage 130

Scalegrid

SEPTEMBER 18, 2020

One option is purchasing your own CA-signed SSL certificates and configuring them on the MongoDB server. If your application connects to the production database over a public network, do reach out to support@scalegrid.io If you move your code to a new server, it can suddenly stop working. to learn more about this. Prerequisites.

C++ 244

C++ Programming Servers Database 244

Scalegrid

JULY 8, 2019

Are you looking to get started with the world’s most popular open-source database, and wondering how you should setup your MySQL hosting ? While Microsoft Azure does offer a managed solution, Azure Database, the solution has some major limitations you should know about before migrating your MySQL deployments.

Azure 219

Azure Cloud Virtualization Database 219

Percona

FEBRUARY 9, 2023

Now it is time to get your databases ready for the rest of the year. If you replicate from one server to the next, are you replicating what you need? Take some to check how the server is being accessed, as you do not want a project to use the root access for all queries. Welcome to 2023! First, how are your backups?

Database 122

Database Open Source Hardware Operating System 122

Scalegrid

MARCH 23, 2020

While its use and importance has decreased as the inbuilt replication options improved on PostgreSQL server side, this still remains a valuable option for older versions of PostgreSQL. Follow these steps to set up Pgpool-II, enable the connection pool services you need, and connect to your PostgreSQL server. At a glance. How it works.

Cache 264

Cache Servers Architecture Processing 264

Scalegrid

JULY 13, 2020

Oracle Database is a commercial, proprietary multi-model database management system produced by Oracle Corporation, and the largest relational database management system (RDBMS) in the world. While Oracle remains the #1 database on the market, its popularity has steadily declined by over 18% since 2013.

Open Source 244

Open Source Tuning C++ Database 244

Dynatrace

MAY 27, 2022

As a result, many IT teams are turning to artificial intelligence for IT operations (AIOps) , which integrates AI into operations to automate systems across the development lifecycle. An IT organization is often unaware a critical server has gone down until a user reports it. An example of the self-healing web.

Artificial Intelligence 246

Artificial Intelligence Innovation Servers Database 246

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 218

Monitoring Best Practices Infrastructure Servers 218

Percona

OCTOBER 10, 2023

Databases are different from a lot of software. This is not a general rule, but as databases are responsible for a core layer of any IT system – data storage and processing — they require reliability. Why choose Percona Server for MongoDB? Why release Percona Server for MongoDB 7 now?

Availability 120

Availability Servers Database Open Source 120