What is Greenplum Database? Intro to the Big Data Database


Greenplum Database is a massively parallel processing (MPP) SQL database that is built and based on PostgreSQL. Greenplum Database is an open-source , hardware-agnostic MPP database for analytics, based on PostgreSQL and developed by Pivotal who was later acquired by VMware.

2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use


Wondering which databases are trending in 2019? Get the latest insights on MySQL , MongoDB , PostgreSQL , Redis , and many others to see which database management systems are most favored this year. SQL Databases. NoSQL Databases. NoSQL Database Use: 39.52%.

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Reducing Your Database Hosting Costs: DigitalOcean vs. AWS vs. Azure


If you’re hosting your databases in the cloud, choosing the right cloud service provider is a significant decision to make for your long-term hosting costs. Over the last few weeks, we have been inundated with requests from SMB customers looking to improve the ROI on their database hosting.

Azure 236

Making it Easier to Manage a Production PostgreSQL Database


PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. If you are planning to build a large 24/7 operation, the ability to easily operate the database once it is in production becomes a very important factor. This is a standard built-in feature in many of the new NoSQL databases, and PostgreSQL would do great to take a leaf out of their books when it comes to operations.

How to Setup a WordPress MySQL Database in the Cloud


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. As any WordPress developer knows, each installation requires a database in the backend, and MySQL is the database of choice for storing and retrieving your WordPress data. Unlimited Databases. Here’s how you can set this up: Create a New MySQL Database.

How DevOps Should Use DBaaS (Database-as-a-Service) To Optimize Their Application Development

High Scalability

Database-as-a-Service (DBaaS) is quickly gaining in popularity across the tech world. These software platform solutions helps users easily manage their database operations without having to really understand any of the abstractions. This allows developers, DBA’s and DevOps engineers to quickly automate their backups, create new SQL and NoSQL clusters, and monitor the performance of their databases for their application without requiring any internal database expertise.

DevOps 198

Millions of tiny databases

The Morning Paper

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.

2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combinations & Top Reasons Used


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. 2019 PostgreSQL Trends Report: Private vs. Public Cloud, Migrations, Database Combos & Top Reasons Used Click To Tweet.

Towards multiverse databases

The Morning Paper

Towards multiverse databases Marzoev et al., The central idea behind multiverse databases is to push the data access and privacy rules into the database itself. A policy just needs to be a deterministic function of a given update’s record data and the database contents.

SQL Clone for Unit Testing Databases


Sometimes, when you are performing unit or integration tests whilst developing code, you need to be able to do something extreme, such as mangling a test database or two, repeatedly, each time subsequently restoring it to its original state before running the next test. database performance sql testing unit testing clone

Database Migration: Challenges, Need & Process


Database Migration is one of those. If you are planning a migration, what are the challenges involved during database migration? Let me walk you through the essentialities before performing database migration. Custom Software Development Database

Distributed Algorithms in NoSQL Databases

Highly Scalable

These developments gradually highlight a system of relevant database building blocks with proven practical efficiency. In this article I’m trying to provide more or less systematic description of techniques related to distributed operations in NoSQL databases.

2019 Open Source Database Report: Top Databases, Public Cloud vs. On-Premise, Polyglot Persistence


Ready to transition from a commercial database to open source, and want to know which databases are most popular in 2019? Wondering whether an on-premise vs. public cloud vs. hybrid cloud infrastructure is best for your database strategy? Or, considering adding a new database to your application and want to see which combinations are most popular? Polyglot Persistence Trends : Number of Databases Used & Top Combinations. 2019 Top Databases Used.

How does Database Migration Work? [Ultimate Checklist]


Database Migration is one of those trends whose charm does not fade and need to be adopted by the existing applications sooner or later. If you are planning for database migration, then you would be keen to know about the actual process involved. Software Development

Updating graph databases with Cypher

The Morning Paper

Updating graph databases with Cypher Green et al., Our understanding of updates in the popular graph database model… is still very rudimentary. Violations of atomicity and non-deterministic update behaviour certainly don’t sound like the kind of things you want in a database!!

Database compression on Nutanix


What space savings should you expect when running databases with default compression in a Nutanix cluster? The TPCx-HCI benchmark mimics a database consolidation setup, meaning that there are many databases per host. Compressability.

Exploring MySQL Binlog Server – Ripple


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. Ripple is an open source binlog server developed by Pavel Ivanov.

Bring Your Own Cloud (BYOC) vs. Dedicated Hosting at ScaleGrid


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?

Cloud 175

Bringing DevOps to the Database

Baron Schwartz

Applying DevOps principles and practices to the database can make software development processes faster, better and cheaper. Yet most companies do not include their databases in their DevOps initiatives because they face a variety of challenges to make it work.

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments

High Scalability

Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. Unlike cloning or replication, this allows you to maintain an active, point-in-time copy of your production data. This extra cluster, known as a follower cluster, can be leveraged for multiple use cases, including for analyzing, optimizing and testing your application performance for MongoDB , MySQL and PostgreSQL.

The Best Way to Host MongoDB on DigitalOcean


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. While adequate for low-traffic applications, small databases, and dev/test environments, we recommend against leveraging shared clusters for your MongoDB production deployments.

Which Is the Best PostgreSQL GUI? 2019 Comparison


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.

