Tag Info

New answers tagged

0

When the folder with binary logs is full, mysqld will freeze everything that does a write to a MyISAM table (even temporary MyISAM tables). See my post "Site Offline" MySQL server failing to start and stop as to why. Anyway, mysqld will wait for free diskspace before continuing whatever operation it was doing. In this particular instance, you must ...


0

The Error Message you received Last_SQL_Error: Could not execute Delete_rows event on table test.pruning; Can’t find record in ‘pruning’, Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event’s master log mysql-bin.000002, end_log_pos 1448 This message can come up when doing a DELETE query with row-based replication. Unfortunately, it is one ...


2

In Windows, you would need to modify the my.ini file and not the my.cnf file Locate you my.ini file If MySQL is being run as a service Enter "services.msc" on the Start menu search box. Find MySQL service under Name column, for example, MySQL56. Right click on MySQL service, and select Properties menu. Look for "Path To Executable" under General tab, and ...


0

You could achieve this with following steps then Installation of new instance on some new port with latest version. Swap the data directory and swap port in config file. Run mysqlupgrade. Verify the new installation. To be on safer side you may take old database backup(folder copy or mysqldump or mysqlenterprisebackup before the activity etc) Hope it ...


0

Actually, this plan is kind of dangerous for the mysql schema. Why ? You are upgrading two versions up. mysql_upgrade will not respond well to this. I have a post where someone upgraded without addressing mysql.user : Any known issues upgrading from MySQL 5.1.73 to 5.6.21? I have old posts on how to upgrade two versions in one shot Apr 11, 2013 : MySQL ...


0

Plan A: The topology as drawn by Rolando: If Master 2 goes down, you have a mess. If Master 1 goes down, you have no valid slaves until you fix the links. Plan B: Dual master, single writer: Slave(s) <- Master1 <-> Master2 -> MoreSlave(s) AND Write to only one of the Masters at a time. That will minimize the repair steps. Plan C: MHA Master -> ...


1

Using the topology you mentioned from the MySQL Documentation Let's setup the first scenario EXAMPLE IPs for Each DB Server Master1 : 10.20.30.40 Master2 : 10.20.30.50 Slave_1 : 10.20.30.60 replication user is repluser@'%' replication password is replpass Make sure binary logging is enabled on all the Slaves We will do the following Promote ...



Top 50 recent answers are included