Frequently Asked Questions2021-05-04T02:36:26+08:00

Frequently Asked Questions

POSTGRESQL

Is there any tool to migrate from SQL to PostgreSQL?2021-07-22T13:48:32+08:00

To migrate data, you can use the EDB Migration tool kit, a part of the EnterpriseDB subscription.

How can Postgres support multitenant?2021-07-22T13:44:41+08:00

Postgres instance has three default databases in it, and users can create multiple databases in the future as per their application requirement. It means one Postgres instance can have many databases, and each database may cater to the need of specific applications. So for microservices architecture, you can host multiple databases on a single Postgres server.

Does Postgres have MOS Documents like oracle, and please provide some details on Support in case of issues?2021-07-22T13:43:56+08:00

Postgres has the PostgreSQL community, where all the email archives are maintained about old queries by community members. One needs to search through the email archives to get available solutions for their issues, but the community maintains no MOS-like documents.

Just like in SQL express version, does it supports 10GB of DB? What about in PostgreSQL?2021-07-22T13:42:10+08:00

Postgres being an open source database, there are no restrictions on database size, unlike proprietary databases like Oracle, MS SQL server where database capabilities are subjective to the license that is bought by the customer.

Would you please highlight few points on BDR performance Benchmarking for a Large Prod setup?2021-07-22T13:39:50+08:00
If Version up-gradation of PG can be automatic in the VM based installations?2021-07-22T13:37:11+08:00

Postgres major or minor version upgrade is not automatic though it has simple steps to follow. You should execute those steps to upgrade, but compared to other database product upgrade in Postgres is quite straightforward.

What key factors must one consider while upgrading a Postgres to a significant version on AWS, e.g., from version 10 to version 13?2021-07-22T13:34:11+08:00

For upgrading Postgres on AWS EC2 machines, the steps would be the same as that of on-premises Postgres deployment.

  1. Check the release note of the latest version for any incompatibilities.
  2. Take the backup of the Postgres database that you plan to upgrade.
  3. Test upgrade in UAT environment and test the application against the latest upgraded version of Postgres for function and performance evaluation
  4. Perform the upgrade in the production environment and identify the cut-off time for the application.
Is any tool available for migration from other DBS?2021-07-22T13:32:34+08:00

You can use EDB runMTK tool for data migration from Oracle, MySQL, and MS SQL servers.

If it’s async, don’t you think it’s not real-time replication or considered it as near real-time replication?2021-07-22T13:26:59+08:00

Asynchronous replication is real-time replication. The significant difference between Asynchronous and Synchronous replication is, Synchronous replication would wait for confirmation from the standby server that it has received all the WAL changes, and then only commit confirmation is given for the corresponding transaction, whereas in async replication master database does not wait for confirmation from standby hence if standby is not available the changes made on the master will not be replicated to standby database and may create the possibility of data loss.

Suppose my barman server is installed on PG version 9.6.is Postgres 13 version server. Can we configure on Barman the server running on 9.6.is it compatible?2021-07-22T13:22:31+08:00

BARMAN is a backup tool, so it does not need the Postgres database to install it. Barman documentation gives information about which minimum version of Postgres it supports, and accordingly, you need to install BARMAN software. However, it’s always advisable to use the latest version of BARMAN.

With this multi-cloud, how do you guarantee the performance is the same on both Clouds?2021-07-22T13:17:38+08:00

There’s no specific or standard computation on Postgres database performance running On-Prem and Cloud. It depends on the workload. Most of the cloud vendor provides pre-configured setup in terms of number of CPU, RAM, Storage, Network Bandwidth, etc. Usually, doing a performance or load testing will give the optimal configuration to meet the performance requirement.

How big a database can be handled with PostgreSQL?2021-07-22T13:37:32+08:00

There is no limitation of the database size. However, there are customer cases where Postgres is being used for storing Petabyte’s size of data. Like any other proprietary database in the market, PostgreSQL can handle TBs of data. The hardware layer is one of the critical components in database sizing.

BDR is sync or async mode?2021-07-22T13:13:48+08:00

It’s in Asynchronous mode only.

Can we take backup using BART, Barman, or pgBackrest on azure blob storage?2021-07-22T13:11:19+08:00

pgBackRest repositories can be in S3, Azure, and GCS compatible object stores to allow the virtually unlimited capacity and retention. Unfortunately, BART & BARMAN cannot directly support store backup on Azure Blob storage.

