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 中文
Showing entries 1 to 30 of 154 Next 30 Older Entries

Displaying posts with tag: ubuntu (reset)

Ubuntu 14.04 – some MySQL ecosystem notes
+1 Vote Up -0Vote Down

Following my previous post on the launch, I just rolled Ubuntu 14.04 LTS on an Amazon EC2 t1.micro instance (not something you expect to run a database server on, for sure – 1 vCPU, 0.613GiB RAM). If you do an apt-cache search mysql you get 435 return result sets with the default configuration (trusty: main & universe).

If you do apt-get install mysql-server, you get MySQL 5.5. You enter the password of choice, and before you know it, MySQL is installed (a SELECT VERSION() will return 5.5.35-1ubuntu1).

Next you decide to install MariaDB. I run an apt-get install mariadb-server. It pulls in libjemalloc (for TokuDB) and I expect future releases to ship this engine by default. You enter the password, and

  [Read more...]
Congratulations Ubuntu, for the wide choice!
+1 Vote Up -0Vote Down

Inspired by Yngve Svendsen’s post, I too think it makes absolute sense to congratulate Ubuntu on the 14.04 LTS release (some server notes - MySQL has a section dedicated to it). Ubuntu users have a lot of server choice today (that’s from all major MySQL ecosystem vendors):

  • MySQL 5.5.35 ships in main. It is the default MySQL. Oracle has committed to providing updates to 5.5 throughout the LTS release cycle of Ubuntu (which is longer than the planned EOL for 5.5). This is why the grant of a
  [Read more...]
Percona Software in Ubuntu 14.04 LTS (Trusty Tahr) release
+0 Vote Up -0Vote Down

I’d like to congratulate Canonical with the new Ubuntu 14.04 LTS (Trusty Tahr) Release, it really looks like a great release, and I say it having my own agenda It looks even more great because it comes with a full line of Percona Software.
If you install Ubuntu 14.04 and run aptitude search you will find:


  [Read more...]
Ubuntu 14.04 LTS first impressions
+0 Vote Up -0Vote Down

The Trusty Tahr is out with support for 5 years. Here are the first thoughts about it…

Stupid Browser comes up when searching “Appearance”

  • Unity feels more responsive than ever, especially the Alt+Tab.
  • New Desktop environments these days (also read as Cinnamon, GNOME Shell) take up a lot of RAM, I wanted to test 14.04′s unity, after few hours usage it too scooped up 320 MB worth of RAM… I expected better
  • One thing that definitely annoyed me
  [Read more...]
Percona server 5.5/5.6 installation failed on Ubuntu 13.04/13.10(amd64)
+0 Vote Up -0Vote Down
While installing Percona Server 5.5/5.6 on Ubuntu 13.04/13.10, I got some weird errors, which I never faced before. Errors were something like, dpkg: error processing /var/cache/apt/archives/libmysqlclient18_1%3a5.5.35-rel33.0-611.raring_amd64.deb (–unpack):   libmysqlclient18:amd64 1:5.5.35-rel33.0-611.raring (Multi-Arch: no) is not co-installable with libmysqlclient18 which has multiple Continue reading →   [Read more...]
Correcting mysql.sock connection error
+0 Vote Up -0Vote Down

I write this post over to have a quick access to this tutorial than to promote the blog. The problem For Several times this has happened to me, always install a new server, or personal machine. I install mysql , and time to connect: The solution Simple and easy, look for the configuration file, my.cnf, make sure it is the same configuration file. Make a backup of it, to avoid any problem. My use is as ubuntu /etc/mysql/my.cnf Edit the uncompensated you will get the following lines: Ensure that the… Continue Reading →

Continue reading Correcting mysql.sock connection error

