…function_codeblogpercona.commanual Com_show_function…
Post: High-Performance Click Analysis with MySQL
December 22, 2008 By 13 Comments
… in many different ways on demand, often to support the functionality of the application as well as to provide reports to… to maintain, back up, and restore. And the partitioning functionality is not done yet and not fully integrated into the… and archiving data can be dramatic. Take It Easy On Replication Building aggregated tables is hard work for the database server…
Post: Upgrading MySQL
January 5, 2010 By 24 Comments
… upgrade two things should normally worry you. It is Regressions – functionality regressions when what you’ve been using before does not… safest if you’re running application which uses simple MySQL functionality which is unlikely to be affected. If you’re something… master. Older slaves may have issues unable to interpret new replication stream correctly. If this is the problem for you can…
Post: MySQL Upgrade Webinar Questions Followup
June 28, 2012 By 7 Comments
… deal with STATEMENT and ROW replication issues at the same time. I would only recommend MIXED replication mode if you have something… format is rather low level and it rarely impacts application functionality wise. As long a you go over normal upgrade checks… idea. In small environments when we often care more about functionality than performance this can be great way to validate the…
Comment: Thanks Giving Challenge: How to detect replication context
November 29, 2008 By 12 Comments
… the UUID function twice. First time, use it as a function which does not replicate well. Second time, allow it to replicate as it… `test`.`deduce_whoami` () BEGIN TRUNCATE TABLE uuid_test; TRUNCATE TABLE replication_status; SELECT UUID() INTO @current_uuid; INSERT INTO uuid_test… uuid_test VALUES(SUBSTRING_INDEX(@current_uuid,’-',-1)) ; INSERT INTO replication_status SELECT CASE COUNT(DISTINCT(uuid)) WHEN ’1′ THEN ‘master…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 11 Comments
… pmp-check-mysql-replication-delay plugin checks for excessive delay, and pmp-check-mysql-replication-running checks that replication is functioning correctly. Replicas have different data than their master. In addition to delay or failure, replication can…
Comment: Database problems in MySQL/PHP Applications
November 6, 2006 By 13 Comments
…) will render mysqld useless! # #skip-networking # Replication Master Server (default) # binary logging is required for replication log-bin=db1-bin log-bin… is not set # but will not function as a master if omitted server-id = 1 # Replication Slave (comment out master section to…-host is set # but will not function as a slave if omitted #server-id = 2 # # The replication master for this slave – required…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… agree – regardless of what database is used, abstracting out core functionality usually means more portable code. You’re right that when… the needs of the application. > 2. Not using auto_increment functionality This is right. With some > exception however. For example Innodb… the same instance of MySQL. If nothing else, it makes replicating a subset of the data much easier. > Regarding if you…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
January 26, 2012 By 102 Comments
… was data missing in: property $id=”mysql_replication” replication_info=”192.168.5.96||” the function “update_data_master_status()” fetches that information…_options was empty . i copied the code from all other functions to fill mysql_options and after that it works perfect! The final version of the function is: # Stores data for MASTER STATUS from MySQL update_data…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 8, 2012 By 102 Comments
… adding some further debug messages, I found out, that the function set_master() is not executed at any time (I never… to this output from crm configure show: property $id=”mysql_replication” \ replication_info=”|mysql-bin.000048|106″ Any idea, why that happens… crm_mon? Shouldn’t we get some errors, if the function set_master is never executed? Cheers, Andreas PS: MarkS, would…
