(Frederic Descamps) In the first post in a series on MariaDB features we find interesting, we begin with selectively skipping replication of binlog events. This feature is available on MariaDB 5.5 and 10.
Tag: Open Source
MySQL: InnoDB transactions, a practical example
(Jan Brinkmann) Only the MySQL storage engine InnoDB supports transactions. A major benefit of transactions is that it’s possible to roll back changes until a transaction is committed.
Examining the TokuDB MySQL storage engine file structure
(Peter Zaitsev) As we know different storage engines in MySQL have different file structures. Every table in MySQL 5.6 must have a .frm file in the database directory matching the table name. But where the rest of the data resides depends on the storage engine.
Using Innodb_large_prefix to Avoid ERROR 1071
(Ike Walker) If you’ve ever tried to add an index that includes a long varchar column to an InnoDB table in MySQL, you may have seen this error:
Prevent MySQL downtime: Set max_user_connections
(Peter Zaitsev) One of the common causes of downtime with MySQL is running out of connections. Have you ever seen this error? “ERROR 1040 (00000): Too many connections.” If you’re working with MySQL long enough you surely have.
Replacing Pt-slave-delay With MASTER_DELAY in MySQL 5.6
(Ike Walker) In the past I have used pt-slave-delay when I want to maintain an intentionally delayed replica. Now that I have upgraded to MySQL 5.6 I am switching over to use MASTER_DELAY, which is a built-in feature that does the same thing.
What I learned while migrating a customer MySQL installation to Amazon RDS
(Michael Coburn) Hi, I recently had the experience of assisting with a migration of a customer MySQL installation to Amazon RDS (Relational Database Service). Amazon RDS is a great platform for hosting your MySQL installation and offers the following list of pros and cons:
Multisource Replication: How to resolve the schema name conflicts
(Daniel Bartholomew) MariaDB 10.0 has introduced the functionality to replicate data from more than one Master server. This is what many have been waiting for, especially those who do business intelligence analysis, aggregation and reporting on data coming from different and sometimes related applic
Some MySQL security tips
(Shlomi Noach) This is a brief list of security tips for MySQL. It is by no means complete.
Prewarm your EBS backed EC2 MySQL slaves
(Paul Moen) This is the story of cold blocks and mismatched instances and how they will cause you pain and cost you money until you understand why.