Topics: replication

replication Feed    replication Open Questions Feed    replication Email    Open Questions via Email

Please sign in or register to post.

Please sign in or register to post.

• How to Add More Columns on Slave Than Master in MySQL

  

  By Chuck Bell : 13 October 2010 - 01:11 PM

  If you need to include additional columns on the slave that the master doesn’t have—for example, to record timestamps or add routing or other localized data—you can add columns to a table on a s...

  Tags:

  • replication
  • mysql

  0Votes

  0Comments

  ---

• Using Replication to Repopulate a MySQL Table

  

  By Chuck Bell : 06 October 2010 - 09:45 AM

  If a table on your slave becomes corrupt either through error or accident (e.g., a user deletes the data), you can use replication to recover the data. Do so by creating a temporary table on the maste...

  Tags:

  • mysql
  • replication

  1Vote

  0Comments

  ---

• What to Do When Your MySQL Slave Stops Unexpectedly

  

  By Chuck Bell : 31 August 2010 - 06:31 PM

  If your slave stops without warning and there is an error message, consult the documentation about the likely causes of the error and perform any repairs necessary. Once you have corrected the error,...

  Tags:

  • mysql
  • replication
  • troubleshooting

  0Votes

  0Comments

  ---

• What Is MySQL Cluster?

  

  By Chuck Bell : 03 August 2010 - 08:51 AM

  MySQL Cluster is a shared-nothing, distributed node architecture storage solution designed for fault tolerance and high performance. Data is stored and replicated on individual data nodes (sometimes c...

  Tags:

  • mysql
  • mysql cluster
  • replication
  • performance
  • database

  4Votes

  2Comments

  ---

• How to Report MySQL Replication Bugs

  

  By Chuck Bell : 13 July 2010 - 02:12 PM

  Once in a while you may encounter a replication problem that you cannot solve without outside help. Even if you do not have a support agreement in place, you can report a bug for the MySQL release you...

  Tags:

  • mysql
  • replication
  • bugs

  0Votes

  0Comments

  ---

• How to Pause Replication in MySQL

  

  By Chuck Bell : 12 July 2010 - 09:39 AM

  To pause replication, execute the following steps on each of your master servers, starting with the prime master (the first master): On the master: Run the FLUSH TABLES WITH READ LOCK command. Run t...

  Tags:

  • mysql
  • replication
  • pause

  0Votes

  0Comments

  ---

• Troubleshooting MySQL Replication Failures

  

  By Chuck Bell : 08 July 2010 - 10:05 AM

  The following is a stepwise procedure you can use when attacking replication problems. Note: You should write down or electronically record all observations while you conduct this procedure. Seeing ...

  Tags:

  • mysql
  • replication
  • troubleshooting

  0Votes

  0Comments

  ---

• Tools for Troubleshooting MySQL Replication

  

  By Chuck Bell : 07 July 2010 - 02:53 PM

  Here are the tools required to diagnose replication problems along with a few suggestions about how and when to use each: SHOW MASTER STATUS and SHOW SLAVE STATUS These SQL commands are your primary ...

  Tags:

  • mysql
  • replication

  1Vote

  0Comments

  ---

• The Value of Asynchronous MySQL Replication

  

  By Chuck Bell : 02 July 2010 - 03:22 PM

  MySQL replication is asynchronous, a type of replication particularly suitable for modern applications such as websites. To handle a large number of reads, sites use replication to create copies of t...

  Tags:

  • mysql
  • replication
  • asynchronous

  0Votes

  0Comments

  ---

• MySQL Replication Troubleshooting Best Practices

  

  By Chuck Bell : 29 May 2010 - 04:54 PM

  MySQL replication is a very stable feature but like any computing solution things can go wrong. Sometimes the problems are not manifested with descriptive error messages (are they ever?) and sometimes...

  Tags:

  • mysql
  • replication
  • best practices
  • troubleshooting

  0Votes

  0Comments

  ---