Best practices for storing sensitive numeric data in MySQL

[Rasheed Mosan]

Hi everyone,

I’m designing a MySQL database to store user information that includes sensitive numeric data. I have a few questions about best practices:

What’s the recommended way to store partially sensitive numbers (like card or account identifiers) securely?

Should I use encryption at the column level, or rely on application-level encryption?

Are there any performance considerations when frequently querying encrypted numeric fields?

Also, if anyone knows any reliable tutorials, tools, or resources for securely handling and querying sensitive numeric data in MySQL, I’d love to check them out.

I’d really appreciate any guidance, examples, or resources for designing a secure and efficient schema.

Thanks in advance!