List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:June 12 2012 4:43pm
Subject:Re: i need advice on redundancy of mysql server.
View as plain text  
Joey,

" I can not afford any downtime and the data is realtime. "

This is a very good reason for asking help to consultants.

If you ask "What is the best method for this setup? master-master or
master-slave?"
then the simple answer is master-slave, for any mysql setup, that is the
only safe mysql replication setup.
If you mean Master-Master Active/Passive I still consider that Master-Slave.
While is very well advisable to stay away from master-master active/active,
unless you really know what you are doing and you have the development
aware, very skilled, and listening to you*.

So, go for master-slave, but I would suggest to read online mysql manuals
and some great books,
because if you post here to ask every single step to set it up, you are
basically asking someone else to do the job for you, for free ;)

Cheers

Claudio



2012/6/12 Joey L <mjh2000@stripped>

> It sounds like you are all consultants.
>
>
> On Mon, Jun 11, 2012 at 4:46 PM, Baron Schwartz <baron@stripped> wrote:
> > Yeah -- that was an unintentional omission. There are solo consultants
> > like Ronald Bradford too.
> >
> > On Mon, Jun 11, 2012 at 3:14 PM, Andrew Moore <eroomydna@stripped>
> wrote:
> >> Not forgetting Pythian, Baron ;)
> >>
> >> On Mon, Jun 11, 2012 at 8:12 PM, Baron Schwartz <baron@stripped>
> wrote:
> >>>
> >>> Ultimately, if you intend to use MyISAM, you must keep in mind that it
> >>> eliminates some of your options. One problem is that MyISAM is very
> >>> slow to repair after a crash. Remember, if a crash can happen, it
> >>> eventually will, it's just a question of when. And MyISAM doesn't have
> >>> recovery -- it only has "repair," which will not necessarily recover
> >>> all of your data.
> >>>
> >>> If you are not aware of Percona XtraDB Cluster, it might be
> >>> interesting for you. (I work for Percona.) There is also Continuent
> >>> Tungsten to consider.
> >>>
> >>> Frankly, though, I'd step back a bit from such microscopic focus on
> >>> technologies. It looks like you need advice from someone who's done
> >>> this before, to get the high-level things right before you dive deeply
> >>> into details. If it's really this important, I personally wouldn't
> >>> trust it to a mailing list, I'd hire someone. It's well worth it.
> >>> There's Percona again, of course, but there's also MySQL, SkySQL,
> >>> PalominoDB, and lots more to choose from.
> >>>
> >>> Baron
> >>>
> >>> --
> >>> MySQL General Mailing List
> >>> For list archives: http://lists.mysql.com/mysql
> >>> To unsubscribe:    http://lists.mysql.com/mysql
> >>>
> >>
> >
> >
> >
> > --
> > Baron Schwartz
> > Author, High Performance MySQL
> > http://www.xaprb.com/
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:    http://lists.mysql.com/mysql
> >
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql
>
>


-- 
Claudio

Thread
i need advice on redundancy of mysql server.Joey L11 Jun
  • Re: i need advice on redundancy of mysql server.Ananda Kumar11 Jun
    • Re: i need advice on redundancy of mysql server.Shawn Green11 Jun
      • Re: i need advice on redundancy of mysql server.Joey L11 Jun
        • Re: i need advice on redundancy of mysql server.Shawn Green11 Jun
          • Re: i need advice on redundancy of mysql server.Baron Schwartz11 Jun
            • Re: i need advice on redundancy of mysql server.Andrew Moore11 Jun
              • Re: i need advice on redundancy of mysql server.Baron Schwartz11 Jun
                • Re: i need advice on redundancy of mysql server.Joey L12 Jun
                  • Re: i need advice on redundancy of mysql server.Claudio Nanni12 Jun
                  • Re: i need advice on redundancy of mysql server.Johan De Meersman13 Jun
                    • Re: i need advice on redundancy of mysql server.Prabhat Kumar13 Jun
    • Re: i need advice on redundancy of mysql server.Joey L11 Jun
      • Re: i need advice on redundancy of mysql server.Andrew Moore11 Jun
        • Re: i need advice on redundancy of mysql server.Joey L11 Jun
  • RE: i need advice on redundancy of mysql server.Rick James13 Jun
    • Re: i need advice on redundancy of mysql server.Joey L14 Jun