I think I have rpl_transaction_enabled working for MySQL 5.1 and will publish the patch after more testing. I hope to never port this again but that depends on whether the distribution I use provides an equivalent feature. Apparently people in operations enjoy not having to restore slaves after hardware and software crashes.
MySQL Reporting requirements sometimes require both unknown column and row values, necessitating a more powerful means of generating crosstabs. Today's article presents Prepared Statements, which dynamically generate the SQL and assign it to a variable so that we can tailor the output based on the number of data values.
Along with maximal possible fsync/sec it is interesting how different software RAID modes affects throughput on FusionIO cards.
In short conclusion, RAID10 modes really disappoint me, the detailed numbers to follow.
To get numbers I run sysbench fileio test with 16KB page size, random read and writes, 1 and 16 threads, O_DIRECT mode.
FusionIO cards are the same [...]
It is time to announce the next version of backup software from Percona - XtraBackup 1.1.
The list of changes in version 1.1 includes:
XtraBackup is built on a base of MySQL 5.1.44 with InnoDB plugin 1.0.6
Added --host option
tar4ibd can treat over 64GB file
tar4ibd is default method for stream, even tar is specified
the binary supports compressed [...]
As soon as we get couple FusionIO cards, there is question how to join them in single space for database. FusionIO does not provide any mirroring/stripping solutions and totally relies on OS tools there.
So for Linux we have software RAID and LVM, I tried to followup on my post
How many fsync / sec FusionIO can [...]
Did that ever happen to you in production?
[percona@sandbox msb_5_0_87]$ ./use
ERROR 1040 (00000): Too many connections
Just happened to one of our customers. Want to know what we did?
For demo purposes I'll use sandbox here (so the ./use is actually executing mysql cli). Oh and mind it is not a general-purpose best-practice, but rather a [...]
MySQL uses SQL for data and name-value pairs for configuration files. Cassandra uses XML for configuration files and something closer to name-value pairs for data (or name-value-value-... pairs). Why does it use a stronger data model for configuration than for data?
While I am writing this in jest I think this is an interesting question.