Tag: Database

Feed: AWS Architecture Blog. Many AWS customers need to run mission-critical workloads—like traffic control system, online booking system, and so forth—using the IBM Db2 LUW database server. Typically, these workloads require the right high availability (HA) solution to make sure that the database is available in the event of a host or Availability Zone failure. This HA solution for the Db2 LUW database with automatic failover is managed using IBM Tivoli System Automation for Multiplatforms (Tivoli SA MP) technology with IBM Db2 high availability instance configuration utility (db2haicu). However, this solution is not supported on AWS Cloud deployment because the ... Read More

Feed: Planet PostgreSQL. When you run an application with a relational database attached, you will no doubt have encountered this question: Which indexes should I create? For some of us, indexing comes naturally, and B-tree, GIN and GIST are words of everyday use. And for some of us it’s more challenging to find out which index to create, taking a lot of time to get right. But what unites us is that creating and tweaking indexes is part of our job when we use a relational database such as Postgres in production. We need to get indexes right, in order ... Read More

Feed: SingleStore Blog. Author: . SingleStore is announcing the industry's first unified cloud database with the separation of storage and compute. SingleStore’s innovative architecture allows customers to run operational and analytical workloads simultaneously while flexibly scaling resources to power the next generation of data-intensive applications.SingleStore has implemented the separation of Storage and Compute, allowing users to effortlessly scale compute to meet the needs of any workload, while managing storage needs completely independently. Many data warehouses have separated storage and compute, but unlike SingleStore’s Unified database, their designs have sacrificed performance and query latency in doing so. SingleStore is unique in ... Read More

Feed: Planet MySQL; Author: Olivier Dasini; MySQL, the world’s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastructure (OCI) under the name of MySQL Database Service (MDS). MySQL Database Service is a fully managed cloud service, 100% Developed, Managed and Supported by the MySQL Team. This is the seventh episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. Please also note that you can run this tutorial and thus try MySQL ... Read More

Feed: Planet MySQL; Author: Vasu V; Setup for SSL MySQL Enterprise Database Version 8.0.22Purpose of the DocumentProcedure for MySQL Database Installation ( 8.0.22 – Enterprise) and setup for SSL on RHEL 8=====================================================================MySQL Database Installation –RHEL 8.x – DB Version 8.0.22 – Enterprise Edition=====================================================================The below procedure is related to MySQL Database Installation Version 8.0.22 on RHEL 8.4. ( Enterprise Edition)MySQL Server 172.31.17.141MySQL Client 172.31.25.170(1) Check the OS version of RHEL by using below command.[root@mysql-server ~]# cat /etc/redhat-releaseRed Hat Enterprise Linux release 8.4 (Ootpa)(2) Create local group for dba[root@mysql-server ~]# groupadd -g 1020 dba(3) Create local user for mysql[root@mysql-server ~]# useradd -g ... Read More

Feed: SingleStore Blog. Author: . The pace of global business increases every day, and all business is now fundamentally data-driven. To thrive in this modern digital services economy, it’s imperative to respond to customer requests in real time and access business insights on a second-by-second basis. These requirements are driving the creation and usage of massive volumes of data. As a result, applications across all industries and use cases are becoming increasingly data-intensive. To keep up with the multi-dimensional demands for data, the common solution has been to wire together multiple databases. These separate databases may well be individually fast and ... Read More

Feed: Planet MySQL; Author: Olivier Dasini; MySQL, the world’s most popular open source database, is available as a managed cloud service in Oracle Cloud Infrastructure (OCI) under the name of MySQL Database Service (MDS). MySQL Database Service is a fully managed cloud service, 100% Developed, Managed and Supported by the MySQL Team. This is the sixth episode of “Discovering MySQL Database Service“, a series of tutorials where I will show you, step by step, how to use MySQL Database Service and some other Oracle Cloud Infrastructure services. Please also note that you can run this tutorial and thus try MySQL ... Read More

Feed: Planet MySQL; Author: Frederic Descamps; We already saw how easy it’s to deploy solutions on OCI using Terraform and Resource Manager’s Stack. I’ve published several resources available on this page. Today we will see how easy it’s to deploy Apache Superset on OCI using MySQL Data Service. Apache Superset is an open source BI, Reporting, Charting tool that competes with Tableau, Looker, etc.  For a list of companies that have deployed Superset, see:  https://github.com/apache/superset/blob/master/RESOURCES/INTHEWILD.md. Superset is loaded with options that make it easy for users of all skill sets to explore and visualize their data, from simple line charts to ... Read More

Feed: Planet PostgreSQL. Introduction As a PostgreSQL Support Engineer, one common scenario we experience is a slow system on a reasonably powerful machine. In these cases, we often see that max_connections is set to 10,000 or more, sometimes even as high as 30,000. While we will advise that max_connections is too high and needs to be lowered, the usual response is, “Well, most of those connections are idle, so they shouldn’t affect performance.” This statement is not true, as an idle connection is not weightless. In this article, we’ll explore why a high idle connection count can be detrimental to ... Read More

Feed: Recent Announcements. AWS Database Migration Service (AWS DMS) expands functionality by adding support for migrating multiple databases in one task using MongoDB and Amazon DocumentDB (with MongoDB compatibility) as a source. Using AWS DMS, you can now group multiple databases of a MongoDB cluster and migrate them using one DMS task to any AWS DMS supported targets including Amazon DocumentDB (with MongoDB compatibility) with minimal downtime ... Read More