List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:December 30 2010 9:53pm
Subject:RE: /etc/init.d/mysql start WITHOUT integrity check?
View as plain text  
 

> -----Original Message-----
> From: andrew.2.moore@stripped [mailto:andrew.2.moore@stripped] 
> Sent: Thursday, December 30, 2010 2:45 AM
> To: daevid@stripped; mysql@stripped
> Subject: RE: /etc/init.d/mysql start WITHOUT integrity check?
> 
> Daevid,
> 
> I'm not quite sure I understand why you want to restart your 
> master. Adding a slave shouldn't require any restarts/reloads. 
> 
> What have you changed in the my.cnf to solicit a restart?

It requires a restart of the slave mysql server. It also requires shutting
down the master so that no data is written while we copy the snapshot to
the slave.

http://dev.mysql.com/doc/refman/5.0/en/replication-howto-existingdata.html
 
> Andy 
> 
> 
> ________________________________________
> From: ext Daevid Vincent [daevid@stripped]
> Sent: 29 December 2010 20:25
> To: 'mysql'
> Subject: /etc/init.d/mysql start WITHOUT integrity check?
> 
> Is there a way to "/etc/init.d/mysql start" WITHOUT doing an integrity
> check?
> 
> Can I pass in a command line parameter or set something in 
> the my.cnf file?
> 
> Our DB is a Billion rows (with a "B") and that check can take HOURS.
> 
> All we want to do is restart the server to put another slave 
> online because
> sadly "/etc/init.d/mysql reload" does NOT re-load the config 
> file (as one
> might hope), it is only to reload PRIVS (how useless is that 
> since GRANT
> already does that).
> 
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?unsub=1
> 

Thread
/etc/init.d/mysql start WITHOUT integrity check?Daevid Vincent29 Dec
  • RE: /etc/init.d/mysql start WITHOUT integrity check?andrew.2.moore30 Dec
    • Re: /etc/init.d/mysql start WITHOUT integrity check?Wagner Bianchi30 Dec
      • RE: /etc/init.d/mysql start WITHOUT integrity check?Daevid Vincent30 Dec
        • Re: /etc/init.d/mysql start WITHOUT integrity check?Shawn Green30 Dec
          • Re: /etc/init.d/mysql start WITHOUT integrity check?Wagner Bianchi30 Dec
    • RE: /etc/init.d/mysql start WITHOUT integrity check?Daevid Vincent30 Dec