Logship from SQL Server to MYSQL

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Logship from SQL Server to MYSQL

Logship from SQL Server to MYSQL

Rate Topic

Display Mode

Topic Options

Author

Message

djones-1062714

Posted Wednesday, June 10, 2009 9:40 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 05, 2011 9:23 AM
Points: 10, Visits: 22

My reporting infrastructure is set up in a way that there is a main production server that all the real-time reports and transactions happen on. That server ships logs to 3 other servers with read only databases. Those servers are responsible for processing all the SQL for the reports in the application that are not required to be real-time. For cost reasons I would like to replace those 3 SQL Servers with MySQL servers. If any of you were presented with this challenge, how would you make it work? Our database size is about 60GB but estimated to grow to many times that over time. Our largest table at the moment is 123 million rows and grows at a rate of 4.6 million per month.

David

Post #732408

Lynn Pettis

Posted Wednesday, June 10, 2009 9:46 AM

SSC-Insane

Group: General Forum Members
Last Login: Today @ 9:56 AM
Points: 21,600, Visits: 27,420

Truth be told, I wouldn't. I am unaware of any tools or products that would read a MS SQL Server t-log backup and restore it to a MySQL database. Depending on the latency required, you may need to use SSIS to transfer data from MS SQL Server to MySQL.

Cool

Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)

Post #732413

GilaMonster

Posted Wednesday, June 10, 2009 10:09 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Today @ 9:37 AM
Points: 37,686, Visits: 29,939

You say you want to replace the 3 SQL Server boxes with MySQL for cost reasons. What cost is there in keeping the SQL Server boxes? Your licences for SQL should be paid for already. If you do move those reporting systems to MySQL, you may have to take a log of time to rewrite the queries. Do you have any MySQL admin skills there? If not how much will it cost to get someone in or train someone up?

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #732434

djones-1062714

Posted Wednesday, June 10, 2009 11:13 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, May 05, 2011 9:23 AM
Points: 10, Visits: 22

The cost comes in when we have to scale out and add more SQL boxes. Our application is designed in a way that we can add as many database servers as we want. The application will determine load on each of the SQL machines and direct the sql to the appropriate place. If we add say, 7 more SQL servers, that is a significant cost.

Post #732494

« Prev Topic | Next Topic »

Permissions