Ideas, releases, practical guides, and perspectives from the people building with MySQL.
JP just wrote in to let me know that the T-Dose 2008 CFP has been extended. So there is still time to send in your abstracts
Oh right .. I was expecting to much from you folks.
So lemme translate, Jean-Paul Saman, one of the T-Dose organizers, wrote me this morning to let the world know that he is still accepting proposals for talks at T-Dose , The Technical Dutch Open Source Event which will take place on 25 and 26 October 2008 at the …
[Read more]JP just wrote in to let me know that the T-Dose 2008 CFP has been extended. So there is still time to send in your abstracts
Oh right .. I was expecting to much from you folks.
So lemme translate, Jean-Paul Saman, one of the T-Dose organizers, wrote me this morning to let the world know that he is still accepting proposals for talks at T-Dose , The Technical Dutch Open Source Event which will take place on 25 and 26 October 2008 at the …
[Read more]In a lot of environments.
Peter gives a nice overview why you don't always need to invest in big fat redundant hardware.
We've tackled the topic last year already ..
Now I often get weird looks when I dare to mention that Raid is obsolete ..people fail to hear the "in a lot of environments"
Obviously the catch is in the second part, you won't be doing this for your small shop around the corner with just one machine. You'll only be doing this in an environment where you can work with a redundant array of inexpensive disks. Not with a server that has to sit in a remote and isolated location.
Next to that there are situations where you will be using raid, but not for redundancy, but for disk throughput.
The following maintenance jobs are typically run against a MySQL database:
Backup
A backup is not a typical maintenance job. But it behaves more or less like one. The backup should be done regularly depending on the restore/PITR (Point in Time Recovery) requirements.
Make sure, that in the backup all the necessary files (data files, transaction log files, configuration files and binary log files) are included. To prove that the backup process is working properly a regular restore should be performed. This can ideally be combined with the set-up of new database instances for developers or testing.
Clean-up the binary logs
The binary logs can be cleaned-up in two ways:
a) Passive by MySQL itself:
# my.cnf expire_logs_days = …[Read more]
Sun Microsystems founder and chairman talks about his current role and what keeps him and Andy Bechtolsheim engaged at Sun READ MORE
I am about to tackle updating the MySQL
Certification Web Pages and need some help. The site needs a
good cleaning, dusting, a little paint, and some re decorating.
Please feel free to add your input.
The pages need to be streamlined to make it easier for candidates
to find information about MySQL Certification. The promotion of
MySQL certifications to recruiters, hiring managers, and
personnel departments is one of my goals. And I want to start
more of a community for those with certifications.
So I am going through my 'to-do' list, the emailed gripes, and
all the other suggestions. But I am offering you a chance to add
thoughts.
--
No North Texas MySQL Meetup with Labor Day next Monday.
--
I just returned from a week in Edinburgh with the MySQL trainers,
ciriculum developers, and the folks …
The following maintenance jobs are typically run against a MySQL database:
“Backup”
Clean-up binary logs.
Optimize tables
Purge query cache
Rotate binary logs
Backup
A backup is not a typical maintenance job. But it behaves more or less like one. The backup should be done regularly depending on the restore/PITR (Point in Time Recovery) requirements.
Make sure, that in the backup all the necessary files (data
files, transaction log files, configuration files and binary log
files) are included. To prove that the backup process is working
properly a regular restore should be performed. This can ideally
be combined with the set-up of new database instances for
developers or testing.
Clean-up the binary logs
…
[Read more]
Are you in Canberra/ACT, and are you an experienced DBA
needing to tune InnoDB? Or do you just maintain some MySQL
instances on the side and need to know more about proper
installation, security and backup/recovery methods?
Well... the upcoming Open Query course days in Canberra still have a few seats left. No, it's not
"nearly full" but it's not empty either. And yes, I know that
Sun/MySQL recently cancelled a DBA training week in Canberra at
the last minute (they also scheduled it close to the last minute
to begin with ;-) however these Open Query days are definitely
going ahead. The topics:
I just finished some testing of the latest MySQL alpha (6.0.6) and focused on the additions put into the new backup/restore utility that will be in 6.0. If you’re not familiar with it, I’d encourage you to check out a new article that I wrote that will take you through what the new backup is all about. The thing people are most excited about is being able to do online backups for MyISAM databases (where online = non-blocking for DML operations; you can also do non-blocking backups for transaction engines that support consistent snapshot). But I also saw faster backups with the new utility as well as much faster restores, and I’m interested to know if those of you testing 6.0 are seeing the same things?
If you haven’t downloaded and given the new backup a test drive, I’d encourage you to do so - you can …
[Read more]|
|
|
Thanks to all who attended my talks at FrOSCon 2008. It was a
pleasurable experience, as it has always been in the past.
The slides of my two sessions are published in the MySQL Presentation Repository