Can you share security options related to encryption, from online to offline copy of database such as backup?2021-07-22T13:05:22+08:00

pgBackRest can encrypt the repository to secure backups wherever stored, while other backup tools like BARMAN & BART don’t have any encryption features.

How will BDR help in synching data the way in Hybrid Model?2021-07-22T13:02:41+08:00

Bi-Directional Replication (BDR) is an asynchronous multi-master replication system for PostgreSQL, specifically designed to allow geographically distributed clusters. Multi-Master Replication in BDR allows efficient replication for both DDL and DML with automatic conflict resolution. It also offers Conflict-free Replicated Data Types (CRDTs), which support merging values from concurrently modified rows.

Can we use Barman, pgBackrest, or BART with open source PostgreSQL? If yes, is it a onetime payment, or should we subscribe for support?2021-07-22T12:59:09+08:00

Yes, you can use all these tools with open-source PostgreSQL. BART is EnterpriseDB subscription-based tool.

Is a tool that are mentioned in the webinar for SQL replication and for tuning the query is free or paid?2021-07-22T12:55:20+08:00

All the EnterpriseDB tools are subscription-based.

Since Postgres is open source, does it have any security issues?2021-07-22T12:51:50+08:00
Does EDB provide support for Extension in PostgreSQL?2021-07-22T12:47:23+08:00

Yes, EDB provides an additional extension developed and maintained by EDB team. Please refer to the link, Extensions supported by EDB.

https://www.enterprisedb.com/edb-docs/d/postgresql/reference/manual/11.2/contrib.html

Is Postgres 13 available now for Linux?2021-07-22T12:52:11+08:00

PostgreSQL 13 supports major Linux distributions like Debian, RHEL/Centos, SUSE, Ubuntu, Other Linux platforms.

While taking backup does real-time transactions go to locking state/blocked state?2021-03-01T18:34:20+08:00

No, there is no blocking/locking that occurred on real-time transactions while taking backup.

IN Bart if you want to specify a new location while restoration?2021-03-01T18:32:37+08:00

Yes, it is possible to specify the new location while restoration. For this requirement, the user has to specify either -p <restore_path> or –restore-path <restore_path> option where restore_path is the directory the path where the backup of the database server is to be restored. The directory must be empty and have the proper ownership and privileges assigned to it.

If we have 100 Database environments, Do we need to install BART in one server and integrate all the PostgreSQL DB into it?2021-03-01T18:30:15+08:00

Yes, you can install BART on a single server and integrate all the PostgreSQL DB into that server.

How exactly BART helps in avoiding incremental backup and reduce the size of backup?2021-03-01T18:25:09+08:00

Block-level incremental backup is a feature of BART which is similar to a full backup, but contains only the modified blocks of the relation files that have been changed since a previous backup instead of all, full relation files.

There are certain advantages of Block-level incremental backup as below:

1) The amount of time required to produce an incremental backup is generally less than a full backup, as modified relation blocks are saved instead of all full relation files of the database cluster.

2) An incremental backup uses less disk space than a full backup taken in the plain text format.

If my synchronous DB is out of sync and not getting sync, how to solve this issue. Can incremental backup be applied? right?2021-03-01T18:19:17+08:00

The recovery of the reported issue depends upon the exact issue and cause of out of sync. If an issue occurred due to missing WAL files then the user can pass missing WAL from archive backups but if it’s due to some other changes like creation of tablespace etc then the restoration of incremental backup not helpful.

Can the Migration tool be used to migrate DB2(LUw) to PostgreSQL?2021-03-01T18:16:02+08:00

Migration Toolkit is a powerful command-line tool that offers detailed control of the migration process. Migration Toolkit facilitates migration of database objects and data to an EDB PostgresDB Postgres Advanced Server or PostgreSQL database from Oracle, MySQL & Microsoft SQL Server only.

Are all the BART/PEM tools part of EDB Advanced Server license package?2021-03-01T18:14:24+08:00

Yes, all the EDB tools like BART, PEM & EFM are part of DB Advanced Server license package.

Does EDB Tools required the extra license to procure?2021-03-01T14:40:23+08:00

All the EDB tools like PEM, EFM, BART and Replication Server are part of the EDB subscription. So, once you purchase the EDB subscription then you can use these tools without any extra cost.

Can PostgreSQL work with ETL tools?2021-03-01T15:02:09+08:00

