Tag: MySQL

Database Platform Migration — Webinar in Australia

I’m excited to announce that Paul Vallée, Pythian Founder and Executive Chairman, will be on-the-air online this week with a free webinar — Database Platform Migration: when is it strategically appropriate to migrate existing applications to an open-source platform? It’s based on our 10+ years experience supporting proprietary databases, such as Oracle and SQL Server, and open-source MySQL databases on the other hand and what we learned on the numerous migrations.

Read More >

Log Buffer #141: A Carnival of the Vanities for DBAs

Welcome to the 141st edition of Log Buffer, the weekly review of database blogs. The Oracle bloggers were especially chatty this week, so let’s start with them.

Read More >

Log Buffer #140: A Carnival of the Vanities for DBAs

This is the 140th edition of Log Buffer, the weekly review of database blogs. Welcome.

Read More >

How To Access MySQL from Oracle With ODBC and SQL

The Oracle gateway for ODBC provides an almost seamless data integration between Oracle and other RDBMS. I won’t argue about its performance, limits, or relevance. It serves a few purposes; set it up and you’ll be able, for example, to create database links between Oracle and MySQL. This post is intended to share some tips related to the setup of the Oracle Gateway for ODBC with MySQL Connector ODBC on Linux.

Read More >

Log Buffer #139: A Carnival of the Vanities for DBAs

Welcome to the 139th edition of Log Buffer, the weekly review of database blogs. Let us begin with a look at the best from the Oracle ‘sphere.

Read More >

Log Buffer #138: A Carnival of the Vanities for DBAs

Welcome to the 138th edition of Log Buffer, the weekly review of database blogs.

Read More >

InnoDB Hot Backup Utility Bug

If you are using InnoDB Hot Backup utility and the innobackup.pl wrapper script, be very careful if you are not running backups under the system mysql user. There is a bug which causes InnoDB Hot Backup to sometimes report a successful backup when it actually failed.

Read More >

Log Buffer #136: A Carnival of the Vanities for DBAs

This is the 136th edition of Log Buffer, the weekly review of database blogs. Welcome.

Read More >

Twitter — Tracking Production Actions?

don’t want to post the link to this (perhaps, it was left public unintentional?) but here is what I stumbled upon recently. This is a log of production maintenance of IT systems in Perth, Western Australia (as far as I could say): Good idea but shouldn’t companies keep this sort of information private?

Read More >

DBA_OBJECTS View for MySQL

Sometimes a client asks us to change the datatype of a column, but forgets to mention the schema name, and sometimes even the table name. As you can imagine, having this kind of information is vital to locate the object and perform the requested action. This kind of behaviour must be related to Murphy’s Law. In any case, I’d like to share with you a simple stored procedure that has helped us a lot in the past.

Read More >
Page 47 of 65« First Page...10...4546474849...60...Last Page »