OurSQL Episode 153: Tooling Around, Part 3

This week we continue our series on MySQL Utilities, talking about replication and failover tools. Ear Candy is a gotcha with poor GRANT syntax that MySQL does not give warnings about, and At the Movies is an open forum from the SkySQL Solutions Day a few months ago.

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 4 of MySQL Utilities
Part 5 of MySQL Utilities

MySQL Utilities part 3
mysqlfailover
screen Unix utility
MySQL Master HA from Yoshinori Matsunobu

mysqlrpladmin
mysqlreplicate

Ear Candy
GRANT

GRANT CREATE ON testdb.* TO iibench@localhost;
Query OK, 0 rows affected (0.14 sec)

In MySQL 5.6 and MariaDB 5.5, this works properly:

mysql> SHOW GRANTS FOR iibench@localhost;
+-----------------------------------------------------+
| Grants for iibench@localhost                        |
+-----------------------------------------------------+
| GRANT USAGE ON *.* TO 'iibench'@'localhost'         |
| GRANT CREATE ON `testdb`.* TO 'iibench'@'localhost' |
+-----------------------------------------------------+
2 rows in set (0.01 sec)

However, on some versions of MySQL, it does not work, and you must do:
GRANT CREATE ON *.* TO iibench@localhost;

At the Movies
This week in At the Movies, we present An open forum hosted by SkySQL's Marc Sherwood and featuring the speakers from the SkySQL and MariaDB Solutions Day 2013, reflecting on the event and fielding questions from the audience.

Where you can see us
We will both be speaking at
MySQL Connect in San Francisco from Saturday September 21st - Monday September 23rd.

Sheeri will be at the Nagios World 2013 Conference in St. Paul, Minnesota on Monday, September 30th through Thursday, October 3rd.

Sheeri will also be at the Mozilla Summit at the Brussels location, Friday, October 4th through Sunday October 6th.

Gerry will be at the 2nd MySQL, NoSQL and Cloud Conference & Expo Monday, October 14th through Wednesday October 16th, 2013 in Buenos Aires, Argentina.

Sheeri will be at the October Boston User Group meeting on Monday, October 14th at 7 pm.

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast

Trackback URL for this post:

http://technocation.org/trackback/1258