… SST is paramount. We recommend Xtrabackup SST for its reduced locking period from its use (which means the donor is blocked… a shorter while). By using Xtrabackup for SST, you also get its benefits like compression, parallel streaming, encryption, compact backups which…
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
…. If you’re just setting up a test environment to get familiar with the technology, certainly there’s nothing wrong with… files on top of a clustered filesystem with an external lock manager. You might say that MySQL/NDB Cluster is also… similarities end. Q: What kind of replication issues can you get with storage solutions like GlusterFS? A: I have to admit…
Comment: MySQL Performance Forums
June 9, 2013 By 18 Comments
… into completely different table (unrelated to the select query) also get hang up. If I do show processlist, the update queries… ‘null’ and Info says ‘commit’ The ‘Table_locks_waited’ remains zero while the ‘Table_locks_immediate’ keeps increasing I have disabled the…
Post: ZFS on Linux and MySQL
May 24, 2013 By 17 Comments
… maybe just normal. We didn’t try too hard to get better performance because we already had more than enough for… start the snapshot while holding a “flush tables with read lock” and the flush operation will take some time to complete…
Post: MySQL and the SSB - Part 2 - MyISAM vs InnoDB low concurrency
May 22, 2013 By Leave a Comment
… accessing pages from the buffer pool should be faster than getting them from the OS cache, which is another advantage of…_log_buffer_size=32M innodb_buffer_pool_instances=16 metadata_locks_hash_instances=32 table_open_cache_instances=8 sort_buffer…
Post: Is Synchronous Replication right for your app?
May 14, 2013 By 18 Comments
… standard Innodb. The first transaction will acquire the necessary row locks while it commits (which will take the 1 RTT). The other transactions will lock wait until the lock(s) they need are available. The application just… the database state changes. retry deadlocks Now we start to get into (*gasp*) territory where your application needs to be modified…
Post: Galera Flow Control in Percona XtraDB Cluster for MySQL
May 2, 2013 By 5 Comments
…. This prevents any node in the synchronous replication group from getting too far behind the others in applying replication. This may… node by simply by running “FLUSH TABLES WITH READ LOCK“, or perhaps by “LOCK TABLE”, in which case flow control will kick… flow control if I execute a FLUSH TABLES WITH READ LOCK on node3: [root@node3 ~]# myq_status wsrep Wsrep Cluster Node…
Post: MySQL and Percona Server in LinkBench benchmark
May 8, 2013 By 18 Comments
…_and_free_block(buf_pool_t*, unsigned long) | buf_LRU_get_free_block(buf_pool_t*) | | | |–94.84%– buf_page_init… mysqld mysqld [.] rw_lock_x_lock_func(rw_lock_t*, unsigned long, char const*, unsigned long) | — rw_lock_x_lock_func(rw_lock_t*, unsigned long…_schema=0 #56only loose-innodb_flush_neighbors=0 loose-metadata_locks_hash_instances=256 innodb_buffer_pool_instances=16 # MySQL 5…
Post: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
…, you provide the following benefits to your customers: No vendor lock-in. And this is significant. Customers often choose products that allow them to avoid being locked in to one product. For example, I believe there is… provider lock-in. Customers should be able to choose who provides services for your product. Independent expertise. Customers like to get trustworthy…
Comment: Open Source, the MySQL market (and TokuDB in particular)
May 10, 2013 By 13 Comments
Can you not have vendor lock in no matter what solution you choose? Whether it is … with it may not be worth the effort) – hence the lock in. The exception might be for something that is truely… supporting a significant number of open source projects, and you get support(maybe it sucks) at the same time. Easier to…
