Re: add index to slave but not master

2011-10-31 Thread Luis Motta Campos
On 31 Oct 2011, at 08:46, Jeff Pang wrote: > Hello, > > I have a question that, if I add the index to the table in slave, but > don't do it in master, will it make problems? Jeff, I manage some big data here and this is my preferred strategy - shard the workload in different mysql pools (behin

Re: importing mysql structures only or restore ignoring non-existing tables and columns?

2011-10-31 Thread Luis Motta Campos
On 29 Oct 2011, at 22:59, luci spam wrote: > I have 2 servers (1 for development, 1 for service) > > I keep ADD/DELETE columns and CREATE/DELETE Indexes on my development > server, so these 2 server have similar but different mysql data structures. > > I know there's an option to expert structur

Re: problem with table

2011-10-31 Thread Sharl.Jimh.Tsin
在 2011-10-31一的 16:18 +0530，nataraj 0102写道： > Hello, > > > > I am using MYSQL database with Linux server. > > I have a problem with one table, when I tried to get the data from that > table, I am getting error : “mysql error 4600: mysql server gone away. > > No connection, trying to re-connect”

problem with table

2011-10-31 Thread nataraj 0102
Hello, I am using MYSQL database with Linux server. I have a problem with one table, when I tried to get the data from that table, I am getting error : “mysql error 4600: mysql server gone away. No connection, trying to re-connect” …. This error message getting and cursor getting stuck in next

Re: DBA MySQL Job Spain

2011-10-31 Thread Sharl.Jimh.Tsin
在 2011-10-31一的 09:40 +，Garcia, Monica写道： > Hello people, > > We are looking for a MySQL DBA, based in Malaga (Spain). If you > have 5+ years experience administering MySQL and you are interested > in join an international company, please send your CV in english to: > monica.gar...@hays.es.

Re: add index to slave but not master

2011-10-31 Thread Andrew Moore
Functionally not a problem. Many people use a slave for different work loads then their master. Different indexes for different queries make sense. Be aware that should you intend to make backups off the slave or even leave yourself open to promoting slave to master as a HA strategy then things wil

DBA MySQL Job Spain

2011-10-31 Thread Garcia, Monica
Hello people, We are looking for a MySQL DBA, based in Malaga (Spain). If you have 5+ years experience administering MySQL and you are interested in join an international company, please send your CV in english to: monica.gar...@hays.es . Salary from 40k and di

add index to slave but not master

2011-10-31 Thread Jeff Pang
Hello, I have a question that, if I add the index to the table in slave, but don't do it in master, will it make problems? Thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org