Stash + MySQL - under 1 host?

Hello Guys,

we are exploring Stash + MySQL + AD implementation. I have it up and running, linked the AD. Everything seems good. I can't find in the documentation the best practices to run Stash and MySQL? Obviosly MySQL should be accessble for Stash but what is the best practice - should they be on same machine? Most probably my production Stash installation would be on virtual machine, run with specific linux user and running as a daemon. We have NetApp storage on which I can create a NFS mount and that mount to be for the MySQL for example. I'm curious what is the best approach where the MySQL db to be - on the same server on local hdd, on different server local hdd (special MySQL server only for Stash) or different server/same server with NFS export? Our users are around 30-40 which isn't that much but I want to choose the best option for us. Can you please advise what is the best approach where the MySQL db to be placed?

Also that is the same with the data folder of Stash.

Thank you.

4 answers

1 accepted

1 vote
Accepted answer

Hi Ivan,

The best option is to have the DB on the same machine as Stash, this will avoid problems with your network having an impact on your performance. But placing it on a different server is ofcourse also an option. Placing them on the same machine will ofcourse mean that they will need to share the resources (cpu, mem,...) on this machine but with your user base and size that shouldn't be a real problem.

The most important part is doing regular backups of your DB, and regularly checking that you can import a DB backup into your DB again.

Best regards,

Peter

Hello Peter,

thank you for your prompt reply! As for the backups I'm oriented to use Stash Backup Client. From your experience would that save me from future troubles?

Thank you!

Best Regards

Ivan

Hi Ivan,

That looks like a good backup solution, but you should still regularly check if your backups do actually work (I've had one client who didn't do this, they had a hardware failure in their DB server and had to put a backup onto a new server : it did not work which caused them a whole bunch of problems), they now do it very regularly.

Best regards,

Peter

Yeah, that's for sure. Backups should be regularly checked!I'll explore more the backup client.

Thank you for your kind reponses!

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Nov 06, 2018 in Bitbucket

Upgrade Best Practices

Hello! My name is Mark Askew and I am a Premier Support Engineer for products Bitbucket Server/Data Center, Fisheye & Crucible. Today, I want to bring the discussion that Jennifer, Matt, and ...

250 views 3 7
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you