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 108 Next 30 Older Entries

Displaying posts with tag: centos (reset)

How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7
+0 Vote Up -0Vote Down

How To Install Nginx With PHP And MySQL (LEMP Stack) On CentOS 7

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 a CentOS 6.5 server with PHP support (through PHP-FPM) and MySQL (Mariadb) support.

Install Apache, PHP And MySQL On CentOS 7 (LAMP)
+1 Vote Up -0Vote Down

Install Apache, PHP And MySQL On CentOS 7 (LAMP)

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

MySQL backup and cleanup bash scripts with mydumper
+1 Vote Up -0Vote Down

1. Backup script

#!/bin/sh
# Fri Jun 27 10:44:49 2014
# done by dragkh
# usage: 
# cat /etc/cron.d/backupmysql 
# 0  3  *  *  *       root    /root/bin/clean.backup.hyperion.mysql.mydumper.daily.sh >>  /var/log/clean.backup.${HOSTNAME}.mysql.mydumper.daily.log 2>&1
# 35  3  *  *  *       root    /root/bin/backup.hyperion.mysql.mydumper.daily.sh >> /var/log/backup.${HOSTNAME}.mysql.mydumper.daily.log 2>&1

ROOT_BACKUP_DIR="/home/mydumper"

seik_date () {
if [ -z $1 ]
then
# cdate=`date +%Y-%m-%d\ %H:%M:%S\ %Z`; export cdate; echo $cdate
cdate=`date -R`; export cdate; echo $cdate
else

if [ -z ${2} ]
then
cdate=`date +%Y-%m-%d.%H.%M.%S`; export cdate; echo $cdate
else
cdate=`date "+%Y-%m-%d %H:%M:%S"`; export cdate; echo $cdate
fi

fi
}


function check_dir {
 test ! -d
  [Read more...]
How To Install Nginx With PHP5 (And PHP-FPM) And MySQL Support On CentOS 6.5
+0 Vote Up -0Vote Down

How To Install Nginx With PHP5 (And PHP-FPM) And MySQL Support On CentOS 6.5

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 a CentOS 6.5 server with PHP5 support (through PHP-FPM) and MySQL support.

Using Percona Server 5.6 with the Docker open-source engine
+0 Vote Up -0Vote Down

There are a couple of posts about setting up Percona XtraDB Cluster on Vagrant and Percona Server on MySQL Sandbox – those are two of the top tools used by the Percona Support team for testing and bug processing among other things.

In this post, however, I will show you how to use Docker with Percona Server on Ubuntu 12.04.

As per Docker’s official site:

Docker is an open-source engine that automates the deployment of any application as a lightweight, portable, self-sufficient container that will run virtually

  [Read more...]
The Perfect Server - CentOS 6.5 x86_64 (Apache2, MySQL, PHP, PureFTPD, Postfix, Dovecot and ISPConfig 3)
+0 Vote Up -0Vote Down

The Perfect Server - CentOS 6.5 x86_64 (Apache2, Dovecot, ISPConfig 3)

This tutorial shows how to prepare a CentOS 6.5 x86_64 server for the installation of ISPConfig 3, and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more. Since version 3.0.4, ISPConfig comes with full support for the nginx web server in addition to Apache; this tutorial covers the setup of a server that uses Apache, not nginx.

‘Open Source Appreciation Day’ draws OpenStack, MySQL and CentOS faithful
+1 Vote Up -0Vote Down

210 people registered for the inaugural “Open Source Appreciation Day” March 31 in Santa Clara, Calif. The event will be held each year at Percona Live henceforth.

To kick off the Percona Live MySQL Conference & Expo 2014, Percona held the first “Open Source Appreciation Day” on Monday, March 31st. Over 210 people registered and the day’s two free events focused on

  [Read more...]
Install Apache2, PHP5 And MySQL Support On CentOS 6.5 (LAMP)
+0 Vote Up -0Vote Down

Install Apache2, PHP5 And MySQL Support On CentOS 6.5 (LAMP)

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

Compile at CentOS 6.5 the new MySQL webscalesql-5.6.17 branch by Facebook, Google, LinkedIn, and Twitter
+1 Vote Up -0Vote Down

http://webscalesql.org/

yeah , big buzz around that one :)

So I decided to check the install process:

1. Clone the repo from

