… series of blog posts on MySQL‘s unsolved severe limitations. I… Try obscure techniques such as external processes to prefetch the data the…would run up until the COMMIT, but not actually commit, and then report… currently impossible. These solutions represent different types of trade-offs. For example…
Post: Measuring the amount of writes in InnoDB redo logs
October 8, 2012 By 4 Comments
… colleague found 2.70 GB/hour (almost a 3x difference!) Something was obviously wrong in our understanding of how… to the redo logs is a much more complicated process: every write is a 512-byte write and there…2 writes 200 bytes to the log buffer At commit, InnoDB appends those 200 bytes to the same …
Post: Infinite Replication Loop
October 10, 2011 By 2 Comments
…to a server-id which is different from the two actual masters. Let…beneficial in 99% of all cases) commits a transaction, the DML statements …disable any automatic failover during the process because high availability tools like mmm…performed on the two slaves (mysql 3 and mysql 4) and the new events…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
…asynchronous replication, galera and built-in mysql replication are independent from each other….process, it gets bootstrapped because of this option, and you can end up having 2 different clusters serving data to different…Q: If the cluster blocks write while it commits to another host, does that not…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
… you can use this sample database to spread processing over up to 20 nodes. The Infobright Community …are available it is important to examine the differences in size. This will give us some …256K tmp-table-size=64M transaction-isolation=READ-COMMITTED user=mysql wait-timeout=86400 To be continued You…
Post: Investigating MySQL Replication Latency in Percona XtraDB Cluster
March 3, 2013 By 13 Comments
…significant load. sysbench –test=oltp –mysql-user=root –mysql-password=”" –oltp-table-size=1000000 –…committed) before serving the read. The great thing is wsrep_causal_reads is session variables so you can mix different… same table can) but the certification process is serial as well as sending…
Post: When would you use SAN with MySQL ?
March 9, 2009 By 18 Comments
… different …processing (and extra trip) involved. This in particular hurts log writes which are very latency critical. Now what is about MySQL…commit too. MySQL also has broken group commit (which we have partial fix for) meaning concurrent transaction commits will need to be serialized. Second, MySQL…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… that, for the second node, the differences in the configuration should be the …, but because of optimistic locking at commit time, rollbacks can happen if we…mysql> grant process on *.* to ‘clustercheckuser’@'localhost’ identified by ‘clustercheckpassword!’; Query OK, 0 rows affected (0.00 sec) mysql…
Post: State of MySQL Market and will Replication live ?
April 9, 2008 By 29 Comments
…it as $/visitor or $revenue/server the difference for most enterprises vs most of web…MySQL could not solve well. There are inhouse and opensource solutions for tasks for large scale file storage, queuing, data processing…split – some companies I talk to are committed to “no vendor lock in” policy and…
Post: Percona and the MariaDB Foundation
December 19, 2012 By 3 Comments
… of the project as its mission, which can streamline the process of sponsorships and donations. A Foundation can also own trademarks… participants as well as define the governance – the decision making process about the project’s future. MariaDB Foundation just has been… continue to be committed to developing our own flavor of MySQL: Percona Server. Our goals for this project are different than those for…
