In July I wrote a blog post MySQL community counseling: talking about your feelings. It was triggered by an earlier blog post and followup threads on Google plus by Monty Taylor, Andrew Hutchings, etc... (everyone involved in that outburst have apologized and moved on long ago). I wanted to use that opportunity to highlight what I call our hidden trauma related to the Oracle acquisition of Sun, things that I still hear being discussed today, 2 years later, and things that I consider unresolved or unsolved that I see causing friction and misunderstandings - the kind of which that outburst too represented. Both before and after writing it I wondered if it was a good idea to publish it - I wondered whether I would be seen as helping to solve the problem or just contributing to it. I actually got some positive feedback about it, …
[Read more]Installing MySQL Administrator Tool To Connect To Remote Databases
This tutorial provides step-by-step instructions on how to install MySQL Admin tool on an Ubuntu 11.04 system and how to connect to a remote host with it. This should also work on most Debian based operating systems.
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 :
| Session ID | 19181 |
| Session Title | MySQL Authentication Options |
| Venue / Room | Marriott Marquis - Golden Gate B |
| Date and Time | 10/3/11, 11:00 |
There's also a MySQL community reception were you'll find most of the mysql experts attending Oracle OpenWorld. …
[Read more]Free MySQL learning Part II from Oracle University
Free MySQL learning Part II from Oracle University
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 < …[Read more]
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 …
[Read more]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.”
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.”
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 :
| Session ID | 19181 |
| Session Title | MySQL Authentication Options |
| Venue / Room | Marriott Marquis - Golden Gate B |
| Date and Time | 10/3/11, 11:00 |
There's also a MySQL community reception were you'll find most of the mysql experts attending Oracle OpenWorld. …
[Read more]