Description
DRBD is a high-availability solution for MySQL that combines MySQL, Linux Heartbeat and Distributed Replicated Block Device (DRBD) for a hot-standby solution that synchronously replicates MySQL data between the primary and secondary server.
The key benefit of DRBD over replication is that it enforces data synchronization between the primary and secondary machine, ensuring that the secondary […]
Definition
Error 1045 is returned when a user is denied permission to connect to the MySQL server.
Sample
[localhost]$ mysql
ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: NO)
Resolution
If the message ends with ‘(using password: NO)’, no password was specified while connecting. Add -p to the call to the mysql client:
mysql -p
If the username in […]
Definition
The SQL_CALC_FOUND_ROWS keyword is used when the result set of a query will be restricted by a LIMIT clause, instructing the MySQL server to store the number of rows that would have been returned had the result set not been restricted. The stored value is exposed through the FOUND_ROWS() function.
Sample
In this example, we first produce […]
Description
Proven Scaling is a MySQL consulting company founded by Jeremy Cole and Eric Bergen. Jeremy and Eric both formerly worked at Yahoo! and Jeremy was previously over training at MySQL AB.
Proven Scaling provides a variety of services from performance consulting to training and is located in the United States.
Further Reference
Proven Scaling
Jeremy Cole’s blog
Eric Bergen’s blog