October 1, 2013 By Severalnines

Database vendors regularly issue critical patch updates to address software bugs or known vulnerabilities, but for a variety of reasons, organizations are often unable to install them in a timely manner, if at all. Evidence suggests that companies are actually getting worse at patching databases, with an increased number violating compliance standards and governance policies1.

Patching that require database downtime would be of extreme concern in a 24*7 environment, however most cluster upgrades can be performed online. ClusterControl performs a rolling upgrade of the cluster, upgrading and restarting one node at a time. The logical upgrade steps might slightly differ between the different cluster types. 

Upgrading your Database

In this post, …

MySQL DBAs know that integrating MySQL and a big data solution can be challenging. That’s why I invite you to join me this Wednesday (Oct. 2) at 10 a.m. Pacific time for a free webinar in which I’ll walk you through how to implement a successful big data strategy with Apache Hadoop and MySQL. This webinar is specifically tailored for MySQL DBAs and developers (or any person with a previous MySQL experience) who wants to know about how to use Apache Hadoop together with MySQL for Big Data.

The webinar is titled, “Implementing MySQL and Hadoop for Big Data,” and you can register here.

Storing Big Data in MySQL alone can be challenging:

• Single MySQL instance may not …

The 3rd season of MySQL Marinate begins October 1st! Join the meetup group and RSVP at season 3 to join! You can do the work on MySQL, or if you prefer, MariaDB or Percona.

If you do not have the book yet, you can still do the first week by using the online material from Browse Contents on the OReilly book page for Learning MySQL. There is homework for week 1, see the master list for all the information.

If you would like to learn MySQL from the ground up, consider joining us. This is for beginners If you have no experience with MySQL, or if you are a developer that wants to learn …

#DBHangOps 10/02/13 -- MySQL Utilities from Chuck Bell!

Thanks to everyone who came. Definitely check out the recording below!

Heyo everybody!

Coming up this Wednesday, October 2nd, 2013 at 12:00pm pacific (19:00 GMT) is another exciting #DBHangOps. Join the google hangout to discuss:

• MySQL Utilities from Chuck Bell!

As always, check out the #DBHangops twitter search, the DBHangops Twitter Feed, or this blog post to get a link for the google hangout on Wednesday!

Looking forward to to the discussion with all of ya!

Show Notes:

Check out Chuck Bell's slide deck:

Also be sure to check out Chuck's notes below to help you along!

Fabric Blogs

Here are some links to blogs, etc. on …

What’s up all, here every person is sharing these experience, therefore it’s nice to read this weblog, and I used to go to
see this website every day.

Table space fragmentation has generally 2 origins :

• File System fragmentation : the data file is spread physically on many non contiguous locations on the disk.
• Internal Fragmentation : the data and index pages have “holes” : this happens when  rows are deleted or updated, especially at random.

As a result, performance is affected by table space fragmentation. Data typically takes more space on disk and in memory. The disk is more busy than it should.

File System fragmentation can be detected using the filefrag command on Linux (and similar on different OS). When using MyISAM, MYI files are usually very fragmented on the FS, much more than the MYD files.

ls -al frag
total 883304
drwx------  2 aadant common      4096 Sep 30 18:41 .
drwxr-xr-x 17 aadant common      4096 Sep 30 18:59 ..
-rw-rw----  1 aadant common …

Here are examples comparing MySQL 5.6 against PostgreSQL 9.3 Core Distribution, where MySQL seems to comply with "standard SQL" more closely than PostgreSQL does. The examples are also true for MariaDB 10.0 so whenever I say "MySQL" I mean "MySQL and/or MariaDB". When I say "more closely" I do not mean that MySQL is completely compliant, or that PostgreSQL is completely non-compliant.

Identifiers

Example:

CREATE TABLE          ŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽ (s1 INT); /* 32-character name */
SELECT COUNT(*) FROM information_schema.tables
  WHERE table_name = 'ŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽŽ';
SELECT COUNT(*) FROM information_schema.tables
  WHERE table_name LIKE LOWER('Ž%');

Result:
PostgreSQL says count(*) is 0. MySQL says it's 1.
Reason:
(1) PostgreSQL maximum identifier length is 63 bytes; MySQL maximum identifier length is 64 …

MySQL Hot Backup Solution: Percona Xtrabackup.

http://krishcon.com/blogs/20131231/Xtrabackup-Setup-Hot-backup-solution-mysql

Tags: Percona Xtrabackuphot backupbackupCategory: MariaDBBackupMySQL

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera 5.5.33a. This is a Stable (GA) release. See the Release Notes and Changelog for detailed information on this release and the Galera section of the MariaDB Knowledge Base for general information about Galera Cluster.

Download MariaDB Galera 5.5.33a

Release Notes …

The upsert (or merge) is a useful statement in SQL, but the syntax in MySQL is not self evident. If you search the MySQL manual for "upsert" you'll probably get this page. If you search for "merge" you'll probably get the page on index merge optimization or the merge storage engine. None of those tell you how to do an upsert. Here's how I do it...

Say I want to execute an insert like this:

insert into sakila.actor (actor_id, first_name, last_name, last_update) values (50,'NATALIE','SMITH','2013-09-27 12:34:56');

But I don't know if a row with actor_id=50 already exists or not. If the row doesn't …