Command Center

#!/bin/GREPing a '[programmer][sysadmin]' with Killer Skillz

Search

Thursday, August 27, 2009

MySQL: RENAME TABLE on Transactional Tables Can Jeopardize Slave Data

Category: MySQL — SkyHi @ Thursday, August 27, 2009

http://www.pythian.com/news/1285/mysql-rename-table-on-transactional-tables-can-jeopardize-slave-data

Newer Post Older Post Home

Labels

Blog Archive

► 2014 (3)
- ► 06/22 - 06/29 (1)
- ► 04/06 - 04/13 (1)
- ► 03/23 - 03/30 (1)

► 2013 (33)
- ► 12/15 - 12/22 (2)
- ► 09/08 - 09/15 (1)
- ► 08/25 - 09/01 (3)
- ► 08/18 - 08/25 (2)
- ► 07/21 - 07/28 (1)
- ► 07/14 - 07/21 (1)
- ► 06/16 - 06/23 (1)
- ► 06/09 - 06/16 (1)
- ► 05/19 - 05/26 (1)
- ► 04/28 - 05/05 (1)
- ► 04/21 - 04/28 (1)
- ► 04/14 - 04/21 (2)
- ► 03/24 - 03/31 (1)
- ► 03/17 - 03/24 (1)
- ► 03/10 - 03/17 (1)
- ► 02/24 - 03/03 (3)
- ► 02/17 - 02/24 (1)
- ► 02/03 - 02/10 (1)
- ► 01/27 - 02/03 (1)
- ► 01/13 - 01/20 (2)
- ► 01/06 - 01/13 (5)

► 2012 (181)
- ► 12/30 - 01/06 (3)
- ► 12/16 - 12/23 (7)
- ► 12/09 - 12/16 (2)
- ► 12/02 - 12/09 (1)
- ► 11/25 - 12/02 (3)
- ► 11/18 - 11/25 (2)
- ► 10/21 - 10/28 (2)
- ► 10/14 - 10/21 (2)
- ► 10/07 - 10/14 (2)
- ► 09/09 - 09/16 (1)
- ► 09/02 - 09/09 (1)
- ► 08/26 - 09/02 (4)
- ► 08/19 - 08/26 (6)
- ► 08/12 - 08/19 (26)
- ► 08/05 - 08/12 (7)
- ► 07/29 - 08/05 (3)
- ► 07/22 - 07/29 (6)
- ► 07/15 - 07/22 (2)
- ► 07/08 - 07/15 (5)
- ► 07/01 - 07/08 (1)
- ► 06/24 - 07/01 (2)
- ► 06/17 - 06/24 (9)
- ► 06/10 - 06/17 (2)
- ► 06/03 - 06/10 (7)
- ► 05/27 - 06/03 (8)
- ► 05/13 - 05/20 (1)
- ► 05/06 - 05/13 (1)
- ► 04/22 - 04/29 (2)
- ► 04/15 - 04/22 (4)
- ► 04/08 - 04/15 (3)
- ► 03/18 - 03/25 (2)
- ► 03/11 - 03/18 (7)
- ► 03/04 - 03/11 (6)
- ► 02/26 - 03/04 (3)
- ► 02/19 - 02/26 (3)
- ► 02/12 - 02/19 (2)
- ► 02/05 - 02/12 (3)
- ► 01/29 - 02/05 (3)
- ► 01/22 - 01/29 (7)
- ► 01/15 - 01/22 (6)
- ► 01/08 - 01/15 (8)
- ► 01/01 - 01/08 (6)

