hdr: what is the optimal resolution setting to send a plain picture of Capture One to Aurora?

I am trying to send a group of raw photos from Capture One to Aurora to create an HDR image.

A dialog box appears when I do it

enter the description of the image here

I think most of the options are fine, except & # 39; Resolution & # 39 ;: I'm not sure if & # 39; 300 px / in & # 39; It is the right value. I am not entirely clear about the original resolution of the original images (I am using a Fujifilm xt-20). I don't want to pass plain files to Aurora with less resolution.

What is the optimal value for the Resolution field in this case?

Amazon Web Services – AWS Aurora – How to enable serverless mode through CLI

I am using the following command to create an AWS Aurora Serverless instance

aws rds create-db-cluster --db-cluster-identifier test-cluster --database-name testdb --master-username test --master-user-password testtest --engine aurora --engine-mode serverless --region us-east-1

But I am getting the following error.

Unknown options: – server mode, no server

The above command works very well in my AWS account, but it does not work in my clients account. (I only have programmatic access to that account). I have verified the permits twice and I have similar permits to those of my own account.

Summary: The AWS command to create an aurora cluster without a server is working on one account but not on another account with similar permissions.

Account 1:


Migration from MySQL 5.7.10 to Aurora (MySQL) -5.6.10a Without server and switching sql_mode

I'm looking to migrate my managed locally MySQL 5.7.10 database for Amazon Aurora Serverless. I'm tired of managing my database manually and I'd like to use an auto-scaling function Aurora Serverless.

Until now only Aurora (MySQL) -5.6.10a It is available for use in the serverless variant. MySQL 5.7.10 have sql_mode by default set in ONLY_FULL_GROUP_BY, STRICT_TRANS_TABLES, NO_ZERO_IN_DATE, NO_ZERO_DATE, ERROR_FOR_DIVISION_BY_ZERO, NO_AUTO_CREATE_USER, NO_ENGINE_SUBSTITUTION.

I noticed the difference between sql_mode& # 39; s in both databases because my application manages the balances of users and without STRICT_TRANS_TABLES the database only returns a warning if the user tries to spend more than he has in balance (the type of balance is a numeric value without sign) instead of throwing an error. Adjustment sql_mode to the values ​​above solve the problem.

However, I wonder if the configuration sql_mode to these values ​​in Aurora (MySQL) -5.6.10a It has some performance / autoscalling drawback or it can cause problems.

aurora postgresql logs – Database administrators stack up exchange

We are in the process of sending Aurora PostgreSQL records to a SIEM records management solution.

However, there does not seem to be an option to publish Aurora PostgreSQL in the Cloudwatch registry group. Is there any other way in which we can publish Aurora PostgreSQL records in an S3 repository or on any remote server from which the records management solution can read the records?

mysql – Amazon Aurora read-only slaves slowly increase to 100% CPU and die

We have a master database instance hosted on AWS Aurora (mysql) and we have many read-only slaves that are replicated from it. The master and the automatic scaling slaves of 4-12 are currently sized db.r4.4xlarge and engine version: 5.7.12.

Each slave connects and performs for a few days, but during that time its use of the CPU increases slowly until each one must be removed individually. Once killed, another is automatically rotated and continues.

Here is the performance graph of the slaves:
enter the description of the image here

As you can see at 11 pm, our warehouse closes and CPU utilization drops until the next day, when it rises and rises above the previous day. This increases day by day until it reaches 100% and should be eliminated.

Has any of you seen this pattern before and could you give us a clue as to where the problem might be?

Python 3.x – Aurora Sensor Project

We are working on a project in which we implemented a library of aurora event sensors. Here is a part of our code written in Python 3. We would like to get a review of the two classes below.

Import registration

from aiohttp.hdrs import USER_AGENT
import requests
Voluptuous import as vol.

from homeassistant.components.binary_sensor import (
PLATFORM_SCHEMA, BinarySensorDevice)
from homeassistant.const import CONF_NAME, ATTR_ATTRIBUTION
import homeassistant.helpers.config_validation as cv
of homeassistant.util import Throttle

Logger = logging.getLogger (__ name__)

