Re: TSM/TDP and MySQL
Hi Zoltan I had a meeting a couple of months back withe the local TSM sales guy and the whole sales stack back to the US, and raised the issue of other DBMS. they pointed me at Zmanda for Mysql and BMC SQLBacktrack for Sybase. I wasn't impressed either. Regards Steve Steven Harris TSM Admin, Paraparaumu, New Zealand. Remco Post wrote: On 18 mei 2010, at 16:23, Zoltan Forray/AC/VCU wrote: Thanks for the reference. I should have mentioned I already looked at this. My bosses requirements are: ANY product must be supported by IBM/Tivoli for usage on a TSM server. Point-in-time recovery is mandatory, or there is no point to using any product. From what I have read (correct me if I am wrong) about using mysqldump, it doesn't do/support this process. it does. You can keep as many backups as you want, and make them as frequently as you want. MySQL supports roll-forward of database journals IIRC, so if you set the DB to roll-forward logging, archive the logs to TSM and make frequent MySQL dumps, you can recover to any point in time. Of course, if your data is that valuable that you need to be able to recover to any specific point in time, investing in a commercial DB like db2 or Oracle makes sense. API applications are all supported for usage on a TSM server. It's just that the code using the API is not supported, so that part is up to you. That is the way open source works Zmanda most likely uses the TSM API as well, it's just a commercial implementation... So you pay for support rather than do it yourself. No virus found in this incoming message. Checked by AVG - www.avg.com Version: 9.0.819 / Virus Database: 271.1.1/2882 - Release Date: 05/19/10 06:26:00
Re: TSM/TDP and MySQL
Hi Zoltan, Take a look at the Backing Up Databases Using ADSMPIPE and the TSM API: Examples Using Linux Redbook - http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/redp3980.html?Open It has a section on backing up MySQL. Regards, Mark Yakushev From: Zoltan Forray/AC/VCU zfor...@vcu.edu To: ADSM-L@vm.marist.edu Date: 05/18/2010 06:37 AM Subject:[ADSM-L] TSM/TDP and MySQL This is a 2-part question: #1 - Has anybody heard of any rumors (or a we are planning to) that IBM/Tivoli will have a TDP for MySQL? #2 - How do you backup MySQL? We are increasingly expanding MySQL use and since IBM currently doesn't offer a TDP for MySQL, we are looking at other commercial products like Zmanda Recovery Manager ( http://www.zmanda.com/tivoli-mysql-backup.html) Zoltan Forray TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html
Re: TSM/TDP and MySQL
Thanks for the reference. I should have mentioned I already looked at this. My bosses requirements are: ANY product must be supported by IBM/Tivoli for usage on a TSM server. Point-in-time recovery is mandatory, or there is no point to using any product. From what I have read (correct me if I am wrong) about using mysqldump, it doesn't do/support this process. Zoltan Forray TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html From: Mark Yakushev bar...@us.ibm.com To: ADSM-L@VM.MARIST.EDU Date: 05/18/2010 09:52 AM Subject: Re: [ADSM-L] TSM/TDP and MySQL Sent by: ADSM: Dist Stor Manager ADSM-L@VM.MARIST.EDU Hi Zoltan, Take a look at the Backing Up Databases Using ADSMPIPE and the TSM API: Examples Using Linux Redbook - http://www.redbooks.ibm.com/Redbooks.nsf/RedbookAbstracts/redp3980.html?Open It has a section on backing up MySQL. Regards, Mark Yakushev From: Zoltan Forray/AC/VCU zfor...@vcu.edu To: ADSM-L@vm.marist.edu Date: 05/18/2010 06:37 AM Subject:[ADSM-L] TSM/TDP and MySQL This is a 2-part question: #1 - Has anybody heard of any rumors (or a we are planning to) that IBM/Tivoli will have a TDP for MySQL? #2 - How do you backup MySQL? We are increasingly expanding MySQL use and since IBM currently doesn't offer a TDP for MySQL, we are looking at other commercial products like Zmanda Recovery Manager ( http://www.zmanda.com/tivoli-mysql-backup.html) Zoltan Forray TSM Software Hardware Administrator Virginia Commonwealth University UCC/Office of Technology Services zfor...@vcu.edu - 804-828-4807 Don't be a phishing victim - VCU and other reputable organizations will never use email to request that you reply with your password, social security number or confidential personal information. For more details visit http://infosecurity.vcu.edu/phishing.html
Re: TSM/TDP and MySQL
On 18 mei 2010, at 16:23, Zoltan Forray/AC/VCU wrote: Thanks for the reference. I should have mentioned I already looked at this. My bosses requirements are: ANY product must be supported by IBM/Tivoli for usage on a TSM server. Point-in-time recovery is mandatory, or there is no point to using any product. From what I have read (correct me if I am wrong) about using mysqldump, it doesn't do/support this process. it does. You can keep as many backups as you want, and make them as frequently as you want. MySQL supports roll-forward of database journals IIRC, so if you set the DB to roll-forward logging, archive the logs to TSM and make frequent MySQL dumps, you can recover to any point in time. Of course, if your data is that valuable that you need to be able to recover to any specific point in time, investing in a commercial DB like db2 or Oracle makes sense. API applications are all supported for usage on a TSM server. It's just that the code using the API is not supported, so that part is up to you. That is the way open source works Zmanda most likely uses the TSM API as well, it's just a commercial implementation... So you pay for support rather than do it yourself. -- Met vriendelijke groeten/Kind Regards, Remco Post r.p...@plcs.nl +31 6 248 21 622