Follower Clusters – 3 Major Use Cases for Syncing SQL & NoSQL Deployments


Follower clusters are a ScaleGrid feature that allows you to keep two independent database systems (of the same type) in sync. It is not available for our in-memory database offerings like hosting for Redis™*. Database Dev/Test Setup. By using follower clusters, you can periodically import data from your production database into the dev/test database. With your development and QA clusters set to follow the production cluster, you can rest easy.

Behavior Driven Development(BDD) With Gherkin


How can we bridge the gap between business and development? How do we make sure that features being developed are according to the business requirements from the beginning? Let us start with understanding what is Behavior Driven Development and the purpose it serves in detail below.

Web Development Trends 2019


Smart developers are always looking ahead for ways to adapt in the ever changing world of web development. Staying on top of the latest web development trends could eventually help you land a job that doesn’t exist yet.

Real-Time Digital Twins Simplify Development

ScaleOut Software

Developers need to write code that extracts patterns out of an incoming telemetry stream and take appropriate action. A database service to host state information for each user. Compare that to standing up web, application, database, and analytics services.

PostgreSQL Connection Pooling: Part 1 – Pros & Cons


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. As a result, popular middlewares have been developed for PostgreSQL.

Microservices, events, and upside-down databases

O'Reilly Software

Back then, the most common pattern I saw for service-based systems was sharing a database among multiple services. The rationale was simple: the data I need is already in this other database, and accessing a database is easy, so I’ll just reach in and grab what I need.

Increasing access to blockchain and ledger databases

All Things Distributed

They've created a way to connect small farms in developing nations to banks and distributers of goods, like seeds, fertilizer, and tools. HARA has had to develop additional technologies to make their application work on Ethereum, a popular, open source, blockchain framework

Tuning PostgreSQL Database Parameters to Optimize Performance


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. In this blog, we will establish basic guidelines for setting PostgreSQL database parameters to improve database performance according to workload. It is important to pay attention to performance when writing database queries.

Installing WordPress 5 on ZEIT Now with MySQL Hosting


With such strong interest in this installation, we decided to write up the steps to configure your MySQL database on the ScaleGrid side to get you up and running ever faster with WordPress on Now. The best part is all you need to do is set it up, and then your MySQL database runs on autopilot so you can keep your development efforts focused on product vs. those time-consuming database operations. Setting Up Your MySQL Database for WordPress on ZEIT Now.

How to Monitor MySQL Deployments with Prometheus & Grafana at ScaleGrid


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. This is usually done through monitoring software and tools either built-in to the database management software or installed from third-party providers.

PostgreSQL Connection Pooling: Part 3 – Pgpool-II


Once authentication succeeds, it checks if it already has a cached connection for this database+user combination. In our previous posts in this series, we discussed the case for connection pooling and introduced PgBouncer.

Sending SentryOne Data to the Azure SQL Database DTU Calculator

SQL Performance

If so, you may have heard about the Azure SQL Database DTU calculator , and you may have also read about how it has been reverse engineered by Andy Mallon. Database – Log Bytes Flushed/sec. I created a table called [AzureDatabaseDTUData] and stored it in the SentryOne database.

Azure 52

Best Practice for Creating Indexes on your MySQL Tables


There will be a short duration (tens of seconds) during which you will lose connectivity to your database due to the failover, but this can be overcome by having application-level retries.

Important Health Checks for your MySQL Master-Slave Servers


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. In this blog post, we explain some basic health checks you can do on your MySQL master and slave nodes to ensure your setup is healthy.

Where microservice development benefits from automation

O'Reilly Software

The growing popularity of microservices and APIs has led developers to automate the repetitive aspects of these technologies, such as defining all the RESTful requests, generating templates for the target code, and scaling out new instances.

The Best Way to Host MySQL on Azure Cloud


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. The first thing to consider when weighing between self-management and a MySQL Database-as-a-Service (DBaaS) solution is what internal resources you have available.

Azure 154

How enterprises can successfully scale Agile development


But here’s the rub: Agile development teams do not work in isolation. And why, in lieu of a single tool or process, organizations need to identify and eliminate long cycles and wait times within development itself, and beyond. The disconnect between the business and Agile development.

Amazon Aurora ascendant: How we designed a cloud-native relational database

All Things Distributed

Relational databases have been around for a long time. The core technologies underpinning the major relational database management systems of today were developed in the 1980–1990s. Those fundamentals helped make relational databases immensely popular with users everywhere.

Design 109

How To Connect To Your MongoDB Deployments Using Robo 3T GUI


Database Specific Users. In order to create simple, per-database, read-write or read-only users, log into the ScaleGrid console , navigate to the cluster details page, and click on the Databases tab. Save the connection, then double click on it, and you will see your database.

Amazon Aurora development team wins the 2019 ACM SIGMOD Systems Award

All Things Distributed

A few months ago, I wrote the post " Amazon Aurora ascendant: How we designed acloud-native relational database ," and now I'm excited to share some news about the people behind the service.

View-centric performance optimization for database-backed web applications

The Morning Paper

View-centric performance optimization for database-backed web applications Yang et al., Empirical studies have found that about a quarter of real-world web application performance problems are solved by developers through view changes, like pagination and view content removal.