► 2011 (283)
- ► 12/25 - 01/01 (5)
- ► 12/18 - 12/25 (7)
- ► 12/11 - 12/18 (9)
- ► 12/04 - 12/11 (13)
- ► 11/27 - 12/04 (8)
- ► 11/20 - 11/27 (3)
- ► 11/13 - 11/20 (4)
- ► 11/06 - 11/13 (7)
- ► 10/30 - 11/06 (5)
- ► 10/23 - 10/30 (1)
- ► 10/16 - 10/23 (11)
- ► 10/09 - 10/16 (2)
- ► 10/02 - 10/09 (3)
- ► 09/25 - 10/02 (8)
- ► 09/18 - 09/25 (9)
- ► 09/11 - 09/18 (5)
- ► 09/04 - 09/11 (4)
- ► 08/28 - 09/04 (9)
- ► 08/21 - 08/28 (3)
- ► 08/14 - 08/21 (1)
- ► 08/07 - 08/14 (3)
- ► 07/31 - 08/07 (2)
- ► 07/24 - 07/31 (6)
- ► 07/17 - 07/24 (2)
- ► 07/10 - 07/17 (6)
- ► 07/03 - 07/10 (10)
- ► 06/26 - 07/03 (6)
- ► 06/19 - 06/26 (8)
- ► 06/12 - 06/19 (5)
- ► 06/05 - 06/12 (6)
- ► 05/29 - 06/05 (4)
- ► 05/22 - 05/29 (3)
- ► 05/15 - 05/22 (8)
- ► 05/08 - 05/15 (6)
- ► 05/01 - 05/08 (8)
- ► 04/24 - 05/01 (1)
- ► 04/17 - 04/24 (2)
- ► 04/10 - 04/17 (3)
- ► 04/03 - 04/10 (3)
- ► 03/27 - 04/03 (6)
- ► 03/20 - 03/27 (3)
- ► 03/13 - 03/20 (8)
- ► 03/06 - 03/13 (7)
- ► 02/27 - 03/06 (5)
- ► 02/20 - 02/27 (4)
- ► 02/13 - 02/20 (6)
- ► 02/06 - 02/13 (4)
- ► 01/30 - 02/06 (1)
- ► 01/23 - 01/30 (5)
- ► 01/16 - 01/23 (11)
- ► 01/09 - 01/16 (6)
- ► 01/02 - 01/09 (8)

► 2010 (750)
- ► 12/26 - 01/02 (8)
- ► 12/19 - 12/26 (7)
- ► 12/12 - 12/19 (3)
- ► 12/05 - 12/12 (8)
- ► 11/28 - 12/05 (11)
- ► 11/21 - 11/28 (8)
- ► 11/14 - 11/21 (1)
- ► 11/07 - 11/14 (27)
- ► 10/31 - 11/07 (6)
- ► 10/24 - 10/31 (6)
- ► 10/17 - 10/24 (7)
- ► 10/10 - 10/17 (4)
- ► 10/03 - 10/10 (6)
- ► 09/26 - 10/03 (4)
- ► 09/19 - 09/26 (4)
- ► 09/12 - 09/19 (13)
- ► 09/05 - 09/12 (13)
- ► 08/29 - 09/05 (7)
- ► 08/22 - 08/29 (17)
- ► 08/15 - 08/22 (5)
- ► 08/08 - 08/15 (11)
- ► 08/01 - 08/08 (3)
- ► 07/25 - 08/01 (5)
- ► 07/18 - 07/25 (8)
- ► 07/11 - 07/18 (13)
- ► 07/04 - 07/11 (9)
- ► 06/27 - 07/04 (15)
- ► 06/20 - 06/27 (13)
- ► 06/13 - 06/20 (40)
- ► 06/06 - 06/13 (23)
- ► 05/30 - 06/06 (33)
- ► 05/23 - 05/30 (37)
- ► 05/16 - 05/23 (21)
- ► 05/09 - 05/16 (10)
- ► 05/02 - 05/09 (8)
- ► 04/25 - 05/02 (19)
- ► 04/18 - 04/25 (13)
- ► 04/11 - 04/18 (19)
- ► 04/04 - 04/11 (10)
- ► 03/28 - 04/04 (16)
- ► 03/21 - 03/28 (11)
- ► 03/14 - 03/21 (4)
- ► 03/07 - 03/14 (8)
- ► 02/28 - 03/07 (7)
- ► 02/21 - 02/28 (12)
- ► 02/14 - 02/21 (50)
- ► 02/07 - 02/14 (26)
- ► 01/31 - 02/07 (33)
- ► 01/24 - 01/31 (5)
- ► 01/17 - 01/24 (69)
- ► 01/10 - 01/17 (20)
- ► 01/03 - 01/10 (14)

