OurSQL Episode 185: Getting in Sync_MySQL-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

OurSQL Episode 185: Getting in Sync_MySQL

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 01, 2016 pm 01:13 PM

This week we discuss pt-table-checksum for keeping data in sync. Ear Candy is a rational look at why one company chose MySQL; At the Movies is using MySQL in a practical way for Big Data.

pt-table-checksum
pt-table-checksum
pt-table-sync

Episode 151, where we talked about Oracle toolsmysqldbcompare and mysqldiff
Options discussed:
--replicate, --no-create-replicate-table
--no-check-binlog-format
--recurse (default is infinite), --recursion-method
--no-replicate-check, --quiet
--retries, --resume, --run-time
--set-vars
--no-empty-replicate-table
--max-lag, --check-slave-lag
--max-load (default: threads_running=25)
--pid
--no-check-plan
--no-check-replication-filters
--no-check-slave-tables

You can also give a comma-separated list of configuration files to read in, with the --config option. If you use it, the --config option has to be the first option on the commandline. The documentation says to look at the output using --help to see the default configuration files, and in the testing we did, this looked at:
/etc/percona-toolkit/percona-toolkit.conf
/etc/percona-toolkit/pt-table-checksum.conf
/root/.percona-toolkit.conf
/root/.pt-table-checksum.conf

--databases, --tables, --engines, --databases-regex, --tables-regex, --columns, --where
--ignore-databases, --ignore-tables, --ignore-engines (FEDERATED,MERGE by default), --ignore-columns, --ignore-databases-regex, --ignore-tables-regex
--chunk-time, --chunk-size, --chunk-index, --chunk-size-limit
--progress
--function (default is CRC32)
--float-precision
--explain
--replicate-check-only
--trim
--replicate-database

Ear Candy
Case study: Why Baron Schwarz chose MySQL for the backend of his company

At the movies
This week in At the Movies, we present Jonathan Levin speaking aboutUsing MySQL to Build Big Data Applications. In this 26 minute video, Jonathan shows how to create summary tables in MySQL for handling big data.

Where you can see us
Sheeri will be at theJune Boston MySQL User Groupon Monday, June 9th, where we'll have Amrith Kumar talking about DB as a service using trove on openstack.

Gerry will be at theJune Seattle MySQL User Groupon Monday, June 9th, where we'll talk about WebScaleSQL.

Sheeri and Gerry will be attendingOSCon 2014from Sunday July 20th through Thursday July 24th.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter:@oursqlcast
orTweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1315

Statement

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

MySQL: How to Add a User RemotelyMay 12, 2025 am 12:10 AM

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

The Ultimate Guide to MySQL String Data Types: Efficient Data StorageMay 12, 2025 am 12:05 AM

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

MySQL BLOB vs. TEXT: Choosing the Right Data Type for Large ObjectsMay 11, 2025 am 12:13 AM

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

MySQL: Should I use root user for my product?May 11, 2025 am 12:11 AM

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQL String Data Types Explained: Choosing the Right Type for Your DataMay 11, 2025 am 12:10 AM

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns

See all articles