Percona Server 8.0 features you always wanted but were afraid to ask for
summary
Percona adds SEQUENCE_TABLE() (Percona Server 8.0.20-11) as a table function that generates integer ranges, bounded by session expressions, supports shifting, filtering, ordering, random values, dictionary-based string selection and even a prime-number generator; examples include SELECT FROM sequence_table, CREATE TABLE AS SELECT and INSERT SELECT materialization. Percona also ships a Data Masking plugin (introduced in 8.0.17) with UDFs like MASK_SSN and MASK_PAN, GEN_DICT for in-memory dictionaries, random-data generators, and a view-plus-grants pattern to expose masked rows; plugin performance matches custom UDFs.
AI-written summary · about
chapters (7)
- 0:00Percona Server 8.0 intro
- 1:08Sequence generation in SQL
- 8:22Sequence table feature
- 16:01Data masking in Percona
- 17:24Installing data masking plugin
- 26:47Data masking performance
- 29:10Summary
