SSD or NVME for MYSQL Database
2 hours ago, raheel syntecx said:Are you suggesting not to with SSD's for database?
Well I think you should use RAID, preferably RAID 1 or 10. But to make it easier an less expensive over time a great way to implement it are to use one set of enterprise SLC SSD's for log and tempdb stuff and another set of, perhaps cheaper consumer grade MLC SSD's, for data and index. (Since data and index aren't that write intensive)
You can also use RAID 5 or 6 to spread the writes over several SSD's, though you loose some of the speed of RAID 1 or 10.
Whichever solution you choose, make sure you do replace the SSD's way ahead of their expected lifetime, at least some of the drives, and of course have a well configured backup! Though I'm sure you are way ahead of me on that one!
Edit: I was thinking MS SQL, but it's pretty much the same with MySQL.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now