Apart from the start/stop commands the below commands show the different commands that can also be used to start and stop mysql daemon especially if you have encountered the following errors when you were using the 'normal' start/stop commands:

ERROR! MySQL manager or server PID file could not be found!

Starting MySQL.................................. ERROR

1: On the server Search for mysqld_safe 

cd /

find . -name mysqld_safe  -print

(ie found : ./usr/local/mysql_5.0.24/mysql-standard-5.0.24a-freebsd6.0-i386/bin/mysqld_safe )

2: To Start mysql daemon:

cd /usr/local/mysql_5.0.24/mysql-standard-5.0.24a-freebsd6.0-i386/bin

./mysqld_safe --user=mysql &

3: To Stop mysql daemon:

cd …

http://www.mysql.com/news-and-events/on-demand-webinars/

090326 12:30:54 [ERROR] Got error 134 when reading table './ANYPROV/ORDERS'

Reference from Mysql Bug Database

http://lists.mysql.org/mysql/51228

perror 134

and get this result:

Unknown error 134

Record was already deleted (or record file crashed)

mysql> check table ORDERS;

+----------------+-------+----------+-------------------------------+

| Table          | Op    | Msg_type | Msg_text                      |

+----------------+-------+----------+-------------------------------+

…

00 08 * * * mysql -uroot -p*** -se 'delete from tacacs.accounting where date < date_sub(now(), interval 90 day);'  > /tmp/delete_accounting.log 2>&1

You can use this script to purge master logs older than the day of the current log.  It checks the slaves are not using the older logs first. 

Some prechecks:

1) create a repl_client user on each slave - i.e

GRANT REPLICATION CLIENT ON *.* TO 'repl_client'@'mk-dbxx-1' IDENTIFIED BY 'r3pl';

2) Put the master and slave user, pwd and hosts in the section below.

3) Set savedays to number of days of logs to keep if more than today+1.

4) Make sure perl DBD and CALC modules are installed.

perl –v , 

instmodsh (and enter l to list modules)

5) The purge statement will not work if the "show master logs;" doesn't match up with the actual log files on disk.  This …

mysql -uroot –p*** -e 'show master logs; purge master logs before date_sub(now(), interval 1 day); show master logs;' 

sample output

+------------------+------------+

| Log_name         | File_size  |

+------------------+------------+

| mysql-bin.000325 | 1073741878 |

| mysql-bin.000326 | 532809491  |

+------------------+------------+

+------------------+------------+

| Log_name         | File_size  |

+------------------+------------+

| mysql-bin.000326 | 532809491  |

+------------------+------------+

Occasionally, mysql is installed in the wrong filesystem, and as the data build, the filesystem runs out of space. Moving the database is relatively straight forward

1.      Ensure there is a good, recent backup. Take an extra backup to be on the safe side

2.      Decide where the files will be moved to and create any subdirectories as required. Ensure the permissions are correct

            cd /local/mysql

            mkdir data

            chown mysql:mysql data

            root@compnode04[mysql] ls -ltr

…

In one of my last blog, named: "Oracle Audit Vault and Database Firewall (AVDF) 12.1 - installation on VirtualBox" I explained how to install AVDF on VirtualBox. Since some of you asked for a blog on "How to configure AVDF", I decided to write this posting on AVDF post-installation configuration. This one only concerns the post-installation phase, a third blog will be dedicated to practical cases concerning the configuration of Database Firewall Policies.

Specifying the Audit Vault Server Certificate and IP Address

You must associate each Database Firewall with an Audit Vault Server by specifying the server's certificate and IP address, so that the Audit Vault Server can manage the firewall. If you are using a resilient pair of Audit Vault Servers for high availability, you …

Finnish tech regains global recognition

Helsinki, Finland – 12 NOVEMBER 2014 – Codership, whose Galera Cluster technology brings high availability to open source databases worldwide, today announced it has been shortlisted for Red Herring’s 2014 Top 100 Global award. This prestigious recognition honours the year’s most audacious and far-reaching private technology companies and entrepreneurs across the globe.

Selected from over 1,000 companies from more than 40 nations, Helsinki-based Galera was shortlisted based on its ability to demonstrate innovative technologies which is helping to create new business models. The finalists were judged on a range of metrics, including financial performance, growth, management’s …

Logging into a MySQL server is generally dead simple—supply a username, a password, and you’re all set!

There are, however, more complex use cases such as when making use of our Enterprise Authentication plugins. It’s also sometimes helpful to have a more detailed understanding of what happens “under the hood”. So I’ll attempt to lift the hood and walk you through all of the nitty-gritty details regarding exactly just what happens when you log into a MySQL server.

Firstly, there are no less than 4 “users” involved in the authentication process. And a distinction between a user id and a user account exists. And it gets more and more advanced with each release. So I thought I’d take the time to try to walk you through the MySQL authentication process and clarify once and for all the stages involved, the information exchanged at each stage and the expected outcome.

I’ll use the tools that come …