• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Bear Bibeault
  • Junilu Lacar
  • Martin Vashko
Sheriffs:
  • Jeanne Boyarsky
  • Tim Cooke
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Scott Selikoff
  • salvin francis
  • Piet Souris

Is MySQL transactional?

 
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I thought it is, but my DBA said I need to use InnoDB to get transactional support. Is InnoDB part of MySQL?
 
Sheriff
Posts: 24737
59
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yes.
 
Ranch Hand
Posts: 63
Firefox Browser Postgres Database Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Take a look at all of the Storage Engines that are part of MySQL. Each offers a different set of features (e.g. advantages and disadvantages.)
 
Bartender
Posts: 10336
Hibernate Eclipse IDE Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Paul Clapham wrote:Yes.



Well, partly. The MyISAM database engine is not.
 
Tejas Jain
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I found InnoDB Engine is transactional, but my DBA told me that InnoDB has no crash recovery support. If it is true, it makes
InnoDB has no real value in production...
 
Marshal
Posts: 66516
251
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is this of any help?
 
Java Cowboy
Posts: 16084
88
Android Scala IntelliJ IDE Spring Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There are many companies who use MySQL for serious projects. It's not just some toy database that isn't suited for real production use.
 
Tejas Jain
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Campbell Ritchie wrote:Is this of any help?



Do you have an URL that shows the official document on crash recovery for InnoDB from MySQL?
 
Paul Clapham
Sheriff
Posts: 24737
59
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Paul Sturrock wrote:

Paul Clapham wrote:Yes.



Well, partly. The MyISAM database engine is not.



I was answering the question in the thread, namely "Is InnoDB part of MySQL?" and not the question in the title of the thread.
 
Paul Clapham
Sheriff
Posts: 24737
59
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Tejas Jain wrote:

Campbell Ritchie wrote:Is this of any help?



Do you have an URL that shows the official document on crash recovery for InnoDB from MySQL?



You know, MySQL does have a website. And it's extremely comprehensive. When I used "crash recovery for InnoDB from MySQL" for my Google keywords it led me directly to this page in the MySQL Reference Manual. I answered your original question tersely because it was a question which was also easily researched.
 
Marshal
Posts: 3838
66
Netbeans IDE Oracle Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I'd say it pretty much depends on what does everybody understand under "crash recovery". The database I currently work with can be configured in such a way that data from every single committed transaction can be recovered from backups and redo logs, even in case of media failure. It seems to be a different concept from the one described by the link provided by Paul, though with proper backup strategy maybe similar level of protection could be achieved in MySQL - I don't know MySQL at all.

On the other hand, it also depends on how much value you put on the data in the database. For a social networking site, losing one day worth of data might be not that dramatic problem. For a bank, the same might be a disaster that could put the bank out of business. Both of these enterprises might clearly be labelled "serious business".
 
Tejas Jain
Ranch Hand
Posts: 119
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Martin Vajsar wrote: ... The database I currently work with can be configured in such a way that data from every single committed transaction can be recovered from backups and redo logs, even in case of media failure. ...



This is the crash recovery I am looking for. I know Oracle can do it and has tools to help you, but not so sure about MySQL.
 
Martin Vashko
Marshal
Posts: 3838
66
Netbeans IDE Oracle Firefox Browser
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

Tejas Jain wrote:This is the crash recovery I am looking for. I know Oracle can do it and has tools to help you, but not so sure about MySQL.


It also depends on the infrastructure in your organization.

If there is a DBA that will take care of your database, and he is not willing to support MySQL, there is probably not much more to talk about. If there is not a database that would meet your needs at all, then you'll probably have to hire a new DBA or train somebody to become a DBA of a new database, and at this time additional factors might pop up, but this would probably be a rare situation.

And yes, you do need a DBA to take care of the database. If you're concerned about recovery in case of media failure, you definitely need somebody skilled enough to be absolutely sure of what he is doing to the database.
 
Ranch Hand
Posts: 662
Eclipse IDE Spring Java
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dispelling the Myths
 
Where all the women are strong, all the men are good looking and all the tiny ads are above average:
Java file APIs (DOC, XLS, PDF, and many more)
https://products.aspose.com/total/java
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!