{"id":66,"date":"2010-04-14T14:28:33","date_gmt":"2010-04-14T19:28:33","guid":{"rendered":"http:\/\/blogs.wp.stage.cpanel.net\/2010\/04\/a_general_overview_of_database_mapping\/"},"modified":"2010-04-14T14:28:33","modified_gmt":"2010-04-14T19:28:33","slug":"a_general_overview_of_database_mapping","status":"publish","type":"post","link":"https:\/\/devel.www.cpanel.net\/blog\/products\/a_general_overview_of_database_mapping\/","title":{"rendered":"A General Overview of Database Mapping"},"content":{"rendered":"
Inside of 11.25.1 we are introducing a new feature called \u201cdatabase mapping\u201d . \u00a0Despite the vague name, this feature has huge implications for integrated applications, transfers from non-cPanel servers and custom themes. \u00a0What this does is remove the restraint of MySQL database and usernames having to be prefixed by the cPanel account\u2019s username.<\/p>\n
The benefit of the DB Mapping feature is that when transferring accounts from non-cpanel systems, the database name will now be preserved rather than having to hunt it down in configuration files and waste extra time on account migrations. \u00a0The other benefit is that users will not longer have the confusion of having their username automatically prefixed to the database name. \u00a0When they create a database it will be the string that they type into cPanel.<\/p>\n
The core DB Mapping functionality has been factored into the cPanel code, however the new behavior is not exposed in the cPanel interface until you enable it, i.e. \u2018opt-in.\u2019 \u00a0This design provides two key benefits. 1) If you\u2019re migrating from \u00a0a non-cPanel system the database names will stay perfectly intact and 2) It eases the transition from the old, username prefixes, to the new non-prefix database names; you can chose when the best time is to offer this functionality and it\u2019s just a click away.<\/p>\n
To enable DB Mapping and remove the prefix behavior, a Tweak Settings toggle as been added. \u00a0Enabling ones cPanel system will have no effect on pre-existing databases. \u00a0CPanel interfaces and database creation will still continue to function as it has until you \u2018opt-in\u2019 from this Tweak Setting.<\/p>\n
The affect of this on themes and integrated applications is that there will be the addition of new API calls to handle the new system of managing databases. \u00a0Some backwards compatibility may be broken in the move to the new system, so please beware!<\/p>\n
We will have a blog post detailing the technical details of this system around the same time that we release 11.25.1 to EDGE.<\/p>\n","protected":false},"excerpt":{"rendered":"
Inside of 11.25.1 we are introducing a new feature called \u201cdatabase mapping\u201d . \u00a0Despite the vague name, this feature has huge implications for integrated applications, transfers from non-cPanel servers and custom themes. \u00a0What this does is remove the restraint of MySQL database and usernames having to be prefixed by the cPanel account\u2019s username. The benefit […]<\/p>\n","protected":false},"author":77,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[49],"tags":[],"class_list":["post-66","post","type-post","status-publish","format-standard","hentry","category-products"],"acf":[],"yoast_head":"\n