Tag Info

New answers tagged

0

I would use LIKE for one very good reason. From the docco here - "This function does not work properly if the first argument contains a comma (“,”) character". You could always use an EXPLAIN to check on performance - but simply for the reason above, I would not use it. [EDIT] You could always use LOCATE(). I strongly recommend that you don't use MySQL's ...


0

If your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with socket=/var/lib/mysql/mysql.sock you can check if mysql is running with the following command: mysqladmin -u root -p status try changing your permission to mysql folder. If you are working locally, you can try: sudo chmod -R 755 /var/lib/mysql/ Hope this helps!


1

Your architecture is not right for asynchronous replication. I strongly recommend against runing a Master-Master standard replication in a fully automated system, as you will run into precisely the issue you are describing. While you may not be writing to both servers at the same time, the fact that you are replicating in a non-syncronous way means that you ...


1

This is not a hack. It is the intention of them: Use auto_increment_increment and auto_increment_offset http://dev.mysql.com/doc/refman/5.6/en/replication-options-master.html#sysvar_auto_increment_increment


0

"Diffs cannot be detected because no slaves were found." That means that you are using the tool incorrectly -a single run must be done so that it creates checksums that are eventually consistent for the master and the slave. Run pt-table-checksum only directed to the master, and create the appropriate permissions so that it can check the slave, too. ...



Top 50 recent answers are included