Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 14:03, Reindl Harald wrote: [...] el5 = RHEL5 el6 = RHEL6 may i suggest to hire someone managing your systems [...] It seems that I gave a wrong impression, but we actually have a big team of sys admins :) so what are they doing then all day long since you still run 5.5 release

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 13:53, Johan De Meersman wrote: - Original Message - From: "Dimitre Radoulov" Sent: Tuesday, 15 April, 2014 12:17:54 PM for major release upgrades - 5.x to 6.x - we'll use a different hosts. I would like to point out that where MySQL is concerned, the minor versions are

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 13:53, Martin Gainty wrote: [...] > It seems that I gave a wrong impression, but we actually have a big team > of sys admins :) MG>he is asking that you hire an experienced DBA MG>(vs packing up your office with Einwanderer) Wow! Thank you! Putting back the list in CC for the be

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 12:18, Reindl Harald wrote: Am 15.04.2014 12:05, schrieb Radoulov, Dimitre: [...] o ABI breakages, that's why you use RHEL or a clone at all Thank you! So I suppose we need to, or actually we *must*, upgrade the binaries only in case of a release upgrade (RHEL 5 to 6, for ex

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
On 15/04/2014 12:13, Manuel Arostegui wrote: [...] Thank you! So I suppose we need to, or actually we *must*, upgrade the binaries only in case of a release upgrade (RHEL 5 to 6, for example), i.e. when a different binary distribution exsists: MySQL-5.6.17-1.rhel5.x86_64.rpm to MySQL-5.

Re: Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
Hi Reindl, On 15/04/2014 11:32, Reindl Harald wrote: Am 15.04.2014 11:22, schrieb Radoulov, Dimitre: we're going to patch our MySQL servers. Most of them are RHEL/OEL 5.x and are going to be upgraded to 5.x+n (for example 5.5 to 5.10). I don't seem to find anything about this in th

Things to be considered before/after the OS patch or upgrade

2014-04-15 Thread Radoulov, Dimitre
Hi all, we're going to patch our MySQL servers. Most of them are RHEL/OEL 5.x and are going to be upgraded to 5.x+n (for example 5.5 to 5.10). I don't seem to find anything about this in the official documentation (verifying the patch compatibility, relinking etc.). Any hints? Best regards

Re: All command has no content, only yield "x rows in set"

2013-09-18 Thread Radoulov, Dimitre
On 18/09/2013 16:17, zxycscj wrote: execute mysql command has no content. help [...] mysql> use ijdb; Database changed mysql> show tables; 7 rows in set (0.00 sec) [...] I suppose that the mysql pager is set to a non-default value. On the mysql prompt try: pager repeat your command here ...

Re: Possible issues with replication filters

2013-03-26 Thread Radoulov, Dimitre
Hi Shawn, thanks for replying! Comments in-line. On 25/03/2013 21:51, shawn green wrote: Hello Dimitre, On 3/24/2013 5:23 PM, Radoulov, Dimitre wrote: [...] The documentation states the following about the replicate-wild-do-table option: == This option applies to tables, views, and triggers

Possible issues with replication filters

2013-03-24 Thread Radoulov, Dimitre
Hi all, we need to move a few databases from one host to another. During the process we need to use replication filters (to replicate only the databases to be moved). The current MySQL version is 5.5, the new one will be 5.6. We're using "mixed" binlog_format. We're planing to use: replicate-wil

Re: Mysql backup for large databases

2012-11-01 Thread Radoulov, Dimitre
On 01/11/2012 11.28, Machiel Richards - Gmail wrote: [...] I am busy investigating some options relating to the backup for MySQL databases when they get quite large. When using the MySQL enterprise, there is the option to use the MySQL enterprise backup as it is part of the Enterprise

Re: MySQL Replication - promote slave

2011-06-22 Thread Radoulov, Dimitre
On 22/06/2011 15:21, Matthias Urlichs wrote: Hi, 1. flush logs on the master (only if it's accessible, of course). Not really necessary if you block clients (firewall rule for new connections to port 3306?). Hi Matthias, thank you for replying! Isn't the flush logs command necessary in or

MySQL Replication - promote slave

2011-06-21 Thread Radoulov, Dimitre
Hi all, I need to document the switch between master and slave and I want to double check if the outlined procedure is correct. We have a simple master slave replication setup on OEL 5.5 and MySQL 5.5.13. Original config: machineA master, machineB slave. Target: machineB master, machineA not

MySQL - licensing data recovery environments

2011-04-06 Thread Radoulov, Dimitre
Hi all, does anybody know where can I find a recent guide/information regarding the licensing of data recovery environments with /MySQL Enterprise Server/? Regards Dimitre -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: source backup.sql - troubleshoot

2010-05-26 Thread Radoulov, Dimitre
On 26/05/2010 12.18, Sydney Puente wrote: [...] CREATE DATABASE /*!32312 IF NOT EXISTS*/ `event` /*!40100 DEFAULT CHARACTER SET latin1 */; USE `event`; Can I have the commands being issued echo to the screen somehow, so I can identify which command is causing the problem? Or investigate

Bug fixes and MySQL versions/releases

2009-12-15 Thread Radoulov, Dimitre
Hi all, I was informed by our security team about a recent attack attempts related to the following MySQL issue/bug: MySQL_Check_Scramble_Auth_Bypass (see tinyurl.com/y8vjbmm fro more info): Systems Affected: MySQL 4.1 prior to 4.1.3, and MySQL 5.0. We have MySQL Server 5.0.45 on RHEL 5.3,

MySQL 5.0.45-0 to 5.0.45-7

2009-04-10 Thread Radoulov, Dimitre
Hi all, because of OS upgrade (RHEL) we need to upgrade from 5.0.45-0 (rpm MySQL-server-community-5.0.45-0.rhel5) to 5.0.45-7. We have also a replication slave on another host with the same version (and I'm not sure if we have to upgrade that one too). It's only about an rpm RHEL package upgra

Re: Count total number of records in db

2008-07-11 Thread Radoulov, Dimitre
Warren Windvogel wrote: Hi, Can anyone tell me how to check the total number of records in a database in MySQL version 4.0 Googling doesn't seem to help and all previous posts assume version 5.* [...] Something like this: mysql -NBe'show databases' | while IFS= read -r db; do printf