THE WORLD DISCUSSES #PYTHIAN ON TWITTER. HAVE A QUESTION? USE OUR HASHTAG AND ASK AWAY.

Know your my.cnf groups, part II

Posted by Sheeri Cabral on Jan 27, 2010

Ronald Bradford‘s recent warning to be sure to know your my.cnf sections reminded me of a similar issue that I ran into last summer, where putting the “group” option in both the [mysqld_safe] and [mysqld] directives resulted in a mostly silent problem.

I started noticing this in MySQL 5.1 and it affected both the official MySQL binary and the Percona binary. In trying to be conscientious, I had the following set:
Read the rest of this entry . . .

3 Comments »

Using mysqld_multi to Manage Multiple Servers

Posted by Keith Murphy on Jul 30, 2008

I recently needed to set up multiple MySQL servers on a test computer to simulate a master-slave setup. I had never done this before, so I think it might be useful for others if I documented what occurred. This setup was done on a Linux server, however other platforms should operate similarly. I choose to use the mysqld_multi script to manage these instances. There is a way that you can compile the MySQL server with different network interfaces, but in my opinion, using mysqld_multi to manage activities is much easier.

So shall we begin?

Read the rest of this entry . . .

8 Comments »

Start NowWith Pythian - database design, management and emergency handling capabilities...

Papers & Books

MySQL Administrator's Bible by Sheeri K. Cabral

Oracle RAC Workload Management whitepaper by Alex Gorbachev

8 Rules for Designing More Secure Applications with MySQL by Augusto Bott and Nick Westerlund

Live Updates

pythian: RT @pythianfielding: My #ukoug2011 #Exadata IORM presentation starts in a few mins in hall 7A
more



Testimonials

  • Serge Racine

    DBA, Brookfield Energy

    We are very satisfied by the service given to us by Andre and Shakir in support of our recent data quality and reorganization initiative.... more