Re: Data masking for mysql

2014-04-15 Thread Reindl Harald
Am 15.04.2014 08:52, schrieb reena.kam...@jktech.com: > 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. > if yes... please provide the links. > else... please suggest other alternatives for this requirement

Re: Data masking for mysql

2014-04-15 Thread Manuel Arostegui
2014-04-15 8:52 GMT+02:00 : > Hi, > > 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. > if yes... please provide the links. > else... please suggest other alternatives for this requirement. > > I look forward

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
The main reason for applying masking to a data field is to protect data from external exposure. for example mobile no. is 9878415877, digits can by shuffle(8987148577) or can replace with other letter/number(first 6 digits replace with X-- xx5877) by using data masking. We can use any one da

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
Yes, we can do it at application level and database level as well. for example mobile no. is 9878415877, digits can by shuffle(8987148577) or can replace with other letter/number(first 6 digits replace with X-- xx5877) by using data masking. We can use any one data masking technique at DB le

Re: Data masking for mysql

2014-04-15 Thread Reindl Harald
Am 15.04.2014 11:08, schrieb reena.kam...@jktech.com: > Yes, we can do it at application level and database level as well. > for example mobile no. is 9878415877, digits can by shuffle(8987148577) or > can replace with other letter/number(first 6 digits replace with X-- > xx5877) by using d

Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
Hi all, we're going to patch our MySQL servers. Most of them are RHEL/OEL 5.x and are going to be upgraded to 5.x+n (for example 5.5 to 5.10). I don't seem to find anything about this in the official documentation (verifying the patch compatibility, relinking etc.). Any hints? Best regards

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Reindl Harald
Am 15.04.2014 11:22, schrieb Radoulov, Dimitre: > we're going to patch our MySQL servers. Most of them are RHEL/OEL 5.x and are > going to be upgraded to 5.x+n (for > example 5.5 to 5.10). > I don't seem to find anything about this in the official documentation > (verifying the patch compatibil

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
Hi Reindl, On 15/04/2014 11:32, Reindl Harald wrote: Am 15.04.2014 11:22, schrieb Radoulov, Dimitre: we're going to patch our MySQL servers. Most of them are RHEL/OEL 5.x and are going to be upgraded to 5.x+n (for example 5.5 to 5.10). I don't seem to find anything about this in the official

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
Hi, On 15-4-2014 11:03, reena.kam...@jktech.com wrote: The main reason for applying masking to a data field is to protect data from external exposure. for example mobile no. is 9878415877, digits can by shuffle(8987148577) or can replace with other letter/number(first 6 digits replace with X-- x

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Manuel Arostegui
2014-04-15 12:05 GMT+02:00 Radoulov, Dimitre : > Hi Reindl, > > > On 15/04/2014 11:32, Reindl Harald wrote: > >> Am 15.04.2014 11:22, schrieb Radoulov, Dimitre: >> >>> we're going to patch our MySQL servers. Most of them are RHEL/OEL 5.x >>> and are going to be upgraded to 5.x+n (for >>> example

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Reindl Harald
Am 15.04.2014 12:05, schrieb Radoulov, Dimitre: > On 15/04/2014 11:32, Reindl Harald wrote: >> Am 15.04.2014 11:22, schrieb Radoulov, Dimitre: >>> we're going to patch our MySQL servers. Most of them are RHEL/OEL 5.x and >>> are going to be upgraded to 5.x+n (for >>> example 5.5 to 5.10). >>> I

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 12:13, Manuel Arostegui wrote: [...] Thank you! So I suppose we need to, or actually we *must*, upgrade the binaries only in case of a release upgrade (RHEL 5 to 6, for example), i.e. when a different binary distribution exsists: MySQL-5.6.17-1.rhel5.x86_64.rpm to MySQL-5.

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
It can be done by data masking tool itself. Its one time activity, I do not need it again & again. Please suggest data masking tool link. -Original Message- From: "Reindl Harald" Sent: Tuesday, 15 April, 2014 2:49pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Am 15.0

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
Actually data masking is a one time activity, so I need data masking tool. I do not need it again & again. -Original Message- From: "Jigal van Hemert" Sent: Tuesday, 15 April, 2014 3:43pm To: mysql@lists.mysql.com Subject: Re: Data masking for mysql Hi, On 15-4-2014 11:03, reena.kam...

Re: Data masking for mysql

2014-04-15 Thread Reindl Harald
Am 15.04.2014 12:37, schrieb reena.kam...@jktech.com: > It can be done by data masking tool itself. Its one time activity, I do not > need it again & again. Please suggest data masking tool link. jesus christ there is not click here and be happy tool just write a small script to do this - that'

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 12:18, Reindl Harald wrote: Am 15.04.2014 12:05, schrieb Radoulov, Dimitre: [...] o ABI breakages, that's why you use RHEL or a clone at all Thank you! So I suppose we need to, or actually we *must*, upgrade the binaries only in case of a release upgrade (RHEL 5 to 6, for example)

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
Hi, On 15-4-2014 12:36, reena.kam...@jktech.com wrote: Actually data masking is a one time activity, so I need data masking tool. I do not need it again & again. So you basically want to replace the data with modified data. You can do that with an update query [1]. There are all kinds of func

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Johan De Meersman
- Original Message - > From: "Dimitre Radoulov" > Sent: Tuesday, 15 April, 2014 12:17:54 PM > > for major release upgrades - 5.x to 6.x - we'll use a different hosts. I would like to point out that where MySQL is concerned, the minor versions are a major upgrade - 5.0->5.1, 5.1->5.5 a

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 13:53, Martin Gainty wrote: [...] > It seems that I gave a wrong impression, but we actually have a big team > of sys admins :) MG>he is asking that you hire an experienced DBA MG>(vs packing up your office with Einwanderer) Wow! Thank you! Putting back the list in CC for the be

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 13:53, Johan De Meersman wrote: - Original Message - From: "Dimitre Radoulov" Sent: Tuesday, 15 April, 2014 12:17:54 PM for major release upgrades - 5.x to 6.x - we'll use a different hosts. I would like to point out that where MySQL is concerned, the minor versions are

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Reindl Harald
Am 15.04.2014 13:53, schrieb Johan De Meersman: > - Original Message - >> From: "Dimitre Radoulov" >> Sent: Tuesday, 15 April, 2014 12:17:54 PM >> >> for major release upgrades - 5.x to 6.x - we'll use a different hosts. > > I would like to point out that where MySQL is concerned, the m

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 14:03, Reindl Harald wrote: [...] el5 = RHEL5 el6 = RHEL6 may i suggest to hire someone managing your systems [...] It seems that I gave a wrong impression, but we actually have a big team of sys admins :) so what are they doing then all day long since you still run 5.5 release

Re: Data masking for mysql

2014-04-15 Thread Peter Brawley
On 2014-04-15 5:37 AM, reena.kam...@jktech.com wrote: It can be done by data masking tool itself. Its one time activity, I do not need it again & again. Rilly? If that's so, the data will never be accessed. 'PB Please suggest data masking tool link. -Original Message- From: "Reindl

Re: Data masking for mysql

2014-04-15 Thread reena . kamboj
data masking tool is like a layer between destination DB(production DB) and target DB(test DB). It does all the changes in target DB, so data never change in destination DB. -Original Message- From: "Peter Brawley" Sent: Tuesday, 15 April, 2014 10:12pm To: reena.kam...@jktech.com, "mysq

Re: Data masking for mysql

2014-04-15 Thread Jigal van Hemert
Hi, On 15-4-2014 18:42, Peter Brawley wrote: On 2014-04-15 5:37 AM, reena.kam...@jktech.com wrote: It can be done by data masking tool itself. Its one time activity, I do not need it again & again. Rilly? If that's so, the data will never be accessed. I'm starting to think that a concept ha