OurSQL Episode 155: Tooling Around, Part 5

In this episode, we finish our series about the MySQL Utilities. Ear Candy is pt-stalk, and At the Movies is a fast parallel query engine.

MySQL Utilities part 5

Part 1 of MySQL Utilities
Part 2 of MySQL Utilities
Part 3 of MySQL Utilities
Part 4 of MySQL Utilities

mysqlrplcheck

[bugzilla2]$ mysqlrplcheck --master=root:PASS@bugzilla1 --slave=root:PASS@localhost:/var/lib/mysql/mysql.sock   
# master on bugzilla1: ... connected.
# slave on localhost: ... connected.
Test Description                                                     Status
---------------------------------------------------------------------------
Checking for binary logging on master                                [pass]
Are there binlog exceptions?                                         [pass]
Replication user exists?                                             [FAIL]

The replication user repl@localhost was not found on bugzilla1:3306.

Checking server_id values                                            [pass]
Checking server_uuid values                                          [pass]
Is slave connected to master?                                        [pass]
Check master information file                                        [pass]
Checking InnoDB compatibility                                        [pass]
Checking storage engines compatibility                               [pass]
Checking lower_case_table_names settings                             [pass]
Checking slave delay (seconds behind master)                         [pass]
# ...done.


mysqlrplshow
report-host
report-port

mysqluserclone
Compared to pt-show-grants
Episode 80, where we reviewed pt-show-grants.

mysqlserverclone
mysqld_multi

Ear Candy
pt-stalk
Episode 150, where we talked about mysqladmin's relative option

At the Movies
This week in at the movies, we present "Introduction to Parallel Universe" by
Hiromichi of Parallel Universe, Inc. Parallel Universe has a fast parallel query engine. It is created by extending MySQL server architecture and runs on commodity server hardware. Speed is achieved by processing tables in parallel utilizing multiple core/CPU of server hardware and scalable to large joins.

Where you can see us
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 SeaGL, the new Seattle GNU/Linux Conference, a grassroots event happening in Seattle Oct 11th and 12th.

Gerry will be at the 2nd MySQL, NoSQL and Cloud Conference & Expo Tuesday, October 15th 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