Mozilla has a great presence at SCALE11x, the 11th Annual Southern California Linux Expo. This annual conference is completely volunteer run and one of the best Linux conferences around. Mozilla sponsored Friday’s DevOps Day LA and were part of the selection committee for MySQL Community Day.

See Firefox OS phones
Want to see a FirefoxOS mobile phone in action? Want to learn how to write apps for FirefoxOS? Come visit us at booth #14 and we will show you the phones and how to write a great app.

Giveaways
Also at booth #14, we are giving away swag! Get the traditional Firefox logo sticker or the new blue rocketship …

This month is a special month. It’s not because of President’s Day or even the exciting day where we revel in groundhogs. No, this month is special because the free book give-away is happening again. This is where you, the reader, gets to win something free for doing nothing more than posting a comment saying that you want a copy of my recently published book – The InnoDB Quick Reference Guide from Packt Publishing. The book is a great reference for DBAs, PHP, Python, or Perl programmers that integrate with MySQL and want to learn more about the InnoDB database engine.

So, all you have to do is post a comment here saying that you want a copy and write out a single (or more) sentence about how you use InnoDB in your development or production environment. At the end of the month two readers will be chosen via a random list sorting script that …

PalominoDB is looking for good people for the following positions:  Mid-level and senior MySQL DBAs in US, Asia/Pacific, and Europe, Devops engineers in US, Asia/Pacific and Europe, and BI architects and engineers.  Technologies are MySQL, Postgres, Cassandra, Couchbase, HBase/Hadoop, Amazon Web Services, Chef, Puppet, Ansible and most monitoring/trending solutions. We support open-source software, have a non-profit program and work virtually so you can work from anywhere.  If you know someone that might be interested, please do pass this along to them. Contact us today!

PalominoDB is looking for good people for the following positions:  Mid-level and senior MySQL DBAs in US, Asia/Pacific, and Europe, Devops engineers in US, Asia/Pacific and Europe, and BI architects and engineers.  Technologies are MySQL, Postgres, Cassandra, Couchbase, HBase/Hadoop, Amazon Web Services, Chef, Puppet, Ansible and most monitoring/trending solutions. We support open-source software, have a non-profit program and work virtually so you can work from anywhere.  If you know someone that might be interested, please do pass this along to them. Contact us today!

A few weeks ago, I made a presentation with the above title at FOSDEM in Brussels. My slides can be found here. The MySQL and Friends devroom had many interesting presentations and the room was full for most of them.

Send to Kindle

Hi guys, Early February Oracle released the new version of MySQL named 5.6, one of the enhancements is the GTID (Global Transaction ID)

GTID is an unique identifier which will be added at each transaction, and will be very useful on the slave. remember before we needed to set MASTER_LOG_FILE and MASTER_LOG_POS, now we don’t need them anymore.

Let’s see some new variables which we need to add to our cnf file:
gtid-mode : It will enable GTID, in order to this function work, we need to turn on log-bin and log-slave-updates
enforce-gtid-consistency : It will guarantee that only allowed command will be executed ( more information here)

Basicly, is only this what we need to enable GTID, for this tutorial I will …

When evaluating a MySQL system one of the first things to look at is the MySQL error log. This is defined by the log[_-]error variable in the MySQL Configuration file. Generally found like:

grep log.error /etc/my.cnf
log_error=/var/lib/mysql/logs/mysql_error_log
log-error=/var/lib/mysql/logs/mysql_error_log

It is possible to find multiple rows because this could be defined in the [mysqld] and [mysqld_safe] sections. It is also possible it is incorrectly defined twice in any given section.

Immediately I see a problem here, and the following describes why. If you look at this file name, in this case it’s actually found, but the file is empty.

$ ls -l /var/lib/mysql/logs/mysql_error_log
-rw-r----- 1 mysql mysql 0 Feb 19 20:35 /var/lib/mysql/logs/mysql_error_log

An error log should never exist and be empty, because starting the instance producing messages. An error log could be empty because the system does …

Oracle, MySQL, and SQL Server bloggers are not only sharing their knowledge through their blogs, moreover, they are also learning about themselves. Their posts are cementing their concepts, while opening vistas of new notions. This Log Buffer Edition is yet another vista for their blogs.

Oracle:

Where is Oracle Block Change Tracking today? World’s leading Oracle expert Alex Gorbachev answers.

Marcin Przepiorowski is asking: Oracle on AIX – where’s my cpu time?

Kyle Hailey is monitoring Oracle I/O latency.

How EBS Concurrent Processing should run on Oracle RAC? Pythian’s own …

MySQL 5.6 is believed to be the best MySQL release ever. In order to find out if it is true or not I ran some benchmarks and I am going to share the results with you in this tutorial. Please note that I only tested with default settings (in both cases) and using sysbench as a benchmarking tool, so its a pretty basic test. I highly recommend that you test on your particular workload before upgrading and share your results.

This morning I was planning to check the integrity of a snapshot of a MySQL database that runs on EC2 using EBS, and I accidentally stumbled upon a fast way to quickly find certain types of problems with a backup.

My plan was to use CHECK TABLE on all of the tables to verify the integrity of the backup. The simplest way to run CHECK TABLES on an entire database is like this:

mysqlcheck -c --all-databases

Rather than using that command, I decided to generate a bunch of individual CHECK TABLE statements dynamically by running a query on the information_schema.tables table. Why do it that way? It gives me the flexibility to check a specific schema first, or check the smallest or most frequently updated tables first, etc.

So I ran this command to generate my CHECK TABLE script:

select concat('check table ', table_schema, …