Difference between revisions of "Mysql"
From Bashlinux
(Redirected page to MySQL) |
|||
(5 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
+ | #REDIRECT [[MySQL]] |
||
− | __NOTOC__ |
||
− | = MySQL = |
||
− | == MySQL server with SSL == |
||
− | # Create a certificate as described in [[openssl|OpenSSL]] section. |
||
− | # Add the following under each directive on `/etc/my.cnf`, if the directive doesn't exists it should be created |
||
− | |||
− | <pre><nowiki> |
||
− | [client] |
||
− | ssl-ca=/etc/pki/openssl/cacert.pem |
||
− | ssl-cert=/etc/pki/openssl/client-cert.pem |
||
− | ssl-key=/etc/pki/openssl/client-key.pem |
||
− | |||
− | [mysqld] |
||
− | ssl-ca=/etc/pki/openssl/cacert.pem |
||
− | ssl-cert=/etc/pki/openssl/server-cert.pem |
||
− | ssl-key=/etc/pki/openssl/server-key.pem |
||
− | </nowiki></pre> |
||
− | |||
− | # Restart the server |
||
− | |||
− | <pre><nowiki> |
||
− | service mysqld restart |
||
− | </nowiki></pre> |
||
− | |||
− | # Test SSL on Mysql. Login into MySQL Server |
||
− | |||
− | <pre><nowiki> |
||
− | mysql -u root -p |
||
− | </nowiki></pre> |
||
− | |||
− | # Check SSL Cipher |
||
− | |||
− | <pre><nowiki> |
||
− | mysql> show status like 'Ssl_cipher'; |
||
− | +--------------+-------------------+ |
||
− | | Variable_name| Value | |
||
− | +--------------+-------------------+ |
||
− | | Ssl_cipher | DHE-RSA-AES256-SHA| |
||
− | +--------------+-------------------+ |
||
− | |||
− | 1 row in set (0.01 sec) |
||
− | </nowiki></pre> |
||
− | |||
− | # Done |
||
− | |||
− | == Master-Master Replication == |
||
− | |||
− | Ensure the following settings in both servers: |
||
− | |||
− | <pre><nowiki> |
||
− | relay-log = /mnt/mysql-binlogs/mysql-relay-bin |
||
− | auto-increment-increment=2 |
||
− | binlog-format=MIXED |
||
− | </nowiki></pre> |
||
− | |||
− | |||
− | Primary server only: |
||
− | |||
− | <pre><nowiki> |
||
− | auto-increment-offset=1 |
||
− | server-id=1 |
||
− | </nowiki></pre> |
||
− | |||
− | |||
− | Secondary server only: |
||
− | |||
− | <pre><nowiki> |
||
− | auto-increment-offset=2 |
||
− | server-id=2 |
||
− | </nowiki></pre> |
||
− | |||
− | |||
− | Good links: |
||
− | * [[http://www.howtoforge.com/mysql5_master_master_replication_debian_etch]] |
||
− | * [[http://www.neocodesoftware.com/replication]] |
||
− | == InnoDB == |
||
− | When work with this engine don't forget to do a "commit" after any INSERT/UPDATE execution. |
Latest revision as of 02:09, 10 June 2015
Redirect to: