In a previous blog, we talked about patterns to run a database in a highly available manner. In this blog, we present our open source recipe for PostgreSQL high availability.

MySQL, a leading open source database for the past few decades, underpins potentially millions of applications, from tiny prototypes to internet-scale e-commerce solutions. The beauty of MySQL is not only its powerful relational database capabilities but also that it can be scaled up as the application grows. Why should you care about MySQL performance? Because MySQL is the backbone of many applications, your application performance will be inherently tied to your MySQL database performance.

In modern software applications, time-stamped data is a common requirement. As a software developer or database administrator, you know that formatting dates is crucial for ensuring data accuracy and consistency. But with so many date formats and SQL engines out there, it can be challenging to find the right way to format dates for your specific needs.

High cardinality in time series data is challenging to manage. But it is necessary to unlock meaningful answers. Learn how streaming aggregations can rein in high cardinality using Levitate.

SQL provides a date type that developers can use to store date values. Also, to make working with dates easier, SQL has several date functions for retrieving, formatting, and manipulating dates. In this post, you’ll learn about some SQL date functions and how to use them.

In this series of blog posts, we speak with database professionals from Financial Services organizations around the world to better understand how DevOps is shaping the sector. On the way, we dig into key current factors including the rise of technology upstarts in fintech and insurtech, the speed of digital transformation and the ever-increasing threat of cyberattacks.

The next major release of VMware GemFire is now available! GemFire is a high-speed in-memory database for low-latency applications. Focused on resiliency and consistency, GemFire makes it easy to scale your data and support business-critical applications, whether they are on-premises, in the cloud, or somewhere in between. GemFire 10* was pre-announced at the SpringOne Essentials conference in January and later released as a public beta.

MySQL is an open-source relational database management system that operates based on the client-server model by using SQL as its mode of communication. It is the second most popular database in the world owing to its flexible and scalable nature, high security, ease of use, and ability to handle large data sets seamlessly. Due to its wide range of functionalities, MySQL is employed as part of the database management system for several high-profile companies such as Facebook, PayPal, and Twitter.

A constant challenge for many development teams is how to include test data management in the development process. Testing with consistent, realistic and compliant datasets, and bringing the database into CI and DevOps pipelines, has been shown to catch data-related issues long before they reach customers. The result: an increase in efficiency, a reduction in costs, and an improvement in the quality of software releases, enabling value to be released to customers faster.

A database is one of the most critical components for almost every application. Making sure it is running with the expected read and write latencies is paramount. This can be the difference between a smooth, pleasing user experience and a slow, error-filled one that makes your customers turn their back on a product — and never come back.