Meanwhile, Heroku is doing its part to keep your database healthy, functioning, and running well, 24 hours a day. All that is left for you to do is to worry about your data and how to store it efficiently.īecause Heroku takes on a lot of the responsibilities of a DBA, you are freed up to consider the parts that are important to your particular application and your particular use case. There is no need to worry about patching for security or stability, and there is no need to worry about backups everything is taken care of for you. In fact, Heroku will do everything aside from architect and optimize your database. With PostgreSQL, as with the rest of the Heroku platform, most of this is done for you. In essence, a qualified DBA needs to be able to set up, manage, secure, back up, scale, architect, and optimize data structures for day-to-day use. Set up and administer databases (perform backup, recovery, monitoring, and tuning as necessary).ĭevise a scalable solution with the highest performance and greatest redundancy. There are a number of other technical reasons as to why PostgreSQL is the favored option, too: for instance, transactional data definition languages (DDLs), fast index creation with concurrent indexes, extensibility, and partial indexing and constraints. Thus, as a user, you are able to take your data wherever you please. This means that now and moving forward, as long as you are using PostgreSQL for your database server, you will not be subject to any vendor lock-in. Over time, Heroku found PostgreSQL to get better and better as the development community around it added updated and new functionality.Īdditionally, and a very key reason, PostgreSQL is an open system and always will be (unlike MySQL). The initial choice was made based on the fact that it was believed to be operationally more reliable than MySQL, which is very important when managing hundreds of thousands of databases on a daily basis. However, over time, opinion has shifted more toward using PostgreSQL. In the early days of Heroku PostgreSQL, this was somewhat surprising, as MySQL was easily the most predominantly used database server at the time. In order to provide the best service available, Heroku decided to use PostgreSQL, and provide this service as the default choice for all database hosting. Over the last few years, two open source database servers have become dominant on the Web.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |