Database - Insurance Software development

Advantages of Azure SQL Database

Author - Webner
01/02/2020
|
5:25 am
|
0 Comments
|
Cloud
|
Post Views: 4,354

Azure SQL Database

Azure SQL Database is a relational database provided as Database-as-a-Service, which is a part of Microsoft’s Cloud Infrastructure Platform, Microsoft Azure. It is also called as SQL Azure. It provides database-backed managed service in the cloud with a petabyte-scale infrastructure. It is based on the latest version of the Microsoft SQL Server database engine and also receives timely and frequent updates. It is a fully managed service by Microsoft, so the user just has to provide the data and can be free of managing the infrastructure, security […]

Openproject: Some important additional configurations

Author - Webner
11/29/2019
|
5:39 am
|
0 Comments
|
Cloud
|
Post Views: 1,222

1. Database migration from ec2 to RDS

Backup and restore DB

# pg_dump -Fc -v -h [instance endpoint] -U [master_username] [database] > [database].dump

createdb [new database name]

# pg_restore -v -h [instance endpoint] -U [master_username] -d [new database name] [database].dump

In below file changes required with following directives

# vi /etc/openproject/conf.d/00_addon_postgres

export DATABASE_URL=”postgres://:@:5432/”

# openproject restart

2. Set S3 bucket for storage for attachments

# vi /etc/openproject/conf.d/other

Comment the below line

#export ATTACHMENTS_STORAGE_PATH=”/var/db/openproject/files”

And, add the below directives at the end of file

export […]

AWS Relational Database System

Author - Webner
11/15/2019
|
8:59 am
|
1 Comment
|
Cloud
|
Post Views: 1,590

Overview:

RDS is a Relational Database Service that helps you to manage your database on the cloud through the desired database engine. The AWS RDS and database administration tasks can be managed easily through simple steps.

Amazon RDS is a fully manageable and scalable cloud service that takes care of all the maintenance, backups, and patching for you. You can take the backup manually or schedule the Amazon RDS for automatic backup. Amazon RDS provides the facility to scale up and scale down the CPU, MEM, and IOPS. If your requirement is high memory, high CPU and low […]

➤
Contact Us