Increase speed and durability with MySQL replication (2 easy ways)
VloĆŸit
- Äas pĆidĂĄn 14. 02. 2024
- To learn more about PlanetScale, head to planetscale.com/youtube!
đŹ Follow PlanetScale on social media
âą Twitter: / planetscale
âą Discord: / discord
âą TikTok: / planetscale
âą Twitch: / planetscale
âą LinkedIn: / planetscale - VÄda a technologie
Although PlanetScale makes it easy to create replicas, but I liked the way you explained the steps of creating replicas the hard way.
Thanks!
Adding value to your day!
@@PlanetScaleI learned something newđ
great video. would love to see a video like this about running multiple masters!
We're going to be releasing a course on scaling databases on our website, which will include concepts like vertical and horizontal sharding (which implies multiple primaries). If that sounds interesting to you, sign up here! planetscale.com/scale
Great video !
if you use the GRANT commands you don't need to FLUSH PRIVILEGES. You need this only if you update the privileges tables directly!
Thanks a lot. very useful.
Glad to help đ€
Really, good video. Would love some more details and nuances of replication. Like GTID based replication, how to handle delay, how to reset a replication etc. I assume Planetscale has extensive knowledge on those topics ;)
We have a few blog posts on replication, links below!
planetscale.com/blog/what-is-mysql-replication-and-when-should-you-use-it
planetscale.com/blog/mysql-replication-best-practices-and-considerations
planetscale.com/blog/mysql-semi-sync-replication-durability-consistency-and-split-brains
Of course, you should also check out the MySQL docs.
Hey, just a heads up when editing a file as sudo, you should prefer to use sudoedit rather than directly sudo-ing the editor.
Why?
@@SebastianMares Well, basically it differs in behaviour. `sudo vim` means you are opening vim the editor program with elevated privilege. It's usually fine, but if the editor did something it shouldn't do then it would be a problem (say, you mistype a command in VIM) since it has elevated privilege now. But sudoedit (its actually alias for sudo -e) tells sudo that you want to edit a file. sudo then will do the procedure to safely do that for you like making a temporary copy of the file, opening the editor that the user specified (IIRC from EDITOR env var), moving those temporary file after finished editing, and this is the most important part, making sure that the editor is not running using elevated privilege. If you want to do that, then sure, do `sudo vim`, but if you just wanted to edit a file, sudo -e (or sudoedit) is usually a good practice.
@@YandiBanyu I wasn't aware of that, I thought sudoedit would simply open the default editor with super-user rights and I always found it inconvenient when the default editor is nano for example and I wanted to use vim. But true, I just tried to do an apt update from within an editor opened via sudoedit, and it complained that it doesn't have the rights to lock the files. Thanks for the suggestion and the explanation!
@@YandiBanyu Good safety tip! đȘ
Plus it will use your file editor configurations not the root configuration s. E.g. you've configured vim, and it will use it.
You don't need to enable binary logs in the replica, will use storage space for nothing. Also the most important part it's to take one consistent master/primary snapshot/dump with the binary log position.
You don't have to tediously set up the log file and position like that. When you take a mysqldump of the master, just pass the --master-data=1 flag and that information will be saved to the .sql file and when you run source [dump.sql] on the slave, those parameters will already be set.
Good tip! In this video we didn't show taking a dump, but if you're setting up replication for an existing database this is a great idea.
@@PlanetScale âTaking a Dumpâ heh⊠Iâm a child.
@@spamviking8591 đ€Ł
Hey great video, great channel! But I am sad that the hobby plan was removed from my country. It was going to be used for a test run on my company, thanks to my recommendation, but now the cheapest plan is kind of expensive for this purpose. Can't you guys just make like a hobby plan just with the price to cover the costs for the countries you removed it?
If you're interested in trialing PlanetScale for business purposes, I recommend you reach out to our sales team! planetscale.com/contact
Where is aaron
died
The fact that you sell it and show how we can do it ourself first massive respect we salute you đ«Ąđ«Ą