Tag: MySQL

Using HAProxy for MySQL failovers

There are a number of solutions available for MySQL architecture that provide automatic failover, but the vast majority involve potentially significant and complex changes to existing configurations. Fortunately, HAProxy can be leveraged for this purpose with a minimum of impact…

Read More >

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

Thanksgiving is here and the circular chain of thankfulness is going on. Clients are thankful that they have applications, applications are thankful to their databases, database are thankful to their DBAs, and DBAs are thankful to clients. And they all are thankful that there is weekly Log Buffer Edition, of which the latest is Log Buffer #247. :)

Read More >

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…

Read More >

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

Administrators across the database technologies find themselves at the center stage of that and they are sharing tips and tricks regarding that in their blogs. This Log Buffer Edition touches that and much more in Log Buffer #246.

Read More >

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…

Read More >

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.

Read More >

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.

Read More >

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…

Read More >

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

From Percona Live, London to TechEd Australia to Oracle Open World USA, the blogosphere of Oracle, MySQL, SQL Server and the related technologies is bustling with the eye witness accounts of these conferences, technical overviews, observations, predictions, and much more. This Log Buffer Edition covers all that and as usual more in Log Buffer #243.

Read More >

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

Whenever Oracle Open World ends, it not only leaves the technology professionals in awe and full of pride, it also makes them come up with new and great blogging ideras and this Log Buffer Edition covers that flowing notions from bloggers across the Oracle and MySQL beauties, in addition to SQL Server in Log Buffer #242.

Read More >
Page 26 of 64« First Page...10...2425262728...40...Last Page »