Back-up Plan for Large Database

Dear all,

Back-up is the most important thing that need special attention. We have
a production Mysql Server of near about 200 GB data and expect to grow @
50 GB per month.

Our application continuously writes data in Mysql tables.

I followed some Links but want some more thoughts to choose best option.

http://www.zmanda.com/mysql-backup-considerations.html

I also read about RAID and some other features too.

But I want to know what is the best back up plan for 24/7 running Large
Production Mysql Cluster.





Thanks & Regards

Adarsh Sharma

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Back-up Plan for Large Database

--001636c5b6bbbf9b3f0498644350
Content-Type: text/plain; charset=ISO-8859-1

Hello there,

ZMANDA is a good tool to extract backups from MySQL databases. But, when
subject is fault tolerant and keep databases on air 24x7, you need to think
about replication to have a SLAVE server as a online copy of your
environment, other SLAVE servers to permit you switch among servers in case
of MASTER fails and things like that.

In advance to have ZMANDA as you backup tool, do you have server replicating
data on you environment?

Best regards.
--
Wagner Bianchi

2010/12/27 Adarsh Sharma

> Dear all,
>
> Back-up is the most important thing that need special attention. We have a
> production Mysql Server of near about 200 GB data and expect to grow @ 50 GB
> per month.
>
> Our application continuously writes data in Mysql tables.
>
> I followed some Links but want some more thoughts to choose best option.
>
> http://www.zmanda.com/mysql-backup-considerations.html
>
> I also read about RAID and some other features too.
>
> But I want to know what is the best back up plan for 24/7 running Large
> Production Mysql Cluster.
>
>
>
>
>
> Thanks & Regards
>
> Adarsh Sharma
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=wagnerbianchijr@gmail.com
>
>

--001636c5b6bbbf9b3f0498644350--

Re: Back-up Plan for Large Database

--0016364eda54242af70498659a69
Content-Type: text/plain; charset=ISO-8859-1

Might want to check out LVM snapshots:

http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for -mysql-backup-and-replication-setup/

Using
a slave to pull backups from is something I would not do. You have no
guarantee the data on the slave matches the master 100%.



On Mon, Dec 27, 2010 at 5:19 AM, Adarsh Sharma wrote:

> Dear all,
>
> Back-up is the most important thing that need special attention. We have a
> production Mysql Server of near about 200 GB data and expect to grow @ 50 GB
> per month.
>
> Our application continuously writes data in Mysql tables.
>
> I followed some Links but want some more thoughts to choose best option.
>
> http://www.zmanda.com/mysql-backup-considerations.html
>
> I also read about RAID and some other features too.
>
> But I want to know what is the best back up plan for 24/7 running Large
> Production Mysql Cluster.
>
>
>
>
>
> Thanks & Regards
>
> Adarsh Sharma
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=johnny@pixelated.net
>
>


--
-----------------------------
Johnny Withers
601.209.4985
johnny@pixelated.net

--0016364eda54242af70498659a69--

Re: Back-up Plan for Large Database

--000325555ad66178820498677847
Content-Type: text/plain; charset=ISO-8859-1

*You have no guarantee the data on the slave matches the master 100%.*
*
*
Try it with *semi-synchronous* replication.

Best regards.
--
Wagner Bianchi


2010/12/27 Johnny Withers

> Might want to check out LVM snapshots:
>
>
> http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for -mysql-backup-and-replication-setup/
>
> <
> http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for -mysql-backup-and-replication-setup/
> >Using
> a slave to pull backups from is something I would not do. You have no
> guarantee the data on the slave matches the master 100%.
>
>
>
> On Mon, Dec 27, 2010 at 5:19 AM, Adarsh Sharma > >wrote:
>
> > Dear all,
> >
> > Back-up is the most important thing that need special attention. We have
> a
> > production Mysql Server of near about 200 GB data and expect to grow @ 50
> GB
> > per month.
> >
> > Our application continuously writes data in Mysql tables.
> >
> > I followed some Links but want some more thoughts to choose best option.
> >
> > http://www.zmanda.com/mysql-backup-considerations.html
> >
> > I also read about RAID and some other features too.
> >
> > But I want to know what is the best back up plan for 24/7 running Large
> > Production Mysql Cluster.
> >
> >
> >
> >
> >
> > Thanks & Regards
> >
> > Adarsh Sharma
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=johnny@pixelated.net
> >
> >
>
>
> --
> -----------------------------
> Johnny Withers
> 601.209.4985
> johnny@pixelated.net
>

--000325555ad66178820498677847--

Re: Back-up Plan for Large Database

--00163630f9078e8eb204986a12f4
Content-Type: text/plain; charset=ISO-8859-1

You could do that, if you have 5.5+

Still no guarantee that the slave matches the master 100%, even says so in
the manual. In my opinion, you shouldn't pull backups from the slave. YMMV.


On Mon, Dec 27, 2010 at 11:14 AM, Wagner Bianchi
wrote:

> *You have no guarantee the data on the slave matches the master 100%.*
> *
> *
> Try it with *semi-synchronous* replication.
>
> Best regards.
> --
> Wagner Bianchi
>
>
> 2010/12/27 Johnny Withers
>
> Might want to check out LVM snapshots:
>>
>>
>> http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for -mysql-backup-and-replication-setup/
>>
>> <
>> http://www.mysqlperformanceblog.com/2006/08/21/using-lvm-for -mysql-backup-and-replication-setup/
>> >Using
>> a slave to pull backups from is something I would not do. You have no
>> guarantee the data on the slave matches the master 100%.
>>
>>
>>
>> On Mon, Dec 27, 2010 at 5:19 AM, Adarsh Sharma >> >wrote:
>>
>> > Dear all,
>> >
>> > Back-up is the most important thing that need special attention. We have
>> a
>> > production Mysql Server of near about 200 GB data and expect to grow @
>> 50 GB
>> > per month.
>> >
>> > Our application continuously writes data in Mysql tables.
>> >
>> > I followed some Links but want some more thoughts to choose best option.
>> >
>> > http://www.zmanda.com/mysql-backup-considerations.html
>> >
>> > I also read about RAID and some other features too.
>> >
>> > But I want to know what is the best back up plan for 24/7 running Large
>> > Production Mysql Cluster.
>> >
>> >
>> >
>> >
>> >
>> > Thanks & Regards
>> >
>> > Adarsh Sharma
>> >
>> > --
>> > MySQL General Mailing List
>> > For list archives: http://lists.mysql.com/mysql
>> > To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=johnny@pixelated.net
>> >
>> >
>>
>>
>> --
>> -----------------------------
>> Johnny Withers
>> 601.209.4985
>> johnny@pixelated.net
>>
>
>


--
-----------------------------
Johnny Withers
601.209.4985
johnny@pixelated.net

--00163630f9078e8eb204986a12f4--

Re: Back-up Plan for Large Database

On 27/12/2010 19:14, Wagner Bianchi wrote:
> *You have no guarantee the data on the slave matches the master 100%.*
> *
> *
> Try it with *semi-synchronous* replication.
>
> Best regards.
> --
> Wagner Bianchi
>

Hiya

Thats why you nagios monitor replication of your slaves (I do master
master replication monitoring)

I use mylvmbackup. Works like a bomb.

HTH
Brent

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org