…slave that is behind. Until it catches up, the view of the data on the slave is “behind” the changes on the master…There is a script to convert SQL to the Flexviews API (see convert.php below) Refresh…refreshable version does not take long to refresh: mysql> call flexviews.refresh( -> flexviews.get_id…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Post: Using MMM to ALTER huge tables
March 27, 2008 By 11 Comments
… to changes that really require table to be rebuilt – adding/dropping columns or indexes, changing data type, converting data to different character set – MySQL master-master… mysql> STOP SLAVE; we don’t want schema changes to be replicated to db1 now. 3. on db2: load the sql scripts $ mysql -…
Post: Migrating several single standalone MySQL server to one Percona XtraDB Cluster... MariaDB to the rescue !
December 18, 2012 By 3 Comments
…slaves would then become a loop : for each production server restoring the dump on the node that will be the dedicated slave convert…slave (standard asynchronous replication of MySQL), it can spread in the cluster all statements received from the master if log_slave…
Post: Percona XtraDB Cluster - installation and setup webinar follow up Q&A
October 28, 2012 By 4 Comments
… mysql replication (asynchronous) for a given node, it’s not possible. However, a node in PXC can be a master or a slave on asynchronous replication, galera and built-in mysql replication are independent from each… to start up a cluster from scratch (i.e. a standalone XtraDB Cluster machine, convert it to a cluster type, and add nodes to…
Post: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 3, 2012 By 11 Comments
… everyone. You can convert your existing MySQL replication setup into …to ask us any questions. Related talks: Tutorial on PL MySQL Conference Galera Synchronous Multi-Master Replication for MySQL. My talk on PL MySQL…master replication. You can write to any node. Parallel applying events on slave. …
Post: Implementing efficient counters with MySQL
July 1, 2007 By 16 Comments
…the most trivial way – they convert read load to write load. When you …to overload the replication, especially as it has to serialize transactions on the slave which could be executed in parallel on the master…to MySQL server. If you rather use existing solutions you can use memcache + another mysql…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… As load increases you might convert certain tables to MyISAM and other storage engines …then rename them back to MySQL database directory. This way accesses to non-checked …slave servers. If it crashes you can simply re-clone it. Make sure however to have at least one proper master to fall back to…
Comment: MySQL Server Memory Usage
September 1, 2006 By 21 Comments
…convert the gained knowledge to…master‘, ’0′ ‘Com_show_open_tables’, ’0′ ‘Com_show_privileges’, ’0′ ‘Com_show_processlist’, ’20′ ‘Com_show_slave_hosts’, ’61′ ‘Com_show_slave…
Post: Lost innodb tables, xfs and binary grep
November 9, 2010 By 12 Comments
…MySQL had a dedicated partition on XFS file system Server was running innodb_file_per_table There was a production master and two slaves, all had same setting Developer accidentally ran DROP DATABASE X on the wrong machine (production master) All slaves… just converted number 837492636 to it…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
…> expect it to beat MySQLi in speed. It is however bad idea to use > mysql_ functions directly as…master to a slave, there is no reason why you can’t remove the foreign key references on the slave… data (think of converting your varchars to chars for example), then having to do byte comparisons across…
