SQL Shack

SEPTEMBER 8, 2020

In this 20th article for the SQL Server Always On Availability Group series, we will cover the steps to restore an existing availability group database. Requirement Suppose we have multiple database environments for a critical application. These environments can be development, stage, UAT (user acceptance testing).

Availability 52

Availability Database Servers Testing 52

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

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. Replication Manager (repmgr). How it Works.

Availability 147

Availability Servers Open Source Database 147

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

SQL Shack

DECEMBER 10, 2020

In this 38th article for SQL Server Always On Availability Groups, we will explore Windows PowerShell scripts to configure it. Introduction Windows PowerShell is a scripting language that offers useful modules for database professionals (Developer and DBA).

Availability 87

Availability Servers Database Performance 87

Official Blog - World Web Technology

NOVEMBER 9, 2023

Choosing the correct programming language for web development is critical for producing outstanding websites. PHP is a language that has weathered the test of time and is still frequently used by web developers. Web developers choose PHP for significant website development due to several reasons.

Website 59

Website Development Open Source Database 59

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 Storage Servers 184

Official Blog - World Web Technology

AUGUST 27, 2023

When you decide to develop a business website, there are many things you need to consider to reap all the benefits it offers. PHP is one of the most prolific and versatile programming languages to develop a highly customized, feature-rich, robust, and secure website that serves all your business purposes. Do I need to say more?

Development 98

Development Ecommerce Open Source Website 98

Scalegrid

OCTOBER 2, 2019

October 2, 2019 – ScaleGrid, a rapidly growing leader in the Database-as-a-Service (DBaaS) space, has just launched their new fully managed Hosting on Azure for Redis™ service. Redis™, the #1 key-value store and top 10 database in the world, has grown by over 300% in popularity over that past 5 years, per the DB-Engines knowledge base.

Azure 100

Azure Availability Open Source Virtualization 100

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

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

Dynatrace

MARCH 6, 2024

IBM i, formerly known as iSeries, is an operating system developed by IBM for its line of IBM i Power Systems servers. It also includes various built-in software components for database management, security, and application development. What is IBM i? How does the extension work?

Monitoring 237

Monitoring Infrastructure Metrics Analytics 237

Percona

JUNE 26, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona Server for MySQL 8.0.33-25 25 Percona Server for MySQL 8.0.33-25

Servers 69

Servers Open Source Scalability Database 69

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

MARCH 13, 2023

Percona is a leading provider of unbiased open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive. Percona Server for MySQL 5.7.41-44 44 On March 2, 2023, Percona Server for MySQL 5.7.41-44 Percona Server for MongoDB 4.2.24-24

Servers 77

Servers Open Source Database Software 77

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

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. Development and demand for AI tools come with a growing concern about their environmental cost.

Cache 206

Cache Azure Infrastructure Monitoring 206

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

Open Source 345

Open Source Java Operating System Programming 345

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

Scalegrid

MARCH 23, 2020

It supports high-availability, provides automated load balancing, and has the intelligence to balance load between masters and slaves so write loads are always directed at masters, while read loads are directed to slaves. Once installed, we must configure Pgpool-II to enable the services we want, and connect to the PostgreSQL server.

Cache 264

Cache Servers Architecture Processing 264

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

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. One option is purchasing your own CA-signed SSL certificates and configuring them on the MongoDB server. ScaleGrid provides you two options for setting up SSL.

C++ 244

C++ Programming Servers Database 244

Dynatrace

MARCH 22, 2023

Application vulnerabilities are an inevitable byproduct of the growth of agile development techniques and can be tricky to spot and address. While these vulnerabilities aren’t anything new, the modular and distributed nature of modern software development introduces a new potential for application security risks.

Open Source 200

Open Source Artificial Intelligence Internet Internet 200

Scalegrid

JULY 17, 2019

July 17, 2019 – ScaleGrid, a leader in the Database-as-a-Service (DBaaS) space, has just announced support for PostgreSQL hosting in the cloud. The database is also widely loved for PostgreSQL extensions which enable users to extend the functionality of their database. PALO ALTO, Calif.,

Azure 182

Azure AWS Open Source Database 182

Scalegrid

JANUARY 8, 2024

AI-driven cloud solutions like ScaleGrid offer a diverse range of database hosting options, robust infrastructure optimized for scalability and security, and enable significant cost reductions, supporting businesses in efficient growth and improved ROI. These services are tailored to meet various business requirements.

Artificial Intelligence 147

Artificial Intelligence Cloud Scalability Analytics 147

Percona

JUNE 23, 2023

Both MySQL and PostgreSQL do the basics very well From a high level, one relational database management system is pretty much like every other relational database management system. It does not follow the SQL Standard as closely as other databases, and some useful functions such as MERGE() are missing.

Database 118

Database Transportation Servers Cloud 118

Dynatrace

OCTOBER 23, 2023

Determining the root cause of these issues can be difficult when the underlying “hardware” is a virtualization software stack rather than a bare-metal server. Therefore, we have redesigned this extension from scratch, replacing the previously available WMI-based extension. Hyper-V is essential for the Windows ecosystem.

Efficiency 216

Efficiency Virtualization Hardware Performance 216

Official Blog - World Web Technology

APRIL 12, 2023

Do you want to develop a new website for your business? The first thing that you will need to do is to finalize the right web development framework for your website. Because WordPress is one of the most preferred content management systems to develop highly user-friendly, competitive, and dynamic websites. Why WordPress?

Development 52

Development Website Ecommerce Programming 52

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 189

Artificial Intelligence Innovation Servers Database 189

Percona

DECEMBER 4, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Find more information in the Telemetry on Percona Server for MySQL document.

Open Source 77

Open Source Azure Servers Programming 77

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

Scalegrid

JANUARY 11, 2024

Key Takeaways Cloud security monitoring is a comprehensive approach involving both manual and automated processes to oversee servers, applications, platforms, and websites, using tools that are customized to fit unique cloud architectures. This includes servers, applications, software platforms, and websites.

Best Practices 130

Best Practices Cloud Monitoring Strategy 130

Scalegrid

APRIL 16, 2020

Where you decide to host your cloud databases is a huge decision. But, if you’re considering leveraging a managed databases provider, you have another decision to make – are you able to host in your own cloud account or are you required to host through your managed service provider? Where to host your cloud database?

Cloud 242

Cloud Azure AWS Database 242

Percona

OCTOBER 2, 2023

Percona is a leading provider of unbiased, performance-first, open source database solutions that allow organizations to easily, securely, and affordably maintain business agility, minimize risks, and stay competitive, free from vendor lock-in. Percona Server for MySQL 8.0.34-26 26 Percona Server for MySQL 8.0.34-26

Open Source 77

Open Source Scalability Database Servers 77

Dynatrace

MAY 19, 2022

Every organization’s goal is to keep its systems available and resilient to support business demands. Organizations have multiple stakeholders and almost always have different teams that set up monitoring, operate systems, and develop new functionality. This refers to the load on your network and servers. Dynatrace news.

Automotive 272

Automotive Latency Architecture Azure 272

Percona

MAY 2, 2023

At the same time that I see database engineers relying on the tool, sites such as StackOverflow are banning ChatGPT. Questions Q: I have a MySQL server with 500 GB of RAM; my data set is 100 GB. A commonly recommended value for the buffer pool size is between 50% to 75% of the available memory.

Social Media 119

Social Media Database Servers Cache 119