Showing entries 31 to 40 of 129
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: centos (reset)
9 Reasons For Attending The Percona Live MySQL Conference & Expo 2014

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 your decision making ;-)

 

1. The 2014 edition showcases the most promising program yet

 

Sounds like a cliché-reason to be listed here, but this year’s program is in fact quite diversified …

[Read more]
Open Source Appreciation Day at Percona Live

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 Today (another great lineup …

[Read more]
Install MySQL fork MariaDB 10.0.9 on CentOS release 6.5 with server_audit-1.1.5 and oqgraph-engine

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 ftp.igh.cnrs.fr:/pub/mariadb/mariadb-10.0.9/yum> ls
drwxr-xr-x  --  ..                   
drwxr-xr-x            - …
[Read more]
Connect MySQL to sqlite3 database or to flat txt file via CONNECT engine of MariaDB 10.0.7 on Fedora/CentOS

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 CONNECT already installed, if not, install it:

mysql root@mariadb-10.0.7:[Wed Jan 29 09:36:14 2014][(none)]> show …
[Read more]
Correcting mysql.sock connection error

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:

  1. Corrigindo erro de conexão com mysql.sock
  2. zend framework 2 with lighttpd
  3. Main Subversion commands
How to install MySQL 10.0.6-MariaDB and to compile lib_mysqludf_preg on CentOS 6.4

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 = ftp://ftp.ulak.net.tr/pub/MariaDB/mariadb-10.0.6/yum/centos6-amd64/
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1 …
[Read more]
How to Enable MySQL Event Scheduler

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 …

[Read more]
Installing MySQL on Ubuntu and CentOS

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

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 instance, set simple python / php / bash script to query the nova database and to inject the hostnames and the …

[Read more]
On operating system upgrades and a packager’s nightmare

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 provided by the OS.  While a workaround is possible: uninstall …

[Read more]
Showing entries 31 to 40 of 129
« 10 Newer Entries | 10 Older Entries »