root@webscalesql-5.6.clean:[Mon Mar 31 11:37:11][~]$ cd /opt/
root@webscalesql-5.6.clean:[Mon Mar 31 11:37:15][/opt]$ mkdir installs
root@webscalesql-5.6.clean:[Mon Mar 31 11:37:17][/opt]$ cd installs/
root@webscalesql-5.6.clean:[Mon Mar 31 11:37:19][/opt/installs]$ git clone https://github.com/webscalesql/webscalesql-5.6.git
Initialized empty Git repository in /opt/installs/webscalesql-5.6/.git/
remote: Counting objects: 30397, done.
remote: Compressing objects: 100% (12678/12678), done.
remote: Total 30397 (delta 18716), reused
  [Read more...]
9 Reasons For Attending The Percona Live MySQL Conference & Expo 2014
+0 Vote Up -0Vote Down
March 28, 2014 By Severalnines

 

Percona Live MySQL Conference & Expo - March 31st to April 4th

The Severalnines Team Will Be Onsite at Booth 418 - Come Say Hello!

 

 

If you’re still thinking about whether or not you should be attending the Percona Live MySQL Conference & Expo that starts on Monday 31st of March, here are 9 reasons (we are Severalnines after all) on why we’ll be there. May these help you positively in

  [Read more...]
Open Source Appreciation Day at Percona Live
+0 Vote Up -0Vote Down

I wrote previously about Percona Live Santa Clara 2014, and I want to bring to your attention something Percona has done that is very nice to open source communities: have an open source appreciation day.

Its before the conference (so on Monday), and you get a choice between the CentOS Dojo (great lineup there including many from Red Hat, Monty from MariaDB, and PeterZ from Percona) or the OpenStack

  [Read more...]
Install MySQL fork MariaDB 10.0.9 on CentOS release 6.5 with server_audit-1.1.5 and oqgraph-engine
+0 Vote Up -0Vote Down

I needed to test the new server audit plug-in on latest MariaDB 10.0.9
More info about that handy plug in you may find here : http://www.skysql.com/downloads/mariadb-audit-plugin
Take a moment to read the info, along with that nice blog : http://www.skysql.com/blogs/ralf-gebhardt/activating-auditing-mariadb-and-mysql-5-minutes

In short:

root@mariadb-10.0.9:[Mon Mar 24 07:51:54][/tmp/]$ lftp http://ftp.igh.cnrs.fr/pub/mariadb/mariadb-10.0.9/yum/
cd ok, cwd=/pub/mariadb/mariadb-10.0.9/yum                                   
lftp ftp.igh.cnrs.fr:/pub/mariadb/mariadb-10.0.9/yum> bookmark add mariadb-10.0.9
lftp


  [Read more...]
Connect MySQL to sqlite3 database or to flat txt file via CONNECT engine of MariaDB 10.0.7 on Fedora/CentOS
+0 Vote Up -0Vote Down

You might don’t know that, but the MariaDB engines are amazing ..
More info you can find here:
https://mariadb.com/kb/en/mariadb-storage-engines/

I was teased by CONNECT engine : https://mariadb.com/kb/en/connect/

