(Stephane Combaudon) Even if you are using a GUI tool to connect to your MySQL servers, one day or another, you will have to deal with the command line. So it is nice to know a few tips that can really make your work easier.
Tag: Open Source
Galera features beyond just HA
(Anders Karlsson) Galera from codership has been getting a lot of attention recently. Galera provides a nice High Availability solution for MySQL where Galera provides synchronous replication with conflict detection using the classic InnoDB Storage Engine.
Nulls Make Things Easier?
(Bruce Momjian) Sql nulls were designed to simplify modeling the real world in relational databases, but the debate about their usefulness has never been resolved. Specifically, nulls were designed to represent:
Bypass TRIGGERS
(peter_laursen) The content here is not new. I have written about same before many years ago (I think in our old Blog system that is now offline for 4+ years). But I feel like to restate my point of view after listening to the latest OurSQL Episode. I was a little excited if Sheeri and Gerry would
How to STOP SLAVE on Amazon RDS read replica
(Aurimas Mikalauskas) We are doing a migration from Amazon RDS to EC2 with a customer. This, unfortunately, involves some downtime – if you are an RDS user, you probably know you can’t replicate an RDS instance to an external server (or even EC2). While it is annoying, this post isn’t going to be a
SFTP virtual users with ProFTPD and Rails: Part 1
(Brian Gadoury) I recently worked on a Rails 3.2 project that used the sweet PLupload JavaScript/Flash upload tool to upload files to the web app. To make it easier for users to upload large and/or remote files to the app, we also wanted to let them upload via SFTP.
Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
(Frederic Descamps) How easy is it to identify and debug Percona XtraDB Cluster replication problem ?
Favorite MySQL 5.6 features: an optimizer perspective
(Jørgen Løland) There are so many exciting new features in MySQL 5.6 that I almost don’t know where to start. To mention a few, MySQL’s multi-core scalability has been significantly improved to meet modern hardware, InnoDB has better index statistics, much better performance, and online ALTER, repli
Some sharding support and cache locality optimization support for PHP MySQL driver
(Ulf Wendel) It is time for christmas presents: some sharding support and cache locality optimizations are coming with PECL/mysqlnd_ms 1.5. PECL/mysqlnd_ms is a plugin for the mysqlnd library. The plugin adds replication and load balancing support to any PHP MySQL API (mysql, mysqli, PDO_MySQL) if c
Is your backup complete? – backup MySQL users privileges / grants – pt-show-grants
(Kedar) Everybody knows the criticality of backup. You might have had your database dumped, data directory copied, flat files exported and even config and binary log files backed-up. But did you backup your MySQL user privileges?
