Re: HD Mirroring

mario.lobo_at_ipad.com.br
Date: 11/24/04

  • Next message: Haulmark, Chris: "RE: Network monitoring" 
    To: Brian Reichert <reichert@numachi.com>
Date: Wed, 24 Nov 2004 14:42:12 -0300

    Ok Brian;

    I read about NDBClusters but the info I found said it would only run on linux and solaris. No
    FreeBSD.

    I didnŽt know of mysql replication ! IŽll check into it too, but what iŽve been reading about vinum
    so far has impressed me a lot, specially in terms of not only mirroring the database but most
    anything you want.

    Maybe IŽll try to replicate the database on vinum volumes to get the best service performance from
    mysql, with the "failsafetyness" of vinum mirrors.

    Thanks for your help,

    On 24 Nov 2004 at 12:13, Brian Reichert wrote:

    > On Wed, Nov 24, 2004 at 10:52:11AM -0300, mario.lobo@ipad.com.br wrote:
    > > I have a mysql server that I need to mirror its data on a 2nd HD, either on the same machine or on
    > > a remote one, but it has to be in real time. Has it been or can it be done at all?
    >
    > Is MySQL's replication not fast enough? I can see why it wouldn't
    > be in all cases, but I wanted to make sure you were aware of it:
    >
    > http://dev.mysql.com/doc/mysql/en/Replication.html
    >
    > And, although I've not tested it, recent versions of MySQL can
    > outright support a cluster:
    >
    > http://dev.mysql.com/doc/mysql/en/NDBCluster.html
    >
    > > Thanks before-hand for any info,
    > --
    > Brian Reichert <reichert@numachi.com>
    > 37 Crystal Ave. #303 Daytime number: (603) 434-6842
    > Derry NH 03038-1713 USA BSD admin/developer at large 

    -- 
   //|  //||
  // | // ||
-//--//---|| ARIO LOBO
//  //    ||
---------------------------------
mario.lobo@ipad.com.br
http://www.ipad.com.br
_______________________________________________
freebsd-hackers@freebsd.org mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-hackers
To unsubscribe, send any mail to "freebsd-hackers-unsubscribe@freebsd.org"
  • Next message: Haulmark, Chris: "RE: Network monitoring"

    Relevant Pages

    • Re: About Design Requirements for Replication across different DBMSs...
      ... I still would need an identity column, a DateLastModified, but I have to add ... one simply modifies the SQL statements to "SELECT * from ... > SQLCE only supports merge replication. ... > Are you trying to replicate from SQLCE to MySQL using merge? ...
      (microsoft.public.sqlserver.replication)
    • Re: About Design Requirements for Replication across different DBMSs...
      ... SQLCE only supports merge replication. ... Are you trying to replicate from SQLCE to MySQL using merge? ... Then get any records on server that were edited later than the ...
      (microsoft.public.sqlserver.replication)
    • Re: MySQL Clustering
      ... The following solves replication breaking over the same auto int race ... Prior to inserting anything into this database, ... mysql> select * from users; ... the user has a random chance of hitting any of your database servers ...
      (freebsd-isp)
    • Re: MySql Load balancing Solutions?
      ... I am part of a team running MySQL 4.1.X on 5 machines in a replication ... A positive advantage is that the 5 machines allows us the opportunity to ... slave to a "W"rite server until the original "W"rite server can be recovered. ... When it comes to management I won't lie, 4.0.XX's handling of Replication ...
      (freebsd-questions)
    • (Fwd) Perl DBI and MySQL
      ... Subject: Perl DBI and MySQL ... When DBI.pm with mysql.pm tries to connect to a database it uses a use statement? ... Because replication only works with the use statement. ... Can you confirm that DBI.pm with the Mysql driver always issues a use;? ...
      (perl.dbi.users)