Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

[DBaaS] Can't load imdb dataset to pxc cluster running under dbaas on EKS

Description

Steps to reproduce

  1. Spin-up k8s cluster on EKS using https://github.com/shoffman-percona/easyK8s

  2. Create Small pxc cluster

  3. https://www.imdb.com/interfaces/  and here are the steps I used to turn it into load files (this is 1 of 3)

It's impossible to load the dataset and there's no any useful information in the dashboards

Attachments

4

Smart Checklist

Activity

Show:

Yusaf Awan February 28, 2023 at 2:30 PM

as discussed, putting it back in progress.

Andrei Minkin December 7, 2022 at 12:06 PM

It works right now. I added configuration options that were suggested by Kamil in . I'll apply additional settings once there will be available for HAproxy.

Kai Wagner December 6, 2022 at 9:26 AM

Denys Kondratenko November 22, 2022 at 8:43 AM

blocked by PXC

Andrei Minkin September 27, 2022 at 1:34 PM

I reproduced this issue.

STR

  1. Spin-up EKS cluster with 3 nodes of m4.xlarge type (you can use easyk8s script for that)

  2. Register it  k8s cluster  to the pmm/dbaas

  3. Spin-up a pxc database cluster with the following resources 

  4. 3 nodes 

  5. 1 vCPU

  6. 8GB of RAM

  7. 25Gb of storage

  8. Enable external access 

  1. Download imdb.tar.gz (ask Steve Hoffman for the access) and extract the contents 

  2. Edit file paths in imdb-load-data.sql file

  3. Connect to the pxc cluster and run the following commands

  4. SET GLOBAL pxc_strict_mode = ‘PERMISSIVE’;

  5. SOURCE ./imdb-create-tables.sql

  6. SOURCE ./imdb-load-data.sql

Unresolved

Details

Assignee

Reporter

Labels

Priority

Smart Checklist

Created September 21, 2022 at 10:10 AM
Updated February 13, 2025 at 10:26 AM