Publications
As with PostgreSQL, MySQL also offers high availibilty using asynchronous replication. Very easy to set up. We will go through the primary-replica scenario in this article. Firstly, you need to restore your dumps onto the replica server in order to obtain relatively recent data. $ mysql -p database_name < dump_file.sql I omit the username because it is assumed that you are logged into the serve...
Replication with MySQL
Mar 03, 2023
241 Vues
PostgreSQL - probably my favourite database vendor. Listed as the world's most advanced open-source database - good enough for me as open-source is what I deal with for a living. Immensely powerful and fun to use, PostgreSQL is an RDBMS. It has many features from B-Tree indexing for concurrency, stored functions and procedures, GSSAPI and LDAP authentication amongst many others. In fact, I've time...
Replication with PostgreSQL - High Availability
Mar 03, 2023
129 Vues
Back in the day, if you've ever needed to segregate your server and application environment, you'd have the choice of using multiple physical servers which technically worked, but it was quite a pain to set up all those servers what with the operating systems and networking configuration. Then came along the virtual machine era which revolutionised our work - we could now have multiple machines al...
Containerising your environment with LXC/LXD
Mar 03, 2023
150 Vues