Month: July 2018

Tuning InnoDB Primary Keys

The choice of good InnoDB primary keys is a critical performance tuning decision. This post will guide you through the steps of choosing the best primary key depending on your workload. As a principal architect at Percona, one of my main duties is to tune customer databases. There are many aspects related to performance tuning […]

The post Tuning InnoDB Primary Keys appeared first on Percona Database Performance Blog.

Oracle Certification Program & The New Oracle LaunchPad

Oracle LaunchPad is a new learning tool from Oracle University that is totally free and fun.  Designed to support you with FREE Introductory SaaS Training.

As you learn you Earn a Rank by collecting points.  Start by selecting your role; then choose your area of interest and the format you would like to learn by.

Check it out for yourself – Oracle LaunchPad

We’re excited about the section titled Build Your Oracle Cloud Career:  Get Certified.  

In the Search Menu enter Get Certified where you’ll find two 10 minute modules:

  1. Overview of Oracle Certifications
  2. Get Certified

Both are really useful no matter what Oracle Certification is being pursued and are a good resource that anyone may find handy.  

See this blog announcement to learn more about Oracle LaunchPad:

Making our way into Dremio

In an analytics system, we typically have an Operational Data Store (ODS) or staging layer; a performance layer or some data marts; and on top, there would be an exploration or reporting tool such as Tableau or Oracle’s OBIEE. This architecture can lead to latency in decision making, creating a

Making our way into Dremio

In an analytics system, we typically have an Operational Data Store (ODS) or staging layer; a performance layer or some data marts; and on top, there would be an exploration or reporting tool such as Tableau or Oracle’s OBIEE. This architecture can lead to latency in decision making, creating a

Webinar Thursday, July 27, 2018: MongoDB Sharding 101 – Geo-Partitioning

MongoDB Sharding

Please join Percona’s Senior Support Engineer, Adamo Tonete as he presents MongoDB Sharding 101 – Geo-Partitioning on Thursday, July 26th, 2018 at 12:30 PM PDT (UTC-7) 3:30 EDT (UTC-4). Register Now In this webinar, we will discuss the common shard keys and demonstrate how to build a worldwide distributed sharded cluster using tags.Tags can be […]

The post Webinar Thursday, July 27, 2018: MongoDB Sharding 101 – Geo-Partitioning appeared first on Percona Database Performance Blog.

Webinar Weds 7/25: XA Transactions

xa transactions distributed transactions

Please join Percona Senior MySQL DBA for Managed Services, Dov Endress, as he presents XA Transactions on Wednesday, July 25th, 2018 at 12:00 PM PDT (UTC-7) / 3:00 PM EDT (UTC-4). Register Now Distributed transactions (XA) are becoming more and more vital as applications evolve. In this webinar, we will learn what distributed transactions are […]

The post Webinar Weds 7/25: XA Transactions appeared first on Percona Database Performance Blog.

InnoDB Cluster in a Nutshell Part 3: MySQL Shell

MySQL InnoDB Cluster MySQL Shell

Welcome to the third part of this series. I’m glad you’re still reading, as hopefully this means you find this subject interesting at least. Previously we presented the first two components of MySQL InnoDB Cluster: Group Replication and MySQL Router and now we will discuss the last component, MySQL Shell. MySQL Shell This is the last […]

The post InnoDB Cluster in a Nutshell Part 3: MySQL Shell appeared first on Percona Database Performance Blog.

New Pluralsight course: SQL Server 2017: Diagnosing Configuration Issues with DMVs

Glenn’s latest Pluralsight course has been published: SQL Server 2017: Diagnosing Configuration Issues with DMVs. It’s just under 2 hours long, and from the course description: It is very common for SQL Server instances to be configured incorrectly in one or more ways, and this often has a detrimental effect on workload performance and stability. In this course, […]

The post New Pluralsight course: SQL Server 2017: Diagnosing Configuration Issues with DMVs appeared first on Paul S. Randal.

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569