MySQL

Last Day at PalominoDB

I have been the Community Liaison and a Senior DBA at PalominoDB for 15 months, and doing remote DBA work for 4 years.  In that time I have learned that “consultant” need not be a dirty word, and that in the DBA world it is actually extremely valuable to have a remote DBA with lots…

Rails and Database Session Variables

Ruby’s ActiveRecord provides a very robust means of manipulating database table structures especially in the context of automated deployments such as Capistrano. When there is a master-slave database configuration, it may not always be prudent to perform DDL statements on the master and let those propagate through to the slave, especially in high-volume sites where…

New England Database Summit

The New England Database Summit is an all day conference-style event where participants from the research community and industry in the New England area can come together to present ideas and discuss their research and experiences working with on data-related problems.  It is an academic conference with applications to real life, and includes any type…

Non-deterministic Functions and the Binary Log

I wrote this post because I ran across this issue when debugging why tables with triggers/functions that were not getting replicated to slaves. The problem appears when binlog_format is set up  as STATEMENT. You can check the ‘change log’ checking the following link for more information about default values [1]. If you have non-deterministic functions…

Log Buffer #245, A Carnival of the Vanities for DBAs

Getting stuck on technical problems is a norm in the life of any IT professional and DBAs are no exception. With evolving databases and their streaming new features make it more challenging. Blogs often provide the Eureka moment for those problems. So sit back and enjoy this Log Buffer Edition, which is Log Buffer #245.

Log Buffer #244, A Carnival of the Vanities for DBAs

Managing the databases of any kind of any size in the production environment requires the administrators to remain up to date and on the toes every time. They need to learn fast and apply their knowledge fast. Keeping abreast of the newer features and the troubleshooting techniques is must for them and this Log Buffer Edition helps easing that task. Enjoy the Log Buffer #244.

How to recreate an InnoDB table after the tablespace has been removed

Does your error log ever get flooded with errors like this one? [ERROR] MySQL is trying to open a table handle but the .ibd file for table my_schema/my_logging_table doesnot exist. Have you deleted the .ibd file from thedatabase directory under the MySQL datadir, or have you used DISCARD TABLESPACE? See http://dev.mysql.com/doc/refman/5.0/en/innodb-troubleshooting.html how you can resolve…

Announcing PalominoDB’s Non Profit Program

I’ve always had a dream of being able to use what we are doing at PalominoDB not only for our for profit clients, but for those who go out day to day helping those who need it.  We always try to work with clients who make people’s lives better, but there are those whose entire…

Getting a List of Users From the MySQL General Log

From time to time, organizations want to know if there are any users that are not used. For clients using MySQL 5.1 and up, that can handle a 1% overhead for general logging, we will enable the general log for a period of time and analyze the users that connect. Note: we have some extremely…

Page 21 of 85« First Page...10...1920212223...30...Last Page »