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 27

Displaying posts with tag: rhel (reset)

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.


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


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


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:

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
    # done for epgmad4@tid.es
    # Barcelona Thu Oct 17 16:30:36 CEST 2013
    exportDate=`date +%Y-%m-%d.%H.%M.%S`
    test ! -d "${export_DIR}" && echo "$(date) : creating ${export_DIR}" && mkdir -p "${export_DIR}"
    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...]
    MariaDB replaces MySQL in RHEL7
    +6 Vote Up -5Vote Down

    Subject says its all, this is of course, very good news coming out of the Red Hat Summit. Looking forward to Red Hat Enterprise Linux 7. And of course, CentOS 7 and the other builds that follow. Thank you Red Hat!

    MariaDB replaces MySQL in RHEL 7. Glad to see that. #rhsummit

    — Major Hayden (@majorhayden) June 12, 2013

    at #rhsummit , rhel7 will come without mysql as it will be replaced with mariaDB; which is mysql api compatible. it will include mongodb too

      [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
    # 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...]
    Log Buffer #279, A Carnival of the Vanities for DBAs
    +0 Vote Up -0Vote Down
    In a typical organization, all work together to bring out a common good for the outside world. It’s interesting to see how all of these entities blog about technology, and there is more and more interest shown by managerial technologists about the database. This Log Buffer Edition appeases their appetites along with the others in [...]
    451 CAOS Links 2011.12.09
    +0 Vote Up -0Vote Down

    Funding for BlazeMeter and Digital Reasoning. Red Hat goes unstructured. And more.

    # BlazeMeter announced $1.2m in Series A funding and launched the a cloud service for load and performance testing.

    # Digital Reasoning announced a second round of funding to help develop its Hadoop-based analytics offering.

    # Red Hat announced the availability of Red Hat Storage Software Appliance, based on its recent acquisition of Gluster.

    # Red Hat also

      [Read more...]
    Got open source cloud storage? Red Hat buys Gluster
    +0 Vote Up -0Vote Down

    Red Hat’s $136m acquisition of open source storage vendor Gluster marks Red Hat’s biggest buy since JBoss and starts the fourth quarter with a very intersting deal. The acquisition is definitely good for Red Hat since it bolsters its Cloud Forms IaaS and OpenShift PaaS technology and strategy with storage, which is often the starting point for enterprise and service provider cloud computing deployments. The acquisition also gives Red Hat another weapon in its fight against VMware, Microsoft and others, including OpenStack, of which Gluster is a member (more on that further down). The deal is also good for Gluster given the sizeable price Red Hat is paying for the provider of open source, software-based, scale-out storage for unstructured data and also as validation of both open source and software in

      [Read more...]
    Open Query looking for new colleagues!
    +1 Vote Up -1Vote Down
    My colleagues and I are looking for extra talent – is that you? What we do:help clients prevent problems (rather than being the fire department), we work on a subscription basis although we also do some ad-hoc consulting, and training. Apart from MySQL/MariaDB query and DBA work, we do quite a bit of system administration. Mainly Red Hat and Debian based distros, and expect to see replication and the MySQL-MMM multi-master system. You’d work from home, whereever it might be, so you will need to be self-motivating (but we do keep in touch online). What we’re not: a full-time employer. With us, you make a life rather than a living. Everybody is contracted part-time. You can make enough to live comfortably, but that has nothing to do with hours. If you’re stressed about not filling all hours in your week with work-work-work, we’re not  [Read more...]
    MariaDB 5.2 repository for RHEL/CentOS
    +2 Vote Up -0Vote Down

    Until now, MariaDB 5.2 was lacking a yum repository for easy installs and upgrades. It is now available, thanks to OurDelta.

    Just follow our very simple installation instructions.

    Linux bash: check the MySQL database disk usage
    +0 Vote Up -0Vote Down
    # get.database.sizes.sh
    # by dragkh
    # Wed, 02 Mar 2011 17:59:44 +0100
    # it will work on linux boxes with working mysql 
    ps axu \
    | grep datadir \
    | grep mysql \
    | grep -v grep \
    | grep var \
    | sed 's/^.*--datadir=//; s/ .*$//'   \
    | sort \
    | uniq  \
    | while read crap
    echo ""
    sized=$(du -s $crap | awk '{print $1}')
    avail=$(df | grep $(dirname $crap) | awk '{print $2}')
    echo -e  "$crap\t$sized\t$avail" | awk '{printf ("%s:\tUsed: %6.2fG \tDISK: %6.2fG\t Usage: %6.2f%% \n",$1,$2/1024/1024,$3/1024/1024,($2/$3)*100)}'
    find $crap/ -maxdepth  1 -type d ! -type l  ! -path "$crap/"   -printf '"%p"\n'  | xargs  --no-run-if-empty  du -s | sort -nk 1,9 | awk -vavail=$avail '{crapy="";for(i=2; i<=NF; i++) {crapy=crapy" "$i;};printf (" -- %s\tUsed: %6.2fG
      [Read more...]
    Downloading, compiling, and installing MySQL Server from source code
    +0 Vote Up -0Vote Down

    This content has been updated and moved to a new place.

    If you are running any GNU/Linux server operating system like RHEL 5 or CentOS 5, you may probably install MySQL server that comes with the operating system packages either during the initial setup or later using yum(8). The advantage being addition/removal of packages either using the GUI package manager or rpm(8), yum(8). Fair enough. But unfortunately the MySQL package (mysql-server) that comes bundled with RHEL 5.5 or CentOS 5.5 is fairly old (5.0.77). What if you want to install the latest stable version of MySQL yet have the advantage of removing/re-installing the software using rpm(8)?

    In this blog post, I will guide you with compiling MySQL from source code yet installing the software through rpm(8) so that we tune and

      [Read more...]
    451 CAOS Links 2010.02.12
    +0 Vote Up -0Vote Down

    Licensing, community, funding, revenue, business models, patents. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
    “Tracking the open source news wires, so you don’t have to.”

    # The OpenOffice.org Community announced the release of OpenOffice.org 3.2.

    # An interview with Michael Tiemann on licensing and community.

    # DotNetNuke raised $8m series B funding.

    # Microsoft updated its Linux Integrated Components, introducing support for RHEL in Hyper-V.

    # An interview with Marten Mickos on how open source businesses can break through the

      [Read more...]
    MariaDB 5.1.39 for Debian, Ubuntu, RHEL/CentOS
    +1 Vote Up -0Vote Down

    You can now yum (RPM) or apt-get (DEB) MariaDB 5.1.39, courtesy of OurDelta and in close cooperation with Monty Program Ab. Simply follow the info on the CentOS, Debian or Ubuntu pages.

    (note: give the mirrors some hours to sync up)

    Quick overview

    • See the Release Notes for relevant bugfixes.
    • Drop-in replacement for stock MySQL 5.0 or 5.1 (If you’re coming from stock MySQL, see the MariaDB extras/differences overview).
    • If you are upgrading from 5.0, please review the
      [Read more...]
    MySQL 5.0.87-d10 OurDelta packages
    +1 Vote Up -0Vote Down

    MySQL 5.0.87-d10 OurDelta builds are now available (32 and 64-bit):

    Apart from the 5.0.87 upstream fixes there were a few minor fixes in the build environment, and one updated Percona patch. The -sail builds now include the OQGRAPH engine. Source packages are with the respective distro repos, and there are base source  [Read more...]
    MySQL in RHEL5/CentOS5 gets an update
    +1 Vote Up -0Vote Down

    It’s worth noting that Red Hat Enterprise Linux (RHEL) 5 has had an update to MySQL in the last month. This naturally means that CentOS 5 also had a similar update. It’s now bumped up to MySQL 5.0.77 (goodbye 5.0.45!; which is what RHEL5 shipped with). This is a moderate security release, so consider updating, if you can afford a mysqld restart.

    Read more about the 4 CVE bugs fixed. CentOS followed suit within two weeks.

      [Read more...]
    Red Hat’s organic growth opportunities
    +0 Vote Up -0Vote Down

    We reported recently on Red Hat’s revenue growth and deferred revenue. One of the things I have been looking at recently is the slowdown in Red Hat’s growth in recent years, and the opportunities that the company has to improve that growth.

    For some perspective it is worth noting that while Red Hat’s revenue has been growing steadily:

    The rate of growth has been in decline for some time:

      [Read more...]
    MySQL: How do you enable sphinxse (Sphinx Storage Engine) in your mysql installation?
    +0 Vote Up -0Vote Down

    As you may know mysql fulltext search is not highly scalable.  One of the options to get around this scalability limitation, which I prefer, is to use Sphinx.  You can use Sphinx with out having to alter your mysql installation.  But, if you would like to use from within mysql and not have to worry about how to pass data between Sphinx and MySQL, you can enable sphinxse (sphinx storage engine).  It is not included with mysql by default so you will have to compile it yourself.

    Here are the instructions on how to get sphinxse compiled with your mysql installation on CentOS x64.  I am sure same instructions will work for other flavors but I have not tested it.  I will be compiling the most current version of sphinx (0.9.8) with most current stable version of mysql (5.0.51b) at the time of the writing. 

      [Read more...]
    Maatkit in RHEL and CentOS
    +0 Vote Up -0Vote Down

    Update: Karanbir says “Just one thing to keep in mind is that we dont want too many people using it from the Testing repository - we only need enough feedback to move it from testing to stable ( and to be honest, there are already 8 people who have said yes it works - so move to stable should happen within the next 24 - 48 hrs ). Once the package is in stable, users on CentOS4 and 5 wont need to do anything more than just ‘yum install maatkit’ and it will install for them.”

    At least one person (Karanbir Singh) is working to get Maatkit into the CentOS repositories, and I believe there might be movement towards RHEL also. From an email to the Maatkit discussion list a little while ago,

    I am in

      [Read more...]
    Duplicate binlog-do-db entry ? Solution
    +0 Vote Up -0Vote Down
    At the November MySQL User Group, Patrick Galbraith ran into a problem where binlog-do-db was duplicated. It manifests itself like this: (copied from http://lists.mysql.com/replication/607) master my.cnf: binlog-do-db=db1 slave my.cnf: replicate-do-db=db1; Relevant show slave status output Replicate_Do_DB: db1;,db1; When db1 is modified on master, Read_Master_Log_Pos and Relay_Log_Pos do changes, also I can open and see the changes in rh3-relay-bin.000002, but they do not appear in [...]
    Showing entries 1 to 27

    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.