Related posts:
  • Corrigindo erro de conexão com
  •   [Read more...]
    MariaDB & distributions update, Dec 2013
    +1 Vote Up -0Vote Down

    A few things to note recently, amongst MariaDB in distributions. 

  • Ubuntu keeps MySQL 5.5 despite MariaDB’s success. There’s a lot of reasons for this, but remember the key takeaway here is MySQL 5.5 & the fact that MariaDB wasn’t even in Debian yet when the decision was made.
  • MariaDB is now inside of Debian/sid – check out the packages.
  • RHEL 7 comes with MariaDB 5.5 as a default; this is a good thing.
  • Now, from a distribution standpoint, we’re looking at starting to ship

      [Read more...]
    Using the PAM authentication plugin
    +2 Vote Up -0Vote Down
    The procedure for using the PAM authentication plugin as documented doesn't work flawlessly on Ubuntu.

    So here is how it works on Ubuntu (and probably also on other Debian based systems).

    Please note that the PAM authentication plugin is an enterprise feature.

    1. Make sure the plugin is loaded

    This can be done by adding the following to the mysqld section of my.cnf (Don't forget to restart). You could also use INSTALL PLUGIN to load it without restart.
    plugin-load=authentication_pam.so
    2.  Add a user which will use the plugin

    mysql> CREATE USER 'dveeden'@'localhost' IDENTIFIED WITH authentication_pam;
    Query OK, 0 rows affected (0.00 sec)
    3. Add a pam config file for 'mysql':
    Create












      [Read more...]
    Percona Server 5.6.14 with TokuDB 7.1 Experimental build
    +1 Vote Up -0Vote Down

    We just announced Percona Server 5.6.14 release, and I decided to make this build with the TokuDB 7.1 engine.
    The build is available here in the TESTING area.

    You are welcome to play with these binaries, but keep in mind:

    • This is an experimental build and not supposed to be used in production environment
    • The binaries built on Ubuntu 12.04 LTS server and may not work on other Linux distributions

    The post Percona Server 5.6.14 with TokuDB 7.1 Experimental build appeared first on MySQL Performance Blog.

    Installing MySQL on Ubuntu and CentOS
    +0 Vote Up -0Vote Down
    MySQL is one of the most famous Open Source Relational Database Management System (RDBMS) created by Michael Widenius. Default choice in systems as WordPress and used by top companies as Google and Wikipedia. Due its simplicity and large community, it is largely used by developers and webmasters around the world. MySQL is under dual license: […]
    An Ubuntu PPA of daily builds of Percona XtraBackup
    +1 Vote Up -0Vote Down

    Run Ubuntu and want to try new features of Percona XtraBackup? Well, now you can. We have a Personal Package Archive (PPA) percona-daily/percona-xtrabackup. Every time code is pushed to our main source code repository, the PPA is updated.

    We are currently building for Ubuntu lucid (10.04LTS), Precise (12.04), Quantal (12.10) and Raring (13.04).

    To add the repository to your Ubuntu system, simply run:

    sudo add-apt-repository ppa:percona-daily/percona-xtrabackup

    You will now have daily builds of Percona XtraBackup available to install.

    Currently, we are in the process of working on the 2.1.4 release. The daily builds currently include some code that is destined

      [Read more...]
    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 13.04
    +0 Vote Up -0Vote Down

    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 13.04

    Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 13.04 server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP) .

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 13.04 (LAMP)
    +0 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 13.04 (LAMP)

    LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 13.04 server with PHP5 support (mod_php) and MySQL support.

    On big technical meetings, or why the end of the UDS is a bad idea
    +0 Vote Up -0Vote Down

    Canonical has just announced that the Ubuntu Developer Summit will no longer be face to face and every six months. Instead it will be entirely online and virtual, using Google Hangouts. (Here is the announcement.)

    On the surface, this seems like a good idea: It's cheaper monetarily, it appears to open things up to people who are unable to travel, and it makes it easier to make complete records.

    However, I think it's a bad idea, for several interrelated reasons.

    Some decision making needs face-time to happen. For whatever reasons, internet-only communication is not enough for a good enough "meeting of the minds" for sticky or subtle engineering and design decisionmaking.

    The IETF, who probably



      [Read more...]
    AppArmor and MySQL
    Employee +0 Vote Up -0Vote Down

    MySQL accesses files in various places on the file system, and usually this isn't something to worry about. For example, in a standard MySQL 5.5 installation on Ubuntu, the data goes in /var/lib/mysql, and the socket is a file in /var/run/mysqld. It puts configuration files in /etc, logs and binaries in various locations, and it even needs to access some operating system files such as /etc/hosts.allow.

    This is all very well until you start trying to be clever and get MySQL to access other parts of the file system. After all, you can configure the location of data, log files, socket, and so on, so why shouldn't you use those settings to optimize your system? Unfortunately, on many modern Linux distributions, it's not that always easy.

    Take Ubuntu, for example. Ubuntu comes with something called AppArmor, a kernel-integrated application security system that controls how

      [Read more...]
    Upgrading to MySQL 5.5 on Ubuntu 10.04 LTS
    +4 Vote Up -0Vote Down

    Ubuntu does not provide an apt-get repository package for MySQL 5.5 on this older OS, however this is still a widely used long term support version. The following steps will upgrade an existing MySQL 5.1 apt-get version to a standard MySQL 5.5 binary.

    Step 1. Remove existing MySQL 5.1 retaining data and configuration

    sudo su -
    service mysql stop
    cp -r /etc/mysql /etc/mysql.51
    cp -r /var/lib/mysql /var/lib/mysql.51
    which mysqld
    dpkg -P mysql-server mysql-server-5.1 mysql-server-core-5.1
    which mysqld
    which mysql
    dpkg -P mysql-client-5.1 mysql-client-core-5.1
    which mysql
    dpkg -P libdbd-mysql-perl libmysqlclient16 mysql-common
    # This will not remove /etc/mysql if any other files are in the directory
    dpkg -l | grep mysql
    [ -d /etc/mysql ] && mv /etc/mysql /etc/mysql.uninstall
    cp -r /etc/mysql.51 /etc/mysql
    

    2. Prepare configuration  [Read more...]

    How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10
    +1 Vote Up -0Vote Down

    How To Back Up MySQL Databases With mylvmbackup On Ubuntu 12.10

    mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on an Ubuntu 12.10 server.

    How To Install Percona Server 5.5 On Ubuntu 12.10
    +0 Vote Up -1Vote Down

    How To Install Percona Server 5.5 On Ubuntu 12.10

    Percona Server is a drop-in replacement for MySQL. It offers more performance and scalability than the default MySQL server coming with your Linux distribution, while it uses the same init scripts and command line tools which makes it easy to use. This tutorial explains how to install Percona Server 5.5 on Ubuntu 12.10.

    How To Install MySQL 5.6 On Ubuntu 12.10 (Including memcached Plugin)
    +0 Vote Up -0Vote Down

    How To Install MySQL 5.6 On Ubuntu 12.10 (Including memcached Plugin)

    According to What's New in MySQL 5.6, MySQL 5.6 will bring some performance improvements over MySQL 5.5. If you want to test out MySQL 5.6, you have to install one of the development releases from the MySQL downloads page because there is no stable release yet. This tutorial explains how to install the MySQL 5.6.8rc1 (Linux Generic) development release on an Ubuntu 12.10 server.

    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 12.10
    +0 Vote Up -0Vote Down

    Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support (LEMP) On Ubuntu 12.10

    Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 12.10 server with PHP5 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP).

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.10 (LAMP)
    +0 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.10 (LAMP)

    LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 12.10 server with PHP5 support (mod_php) and MySQL support.

    Virtual Hosting With vsftpd And MySQL On Ubuntu 12.04
    +0 Vote Up -0Vote Down

    Virtual Hosting With vsftpd And MySQL On Ubuntu 12.04

    Vsftpd is one of the most secure and fastest FTP servers for Linux. Usually vsftpd is configured to work with system users. This document describes how to install a vsftpd server that uses virtual users from a MySQL database instead of real system users. This is much more performant and allows to have thousands of ftp users on a single machine.

    Managing Multiple MySQL Servers From One phpMyAdmin Installation (Using SSL Encryption)
    +0 Vote Up -0Vote Down

    Managing Multiple MySQL Servers From One phpMyAdmin Installation (Using SSL Encryption)

    This tutorial explains how you can manage multiple MySQL servers from one phpMyAdmin installation. For security reasons, communication between phpMyAdmin and any remote MySQL server is using SSL encryption (this is not necessary for a local MySQL server since communication between phpMyAdmin and MySQL is not leaving the server). phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the World Wide Web. phpMyAdmin supports a wide range of operations with MySQL.

    Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Ubuntu 12.04)
    +0 Vote Up -0Vote Down

    Creating Advanced MySQL-Based Virtual Hosts On Lighttpd (Ubuntu 12.04)

    This guide explains how you can create advanced virtual hosts on a lighttpd web server on Ubuntu 12.04 that are stored in a MySQL database. The method described here does not use the lighttpd mod_mysql_vhost module, and unlike mod_mysql_vhost (which allows you to store only the hostname and document root of a vhost in a database), this method allows to store individual configuration directives for each vhost in the MySQL database.

    Creating Simple Virtual Hosts With mod_mysql_vhost On Lighttpd (Ubuntu 12.04)
    +0 Vote Up -0Vote Down

    Creating Simple Virtual Hosts With mod_mysql_vhost On Lighttpd (Ubuntu 12.04)

    This guide explains how you can use mod_mysql_vhost to create simple virtual hosts on a lighttpd web server on Ubuntu 12.04. With mod_mysql_vhost, lighttpd can read the vhost configuration from a MySQL database. Currently, you can store the domain and the document root in the MySQL database which results in very simple virtual hosts. If you need more directives for your vhosts, you'd have to configure them in the global section of lighttpd.conf, which means they'd be valid for all vhosts. Therefore, mod_mysql_vhost is ideal if your vhosts differ only in the domain and document root.

    Setting up RAID0 in Ubuntu 12.04 in AWS High I/O
    +0 Vote Up -0Vote Down

    Amazon announced high I/O instances today. This is huge for anyone with a database larger than available memory, as it’s been a complete nightmare dealing with EBS up till now. Now your Cassandra, MongoDB, MySQL, or whatever your using should be able to perform well without requiring keeping your entire dataset in memory.

    With each instance you get 2x1TB of disk. In this tutorial I’ll be setting it up as a RAID0 to get a single 2TB disk which should deliver excellent performance.

    Before you get started, make sure you’ve got mdadm installed:

    apt-get install mdadm

    To begin, check fdisk and make sure your 1TB drives are mounted.

    root@ip-10-140-128-232:~# fdisk -l

    Disk /dev/xvda1: 8589 MB, 8589934592 bytes
    255 heads, 63 sectors/track, 1044

      [Read more...]
    Living With Linux
    +0 Vote Up -0Vote Down

    I learned how to use a computer on DOS and Windows. My first programming projects were written in QBASIC and my first Web applications were written in VB using ASP on Windows 2000. The first job where I made decent money was developing a SQL Server-based application. I bought my first car, an engagement ring, and a honeymoon with money from making software on Windows. Needless to say, I found a lot of intellectual and financial fulfillment from Windows over the years.

    That first real job also allowed me flexibility in what technology I could employ, and I helped implement a features using Redis on top of Ubuntu. This was a fun time, because my company basically paid me to study a new technology and to gain experience using it. On my own, I began to use Linux and to embrace open-source ideas, one of which is that the consumer

      [Read more...]
    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.04 LTS (LAMP)
    +1 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 12.04 LTS (LAMP)

    LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 12.04 LTS server with PHP5 support (mod_php) and MySQL support.

    Benchmarking your MySQL servers
    +0 Vote Up -0Vote Down
    Benchmarking tools like Sysbench and DBT2 has helped alot of DBAs in measuring their MySQL databases performance. By benchmarking you will really know how far your current setup will go. In this part, you will learn how to install the sysbench in Ubuntu and other Enterprise linux.

    1. Installing sysbench to Ubuntu is never been easy as issuing the apt-get command. You can also download the source from sourceforge.

    In ubuntu, execute below.


    sudo apt-get install sysbench

    2. Installing to enterprise linux like Oracle Linux/ Red Hat Linux. Download the rpm file from rpmfind.net or any sites providing rpm downloads. You can also check this








      [Read more...]
    The Ubuntu Developer Summit
    Employee_Team +2 Vote Up -0Vote Down

    The Ubuntu Developer Summit takes place at The Oakland Marriott City Center, Oakland, California from 7–11 May 2012. 

    If your attending this event, you will have a few different MySQL opportunities to attend:

    Oracle is proud to also be a Sponsor of the Ubuntu Developer Summit. A full schedule of the event is available here.

     Join us as we help support and grow the MySQL Communities. 

    Showing entries 1 to 30 of 154 Next 30 Older Entries

    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.