I need to do data masking to sensitive data exists in mysql db. is there any data masking tool available for mysql with linux platform.
I don't think there's a generic tool for it. It depends on your data, format etc. ie: it's not the same a credit card record than an email or a phone number one.
It depends on your data, so you might want to do it from an application level.
Yes, you can use DataSunrise Data Masking. Supports MySQL database as well as other databases. Can run on Linux or Windows. DataSunrise Static data masking - to create a functional copy of production data in test while masking sensitive data. DataSunrise Dynamic Data Masking - obfuscate data in runtime based on security policies. Can be combined with Database firewall and database audit and activity monitoring datasunrise.com
Assume there is one database in a system having multiple processes that are accessing this database. If one process updates database table other processes should be notified. If someone has MySql C APIs document please send me. Thanks in advance.
How can I insert data into one table from two other tables where i have three tables namely users, role and userrole. Now I want to insert the data into userrole table from users table and role table with a single statement.