Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 72

Displaying posts with tag: configuration (reset)

Do we need sql_mode?
+0 Vote Up -0Vote Down

sql_mode must be one of the most elusive issues in setting up a MySQL database. It is also responsible for difficulties in migration, upgrading and securing of databases.

MySQL usually has little issues with migrating database from one machine to another, one version to another, one OS to another, one architecture to another. If we’re not sure, we can always migrate using mysqldump’s logical dump, right?

Not entirely right. The elusive sql_mode (empty by default) may affect out backup+restore, may affect our application behavior, may affect our data integrity.

  • Did we remember to set NO_AUTO_CREATE_USER? Oh dear, we have some users without passwords.
  • Did we remember to set NO_AUTO_VALUE_ON_ZERO? Oh dear, we’ve dumped our database for backup, restored, but AUTO_INCREMENT values
  [Read more...]
MySQL Cluster Sandbox - test cluster to cluster replication!
+0 Vote Up -0Vote Down
If you have max 15 minutes and want to try out MySQL Replication (geo redundancy) between two Clusters on your localhost (only tested on Linux) or on vmware then this Sandbox is for you.

Here is what you have to do:
  • Go to www.severalnines.com/sandbox
  • Create a master cluster:
    I have used the ports 1186 (for the management server) and 3306 and 3307 for the mysql servers).
  • Enter the email address and a set of scripts to install cluster will be sent.
  • Create a slave cluster:
    Make sure you use

  •   [Read more...]
    cmon 0.12 - with diskdata support and a lot of fixes
    +0 Vote Up -0Vote Down
    cmon 0.12 is now released and can be downloaded from www.severalnines.com/cmon.

    Release notes:
    • connection handling - cmon will now retry connects forever. cmon will also recover and automatically reconnect to cluster after a cluster failure or if the connection to the mysql server crashes where cmon logs information. This means you will have to terminate the cmon using e.g 'killall cmon' or /etc/init.d/cmon stop
    • disk data - cmon now gathers information about the amount of table space used and this is presented in the web interface
    • init.d scripts - fixed bugs in creating the init.d scripts during make install-extra
    • fixed compiler warnings - now 0 compiler warnings on Linux systems
    • mysql_statistics table - now explicitly using engine=myisam
    • web

      [Read more...]
    Disk data - a summary
    +0 Vote Up -0Vote Down
    Here is a summary about Disk Data tables in MySQL Cluster.

    Data node configuration:
    • SharedGlobalMemory=384M
      RAM from the shared global memory is used for the UNDO_BUFFER when you create the log file group.
      In the configuration generated by severalnines.com/config then you have to uncomment the SharedGlobalMemory in mysqlcluster-63/cluster/config/config.ini before you start the cluster.
    • DiskPageBufferMemory=3072MB
      If you are relying a lot on the disk data, we recommend to set this to as much as possible.
      In the configuration generated by severalnines.com/config then you have to uncomment the DiskPageBufferMemory in mysqlcluster-63/cluster/config/config.ini before you start the

      [Read more...]
    Dangers of skip-grant-tables
    +0 Vote Up -0Vote Down

    When MySQL’s root password is lost and must be reset, there are two popular ways to create a new password. One of the options is far too popular, in my opinion.

    The preferred way of setting a root’s password is by using an init-file. The process for doing this is well explained in MySQL’s manual. Using this method requires creating a simple text file, in which the required

    GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFY BY '****' WIth GRANT OPTION;

    (or, alternatively,  SET PASSWORD …) statement is written.

    An entry must be written to my.cnf, or supplied via command line parameters:


    MySQL must then be restarted. Upon restart, and before

      [Read more...]
    MySQL parameters & configuration sample file
    +0 Vote Up -0Vote Down
    The following is a sample my.cnf configuration file. It includes some common and uncommon parameters, along with occasional comments. You can use this file, and tune as appropriate for your machine, operating system, and application needs. In particular, note the high values set for the InnoDB related parameters, below, and change them to match your system and [...]
    Why is MSNBot ignoring robots.txt?
    Employee +0 Vote Up -0Vote Down

    Today, the root file system on our public svn server nearly ran out of disk space. The reason? The /tmp directory was quickly filling up with temporary files created by websvn, which I set up parallel to the FishEye repository browser for testing purposes. A quick investigation of the apache log files revealed the culprit - a crawler from Microsoft was running haywire and decided to ignore the rules in the robots.txt file, even though it did actually looked at the file before!

    Here is how robots.txt looked like (I now changed it to disallow everything):

    User-agent: *
    Disallow: /fisheye/
    Disallow: /websvn/

    If I am not mistaken, no crawler should actually consider going into the SVN browser directories. Some snippets from

      [Read more...]
    Running Drupal 6 on MySQL 6 using the Falcon Storage Engine
    Employee +0 Vote Up -0Vote Down

    This article describes how to install the Drupal 6.2 CMS on MySQL (http://mysql.com/) 6.0, using the Falcon Storage Engine. The operating system is a default Ubuntu 8.04 "Hardy Heron" (x86) installation.

    I will make a few assumptions here, in order to keep the instructions simple: a fresh OS install, no other MySQL databases or web services are running or have already been installed. Both MySQL and the web server are installed on the same host. You should be able to become root to install packages and to have access to the local file system and

      [Read more...]
    Why MySQL says the server is not configured as a slave
    +0 Vote Up -0Vote Down

    Is MySQL giving you the error message "ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO" when you try to run START SLAVE? There are a few simple troubleshooting steps to take, but I always forget what to do. This article is to help me remember in the future!

    To start or not start the MySQL server during the RPM installation?
    Employee +0 Vote Up -0Vote Down

    So far, the MySQL Server RPM packages as provided by MySQL AB used to automatically start the mysqld process after the package has been installed. It has been like that since the very beginning and we think of it as a convenience for our users when they want to get up and running quickly.

    However, Kristian raised an interesting point in BUG#27072 where he points out that automatically starting mysqld during the RPM installation might not always be the desired behaviour, especially in automatic installation environments or during a fresh installation (where the system might not be fully configured yet). Therefore he proposes to change this behaviour to not start mysqld as part of the installation.

    While I personally agree with his proposal,

      [Read more...]
    SUSE Linux 10.1 "vorkon" - SUSE Linux as it's supposed to be?
    Employee +0 Vote Up -0Vote Down
    Yesterday I received a sample copy of the "SUSE Linux 10.1 OSS - vorkon" DVD, which was assembled by Nicolaus Millin. While I have not installed it yet (as I by now have a very well running installation of SUSE Linux 10.1 on my laptop), the content of the DVD sounds very promising. In addition to incorporating all the updates that have been published since SUSE Linux 10.1 was released (around 100), this version also includes additional drivers like the 3D graphics drivers from ATI and nVidia, network card drivers like ndiswrapper, madwifi and rt2500 as well as drivers for AVM products and Logitech QuickCams. So the base system  [Read more...]
    Enabling and using the MySQL Instance Manager (IM)
    Employee +0 Vote Up -0Vote Down

    The release of MySQL 5.0 introduced the MySQL Instance Manager (IM), which intends to replace the mysqld_safe wrapper script as well as the mysqld_multi script that keeps track of multiple MySQL instances running on the same machine.

    This article will qive you a quick overview about the IM and how to enable and configure a minimal setup that uses the IM to manage the default mysqld instance. I used MySQL 5.1.7-beta for my tests, some of this may work differently on other versions of MySQL.

    Continue reading "Enabling and using the MySQL Instance Manager (IM)"
    Previous 30 Newer Entries Showing entries 61 to 72

    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.