If you're attending the Oracle Open World 11, come hear me talking about pluggable authentication and developments around it (and if you're not attending here's one more good reason why you should :) ).

The current what/when/where for my talk are :

There's also a MySQL community reception were you'll find most of the mysql experts attending Oracle OpenWorld. …

Free MySQL learning Part II from Oracle University

Register now!

Free MySQL learning Part II from Oracle University

Register now!

In our last episode we were able to select some information from our bookshop database, this time we look at putting this into some semblence of order.  To fully investigate this topic we need a few more entries in our database, so rather than detail them here, I've put together this SQL file you can download and build your database to follow along.

To install the database, unpack the SQL file from its ZIP archive, and use the SOURCE command to pull the data into your database:

SOURCE mysql101_bookshop_20110912.sql;

You can also pass the file to the mysql command line interpreter from the shell:

mysql -uroot -p bookshop < …

Backing up data is critical for production databases – and there are a lot of well-known solutions for backing up databases.

When the database is sharded, backing up data becomes problematic. If the backup is not synchronized across all shards, data inconsistency might occur. In this blog post I’ll try to detail the possible backup scenarios for sharded databases when using ScaleBase.

Backup Types

Let’s start by understanding the different backup types that are out there. You can read all about it here.

A physical backup involves copying all database files to a different location. Copying can take several hours for a decent database if it’s done to a disk or a tape. It might take only seconds if the database files reside on SAN/NAS storage hardware that supports snapshot technology.

A logical backup is a …

Patrick Hurley will be delivering a webinar entitled “MySQL: The Least an Oracle Professional Needs to Know” tomorrow at 12.00 pm EST for the ODTUG (Oracle Development Tools User Group).

I met Patrick a few months ago at an Oracle User Group seminar where he delivered his presentation, and I recommend it to Oracle DBAs who would like to get going with MySQL.

Here is the abstract:

“This talk is an introduction to the MySQL database, particularly for Oracle professionals. Patrick will give an overview of its architecture and concepts. He will describe and demonstrate many MySQL administrative tasks, including installation, database creation, backup, and recovery. Patrick will finish by showing how relatively easy it is to set up replication between two MySQL databases.”

Register Now!

Patrick Hurley will be delivering a webinar entitled “MySQL: The Least an Oracle Professional Needs to Know” tomorrow at 12.00 pm EST for the ODTUG (Oracle Development Tools User Group).

I met Patrick a few months ago at an Oracle User Group seminar where he delivered his presentation, and I recommend it to Oracle DBAs who would like to get going with MySQL.

Here is the abstract:

“This talk is an introduction to the MySQL database, particularly for Oracle professionals. Patrick will give an overview of its architecture and concepts. He will describe and demonstrate many MySQL administrative tasks, including installation, database creation, backup, and recovery. Patrick will finish by showing how relatively easy it is to set up replication between two MySQL databases.”

Register Now!

If you're attending the Oracle Open World 11, come hear me talking about pluggable authentication and developments around it (and if you're not attending here's one more good reason why you should :) ).

The current what/when/where for my talk are :

There's also a MySQL community reception were you'll find most of the mysql experts attending Oracle OpenWorld. …

1. Apache and MySQL Logging with Syslog-ng
This article shows how to use the popular system logging tool Syslog-ng to log Apache and MySQL events. Apache does not log via syslog-ng by default so we go over two methods of easily remedying this. We also show how to use SQL queries to view syslog-ng data.

2. Using M3 to take System Monitors to the Next Level
Monitis provides built in functionality to monitor a wide variety of system statistics as well as the ability to create custom system monitors. Monitis Monitor Manager, or M3 for short, allows you to take these custom monitors …

Isn’t that that time of the year again? Yes, it is — it’s time for our annual Oracle Bloggers Meetup and of course Oracle is piggybacking OpenWorld with the meetup again! ;) What: Oracle Bloggers Meetup 2011 When: Wed, 5-Oct-2011, 5:00pm Where: Main Dining Room, Jillian’s Billiards @ Metreon, 101 Fourth Street, San Francisco, CA [...]