Issues

Select view

Select search mode

 
50 of

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

Unresolved

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
  • 09 Oct 2023, 04:32 PM
  • 09 Oct 2023, 04:31 PM
  • 23 Sep 2022, 10:08 AM
  • 23 Sep 2022, 10:08 AM

Smart Checklist

Details

Assignee

Reporter

Priority

Smart Checklist

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

Activity

Show:

Yusaf AwanFebruary 28, 2023 at 2:30 PM

as discussed, putting it back in progress.

Andrei MinkinDecember 7, 2022 at 12:06 PM

It works right now. I added configuration options that were suggested by Kamil in https://perconadev.atlassian.net/browse/PXC-4047#icft=PXC-4047. I'll apply additional settings once there will be available for HAproxy.

Denys KondratenkoNovember 22, 2022 at 8:43 AM

blocked by PXC

Andrei MinkinSeptember 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

Flag notifications