… systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems would…_password=”password”, master_log_file=”host-bin.000335″, master_log_pos=401934686; 12) Run SLAVE START to restart replication. With slightly modified… SHOW SLAVE STATUS instead of SHOW MASTER STATUS to find out appropriate binary log position. Be careful however – cloning slave from…
Post: Looking at Redis
August 27, 2009 By 27 Comments
… keeps overhead rather low. The database is dumped in temporary file which is renamed only after fsync which means if you… supports master/slave replication out of the box and it is extremely simple. You just specify from which node to replicate and this… not need to deal with snapshot or binary log position. Replication is asynchronous and low overhead – redis will perform the database…
Post: Why audit logging with triggers in MySQL is bad for replication
September 29, 2008 By 10 Comments
… –algorithm=BIT_XOR h=hostname.local,u=root,p=xxx –replicate=checksum.checksum –emptyrepltbl –chunksize=500000 –databases mydb –sleep 1 He… parse the binary log files, extracting the relevant statements. mysqlbinlog bin_log.000001 | mysqlsla -lt binary – Check out http://hackmysql.com/mysqlsla…
Post: Figuring out what limits MySQL Replication
March 7, 2007 By Leave a Comment
… was taking quite a while to catch up, which highlighted replication could be the limiting factor for this system quite soon… of course could just restart MySQL but this would make replication to be delayed few more hours because of the time… log file which is basically queries one query per line. mysqlbinlog almost provides what we’re looking for, if you strip out…
Post: Making MySQL Replication Parallel
January 30, 2007 By 1 Comment
…, the problem is however implementing it right without changing MySQL Replication semantics – which is – Slave database state corresponds to master database… Parallel Replication could be implemented simply by filtering transactions and writing to number of binary logs. If you’re “Scaling Out” you… binary log file and setup multi-master replication so slave can read all of them in parallel you can get replication parallel enough…
Post: The ultimate tool for generating optimal my.cnf files for MySQL
August 18, 2008 By 34 Comments
…” and “my.cnf generators” and “sample my.cnf files” online. The ultimate tool for generating an …primer or question-and-answer script that spits out “optimal” parameters for my.cnf. Most of … Much harder than syncing data, or manipulating a replication hierarchy, or any of the other things Maatkit…
Post: Making the impossible: 3 nodes intercontinental replication
January 11, 2012 By 29 Comments
… you theoretically could create 3 node traditional MySQL ring replication, but this is not what you want to … nodes host names and your keys in the file: install.nodes.sh When all nodes start, we … takes time (or at least until scientists figure out how to attach transaction to Faster than light …
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… it write out a CSV file and import that with LOAD DATA INFILE. Keep those big fat log files out of the database… a little meta-table. Then your script can figure out which files it can ignore. What we’re doing here… and archiving data can be dramatic. Take It Easy On Replication Building aggregated tables is hard work for the database server…
Post: Emulating global transaction ID with pt-heartbeat
November 4, 2011 By 6 Comments
…-B-C replication, and we needed to start at C and work up the chain to figure out its replication position relative to…:12:18.001960 server_id: 15511 file: ginger-bin.000002 position: 26478 relay_master_log_file: ginger-bin.000020 exec_master_log… it update every server in their replication topology so that it’s easier to figure out replication positions when things go wrong. It…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… The pmp-check-mysql-deleted-files plugin will alert when files have been deleted but remain…debt: easy to start, impossible to dig out afterwards. Another very common cause of …-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication…
