Reputation
11,645
Top tag
Next privilege 15,000 Rep.
Protect questions
Badges
1 13 32
Newest
 Caucus
Impact
~716k people reached

9h
comment Mysql backup bug
Please post the exact error you get, omitting no details or punctuation. Errors can be cryptic to the untrained eye and obvious to experienced DBAs, and there are easy ways to examine large files using sed or perl or other tools, but we need more info. Also the output of mysqldump -V and the query SELECT @@VERSION;.
18h
answered Data and index file compatibility between patch/revision releases of MySQL
19h
awarded  Caucus
Jul
19
comment Active-active Cluster In MySQL
@tesla747 you are correct.
Jul
19
comment Active-active Cluster In MySQL
NDB Cluster is synchronous, but it's its own different product, it's not "Standard MySQL behavior + Synchronous Replication" which is what PXC and MariaDB essentially provide, with Galera. There are arguments on both sides of the MariaDB/Percona preference debate, which are not on topic here, but I suggest that of those two is more likely to fit what you want than NDB, because unlike them, NDB is not a drop-in replacement for MySQL Server, and has a smaller set of applications and environments to which it is suited.
Jul
19
answered Active-active Cluster In MySQL
Jul
12
comment restoring a EC2 snapshot on RDS
The phrase "restore our database snapshot on ec2 directly on RDS" does not really explain what you are trying to do. Please edit the question to clarify exactly what you are trying to do, and why.
Jul
10
awarded  Enlightened
Jul
10
awarded  Nice Answer
Jul
10
comment Best way to backup mysql database?
Rsync? Of the actual MySQL data files from a running server? That's not an acceptable method of backup.
Jul
9
comment Cannot Start mySQL Daemon with Error “mysqld from pid file … ended”
$ ps auwwx | grep mysqld | grep -v grep ... does that return anything?
Jul
2
comment RDS Replication Error (Apply Error 1406 / Truncation)
You made schema changes on the replica, directly?
Jun
29
comment mysql query choosing an incorrect execution plan
You may not have noticed, based on the boxes you drew, but the optimizer has actually swapped the order of the last 2 tables in the query plan.
Jun
29
comment MySQL is inserting “” as 0 in decimal fields. How to stop that?
Empty string is no more like NULL than it is like 0 and arguably even less so. If you want null, why exactly would you not insert null?
Jun
29
answered update query field order guaranteed
Jun
24
comment MySQL - Add index to low cardinality text column?
@gview There is no intention to imply that indexes are somehow without cost. Indexes, of course, require space to exist and resources to maintain. The example is an attempt to dispel the pervasive myth that low cardinality indexes in MySQL are not worth their cost because the optimizer won't use them... and for exactly that reason, it is a deliberately extreme example, with an index "less useful" than OP's question contemplates. Yes, indexes consume space in the InnoDB buffer pool, but that memory is not shared with the query cache, which is the only place MySQL caches actual result sets.
Jun
24
comment DB Schema design : single table with more columns vs multiple tables with fewer colomns
...Or indexes, covering indexes, index scans?
Jun
23
comment MySQL trigger after insert with insert and delete instructions does not work properly
@RickJames there shouldn't be: NOW() returns a constant time that indicates the time at which the statement began to execute. (Within a stored function or trigger, NOW() returns the time at which the function or triggering statement began to execute.) This differs from the behavior for SYSDATE(), which returns the exact time at which it executes.
Jun
23
comment Mysql Replication - How it works offline?
You can create additional tables on a slave server without causing a problem, as long as there are no conflicting table names, and you never modify the replicated tables directly on the slave. You could use the MySQL event scheduler (again, only on the replica) to populate the tables. It's not entirely clear what you are trying to accomplish but it sounds viable.
Jun
20
comment Killing a process without login to MySQL
It does nothing of the sort. It's harmless, but all it does is clear the host cache, primarily used to relieve the condition where a host is being denied access because of too many errors ... Not too many connections. dev.mysql.com/doc/refman/5.6/en/flush.html