Skip to main content

Portlet (enh)

Analytics

Aurora vs MySQL vs Elastic

Benchmark

Kubernetes (06/30/21)

Monitoring & Analytics

SFDC Summer '21

Monitoring & Analytics

Germain Management

Maintenance

Performance Optimization

Maintenance

Relational db-to-Elastic data migration script

Maintenance

Other Enhancement & Bugs (06/30/21)

Maintenance

Analytics - Portlet (enh)

Description

As always, we take our customers’ feedback very importantly. Here are a number of portlet usability enhancements to make it even easier to use:
  • Zoom into the data (before zoom only increased/decreased the X axis. now it maximizes both X and Y axis)
  • Date/time added on tooltip
  • Portlet maximization - now occurs when clicking on a “blank” area of any portlet (instead of having to click on the maximize icon on the top right end corner…icon which has been removed)
    Minimized portlet:
    Maximized portlet:
  • Tooltip behavior enhanced (so it does not feel like it gets in the way)

Benchmark - Aurora vs MySQL vs Elastic

Description

We performed some testing to understand scalability differences between AWS RDS for Aurora, MySQL 5.7 and Elastic 7.13.
  • RDS Aurora - overall not impressed, no control over I/O throughput, auto-scaling applies only to server hardware
  • Single-query performance of Aurora worse than MySql.
  • Single-query performance of MySql and Elastic similar
  • Elastic scalability better over MySql, nothing we didn’t know 🙂
Data volume during this benchmark: 3 TB data volume @ 300-400Million Germain unit inserted per day

Monitoring & Analytics - Kubernetes (06/30/21)

Description

Enhanced our monitoring of Kubernetes clusters.
  • New control flags
  • New display hints
  • New component type and server profile

Benefits

A reminder of other benefits you get using Germain for Kubernetes: Monitoring & Analytics - Kubernetes

Monitoring & Analytics - SFDC Summer ‘21

Description

Maintenance of Germain components for Salesforce.com Summer 21 release.

Benefits

A reminder of all the benefits you can get using Germain to monitor uptime, performance and ux of salesforce.com : Monitoring & Analytics - Salesforce.com (12/31/20) 02/28/21 release notes Monitoring & Analytics - SalesForce.com (03/31/21) Monitoring & Analytics - SalesForce.com (04/30/21)

Maintenance - Germain Management

Description Our State dashboard that allows Germain administrator maintain the Germain features has been gaining some traction and as a result here are a few more enhancements we built this month:
  • Component restart loading indicator
  • PID added for services and engines
  • Last error shown on hover where available
  • Workspace and Service release number added
  • CPU and Heap usage shown for all services and engines
  • Number of facts processed for Germain Services
  • JVM and application.properties shown for services

Maintenance - Performance Optimization

Description

Performed a round of optimization to make Germain faster, more scalable as these customers are growing their use of Germain to some significant levels. And things to note:
  • Faster when using sub-partitions
  • Query performance scales linearly with faster storage and available I/O speed. We confirmed that by using provisioned storage (500 MBs/sec baseline throughput) and non-provisioned (250 MBs/sec baseline throughput)
  • Reduced network traffic by 3x. If you use our UX Monitoring & Replay feature and have very active users using your business applications, you will want to upgrade your Germain in order to have this optimization.
  • Improved by 2x Storage Service performance

Maintenance - Relational db-to-Elastic data migration script

Description

GE’s Germain has been growing over the years and its MySql database needed to be replaced by Elastic to provide better scalability. Germain database for GE is currently ~3TB (3,158 GB). The Germain’s database switch was first performed and took place in a few hours, then Germain’s data migration was performed and lasted 1 weeks. The data migration script we created for this project can be used to migrate data of any other environment, if you also want to switch database technology.

Maintenance - Other Enhancement & Bugs (06/30/21)

Other Enhancements and Bugs we have resolved this month. More details available upon request: support@germainux.com

Get Help

Contact GermainUX Support

The Germain Team can help you set this up.

Can't find what you need?

Search all GermainUX docs with Ctrl + K, or use the feedback buttons at the bottom of this page to tell us what is missing.

The content of this document is proprietary to GERMAIN SOFTWARE LLC.