Databases
Not a cool new feature for Master_Host
I was surprised to find on a customer MySQL server this new syntax for Master_host in SHOW SLAVE STATUS. mysql> SHOW SLAVE STATUSG *************************** 1. row *************************** Slave_IO_State: Connecting to master Master_Host: testdb1.
Read moreInstalling MySQL MHA with Percona Server
MySQL MHA by Oracle ACE Director Yoshinori Matsunobu is an excellent open source tool to help in providing HA with native MySQL replication. The installation however is dependent on some Perl packages and to the untrained eye this may be an issue if you are using Percona Server as your choice of MySQL implementation.
Read moreSQLSTATE[HY000]: General error: 2006 MySQL server has gone away
This would have to be one of the most common MySQL error messages that is misleading to the end user developer. The MySQL Manual page confirms the broad range of possible conditions, but offers little to a PHP developer that does not speak MySQL Geek.
Read moreOpen Source Database Schemas
I am seeking the help of the community. I am working on an evaluation project about schema design in open source applications. While it’s possible for me to download the software of many popular apps, and install the software and then do a mysqldump, it takes time.
Read moreControlled failover simplicity with MySQL
As part of a recent engagement, I described the relative products to manage a MySQL pair (i.e. an Active/Passive MySQL masters configuration). This included the steps to undertake a controlled failover for supporting software maintenance using manual procedures.
Read moreJoining the Continuent Team
This month I have joined the team at Continuent . No stranger to the MySQL ecosystem, Continuent provides replication and clustering technology for managing data between MySQL, Oracle, PostgreSQL, Vertica and a growing list of data stores.
Read moreLooking for MySQL 4.1
I had need today to download a version of MySQL 4.1 to test something. The MySQL Developer Zone archives no longer provides any software before 5.0. While this may have long reached EOL and is no longer support, customers still do run this version of MySQL.
Read moreSPOF Internet
SPOF (i.e. Single Point of Failure) is the bane for technologists. Avoiding SPOF generally requires redundancy, and redundancy has a cost, often more then a business is prepared to pay. In the database field, I see this regularly and advise clients on how to improve availability and potential avoid disasters that can affect their business.
Read moreMySQL client password security
In case you missed it, MySQL 5.6.6, also known as Milestone 9, was recently released. I have yet to install this, however just one part of the MySQL 5.6.6 Release Notes makes placing installing and testing high on my TODO list.
Read moreWhen is a crashing MySQL bug not a bug?
Answer: When Oracle acknowledges the bug in 5.5.25 (to the owner only), corrects the bug in 5.5.27 (to the owner only), yet hides all information of its existence. Recently a colleague and good friend discovered a bug in MySQL 5.
Read moreRecent Presentations in Cali, Colombia
On July 4 I gave two presentations at the OTN Tour Day, and on July 5 I have three presentations at the MySQL Training Days. This was my 3rd visit to Colombia and it was great to see a receptive audience.
Read moreVideo interviews at OTN Colombia
The following are short interviews from the Oracle Technology Network (OTN) event in Cali, Colombia. One with myself and another with Sheeri Cabral . These Videos are sourced from OTN Tour Latin America 2012 .
Read moreNew security fixes for MySQL reported
6 new security fixes for Oracle MySQL have been detailed in the most current Oracle Critical Patch Update (CPU). These are: CVE-2012-1735 (5.5.23 and earlier) CVE-2012-0540 (5.1.62 and earlier, 5.5.23 and earlier) CVE-2012-1757 (5.
Read moreI will be speaking at Percona Live New York
Percona is back for a second New York Percona Live Conference . As the resident New York MySQL Expert , I will again be presenting. My session will be on MySQL Backup and Recovery Essentials .
Read more