# Any Idea xtradb Cluster 8.0 for field symmetric encryption?

**URL:** https://forums.percona.com/t/any-idea-xtradb-cluster-8-0-for-field-symmetric-encryption/7930
**Category:** Percona XtraDB Cluster 8.x
**Created:** [August 19, 2020, 11:58am UTC](https://forums.percona.com/t/any-idea-xtradb-cluster-8-0-for-field-symmetric-encryption/7930 "2020-08-19T11:58:40Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![lokesh123](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lokesh123/32/5519_2.png) [@lokesh123](https://forums.percona.com/u/lokesh123)
#### Post date: [August 19, 2020, 11:58am UTC](https://forums.percona.com/t/any-idea-xtradb-cluster-8-0-for-field-symmetric-encryption/7930/1 "2020-08-19T11:58:40Z")

</div>

like MySQL public private encryption.

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [August 25, 2020, 1:55pm UTC](https://forums.percona.com/t/any-idea-xtradb-cluster-8-0-for-field-symmetric-encryption/7930/2 "2020-08-25T13:55:34Z")

</div>

I don’t understand this question. Can you please rephrase the question? What exactly are you asking?

---

<div class="post-metadata">

### Author: ![lokesh123](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lokesh123/32/5519_2.png) [@lokesh123](https://forums.percona.com/u/lokesh123)
#### Post date: [August 26, 2020, 2:06am UTC](https://forums.percona.com/t/any-idea-xtradb-cluster-8-0-for-field-symmetric-encryption/7930/3 "2020-08-26T02:06:08Z")

</div>

I want to encrypt my field&nbsp; in a table with private, public key&nbsp; combination with Asymmentic encryption?

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [August 26, 2020, 10:27am UTC](https://forums.percona.com/t/any-idea-xtradb-cluster-8-0-for-field-symmetric-encryption/7930/4 "2020-08-26T10:27:47Z")

</div>

[https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html](https://dev.mysql.com/doc/refman/8.0/en/encryption-functions.html)  
You can also use encryption functions native to your programming language. For example,&nbsp;[https://www.php.net/manual/en/ref.gnupg.php](https://www.php.net/manual/en/ref.gnupg.php)  
Use BLOB columns within MySQL to store the encrypted data. Do the encrypting/decrypting within your code.

---

<div class="post-metadata">

### Author: ![lokesh123](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lokesh123/32/5519_2.png) [@lokesh123](https://forums.percona.com/u/lokesh123)
#### Post date: [August 26, 2020, 12:38pm UTC](https://forums.percona.com/t/any-idea-xtradb-cluster-8-0-for-field-symmetric-encryption/7930/5 "2020-08-26T12:38:50Z")

</div>

No, I was asking for Asymmetric Function like&nbsp;  
[MySQL :: MySQL 8.0 Reference Manual :: 6.6.3 MySQL Enterprise Encryption Usage and Examples](https://dev.mysql.com/doc/refman/8.0/en/enterprise-encryption-usage.html)

---

<div class="post-metadata">

### Author: ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)
#### Post date: [August 26, 2020, 1:15pm UTC](https://forums.percona.com/t/any-idea-xtradb-cluster-8-0-for-field-symmetric-encryption/7930/6 "2020-08-26T13:15:21Z")

</div>

Unfortunately those functions are closed-source and are only available with a MySQL Enterprise contract from Oracle.  
As I said above, your other option is to use your app’s programming language to do this and simply store the blob data in MySQL. You can also check out this plugin&nbsp;[https://dev.mysql.com/doc/refman/5.7/en/keyring-udfs-general-purpose.html](https://dev.mysql.com/doc/refman/5.7/en/keyring-udfs-general-purpose.html "Link: https://dev.mysql.com/doc/refman/5.7/en/keyring-udfs-general-purpose.html"), which is available on PXC8, to store some secrets information.