ATTRIBUTION = "National Oceanic and Atmospheric Administration"

DEFAULT_DEVICE_CLASS = & # 39; visible & # 39;

HA_USER_AGENT = "Aurora Home Assistant"

MIN_TIME_BETWEEN_UPDATES = timedelta (minutes = 10)

URL = "http://services.swpc.noaa.gov/text/aurora-nowcast-map.txt"

AuroraSensor class (BinarySensorDevice):
# Implementation of an aurora sensor.

def __init __ (auto, DATA, name):
# Initialize the sensor.
self.aurora_data = DATA
self._name = name

Name def (self):
# Returns the name of the sensor.
returns the format & # 39; {} & # 39; (self._name)

def is_on (self):
# return true if aurora is visible.
returns self.aurora_data._is_visible if self.aurora_data else False

def DeviceClass (self):
# Returns the class of this device.

def device_state_attributes (self):
# Returns the attributes of the state.
attrs = {}

yes self.aurora_data:
attrs['visibility_level'] = self.aurora_data.visibility_level
attrs['message'] = self.aurora_data._is_visible_text
back attrs

else: # if there is no data
back attrs

def update (auto):
# Get the latest Aurora API data and update the statuses.
self.aurora_data.update ()

AuroraData class:
# get the forecast of the aurora

def __init __ (auto, latitude, longitude, threshold):
# Initialize the data object.
auto.latitude = latitude
long.longitude = length
self.number_of_latitude_intervals = 513
self.number_of_longitude_intervals = 1024
self.headers = {USER_AGENT: HA_USER_AGENT}
self.threshold = int (threshold)
self._is_visible = None
self._is_visible_text = None
self.visibility_level = None

def update (auto):
# Get the latest data from the Aurora service
self.visibility_level = self.get_aurora_forecast ()
if int (self.visibility_level)> self.threshold:
self._is_visible = True
self._is_visible_text = "visible!"
self._is_visible = False
self._is_visible_text = "nothing is out"

except requests.exceptions.HTTPError as error:
Logger.error (
"Connection failed with aurora forecast service:% s", error)
false return

def get_aurora_forecast (self):
# Obtain forecast data and analyze for long / lat given.
raw_data = requests.get (URL, headers = self.headers, timeout = 5) .text
forecast_table = [
            row.strip(" ").split("   ")
            for row in raw_data.split("n")
            if not row.startswith("#")

        # Convert lat and long for data points in table
convert_latitude = round ((self.latitude / 180)
* self.number_of_latitude_intervals)
convert_longitude = round ((self.longitude / 360)
* self.number_of_longitude_intervals)

return forecast_table[converted_latitude][converted_longitude]

postgresql – Elimination of temp files RG Aurora postgres

A report application generates many temporary files in RDS aurora postgresql. The temporary file records show an average of 20G of generated files for each query execution. But the execution of the query does not take long.

According to my understanding, once the execution has completed, the storage of 20G must be released and used by another consultation process. But you see, it's accumulating.

How to delete deletes the temporary files once the user obtained the result or do we need to modify some configuration to do it?

After some time, I'm getting stuck due to a space problem in LocalStorage.

I am very confused here, how to see the local storage space (maximum, used, free) in RDS aurora postgresql?

What database should I use locally if I am going to use Aurora Serverless?

I'm planning to use Aurora Serverless in QA / PROD and then a docker container to run a locally compatible engine. Should I use MariaDB 10.0 or MySQL 5.6?

Also, if this is a bad idea, please speak: thank you!

How to remove a halo from a sunset image in Aurora HDR?

I'm trying to take a HDR photo from a sunset taken from a boat. Using typical configurations, I get a sun that looks like this:

Halo around the sun

How do I fix it?

mysql – RDS Aurora Serverless "Parameter groups"

I have a MySQL RDS Aurora Serverless cluster, and I am trying to change a MySQL configuration (connect_timeout). Normally, you would use a group of parameters to set the value in the database instance. But, since this does not have a server, the instances are managed by AWS, so it seems that I can only configure the cluster.

Is there any way to set the Parameter Group that uses the instances that AWS creates?