Ssd vs mix of ssd and spinning disk

Hello, We have traditionally setup our mysql database servers with a mix of ssd and spinning disk drives. We use the ssd drives (Raid-1) for the mysql tablespace data, and we use the spinning disks (15 sas in Raid-1) for the index data, etc. I am wondering if going forward we should simply put

Re: which mysql 64 bit binary for PowerEdge 1950 ?

Sanjeev, As far as I know that is the version you should use. Shain Sanjeev Sagar wrote: Is there anyone, who is using the mysql 64 bit on Intel(R) Xeon(R) CPU processors? Will it be *IntelEM64T* ? Regards, Sanjeev Sagar wrote: Hello Everyone, I would like to verify that which mysql 64

Mysql Replication out of sync

Hello all, I noticed that my two Mysql slave servers were running out of sync this morning. After looking into it...it appears that yesterday when I tried to change the username of a user on the master server...it caused some issues on the slaves. Here is what I was able to pull from the

Re: Mysql Replication out of sync

; ... Slave_IO_Running: Yes Slave_SQL_Running: Yes ... it will restart the replication, but you have to check then why this happened, just in case... - Original Message - From: Shain Miley To: mysql@lists.mysql.com Sent: Friday, January 09, 2009 3:17 PM Subject: Mysql

Re: MySQl and LVM

snapshot and then move it..take another one then move it? Also...if anyone else is doing this...how often are you taking the snapshots...every 5 minutes, every hour, every 12 hours, etc? Thanks, Shain Simon J Mudd wrote: [EMAIL PROTECTED] (Shain Miley) writes: I am trying to plan we

MySQl and LVM

Hello, I am trying to plan we in advance our methods for backup and recovery of our new MySQL replication cluster. After doing some research it looks like a lot of people are using LVM snapshots as their backup solution. We currently have two MySQL servers with 2 300 GB (Raid 1). What I

Mysql and Flashback

Hello, We are planning on trying to do an Oracle to MySQL migration in the near future. The issue of a Mysql equivalent to Oracle's flashback was being discussed. After some digging it appears that there is no such feature in Mysql. One thought that I had was to do some intentional

Re: Virtualizing MySQL

PROTECTED] (Shain Miley) writes: I am looking into the idea of setting up 10 - 15 virtualized instances of MySQL. The reason for this is as follows...we are going to be setting up a 3 to 4 node MySQL replication cluster (1 master-rw and 2 slaves-ro)...each having 16 to 32 GB of RAM. In order

Virtualizing MySQL

I am looking into the idea of setting up 10 - 15 virtualized instances of MySQL. The reason for this is as follows...we are going to be setting up a 3 to 4 node MySQL replication cluster (1 master-rw and 2 slaves-ro)...each having 16 to 32 GB of RAM. In order for our development team to do

Server Setup Question

Hello all, I was wondering if anyone had any good insight into running the 32 bit and 64 bit versions of MySQL? We are going to be using a replication setup within my organization very shortly. We intend to a have at least one master (writable) DB and several (let's say 3 for this

Re: Server Setup Question

with performance as well... Thanks, Shain Daniel P. Brown wrote: On Wed, Nov 12, 2008 at 12:35 PM, Shain Miley [EMAIL PROTECTED] wrote: Hello all, I was wondering if anyone had any good insight into running the 32 bit and 64 bit versions of MySQL? We are going to be using a replication

Oracle to Mysql Sync

Hello everyone, I had a quick question...I am looking to move away from our dependence on Oracle over to using a Mysql Cluster. Due to the complexity of the move it will have to happen over a period of time, what I would like to do is keep our mysql database in sync with our Oracle DBthis