Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 3

Displaying posts with tag: Tip of the Day (reset)

MySQL PAM and Active Directory authentication
+0 Vote Up -0Vote Down

How-To configure your MySQL to use PAM and/or Active Directory authentication with percona-pam-authentication plugin. Continuing articles about Two-Factor authentication or integrating Linux services with Active Directory, this How-To is one of my recent works that I have done these days, so I hope it may help the community with this guide to configure MySQL with PAM and subsequently using Active Directory to authenticate. If you are new here, please refer to SSH Two-Factor authentication, which explains how to install likewise and …

  [Read more...]
Tip of the Day - Queries that you do not want to replicate
+0 Vote Up -0Vote Down

If you use MySQL Replication, 99% of the times your main concern is to keep the master and the slave fully consistent and in sync. Some applications require exactly the opposite.

Let's take, for example, some reporting solutions. You may want to run reports against a data mart (ok, I can see some BI experts here jumping off their chairs - please forgive the simplification for the sake of this example), that is a subset of the whole historical data within your data warehouse. So, you may have a master server containing only the last 3 months of your sales and a slave containing three years of sales. Sales managers can happily to see …

  [Read more...]
Tip of the Day: Installing MySQL Coolstack on Solaris
+0 Vote Up -0Vote Down

Here are few tips if you are going to install the MySQL Coolstack package on Sun Solaris.

First of all, let me say that, as usual, these tips are based on my personal experience and they may not be applicable to your sw version or environment. For this specific tip, I can't say if it is applicable for all versions of Solaris - 9, 10, OpenSolaris, X86, SPARC etc.

You can get the Coolstack from here - http://cooltools.sunsource.net/coolstack. Within Coolstack you will find CSKmysql, a specific 64 bit package prepared by Sun that provides some …



  [Read more...]
Showing entries 1 to 3

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.