Yes, PostgreSQL can work very well with most of the ETL tools which are available in market. I.e. Pentaho Data Integration, IBM InfoSphere DataStage, Informatica Power Center etc.

What is the supported replication type to configure EFM?2021-03-01T19:23:22+08:00

EFM support only PostgreSQL Streaming Replication.

What is VIP & Why we need in EFM?2021-03-01T19:24:15+08:00

A virtual IP address (VIP) is an IP address that doesn’t correspond to an actual physical network interface. Uses for VIPs include network address translation, fault-tolerance, and mobility. In EFM, VIP will help you to make auto-failover operation seamless from Application point of view. With the help of VIP, after the auto-failover there is no manual effort required to point your application to newly promoted master server.

What happened if master node failed?2021-03-01T19:26:51+08:00

If master node failed then EFM will send notification to DBA about the master node failure and perform auto-failover to your most up to date standby server. So, that server will become master server.

What happened if standby node failed?2021-03-01T19:28:49+08:00

If standby node failed then EFM will send notification to DBA about the standby node failure. Here, in this case only standby server failed hence it will not perform auto-failover.

MONGODB

Does MongoDB handle caching?2021-03-01T15:14:54+08:00

Yes. MongoDB keeps most recently used data in RAM. If you have created indexes for your queries and your working data set fits in RAM, MongoDB serves all queries from memory.

Does MongoDB support transactions?2021-03-01T15:12:07+08:00

Because a single document can contain related data that would otherwise be modelled across separate parent-child tables in a relational schema, MongoDB’s atomic single-document operations already provide transaction semantics that meet the data integrity needs of the majority of applications. One or more fields may be written in a single operation, including updates to multiple sub-documents and elements of an array. The guarantees provided by MongoDB ensure complete isolation as a document is updated; any errors cause the operation to roll back so that clients receive a consistent view of the document.

However, for situations that require atomicity of reads and writes to multiple documents (in a single or multiple collections), MongoDB supports multi-document transactions:

  • In version 4.0, MongoDB supports multi-document transactions on replica sets.
  • In version 4.2, MongoDB introduces distributed transactions, which adds support for multi-document transactions on sharded clusters and incorporates the existing support for multi-document transactions on replica sets.

For details regarding transactions in MongoDB, see the Transactions page.

Does MongoDB support SQL?2021-03-01T15:07:09+08:00

Not directly, no. However, MongoDB does support a rich query language of its own.

What platforms does MongoDB support?2021-03-01T15:05:10+08:00

For the list of supported platforms, see Supported Platforms

What’s mongodb cluster minimum node requirement?2021-03-01T19:27:22+08:00

As a best practice and the recommended way cluster should have minimum three nodes.
Primary with Two Secondary Members (P-S-S)
These deployments provide two complete copies of the data set at all times in addition to the primary.
These replica sets provide additional fault tolerance and high availability. If the primary is unavailable,
the replica set elects a secondary to be primary and continues normal operation.
The old primary re-joins the set when available.
if circumstances (such as cost) prohibit adding a third data bearing member, two data-bearing members and an arbiter (Primary-Secondary-Arbiter)

Primary with a Secondary and an Arbiter (P-S-A)
Since the arbiter does not hold a copy of the data, these deployments provides only one complete copy of the data.
Arbiters require fewer resources, but at the expense of more limited redundancy and fault tolerance.
However, a deployment with a primary, secondary, and an arbiter ensures that a replica set remains available if the primary or the secondary is unavailable.
If the primary is unavailable, the replica set will elect the secondary to be primary.

MongoDB Community edition can add to the ops manager?2021-03-01T19:27:56+08:00

OpsManager is part of Enterprise subscription. as per the Subscription Policy Mixed Environment is not supported.

Do we need to set config-set while using ops-manager?2021-03-01T19:32:40+08:00

Yes., there are few Prerequisites and configuration needed to setup OpsManager. In this Webinar we have covered this in detail.

You may like to watch this on-demand. please refer: https://www.ashnik.com/resources/webinars/how-to-automate-deployment-monitoring-and-manage-mongodb-clusters/

What instance type you would prefer for self-hosted MongoDB on AWS?2021-03-01T19:33:19+08:00

On AWS, you have an option to configure mongodb from Micro., you may like to choose your requirement of the workload.

For Complete AWS EC2 Instance Types. Please Refer: https://aws.amazon.com/ec2/instance-types/

Kubernetes

Can we have container Image from multiple could in Docker Enterprise (now Mirantis Kubernetes Engine)?2021-03-01T19:16:19+08:00

Container Image is an unchangeable, static file that includes executable code. so it can run on any isolated environment.

Can you give a comparison of Kubernetes vs dcos?2021-03-01T19:15:29+08:00

please find the difference here

Build promotion/ image promotion, how will we go about it?2021-03-01T19:11:34+08:00

Once you’ve made changes to your application and want to make them available to your users, you typically push an image to DTR, or have a CI/CD pipeline that does it for you. A team responsible for QA will notice you’ve pushed a new image, run tests, and if the image is working as expected, they’ll promote it to production.

As an example, you push the image to docker/website-dev:3-stable, the QA team will pull and test it, and push it as docker/website-prod:latest

DTR allows you to automate this. If the image you pushed to DTR meets certain criteria, like it has a specific name, and doesn’t have any vulnerabilities, the image is automatically promoted. You can combine multiple promotion criteria, and chain promotion rules, to build complex deployment pipelines.

Does Kubernetes work with AWS spot instances?2021-03-01T18:48:14+08:00

Yes we can use AWS spot instances for Kubernetes. For more read here.

How do your Docker EE platform compete in this highly crowded ecosystem and maybe tell us about the future of Docker Enterprise (now Mirantis Kubernetes Engine)? Also, what is Docker Enterprise Container Cloud?2021-03-01T18:45:44+08:00

Docker Enterprise Container Cloud is a multi-cloud management solution that gives you one set of APIs and tools to deploy, manage, and observe secure-by-default, certified, batteries-included Kubernetes clusters on any infrastructure: public cloud, private cloud, or bare metal.  For more read here

NGINX

Can we integrate Kerberos authentication as well?2021-03-01T18:13:18+08:00

Yes.

Can we integrate email alerts with monitoring on NGINX? like for 404 send email?2021-03-01T18:09:03+08:00

Yes.

How do I obtain NGINX Plus?2021-03-01T18:07:02+08:00

Get in touch and our experts will get on it right away.

What kind of advanced load balancing does NGINX Plus provide on top of NGINX Open Source?2021-03-01T18:04:50+08:00

Load‑balancing algorithms function better in NGINX Plus due to cross‑core synchronization, multiple session persistence methods to fine‑tune load balancing decisions, health checks to better identify failed servers, and slow‑start to reintroduce them. For more information please see: Application Load Balancing with NGINX Plus

Who benefits the most from NGINX Plus?2021-03-01T18:03:51+08:00

Companies who:

  • Are running a commercial application or website that requires a predictable, reliable and high performance user experience;
  • Have used NGINX OSS, but want to reduce complexity and have a supported NGINX build;
  • Are migrating their web architectures from a monolithic application to a lightweight, “scale out” distributed, componentized architecture (and need an outer “shell/routing layer” on top of that);
  • Are moving to virtualized/cloud environments and need a more modern, cloud-friendly alternative to their existing hardware-based LB/ADC solutions;
  • Have a hardware-based LB/ADC solutions and don’t want to continue to purchase expensive, non-scalable, rigid solutions at 10x more cost compared to NGINX Plus;
  • Media/Content owners doing massive HTTP streaming media (HTTP video/audio).
What are the main benefits of using NGINX Plus over NGINX Open Source?2021-03-01T15:36:57+08:00

NGINX Plus is convenient, fully supported by NGINX, Inc., and provides a range of advanced features.

  • It’s convenient – Install prebuilt and tested binaries from NGINX’s private repo.
  • It’s supported – Take advantage of full support and updates from NGINX, Inc., the team behind both NGINX Open Source and NGINX Plus.
  • It’s feature-rich – NGINX Plus combines the functionality of a high‑performance web server, a powerful front‑end load balancer and a highly scalable accelerating cache to create the ideal end-to-end platform for your web applications. NGINX Plus is built on top of NGINX Open Source and we are continuing to develop NGINX Open Source.
What is NGINX Plus and how is it different from NGINX Open Source?2021-03-01T19:20:12+08:00

If You Like NGINX, You’ll Love NGINX Plus

NGINX Plus is a cloud‑native, easy-to-use reverse proxy, load balancer, and API gateway. Whether you need to integrate advanced monitoringstrengthen security controls, or orchestrate Kubernetes containers, NGINX Plus delivers with the five‑star support you expect from NGINX.

    Have a technical query? Ask us.