… obvious how they will affect your database workload. For example: Transaction commit takes … MySQL replication from this instance, since MySQL replication is asynchronous. What about semi-sync MySQL replication…. But in Galera you cannot relax synchronous replication. You can’t change the law…
Post: Percona Server for MySQL 5.5.30-30.2 now available
April 10, 2013 By 10 Comments
…). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed… #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were actually asynchronous when Thread Pool feature was…
Post: Percona Server 5.5.30-30.2 rerelease fixes non-restart issue
April 24, 2013 By Leave a Comment
…). Percona Server for MySQL would re-create the test database when using rpm on server upgrade, even if the database was previously removed… #68197 that caused InnoDB to misclassify internal read operations as synchronous when they were actually asynchronous when Thread Pool feature was…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
… is writing as synchronous? I was able to write 100,000 queries in about 50-60 seconds to mysql 5.1 and… with six 300G SAS drives in a raid10 for the database and four 2TB SATA drives in a raid10 for the…=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server…
Post: Automation: A case for synchronous replication
September 19, 2012 By 2 Comments
… how Synchronous Replication solutions such a Percona XtraDB Cluster and MySQL Cluster are different. Synchronous replication essentially allows you to work with database nodes (SQL nodes for MySQL Cluster) in the…
Post: MongoDB Approach to database synchronization
April 30, 2010 By 5 Comments
… operations can be very expensive for large databases. MongoDB approach used in Replication Sets is… no more exist). Such approach allows quick synchronization without any complex support of rolling back …be possible to apply the same concept to MySQL Replication, possibly with help of some tools …
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
… databases but until recently this type of software was not available for MySQL. Change Data Capture can be used to: Monitor a database…) to identify rows that have changed Triggers to capture changes synchronously Database log reading to capture the changes asynchronously The first method… name. The Binary Log is the MySQL log which records changes to tables in the database. FlexCDC reads the binary log to…
Post: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… for creating materialized views for MySQL data sets. The tool is for MySQL, but the methods are database agnostic. A materialized view is… Flexviews can move database objects forward in time synchronously with each other to specific points in time in database state, invalid database state is…
Post: Percona XtraDB Cluster reference architecture with HaProxy
June 20, 2012 By 63 Comments
… software that we will use. First, install PXC on the database nodes. # yum -y install Percona-XtraDB-Cluster-server Percona-XtraDB… JOINED -> SYNCED (TO: 105) 120619 13:21:20 [Note] WSREP: Synchronized with group, ready for connections For debugging information about the…’s create a database and a userfor it. mysql> create database sbtest; Query OK, 1 row affected (0.01 sec) mysql> grant all on…
Post: Thank you for joining us at Percona Live, NYC 2012
October 7, 2012 By 1 Comment
… solutions including our own Percona XtraDB Cluster. This synchronous replication clustering technology for MySQL is getting a lot of interest these days… in his inspiring Keynote. Clustrix have been showing their scalable MySQL compatible database solution built from the ground up. They got very…
