October 2019

As a Logi Analytics Partner, dbSeer is excited to attend and lead training at the 2019 Logi Analytics Conference on October 22nd and 22rd. Our technical team is leading trainings on a variety of Logi Analytics topics, including all the sessions below:

  • Introduction to Info Studio
  • All About Crosstabs
  • Security Fundamentals
  • Building Embedded Analytics
  • Process Task Overview
  • Advanced Charting Capabilities

The conference provides over 25 hours of in-depth presentations and 1:1 support to diagnose, troubleshoot, and resolve bugs with an expert. dbSeer has been a Logi Analytics Partner since our founding in 2013. We primarily provide consulting services for data architecture and Logi Analytics UI Modernization. As an AWS Advanced Consulting Partner, we can also migrate your application to a cloud-based platform. We offer a Logi Assessment, which evaluates your Logi implementation against our 42-point checklist and provides a report detailing areas for improvement. Finally, our customized Logi training packages will focus on the issues you request and help your team kick off their development.

If you’re at the conference, stop by and say hello to our team! We’re happy to help with any analytics issues you’re experiencing. If you couldn’t make it but our training topics look interesting, please reach out and we can provide you with more information.

 Like

Amazon Aurora is relational engine that is designed to be compatible with databases like MySQL and PostgreSQL. This allows you to make your existing application work in the cloud – but at 5x the standard performance of these databases! Amazon Aurora supports very large databases with compromising performance. It’s a reliable and cost-efficient option for growing businesses.

Below you can explore the plethora of updates that came with RDS for Amazon Aurora in 2019!

 

Amazon Aurora Updates

Sharing and Cross-Region Copying of Snapshots

Aurora Serverless DB clusters snapshots can now be shared publicly or with other AWS accounts. Aurora Serverless DB cluster snapshots across multiple AWS regions.

Authorized AWS accounts can easily restore a DB cluster from the shared DB cluster snapshot without copying the snapshot.

This feature is also supported by Amazon Aurora with PostgreSQL.

Capacity of 1 Unit and a New Scaling Option

Instead of managing and providing DB instances, Aurora serverless lets you provide minimum (1 unit) and maximum values of ACUs for your DB cluster. An ACU is a capacity measure that describes both performance and memory capacity.

Availability to 14 AWS Regions

Aurora global is now supported and is available in 14 AWS regions – see below.

EU (Ireland), EU (London), US East (Ohio), Asia Pacific (Seoul), US East (N. Virginia), US West (Oregon), Asia Pacific (Mumbai), Canada (Central), EU (Frankfurt), Asia Pacific (Singapore), EU (Paris), Asia Pacific (Tokyo), US West (Northern California), and Asia Pacific (Sydney).

Replications can be set in-between any of the two AWS regions mentioned above.

 

Performance Insight Support

Performance Insights a feature that monitors the database performance by visualizing database load and performance. This later helps in spotting and troubleshooting performance challenges.

This feature is available in Amazon Aurora.

RDS Recommendations

The RDS Recommendations feature in Amazon Aurora provides automated best practice guidance by evaluating your configuration, usage, and performance data. This includes information about issues in configurations, such as mismatch in instance classes or outdated versions of engine.

 

Amazon Aurora with MySQL Updates

Performance Insights Counters

Performance Insights is an advanced performance monitoring tool for database workloads. Additional Counter Metrics are now supported for AWS MySQL RDS. Counter Metrics allows customizing the Performance Insights dashboard with 10 additional graphs.

Amazon CloudWatch

Amazon Aurora serverless- MySQL compatible databases can now be set to issue a log report to Amazon CloudWatch that holds information about general logs, slow query logs, audit logs, and error logs. This will help you keep track of your Aurora Serverless databases query performance, database activity, and errors.

Supports db.r5 an db.t3 DB Instance Classes

Amazon EC2 R5 instances are the next generation of memory optimized instances for the Amazon Elastic Compute Cloud.  R5 instances are well suited for memory intensive applications such as high performance databases, distributed web scale in-memory caches, mid-size in-memory databases, real time big data analytics, and other enterprise applications.

T3 instances are the next generation low cost burstable general-purpose instance type that provide a baseline level of CPU performance with the ability to burst CPU usage at any time for as long as required. T3 instances are designed for applications with moderate CPU usage that experience temporary spikes in use.

Amazon Aurora for MySQL now supports R5 and T3 instance classes.

GTID based replication

Amazon Aurora with MySQL 5.7 compatibility now supports GTID. GTID (Global Transaction Identifier) is a unique identifier that is assigned to each transaction of the MySQL database.

Faster Migration from MySQL 5.7 databases

MySQL 5.7 backups stored in S3 can now be restored in Amazon Aurora with MySQL compatibility. Both full and incremental backups of the database can be restored. This is much faster than the mysqldump utility.

Data API

Data API is now available for Aurora with MySQL Compatibility. Web service based applications like AWS Lambda, AWS AppSync, AWS Cloud9 can access the Aurora cluster. Data API doesn’t require a persistent connection to the DB cluster. It provides a secure HTTP endpoint to run SQL statements.

 

Amazon Aurora with PostgreSQL Updates

Logical Replication

Amazon Aurora with PostgreSQL compatibility supports Logical Replication. Using logical replications, you are able to replicate the data changes from one Amazon Aurora database to other databases by utilizing replication tools like Amazon DMS or native replication slots of PostgreSQL.

