…the most important issue – with modern multi core servers not only the fact you can’t …of time to implement any significant changes to schema or queries. In general cross storage engine replication is …used for full text search. In certain cases you can just use MySQL triggers to maintain such table, …
Post: What to do with MySQL Full Text Search while migrating to Innodb ?
September 10, 2009 By 12 Comments
Post: Percona Welcomes MySQL 5.6!
February 25, 2013 By Leave a Comment
…Search project was started over 6 years ago, in addition with many optimizer and replication features. We’re happy to congratulate MySQL…
Page: Consulting for MySQL
July 31, 2006 By
…MySQL Replication Advanced MySQL Replication consulting including chained and circular replication, bi-directional replication, troubleshooting MySQL Replication performance problems. MySQL Operations and Administration Assistance with MySQL Server…
Post: Ultimate MySQL variable and status reference list
January 8, 2011 By 4 Comments
…replicate_do_dbblogpercona.commanual replicate_do_tableblogpercona.commanual replicate_ignore_dbblogpercona.commanual replicate_ignore_tableblogpercona.commanual replicate_rewrite_dbblogpercona.commanual replicate_same_server_idblogpercona.commanual replicate…
Post: Finding your MySQL High-Availability solution – The questions
October 16, 2009 By 36 Comments
…MySQL replication” and “Master-Master with MMM manager”. Depending on the application, the MyISAM Full text indexes might be replaced by another search… access to the servers is the preferred way, especially for the most complex solutions. Proof of concept Migration to Production MySQL replication 4 …
Post: Debugging problems with row based replication
May 6, 2010 By 12 Comments
… MySQL doesn’t know anything is wrong. This isn’t the case with row-based replication. Only actual changes are written to the… the ‘less’ utility, and search forward for the value 340718: # at 340718 #100506 12:42:56 server id 1 end_log_pos…:42:56 server id 1 end_log_pos 340678 Table_map: `repl`.`t1` mapped to number 15 #100506 12:42:56 server id…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
…MySQL Server settings. It is more the question of knowing there to…MySQL Related work – it is very hard to find people with good enough MySQL knowledge. MySQL themselves are searching for them, Google is searching…
Post: Using Flexviews - part two, change data capture
March 25, 2011 By 26 Comments
…search engines like Sphinx or Solr only the rows that change. Feed third party replication systems. Provide data to…MySQL installations which allow connections as root with no password from localhost. It is possible to read from and/or write to remote servers… default config filename to search for. I …
Post: Percona Server 5.5.8 Beta Release
February 16, 2011 By 16 Comments
… to replication, partitioning, stored procedures More diagnostics and tunability More pluggability, including pluggable authentication In addition to building on MySQL 5.5, here are the changes we’ve made from previous Percona Server releases: New Features InnoDB adaptive hash function searches…
Post: MySQL Workshops: Chicago & London this April
March 15, 2013 By Leave a Comment
…MySQL replication. Monitor MySQL servers in production. Discuss security issues with MySQL. Solve via case-study some real-life problems that Percona consultants faced in MySQL…
