Tag: MySQL

MySQL 5.1 and InnoDB Hot Backup Gotcha

Recently while we were building a slave with a newer version of MySQL 5.1 from an InnoDB Hot backup an error occurred The problem is, in MySQL 5.1, it is possible to log the slow query log and general log to tables in the mysql schema. These tables are created by default as CSV tables for performance reasons, even if MySQL is set not to log to tables. CSV tables, however, are not copied as part of the InnoDB Hot Backup process, creating this error. Here is the fix to get the slave working

Read More >

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

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

Read More >

Sydney MySQL User Group meetup #9 — In-depth MySQL with Arjen Lentz

Arjen Lentz is in town doing his Sydney training program 7-Sep to 9-Sep and kindly agreed to drop by and talk about something interesting in the MySQL world – be it a technical topic or the state of the MySQL community eco-system.

Read More >

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

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

Read More >

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

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

Read More >

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

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

Read More >

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

Welcome to the 154th edition of Log Buffer, the weekly review of database blogs. Let’s dive right in, shall we?

Read More >

Database Analyst Steals Credit Card Data

This blog post was inspired by a recent report of a Database Analyst at American Express stealing Credit Card data. It’s amazing how many companies still follow a mainly “perimeter security” approach when it comes to controlling access to sensitive information—their focus is on network security using firewalls, advanced authentication options, and so on. Even with such measures, it’s very common to setup strong barriers to the outside world but very little by way of internal limits; most internal people have some level of access to servers that store and process sensitive data.

Read More >

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

This is the 153rd edition of Log Buffer, the weekly review of database blogs.

Read More >

Want to spend a weekend in Germany talking about Databases?

OpenSQL Camp will take place Saturday 22nd and Sunday 23rd of August, in St. Augustin, Germany, so it could do for a nice August getaway to Germany. It’s not really the biggest of cities, but then again, that is part of the charm, going to some small city and learning more about databases.
In case you do happen to be curious, feel free to check out the list of proposed sessions, although it is not complete, it does give a overview of what to expect.

Read More >
Page 43 of 65« First Page...10...4142434445...50...Last Page »