Activity Streams

Amazon Aurora with PostgreSQL now supports Activity Streams for real time monitoring. Database Activity Streams provide a real-time data stream of the database activity in your relational database.

Cluster cache management

Cluster cache management is now supported by Amazon Aurora with PostgreSQL compatibility. This feature provides a faster way to recover incases of failovers. With Cluster cache management, a specific reader DB instance in the cluster is designated as the failover target. Data in the designated failover target cache is synchronized with the read-write instance cache. Incases of failover, the designated failover target is promoted as the read-write instance.

Data import from Amazon S3

Amazon Aurora with PostgreSQL allows you to import data from an Amazon S3 bucket into Aurora Postgres instance. A new extension aws_s3 has been added to support the import of data. Any data format that is supported by PostgreSQL COPY command is supported for import.

Copy tags from cluster to database snapshot

Tags on an Amazon Aurora with PostgreSQL compatibility database cluster can automatically be copied to any cluster-created database snapshots. This allow easily setting metadata on the snapshots to match the parent cluster and access policies.

Restore an Encrypted Amazon Aurora PostgreSQL Database from an Unencrypted Snapshot

An encrypted Amazon Aurora with PostgreSQL compatibility cluster can now be restored from an unencrypted snapshot. To encrypt the new database, create a new key or choose any existing Amazon Key Management Service (KMS) key.

Cloning Across AWS Accounts

Amazon Aurora DB cluster can now be shared with other AWS accounts. This provides a quick and efficient way of cloning the database. Database cloning does not require additional space and is faster than restoring a snapshot.

Clearly, RDS for Amazon Aurora saw a lot of upgrades this year! Feel free to contact us if you want to get started with these services.

 Like

Amazon RDS (Relational Database Service) is one of the many web services offered with AWS. Amazon RDS makes the job of database administrators easier – aiding to setup, operate, and scale the database and deployments. RDS is a great platform for DBAs who are looking to spend less time on traditional tasks like platform work, security policy provisions, performance monitoring and database handling. This frees up time to focus on developing an application.

RDS supports DB engines such as MySQL, MariaDB, PostgreSQL, SQL Server and Oracle. If you now have an Oracle database and are planning to move to cloud, RDS will help you deploy within minutes. You won’t lose any of your capabilities or features and will gain flexible capacity at a low cost. You can also migrate any applications or tools that use Oracle databases. RDS is improving constantly, with the primary goal of making its platform easier for DBAs.

Without further adieu, here are the new features added to RDS for Oracle in 2019.

Supports a new version of SQLTXPLAIN (SQLT)

SQLT is an Oracle tool that helps identify and troubleshoot performance of SQL Statements. Oracle SQLT delivers a report that includes statistics, execution plan, optimizer performance and other details that can help tune SQL queries. RDS for Oracle now supports 12.2.180725 version of SQLTXPLAIN.

Supports db.z1d and db.t3 DB instance classes

Z1d are the latest generation of instance classes optimized for memory intensive applications. They offer both high compute capacity and high memory footprint.

T3 instances are the next generation low cost burstable general-purpose instance type that provide a baseline level of CPU performance with the ability to burst CPU usage at any time for as long as required. T3 instances are designed for applications with moderate CPU usage that experience temporary spikes in use.

Oracle RDS now supports for the Z1d and T3 instance families.

Supports Oracle APEX versions 19.1.v1 ,18.1.v1 and 18.2.v1

APEX (Application Express) is a low code browser-based development platform that helps developers to build applications that can be deployed anywhere. 11.1, 12.1 and 12.2 versions of Oracle in RDS now support 19.1, 18.1, and 18.2 versions of Oracle APEX.

Supports Amazon S3 integration

Oracle RDS now supports integration with S3 for data ingress and egress. This integration support easy, efficient and secure data transfer between Oracle RDS and S3. Before this integration support, data transfer from S3 to Oracle RDS required an additional DB instance and a networking link between the two instances.

Supports Read Replicas

Oracle RDS supports Read replicas with Active Data Guard. Oracle RDS makes it easy to create replicas within the same region. The Primary DB instance manages the configuration of Active Data Guard and has a secure communication between the replica instances.

Supports RMAN DBA tasks

Oracle RDS supports Oracle Recovery Manager (RMAN) DBA tasks. Using Amazon RDS package rdsadmin.rdsadmin_rman_util, database backups can be performed to disk. rdsadmin.rdsadmin_rman_util package supports full and incremental database file backups, tablespace backups, and archive log backups.

Support for 64 TiB of storage and 80k IOPS

Maximum Storage of Oracle has now been increased to 64 TiB. Oracle RDS also supports a provisioned IOPS performance of 80,000 IOPS. Any existing databases can be scaled up to 64 TiB without any downtime. With this increased limit, you can consolidate your database shards into a single database instance.

Amazon RDS Performance Insights Counters

Performance Insights is an advanced performance monitoring tool for database workloads. Additional Counter Metrics are now supported for AWS Oracle RDS. Counter Metrics allows customizing the Performance Insights dashboard with 10 additional graphs.

Amazon RDS Performance Insights Supports Viewing More SQL Text

Performance Insights for Oracle RDS now supports 1024 bytes of SQL text to be shown for each row in Top Load Items. The earlier limit was 500 Bytes.

 Like