… post focuses on the key aspects of synchronous replication setup with high-availability guarantees like split-brain… any latter modifications like these to cnf files are not required and preset it during …. We recommend Xtrabackup SST for its reduced locking period from its use (which means the …
Post: Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
June 17, 2013 By Leave a Comment
Post: Choosing a MySQL HA Solution - Post-Webinar Q&A
June 7, 2013 By Leave a Comment
…’d suggest reading over the manual’s description of how replication filtering rules are processed. There are some informative flowcharts in… if you’re not using GTID-based replication. If you are using GTID-based replication, it looks like you’ll need to… the MySQL world, except maybe MyISAM files on top of a clustered filesystem with an external lock manager. You might say that…
Comment: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… Early Lock Release (http://infoscience.epfl.ch/record/152158) or the followup from VLDB ’10: http://infoscience.epfl.ch/record/149436/files/vldb10aether.pdf The paper doesn’t reference multi-node replicated systems, but I’m fairly…
Post: No more MySQL Crash Safe Replication in 5.0 ?
January 29, 2008 By 7 Comments
… log files up to which replication was done: InnoDB: In a MySQL replication slave the last master binlog file InnoDB: position 0 115, file name… thing works. Until this issue is fixed getting Crash Safe replication with MySQL is not impossible but surely more complicated and… do traditional and recommended way with FLUSH TABLES WITH READ LOCK for snapshot creation. This happens when you have large amount…
Post: Using LVM for MySQL Backup and Replication Setup
August 21, 2006 By 53 Comments
… systems with similar features set for other operation systems. Veritas File System can do it for Solaris. Most SAN systems would… running queries. The catch here is FLUSH TABLES WITH READ LOCK actually waits for all statements to complete, even selects. So…_password=”password”, master_log_file=”host-bin.000335″, master_log_pos=401934686; 12) Run SLAVE START to restart replication. With slightly modified…
Post: Estimating Replication Capacity
July 20, 2010 By 4 Comments
…. So what is replication capacity I call replication capacity the ability to replicate the master load. If replication is able to replicate 3 times the… median # Exec time 819s 1us 92s 669us 260us 120ms 93us # Lock time 28s 0 166ms 23us 49us 192us 25us # Rows sent… the log file covers. In this case as we know there is only one replication thread it will be same as replication load…
Post: MySQL Limitations Part 1: Single-Threaded Replication
October 20, 2010 By 16 Comments
…? Here are a few I’ve seen: Use DRBD replication instead of MySQL replication. Problem: you end up with an idle standby… order. If any error occurred, such as a deadlock or lock wait timeout, then the coordinator would instruct the workers to… files on the replica, and new SQL syntax for administering replicas, and is generally not something I personally want to administer (replication…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…introduced relatively simple performance boosters – Query Cache and Replication, which were clearly not enough to … solutions for tasks for large scale file storage, queuing, data processing etc. But … talk to are committed to “no vendor lock in” policy and would not like proprietary solutions…
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… threads inside the server to share same transactional/lock context. In this case replication could accumulate number of queries execute them in… binary log file and setup multi-master replication so slave can read all of them in parallel you can get replication parallel enough…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…replication_delayblogpercona.commanual innodb_rollback_on_timeoutblogpercona.commanual Innodb_row_lock_current_waitsblogpercona.commanual Innodb_row_lock_timeblogpercona.commanual Innodb_row_lock…