▼ 2009 (429)
- ► 12/27 - 01/03 (25)
- ► 12/20 - 12/27 (9)
- ► 12/13 - 12/20 (19)
- ► 12/06 - 12/13 (43)
- ► 11/29 - 12/06 (18)
- ► 11/22 - 11/29 (38)
- ► 11/15 - 11/22 (3)
- ► 11/08 - 11/15 (3)
- ► 11/01 - 11/08 (19)
- ► 10/25 - 11/01 (1)
- ► 10/18 - 10/25 (1)
- ► 10/11 - 10/18 (3)
- ► 10/04 - 10/11 (1)
- ► 09/27 - 10/04 (17)
- ► 09/20 - 09/27 (10)
- ► 09/13 - 09/20 (13)
- ► 09/06 - 09/13 (14)
- ► 08/30 - 09/06 (11)
- ▼ 08/23 - 08/30 (61)
- ► 08/16 - 08/23 (93)
- ► 08/09 - 08/16 (13)
- ► 08/02 - 08/09 (14)

My Blog List

Unixmen

Unlocking Innovation in Computer Vision with Open-Source OS - Diving into the Future At the heart of today’s tech revolution lies computer vision, a brilliant star in the vast universe of artificial intelligence. It...
2 days ago
Frequently Asked Questions About Linux / UNIX

How to find hard disk (SSD) serial numbers in Linux - [image: See all GNU/Linux related FAQ] You need to use the smartctl command to display the hard disk (SSD) serial numbers in Linux. This is useful when cha...
4 days ago
The Geek Stuff

PaloAlto init-cfg.txt Bootstrap Config file Layout with Examples - When you install and configure the PaloAlto firewall, when the firewall boots up for the first time, it does the bootstrapping process. PaloAlto uses the s...
2 years ago
Ubuntu Geek

Clusterssh – Administer multiple ssh or rsh shells simultaneously - Sponsored Link The command opens an administration console and an xterm to all specified hosts. Any text typed into the administration console is replicate...
3 years ago
There is no place like 127.0.0.1

Web Application Vulnerability Scanning Tools - Web Application Vulnerability Scanning Tools Nessus http://www.tenable.com/products/nessus PortSwigger https://portswigger.net/ qualys https://www.qualys....
5 years ago
Linuxaria » Linuxaria – Everything about GNU/Linux and Open source

What You Don’t Know About Linux Open Source Could Be Costing to More Than You Think - Guest post by Marc Fisher If you would like to test out Linux before completely switching it as your everyday driver, there are a number of means by which ...
6 years ago
WindowsNetworking.com

Resolving Sysprep problems with App-X packages (Part 1) - This is the first of two articles explaining how to fix systems that won't Sysprep if Windows Native/App-X applications have been removed and Windows patches.
7 years ago
WindowSecurity.com

V2V Communications security considerations - The future of vehicles, road infrastructure and driving are changing. We are progressing with vehicle-to-vehicle (V2V) and vehicle-to-infrastructure (V2I) ...
7 years ago
Linux 101 Hacks

10 UNIX / Linuz Size Command Examples for ObjectFiles - Linux size is part of GNU binutils. This utility is very helpful for programmers to analyze the data from the executable files (or object files). By defaul...
10 years ago
Aaron Walrath - Another IT Guy's Meanderings

Updating VMware Tools on Red Hat Enterprise/Scientific/CentOS Linux 6 for VMware ESXi 5 - In a previous post I discussed installing the open source VMware tools for Red Hat Enterprise/Scientific/CentOS Linux 6 from a yum package repository provi...
13 years ago