In On learning InnoDB: A journey to the core, I introduced the innodb_diagrams project to document the InnoDB internals, which provides the diagrams used in this post. Later on in A quick introduction to innodb_ruby I walked through installation and a few quick demos of the innodb_space command-line tool.
The physical structure of InnoDB’s INDEX pages was described in The physical structure of InnoDB index pages, and the logical structure was described in B+Tree …
[Read more]
I've created a graph about the MySQL version history.
It's mysql-graph-history on github.
Please let me know if this is correct or if I'm forgetting some
versions.
Update: Recording!
Finally, the end of year madness is over and we're in a fresh new year. That must mean it's time to get back into #DBHangops! Tune in on Wednesday, 1/16/13 at 5:00pm PST to get in on the fun and share your experiences.
Check back on this blog post tomorrow or check this twitter search to grab the link to join the Google Hangout.
Topics for this weeks hangout include: * triggers: maintenance, problems, etc. * Oracle MySQL utilities (similar to Percona toolkit) ** Slideshow of MySQL utilities * Database caching and cache expiration * InnoDB log file size ** …
[Read more]The authentic MySQL for Developers course will introduce you to tools used by MySQL development professionals and you get the opportunity to work through examples specific to Java and PHP development cases.
In this course you will learn to:
You can take this 5 day live-instructor course via these two delivery methods:
In May of last year I blogged about MariaDB 10.0 for the first time. We received some feedback, digested it, and I further explained MariaDB 10.0. Now, with the first Alpha of MariaDB 10.0 out and a new year just beginning, now is a good time to explain a little bit more, especially about MariaDB 10.0 and MySQL 5.6 as I and others in the MariaDB project get asked a lot about the differences between them.
First, here are some details as to why we didn’t just take MySQL 5.6 as a base and create something that would have been called MariaDB 5.6. These details haven’t been widely shared before:
Our customised training courses for the MySQL & MariaDB databases help your team learn exactly what they need to know
Since SkySQL’s inception, training has been an integral part of the services we provide. Training isn’t just something we offer, but an intrinsic aspect of our business model as we evolve into an all-inclusive service and product provider. And customized onsite training is the best way your team learns what your specific team needs to know.
Percona Live MySQL Conference and Expo 2013 – the largest MySQL Conference event of the year is getting close and we’re now announcing two community activities which are going to happen at this event.
Call of DotOrg Pavilion exhibitors is open – DotOrg pavilion is a free expo hall space for non commercial projects relevant for MySQL community. If you’re working on the project which you would like to get in front of a larger community but can’t afford expo hall exhibitor price tag because of non commercial nature of the project it is a great opportunity to do so. In the previous years participants included projects like …
[Read more]In a few hours I’m leaving for my “SouthEast Meetup Tour” first going to Charlotte where I’m speaking Today, Jan 14, about MySQL Indexing: Best practices on local MySQL Meetup and then going to Atlanta to give the same talk on Atlanta MySQL Meetup Jan 15th. If you’re in the area please come by, I’ll have some Books and T-shirts to give away!
The post Reminder: Speaking at MySQL Meetups in Charlotte and Atlanta today and tomorrow. appeared first on MySQL Performance Blog.
There have been a number of comments that Amazon RDS does
not allow users access to MySQL replication capabilities (for
example here and here). This is a pity. Replication is
one of the great strengths of MySQL and the lack of it is a
show-stopper for many users. As of the latest build
of Tungsten Replicator half of this problem
is on the way to being solved. You can now set up real-time
replication from an external MySQL master into an Amazon RDS
instance.
In the remainder of this article I will explain how to set up
Tungsten replication to an Amazon RDS slave, then add a few
thoughts …
How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on an Ubuntu 12.10 server.