What is good for ? Well, I leave that to your imagination, as you could have MariaDB as a spider connected and managing InnoDB tables, flat files, MS ACCESS databases, MS Excel files … all that in same time.
So how to use it?
By the documentation :
1. https://mariadb.com/kb/en/loading-the-connect-handler/
check if there is





  [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 ,… Continue Reading →

Continue reading Correcting mysql.sock connection error

Related posts:
  • Corrigindo erro de conexão com mysql.sock
  • zend framework 2 with lighttpd
  • Main Subversion commands
  • How to install MySQL 10.0.6-MariaDB and to compile lib_mysqludf_preg on CentOS 6.4
    +0 Vote Up -0Vote Down

    In short, during an optimization or a MySQL query involving a lot of replace(replace(replace…))) I decided to compile PREG as lib_mysqludf_preg from UDF Repository for MySQL in a view to use PCRE functions directly in MySQL.

    Too bad MySQL still cant not use functions for index creation, but this is not the theme of this post.

    So, fist install MariaDB 10.0.6:
    set the MariaDB 10.0.6 repo, I used the ftp mirror at ftp.ulak.net.tr

    
    root@seik-centos-01:[Wed Dec 18 23:55:12][/tmp]$ cat /etc/yum.repos.d/MariaDB.repo 
    # MariaDB 10.0 CentOS repository list - created 2013-12-18 18:07 UTC
    # http://mariadb.org/mariadb/repositories/
    [mariadb]
    name = MariaDB
    #baseurl = http://yum.mariadb.org/10.0/centos6-amd64
    baseurl =

      [Read more...]
    How to Enable MySQL Event Scheduler
    +0 Vote Up -0Vote Down

    You may think that you already know what's the opposite of "DISABLED", but with MySQL Event Scheduler you'll be wrong.

    In fact MySQL Event Scheduler may have three different states[1][2]:

    DISABLED -  The Event Scheduler thread does not run [1]. In addition, the Event Scheduler state cannot be changed at runtime.
    OFF (default) - The Event Scheduler thread does not run [1]. When the Event Scheduler is OFF it can be started by setting the value of event_scheduler to ON.
    ON - The Event Scheduler is started; the event scheduler thread runs and executes all scheduled events.
    

    So if you're going to find it in the DISABLED state and instinctively set it to ENABLED you'll end up with a non-starting MySQL daemon.
    Be warned and stay safe out there!


    [1]: http://dev.mysql.com/doc/refman/5.5/en/events-configuration.html
    [2]: When the Event Scheduler is not running does not appear in the output of SHOW PROCESSLIST
    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: […]
    Public DNS resolve for VM instances hosted at OpenStack nova compute grizzly edition
    +0 Vote Up -0Vote Down

    Issue – the OpenStack instances hostnames are not resolved at the moment by their floating IPs.

    Fast solution – use PowerDNS
    Short story:
    1. Boot an instance , assign it a floating IP, open tcp ports 22 8001 and udp port 53.
    2. Install PowerDNS, the particular yum package is named pdns.
    3. install the mysql backend for PowerDNS, its available as yum package as well.
    4. Install MariaDB , set the proper configuration, the initialize it at the default location.
    5. Set the pdns user, create the pdns database and create the tables needed.
    6. Configure the pdns service to use the gmysql backend.
    7. Create and user at the OpenStack MySQL able to connect from the floating IP subnet.
    8. Grant that user select permissions on all nova.* tables.
    9. At the PowerDNS









      [Read more...]
    On operating system upgrades and a packager’s nightmare
    +1 Vote Up -0Vote Down

    A fairy tale

    Once upon a time I did an operating system upgrade, a minor one that should do no harm, but just get me up to date by fixing any bugs in the version I had been using. It seemed like a good idea.

    All seemed to be fine. I use a package provided by an external vendor and not the one produced by the operating system provider as this vendor provides a newer version of the package and I need that. The vendor has to make his package fit in the os environment his package is built for and normally does a pretty good job.

    I use automation to build my systems and when I built a new one some issues appeared. Related to the new version of the OS the provider had enhanced one of his packages and the installation pulled in new dependencies. The install of the external package I use then broke as it conflicted with the new dependency

      [Read more...]
    MariaDB 10.0.3: installing the additional engines
    +4 Vote Up -0Vote Down

    So MariaDB 10.0.3 Alpha is out. Download it and remember to provide feedback.

    When you run SHOW ENGINES by default, you don’t get CassandraSE or the CONNECT engine. Make sure you do a yum install MariaDB-cassandra-engine and a yum install MariaDB-connect-engine. 

    You will run into conflicts if you had an older MariaDB-CassandraSE engine (so yum remove MariaDB-CassandraSE).

    Once you’ve got the packages installed, you can either install the plugin or just restart mysqld.

    Happy testing!

      [Read more...]
    How To Run Your Own Web SMS Portal With PointSMS
    +0 Vote Up -0Vote Down

    How To Run Your Own Web SMS Portal With PointSMS

    This tutorial will show you how you can set up an SMS web site on CentOS using PointSMS.

    How to fix the Percona repo failure when installing Percona Toolkit
    +0 Vote Up -0Vote Down

    Here’s a solution to the not-so-long-standing issue of the Percona yum repo being broken for the CentOS 6 x86_64 version of the Percona-toolkit package. The repo listing is reporting an older version of the RPM which is not available on the site, so to fix this you just have to download the newer file and tell yum to add it locally. The side benefit is that you can use Yum to manage the RPM without adding the Percona repo, since the default settings for their repo could/have/had caused conflicts with Base Repo versions of MySQL packages; the Percona repo instructions set ‘enabled=1′ — not a great idea if you’re not setup to use the Yum priorities method of repo weighting.

    So, if you see this after installing the repo via the instructions on their site:
    Downloading Packages:


      [Read more...]
    Using MariaDB on CentOS 6
    +4 Vote Up -0Vote Down

    This is just for testing purposes, but you might want to play around with MariaDB 5.5.29 coming via the CentOS 6 repositories as mentioned in this post. Please test it out and report bugs if required. The process was simple on a fresh install:

    yum update
    cd /etc/yum.repos.d/
    wget http://dev.centos.org/centos/6/mariadb/mariadb.repo
    yum list mariadb\*
    yum install mariadb-server mariadb
    /etc/init.d/mysqld start

    That’s it, it just works. It comes with MEMORY, CSV, MRG_MYISAM, BLACKHOLE, MyISAM, PERFORMANCE_SCHEMA, ARCHIVE, FEDERATED, InnoDB (XtraDB) and Aria.

    Remember this replaces mysql-libs, and is set to replace MySQL in your install. Here’s hoping it hits mainline CentOS soon.

    Related posts:

  •   [Read more...]
    Migrating MySQL 5.5.25a jiradb ERROR 2013 (HY000) on huge single db import
    +0 Vote Up -0Vote Down

    well, I incremented max_allowed_packet from 16M to 512M
    anyway, I got the same error on the next clean import.
    so decided to find a workaround.
    so, how to get the data separated from the ddl statements:

    # get the tables names into the insert statement, its better to have that in file for future usage
    sed '/^INSERT INTO/!d;s/ VALUES.*$//' jiradb.20130118.sql | sort | uniq > tablas.como.nombres.txt
    

    then how to get the data separated:

    root@jiragg:[Fri Jan 18 15:26:33]:[/usr/local/BACKUP]$ cat make.inserts.sh
    #!/bin/sh
    # trim function thank to http://stackoverflow.com/questions/369758/how-to-trim-whitespace-from-bash-variable
    # and http://codesnippets.joyent.com/posts/show/1816
    trim() {
        local var=$1
        var="${var#"${var%%[![:space:]]*}"}"   # remove



      [Read more...]
    Install MySQL at non default data directory on different drive on CentOS6.3/RHEL 6
    +0 Vote Up -0Vote Down

    We assume the new disk is /dev/sdb1 formatted as ext3
    and it will be mounted as /data

    # 0. make sure there is no mysqlm mysql data directory :
    yum remove mysql mysql-server -y 
    test -d /data/mysql/ && rm -rf /data/mysql/
    test -d /var/lib/mysql/ && rm -rf /var/lib/mysql/
    
    # 1. install Mysql
    yum install mysql mysql-server -y
    
    # 2. check the mysql  status
    service mysqld status
    
    # 3. start the mysqld if not started
    service mysqld start
    
    # 4. check the mysql status again
    service mysqld status
    
    # 5. stop mysqld in case its started, and check thre is n mysql process:
    service mysqld stop
    ps axu | grep mysql
    
    # 6. make sure the /data partition is added to the /etc/fstab. If not add it:
    test  `cat  /etc/fstab | grep /data | wc -l ` -eq 0  && echo "/dev/sdb1 /data ext3

      [Read more...]
    Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On CentOS 6.3
    +0 Vote Up -0Vote Down

    Installing Lighttpd With PHP5 (PHP-FPM) And MySQL Support On CentOS 6.3

    Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on a Centos 6.3 server with PHP5 support (through PHP-FPM) and MySQL support. PHP-FPM (FastCGI Process Manager) is an alternative PHP FastCGI implementation with some additional features useful for sites of any size, especially busier sites. I use PHP-FPM in this tutorial instead of Lighttpd's spawn-fcgi.

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

    Installing Apache2 With PHP5 And MySQL Support On CentOS 6.3 (LAMP)

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

    The blog was down yesterday
    +0 Vote Up -0Vote Down

    The brief outage was due to a scheduled move of the servers to a separate rack and subnet dedicated to our work with the Center for Information Assurance & Cybersecurity (ciac) at the University of Washington Bothell (uwb), and a11y.com

    I am currently exercising the new (to us) equipment and hope to winnow the less than awesome equipment over the next quarter. I spent the last six months finding the best in breed of the surplussed DL385 and DL380 chassis we (work) were going to have recycled. The team and I were able to find enough equipment to bring up one of each with eight and six gigs of memory, respectively. These will make excellent hypervisors for provisioning embedded instances of Slackware, Fedora, RHEL, CentOS, Debian, FreeBSD, OpenSolaris, OpenIndiana, FreeDOS, etc.

    When I initially configured this xen paravirt environment, I failed to plan for integration with libvirt, so I am

      [Read more...]
    Creating A Portable MySQL On CentOS 6 And Ubuntu 11.10 Linux From Sources
    +0 Vote Up -0Vote Down

    Creating A Portable MySQL On CentOS 6 And Ubuntu 11.10 Linux From Sources

    This tutorial shows how to create a portable MySQL installation on GNU/Linux. At the end of this guide you will obtain a portable MySQL installation on a target directory with its own databases, binaries, logs, pid files, etc.  Consider always the use of a permission preserving packaging (like TAR) for moving the installation between systems or removable storages.

    Installing Apache2 With PHP5 And MySQL Support On CentOS 6.1 (LAMP)
    +1 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On CentOS 6.1 (LAMP)

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

    Showing entries 1 to 30 of 108 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.