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

Displaying posts with tag: rhel (reset)

How to install MySQL 5.6 on CentOS 7
+0 Vote Up -0Vote Down

A bit of history

The latest version of Red Hat Enterprise Linux, one of the most popular and respected Linux distributions in the server market, was released in June 2014, followed by CentOS 7 and Oracle Linux releases in July of the same year.

There are very interesting changes for database administrators in these new releases, among which I would like to highlight the fact that installer now chooses XFS as its filesystem by default, which

  [Read more...]
How to install Phalcon PHP framework in Ubuntu linux?
+0 Vote Up -0Vote Down
Well, we have all heard about the fastest php framework out there. But how do we install it in a Ubuntu Linux machine.

Default process for any linux setup.

Steps:

1. First, we need  a few packages previously installed. To install them, issue the distro specific command in your linux terminal.

For Ubuntu:

sudo apt-get install php5-dev php5-mysql gcc libpcre3-dev

For Fedora:

sudo yum install php-devel php-mysqlnd gcc libtool

For RHEL:

sudo yum install php-devel php-mysql gcc libtool

For Suse:

yast2 -i php5-pear php5-devel php5-mysql gcc

Basically, here we are installing the dev tools we require to compile and setup the Phalcon extension.

2. Get the Phalcon build using

























  [Read more...]
RHEL7 now with MariaDB
+3 Vote Up -1Vote Down

Congratulations to the entire team at Red Hat, for the release of Red Hat Enterprise Linux 7 (RHEL7). The release notes have something important, under Web Servers & Services:

MariaDB 5.5

MariaDB is the default implementation of MySQL in Red Hat Enterprise Linux 7. MariaDB is a community-developed fork of the MySQL database project, and provides a replacement for MySQL. MariaDB preserves API and ABI

  [Read more...]
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...]
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...]
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...]
    Daily backup OpenStack single MySQL with Percona innobackupex including the /etc directory
    +0 Vote Up -0Vote Down

    this is a short script for daily backup of the OpenStack MySQL and the /etc direcotry of the control node

    [root@dev-epg-rhos-01 BACKUP]# cat /root/bin/epg.innobackupex.openstack.sh
    #!/bin/sh
    # done for epgmad4@tid.es
    # Barcelona Thu Oct 17 16:30:36 CEST 2013
    
    days_to_keep=7
    NFS=/BACKUP
    exportDate=`date +%Y-%m-%d.%H.%M.%S`
    export_DIR=${NFS}/${HOSTNAME}.${exportDate}
    test ! -d "${export_DIR}" && echo "$(date) : creating ${export_DIR}" && mkdir -p "${export_DIR}"
    export_MySQL_DIR=${export_DIR}/mysql.bckp
    export_ETC_DIR=${export_DIR}/etc.bckp
    rsync -avh /etc ${export_ETC_DIR}
    echo "=========================================================================================================" >> ${export_DIR}/README.restore.with.innobackupex
      [Read more...]
    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...]
    Some MariaDB related news from the Red Hat front
    +1 Vote Up -0Vote Down

    This is a followup to my early post a month ago titled: MariaDB replaces MySQL in RHEL 7 (lots of stuff in the comments). It’s clear that MariaDB’s role is in Software Collections, which is new in RHEL.

    Steven J. Vaughan-Nichols writes Red Hat will switch from Oracle MySQL to MariaDB, reports.

    Sean Michael Kerner has a video (and writeup) with Denise Dumas, RHEL team leader, who talks about Software Collections, MariaDB, and how

      [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...]
    Showing entries 1 to 10 of 28 10 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.