Re: Back-up Plan for Large Database

[Johnny Withers]

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=joh...@pixelated.net
>> >
>> >
>>
>>
>> --
>> -
>> Johnny Withers
>> 601.209.4985
>> joh...@pixelated.net
>>
>
>


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

Re: Back-up Plan for Large Database

[Wagner Bianchi]

*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=joh...@pixelated.net
> >
> >
>
>
> --
> -
> Johnny Withers
> 601.209.4985
> joh...@pixelated.net
>

[NEWS]

[Sergey Lazurenko]

November 29, 2010





Extended Model Design and Runtime Capabilities in LINQ to SQL Compatible ORM 
Solution from Devart



New version of LINQ to SQL compatible ORM solution with extended 
functionality and advanced Model-First support and Update model from 
database functionality.






 Devart is glad to announce the release of LinqConnect 2.00, the new 
version of LINQ to SQL compatible ORM solution with extended functionality 
and enhanced own visual model designer - Entity Developer.


 LinqConnect supports SQL Server, Oracle, MySQL, PostgreSQL, and SQLite. It 
is developed closely to the Microsoft LINQ to SQL technology, while 
extending its functionality, thus allowing LINQ to SQL developer to easily 
get started with LinqConnect. In addition to LINQ to SQL features, 
LinqConnect provides its own advanced functionality.


 LinqConnect continues to improve, and now in version 2.00 it has many new 
features:


 a.. Batch Updates
 Now LinqConnect can execute DML statements in batches on SubmitChanges 
call, which improves performance of update operations.


 b.. Table Per Type inheritance
 New kind of inheritance hierarchy - Table per Type is supported now in 
addition to Table Per Hierarchy support.


 c.. ASP.NET Dynamic Data
 New templates for ASP.NET Dynamic Data projects are now included into 
LinqConnect package. This allows you to create ASP.NET Dynamic Data 
applications, using LinqConnect.


 d.. PLINQ
 LinqConnect 2.00 supports Parallel LINQ, which offers performance 
improvements for your applications, using LinqConnect.


 e.. Visual Studio Debugger Visualizer for DataQuery objects
 Now you can view SQL code, generated for your LINQ queries, while 
debugging your application. Debugger visualizer highlights SQL syntax of 
your query for better readability.


The important enhancement in LinqConnect 2.00 is the upgraded model 
designer - Entity Developer, that delivers advanced Model First support and 
Update model from database functionality:


Model-First

Model-First approach implementation in Entity Developer offers automatic 
synchronization of mapping and storage part with the conceptual part of the 
model and easy to use wizards for synchronizing database with the model.


 a.. Synchronizing Database with the Model

 Entity Developer offers you two options for creating database based on 
your model. You may either generate a create script, that creates a new 
database, or use Update to Database Wizard that synchronizes an existing 
database with the model. This wizard makes only necessary changes to the 
database and retain the data if possible. Even changes inside entity are 
detected and resulted in ALTER statements, the table doesn't need to be 
dropped and created again. The wizard displays the tree of the changed 
objects and their changes, allowing you to choose which database objects 
need to be synchronized with the model, specify the renamed objects, etc.


 b.. Mapping Synchronization

 When automatic mapping synchronization is enabled, changes to the 
conceptual model are automatically applied to its mapping and storage part. 
For example, when you add a class to the conceptual part, a corresponding 
table is created in the storage part, and the class is automatically mapped 
to this table. Even the most complex conceptual part changes are supported - 
complex types, many-to-many associations, complex hierarchies. All these 
changes can be automatically reflected in the storage part. However you may 
make manual changes to the storage part, and they will be preserved when 
editing conceptual part.


Updating Model from Database

Update From Database Wizard allows synchronizing your model with the 
database for Entity Framework and LinqConnect in a fast and convenient way. 
Unlike standard Visual Studio Update Wizard, Entity Developer Update From 
Database Wizard tries to preserve manual changes to the model where 
possible. The wizard detects all the database changes that can affect the 
model, e.g. created and deleted tables and views, their columns and foreign 
keys, column datatype changes, created and deleted stored procedures and 
functions, changes to their parameters etc.






Pricing and Availability

A Single license costs $249.95. To learn more about LinqConnect 2.00 please 
visit the Devart site: www.devart.com/linqconnect/


Please, feel free to download and try LinqConnect 2.00 from 
http://www.devart.com/linqconnect/download.html


Users are welcome to write any comments and suggestions about 2.00 on its 
support page - http://www.devart.com/linqconnect/support.html






About Devart

Devart is a software development company with 11 years of experience on the 
software market and over 20 thousands of devoted users.


We specialize in providing comprehensive development and management tools as 
well as native connectivity solutions for the most popular databases, 
including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and 
SQLite.


For addi

Re: Back-up Plan for Large Database

[Johnny Withers]

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=joh...@pixelated.net
>
>


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

Re: Back-up Plan for Large Database

[Wagner Bianchi]

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=wagnerbianch...@gmail.com
>
>

Back-up Plan for Large Database

[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=arch...@jab.org