SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Logship from SQL Server to MYSQL


Logship from SQL Server to MYSQL

Author
Message
djones-1062714
djones-1062714
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 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
Lynn Pettis
Lynn Pettis
SSC Guru
SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)SSC Guru (150K reputation)

Group: General Forum Members
Points: 150648 Visits: 39285
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)
GilaMonster
GilaMonster
SSC Guru
SSC Guru (370K reputation)SSC Guru (370K reputation)SSC Guru (370K reputation)SSC Guru (370K reputation)SSC Guru (370K reputation)SSC Guru (370K reputation)SSC Guru (370K reputation)SSC Guru (370K reputation)

Group: General Forum Members
Points: 370698 Visits: 46957
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, MVP, M.Sc (Comp Sci)
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


djones-1062714
djones-1062714
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search