[Maria-discuss] Spider Engine

2016-08-05 Thread Suresh Rajagopal
Hi, I am looking for some references for Spider Engine in production. Any known issues/recommendations for setup ? ThanksSuresh Rajagopal___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe :

Re: [Maria-discuss] Spider Engine

2016-08-24 Thread Suresh Rajagopal
Hi Colin, Is there any recommendation for placing Spider Nodes ? Can i use the backend node also for spider node ? How to handle HA for Spider ? ThanksSuresh Rajagopal From: Colin Charles To: Suresh Rajagopal Cc: Maria Discuss Sent: Friday, August 5, 2016 4:06 AM Subject: Re: [Maria

[Maria-discuss] Spider Nodes

2016-09-10 Thread Suresh Rajagopal
Hi, What is best place to keep spider nodes ? Dedicated Physical Servers or Virtual Machines or Backend Nodes  Backend nodes are physical servers with SSD.  ThanksSuresh Rajagopal ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-

[Maria-discuss] Database Platform Migration

2016-09-10 Thread Suresh Rajagopal
Hi, How to migrate mysql 5.0 database from darwin to Linux? Database size is close to 1 TB Thanks Suresh Rajagopal ___ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https

[Maria-discuss] latin1 to utf8 conversion

2017-02-24 Thread Suresh Rajagopal
Hi, I have a database(MariaDB 10.1.18) with latin1 characterset and a table with utf8 characterset.I can query the data only if i set names to latin1. How to convert the data to utf8 ? I have tried export/import,iconv. But still data doesn't show up. show create database test;+--+--

[Maria-discuss] Partition a Huge table

2017-03-13 Thread Suresh Rajagopal
Hi, What is the fastest approach to partition a huge table with 2 additional columns? How safe its to alter table on slave and promote slave as master? It takes 25 hours to alter the table for now on slave. MariaDB Version : 10.1.18OS              : Centos 6 ThanksSuresh__

Re: [Maria-discuss] Partition a Huge table

2017-03-13 Thread Suresh Rajagopal
Thanks Peter. I am moving this database to a new datacenter. So i do have a backup slave. I tried this approach on QA and worked fine. Need to know if there is any known issues before i migrate the prod.   From: Peter Mclarty To: Suresh Rajagopal Cc: Maria Discuss Sent: Monday

Re: [Maria-discuss] Partition a Huge table

2017-03-13 Thread Suresh Rajagopal
i have to modify primary for partitioning. pt-online-schema-change complaints about dropping primary.Still i can ignore the warning and proceed. Thanks From: Guillaume Lefranc To: Suresh Rajagopal ; Maria Discuss Sent: Monday, March 13, 2017 6:08 PM Subject: Re: [Maria-discuss

Re: [Maria-discuss] Partition a Huge table

2017-03-14 Thread Suresh Rajagopal
How do you take care of the data changes that's happening in this table in master while you undergo these schema changes in slave (that you mentioned will take 24 hours or so).  On Tue, Mar 14, 2017 at 10:38 AM, Suresh Rajagopal wrote: i have to modify primary for partitioning. pt-online