Showing entries 1 to 7
Displaying posts with tag: MySQL MHA (reset)
MySQL MHA and Perl pathing

I am certainly not a knowledgeable Perl person, however I recently ran into the error Can’t locate MHA/MasterMonitor.pm on Red Hat 6.x. I have installed MySQL MHA on various systems before without any issues.

$ masterha_manager -version
Can't locate MHA/MasterMonitor.pm in @INC (@INC contains: /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 .) at /usr/bin/masterha_manager line 26.
BEGIN failed--compilation aborted at /usr/bin/masterha_manager line 26.

The issue was that MySQL MHA is not installed in any of the acceptable default paths for this disto default installation.

$ find / -type d -name MHA
/usr/lib/perl5/vendor_perl/MHA

The fix was simple on this OS, but I expect there is a correct Perl approach?

ln -s …
[Read more]
Not a cool new feature for Master_Host

I was surprised to find on a customer MySQL server this new syntax for Master_host in SHOW SLAVE STATUS.

mysql> SHOW SLAVE STATUS\G
*************************** 1. row ***************************
               Slave_IO_State: Connecting to master
                  Master_Host: testdb1.xxx.com or 10.XXX.XX.XXX
                  Master_User: repl
                  Master_Port: 3306
                Connect_Retry: 60
              Master_Log_File: db1-354215-bin-log.000005
          Read_Master_Log_Pos: 1624
               Relay_Log_File: db2-354214-relay-log.000001
   

Is this a fancy new Percona Server feature? No. It’s operator error.

We read a little further to find.

mysql> SHOW SLAVE STATUS\G
...
             Slave_IO_Running: Connecting

...
                Last_IO_Errno: 2005
                Last_IO_Error: error connecting to master 'repl@ testdb1.xxx.com or 10.XXX.XX.XXX' - retry-time: 60  retries: 86400
[Read more]
Installing MySQL MHA with Percona Server

MySQL MHA by Oracle ACE Director Yoshinori Matsunobu is an excellent open source tool to help in providing HA with native MySQL replication. The installation however is dependent on some Perl packages and to the untrained eye this may be an issue if you are using Percona Server as your choice of MySQL implementation.

The MHA Node page requires the perl-DBD-MySQL package to be installed. The installation on RedHat/CentOS/Oracle Linux look like this:

$ sudo yum install perl-DBD-MySQL
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
* base: mirror.anl.gov
* extras: mirror.anl.gov
* updates: mirror.anl.gov
Setting up Install Process
Resolving Dependencies
--> Running transaction check …
[Read more]
SkySQL and its Partners to Speak at Percona Live UK

SkySQL executives and a number of its partners have been invited to share their insight and expertise on MySQL® technologies and trends during the Percona Live UK conference speaking program, including:

  • "Linux & H/W Optimizations for MySQL", Yoshinori Matsunobu (DeNA), Oct. 24, 9:00AM
  • "The SkySQL Reference Architecture in Action", Ivan Zoratti (SkySQL), Oct. 25, 2:30PM
  • "Why MariaDB?", Colin Charles (MontyProgram AB), October 25, 3:30PM

Use discount code "PLUK11sky" and save 40 GBP when you register.

OSCON Recap

As the dog days of summer set in and temperatures rise, this year’s O’Reilly OSCON conference in Portland, OR offered the open source community a brief respite from the heat. However, if you’re thinking the event lacked sizzle, think again. The energy, the discussions and the opportunities to collaborate, plus the chance to learn from/ interact with customers and potential customers, made OSCON one of the highlights of July.

 

While I’ve attended previous OSCON conferences while at MySQL AB, this was the first time I’ve attended as the CEO of SkySQL. My new role provided a different perspective, as well as new kinds of opportunities to interact with the open source community. There were plenty of terrific, formal presentations and Birds of a Feather (BOF) sessions, however, those from MySQL, MariaDB and Drizzle were especially noteworthy and informative. Here were a few high points:

 

[Read more]
451 CAOS Links 2011.07.26

CloudBees raises $10.5m. Microsoft commits $100m to SUSE. And more.

# CloudBees secured $10.5m in Series B venture funding.

# Microsoft renewed its vows with Attachmate’s SUSE business unit, committing to invest $100m in new SUSE Linux Enterprise certificates over the next four years.

# Oracle announced that it has acquired Ksplice, twhioch offers zero downtime update technology for Linux.

# Ingres announced that Steve Shine has been named Chief Executive Officer and President.

# Dell …

[Read more]
SkySQL Partners with Yoshinori Matsunobu to Provide Commercial Services for MySQL® Master High Availability Manager & Tools

Today, SkySQL announced a partnership with Yoshinori Matsunobu, an Oracle ACE Director and the creator of the newly announced MySQL Master High Availability Manager and Tools (MySQL MHA) for automating MySQL master failover. With this partnership, SkySQL will be the first MySQL database commercial services company to provide technical support, professional services, and training, for MySQL MHA.

read more

Showing entries 1 to 7